Entity-Relationship modeling revisited

ABSTRACT

In this position paper, we argue the modern applications require databases to capture and enforce more domain semantics than traditional applications. We also argue that the best way to incorporate additional semantics into database systems is by capturing the added information in conceptual models and then using it for database design. In this light, we revisit Entity-Relationship models and investigate ways in which such models could be extended to play a role in the process. Inspired by a paper by Rafael Camps Pare ([2]), we suggest avenues of research in the issue.

REFERENCES

• 1: Paolo Atzeni , Carlo Batini , Maurizio Lenzerini , Fulvio Villanelli, INCOD: A System for Conceptual Design of Data and Transactions in the Entity-Relationship Model, Proceedings of the Second International Conference on the Entity-Relationship Approach to Information Modeling and Analysis, p.375-410, October 12-14, 1981
• 2: Rafael Camps Paré, From ternary relationship to relational tables: a case against common beliefs, ACM SIGMOD Record, v.31 n.2, June 2002 [doi>10.1145/565117.565125]
• 3: Castellanos, M. Semantic Enrichment of interoperable databases, in Proceedings of the RIDE-IMS, 1993.
• 4: Peter Pin-Shan Chen, The entity-relationship model—toward a unified view of data, ACM Transactions on Database Systems (TODS), v.1 n.1, p.9-36, March 1976 [doi>10.1145/320434.320440]
• 5: Connolly, T., Begg, C. and Strachan, A. Database Systems, Addison-Wesley, 1999.
• 6: Alan M. Davis, Software requirements: objects, functions, and states, Prentice-Hall, Inc., Upper Saddle River, NJ, 1993
• 7: Clesio Saraiva dos Santos , Erich J. Neuhold , Antonio L. Furtado, A Data Type Approach to the Entity-Relationship Approach, Proceedings of the 1st International Conference on the Entity-Relationship Approach to Systems Analysis and Design, p.103-119, January 1980
• 8: Eder, J., Kappel, G., Tjoa, A. and Wagner, R. BIER:The Behavior Integrated Entity Relationship Approach, in Proceedings of the 5th International Conference on Entity-Relationship Approach, 1986.
• 9: Heterogeneous and Autonomous Database Systems, Elmagarmid, A., Rusinkiewicz, M. and Sheth, A. eds., Morgan Kaufmann, 1999.
• 10: Peter Fankhauser , Martin Kracker , Erich J. Neuhold, Semantic vs. structural resemblance of classes, ACM SIGMOD Record, v.20 n.4, p.59-63, Dec. 1991 [doi>10.1145/141356.141383]
• 11: Garcia-Solaco, M., Castellanos, M. and Saltor, F. Discovering interdata resemblance of classes for interoperable databases, in Proceedings of the RIDE-IMS, 1993.
• 12: C Goh and S. Bressan and S. Madnick and M. Siegel, Context Mediation: New Features and Formalisms for the Intelligent Integration of Information, Sloan Working Paper 3941, 1997.
• 13: Martin Gogolla , Uwe Hohenstein, Towards a semantic view of an extended entity-relationship model, ACM Transactions on Database Systems (TODS), v.16 n.3, p.369-416, Sept. 1991 [doi>10.1145/111197.111200]
• 14: Richard Hull, Relative information capacity of simple relational database schemata, SIAM Journal on Computing, v.15 n.3, p.856-886, August 1986 [doi>10.1137/0215061]
• 15: Richard Hull , Chee K. Yap, The Format Model: A Theory of database Organization, Journal of the ACM (JACM), v.31 n.3, p.518-544, July 1984 [doi>10.1145/828.832]
• 16: Vipul Kashyap , Amit Sheth, Semantic and schematic similarities between database objects: a context-based approach, The VLDB Journal — The International Journal on Very Large Data Bases, v.5 n.4, p.276-304, December 1996 [doi>10.1007/s007780050029]
• 17: Won Kim , Injun Choi , Sunit Gala , Mark Scheevel, On resolving schematic heterogeneity in multidatabase systems, Distributed and Parallel Databases, v.1 n.3, p.251-279, July 1993 [doi>10.1007/BF01263333]
• 18: J. A. Larson , S. B. Navathe , R. Elmasri, A Theory of Attributed Equivalence in Databases with Application to Schema Integration, IEEE Transactions on Software Engineering, v.15 n.4, p.449-463, April 1989 [doi>10.1109/32.16605]
• 19: Reée J. Miller, Using schematically heterogeneous structures, Proceedings of the 1998 ACM SIGMOD international conference on Management of data, p.189-200, June 01-04, 1998, Seattle, Washington, United States
• 20: Jim Melton , Alan Simon, SQL:1999: understanding relational language components, Morgan Kaufmann Publishers Inc., San Francisco, CA, 2001
• 21: R. J. Miller , Y. E. Ioannidis , R. Ramakrishnan, Schema equivalence in heterogeneous systems: bridging theory and practice, Information Systems, v.19 n.1, p.3-31, Jan. 1994 [doi>10.1016/0306-4379(94)90024-8]
• 22: Roger S. Pressman, A manager's guide to software engineering, McGraw-Hill, Inc., Hightstown, NJ, 1996
• 23: James Rumbaugh , Ivar Jacobson , Grady Booch, The Unified Modeling Language reference manual, Addison-Wesley Longman Ltd., Essex, UK, 1998
• 24: William W. Song , Paul Johannesson , Janis A. Bubenko, Jr., Semantic Similarity Relations in Schema Integration, Proceedings of the 11th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach, p.97-120, October 07-09, 1992
• 25: Wen-Syan Li , Chris Clifton, Semantic Integration in Heterogeneous Databases Using Neural Networks, Proceedings of the 20th International Conference on Very Large Data Bases, p.1-12, September 12-15, 1994
• 26: S. Spaccapietra , C. Parent, View Integration: A Step Forward in Solving Structural Conflicts, IEEE Transactions on Knowledge and Data Engineering, v.6 n.2, p.258-274, April 1994 [doi>10.1109/69.277770]
• 27: Sciore, E., and Siegel, M., and Rosenthal, A. Context Interchange Using Meta-attributes, in Proceedings of CIKM, 1992.
• 28: Edward Sciore , Michael Siegel , Arnon Rosenthal, Using semantic values to facilitate interoperability among heterogeneous information systems, ACM Transactions on Database Systems (TODS), v.19 n.2, p.254-290, June 1994 [doi>10.1145/176567.176570]
• 29: Bernhard Thalheim , B. Thalheim, Entity-Relationship Modeling: Foundations of Database Technology, Springer-Verlag New York, Inc., Secaucus, NJ, 2000
• 30: Aris M. Ouksel , Channah F. Naiman, Coordinating context building in heterogeneous information systems, Journal of Intelligent Information Systems, v.3 n.2, p.151-183, April 1994 [doi>10.1007/BF00962977]