Entity-Relationship modeling revisited

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.

[1]  Stefano Spaccapietra,et al.  View Integration: A Step Forward in Solving Structural Conflicts , 1994, IEEE Trans. Knowl. Data Eng..

[2]  James A. Larson,et al.  A Theory of Attribute Equivalence in Databases with Application to Schema Integration , 1989, IEEE Trans. Software Eng..

[3]  Chris Clifton,et al.  Semantic Integration in Heterogeneous Databases Using Neural Networks , 1994, VLDB.

[4]  RosenthalArnon,et al.  Using semantic values to facilitate interoperability among heterogeneous information systems , 1994 .

[5]  Bernhard Thalheim,et al.  Entity-relationship modeling - foundations of database technology , 2010 .

[6]  Ivar Jacobson,et al.  The unified modeling language reference manual , 2010 .

[7]  Alan R. Simon,et al.  Sql: 1999 Understanding Relational Language Components , 2002 .

[8]  M. Blasgen.  Database Systems , 1982, Science.

[9]  Roger S. Pressman.  A Manager's Guide to Software Engineering , 1992 .

[10]  Erich J. Neuhold,et al.  A Data Type Approach to the Entity-Relationship Approach , 1979, ER.

[11]  Erich J. Neuhold,et al.  Semantic vs. structural resemblance of classes , 1991, SGMD.

[12]  Maurizio Lenzerini,et al.  INCOD: A System for Conceptual Design of Data and Transactions in the Entity-Relationship Model , 1981, ER.

[13]  Janis A. Bubenko,et al.  Semantic Similarity Relations in Schema Integration , 1992, ER.

[14]  Richard Hull,et al.  The Format Model: A Theory of database Organization , 1984, J. ACM.

[15]  Malú Castellanos,et al.  Semantic enrichment of interoperable databases , 1993, Proceedings RIDE-IMS `93: Third International Workshop on Research Issues in Data Engineering: Interoperability in Multidatabase Systems.

[16]  Won Kim,et al.  On resolving schematic heterogeneity in multidatabase systems , 1995, Distributed and Parallel Databases.

[17]  Peter P. Chen.  The Entity-Relationship Model: Towards a unified view of Data , 1976 .

[18]  Peter P. Chen.  The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[19]  Rafael Camps,et al.  From ternary relationship to relational tables: a case against common beliefs , 2002, SGMD.

[20]  Rafael Camps Paré.  From ternary relationship to relational tables: a case against common beliefs , 2002, SIGMOD 2002.

[21]  Vipul Kashyap,et al.  Semantic and schematic similarities between database objects: a context-based approach , 1996, The VLDB Journal.

[22]  Amit P. Sheth,et al.  Management of heterogeneous and autonomous database systems , 1998 .

[23]  Renée J. Miller.  Using schematically heterogeneous structures , 1998, SIGMOD '98.

[24]  Richard Hull,et al.  The format model: a theory of database organization , 1982, JACM.

[25]  Aris M. Ouksel,et al.  Coordinating context building in heterogeneous information systems , 1994, Journal of Intelligent Information Systems.

[26]  Fèlix Saltor,et al.  Discovering interdatabase resemblance of classes for interoperable databases , 1993, Proceedings RIDE-IMS `93: Third International Workshop on Research Issues in Data Engineering: Interoperability in Multidatabase Systems.

[27]  Renée J. Miller,et al.  Schema equivalence in heterogeneous systems: bridging theory and practice , 1994, Inf. Syst..

[28]  Richard Hull,et al.  Relative information capacity of simple relational database schemata , 1984, SIAM J. Comput..

[29]  Stéphane Bressan,et al.  Context Interchange: New Features and Formalisms for the Intelligent Integration of Information Context Interchange: New Features and Formalisms for the Intelligent Integration of Information , 1997 .

[30]  Martin Gogolla,et al.  Towards a semantic view of an extended entity-relationship model , 1991, TODS.

[31]  Arnon Rosenthal,et al.  Using semantic values to facilitate interoperability among heterogeneous information systems , 1994, TODS.

[32]  Gerti Kappel,et al.  BIER - The Behaviour Integrated Entity Realtionship Approach , 1986, ER.