An ontology based approach to the integration of entity-relationship schemas

Data and Knowledge Engineering

Volumn 58, Issue 3, 2006, Pages 299-326

  He, Qi ^a   Ling, Tok Wang ^a  

^a NATIONAL UNIVERSITY OF SINGAPORE   (Singapore)

Author keywords

Entity relationship approach; Ontology; Schema integration; Schematic discrepancy

Indexed keywords

ALGORITHMS; CLASSIFICATION (OF INFORMATION); CONSTRAINT THEORY; INFORMATION RETRIEVAL; METADATA; SEMANTICS;

ENTITY-RELATIONSHIP APPROACH; ONTOLOGY; SCHEMA INTEGRATION; SCHEMATIC DISCREPANCY;

DATABASE SYSTEMS;

EID: 33745618929     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.datak.2005.07.005     Document Type: Article

References (23)

1. Abiteboul S., Hull R., and Vianu V. Foundations of Databases (1995), Addison-Wesley pp. 173-187, 216-235 (Chapters 8, 10)
2. R. Agrawal, A. Somani, and Y.R. Xu, Storing and querying of e-commerce data, in: VLDB, 2001, pp. 149-158.
3. Batini C., and Lenzerini M. A methodology for data schema integration in the entity-relationship model. IEEE Trans. Software Eng. 10 6 (1984)
4. Batini C., Lenzerini M., and Navathe S.B. A comparative analysis of methodologies for schema integration. CN Comput. Surveys 18 4 (1986) 323-364
5. Elmagarmid A., Rusinkiewicz M., and Sheth A. Management of Heterogeneous and Autonomous Database Systems (1999), Morgan Kaufmann
6. Goh C.H., Bressan S., Madnick S., and Siegel M. Context interchange: new features and formalisms for the intelligent integration of information. ACM Trans. Inform. Syst. 17 3 (1999)
7. G. Gottlob, Computing covers for embedded functional dependencies, in: SIGMOD, 1987.
8. Q. He, T.W. Ling, Extending and inferring functional dependencies in schema transformation, in: CIKM, 2004.
9. Hsu C.N., and Knoblock C.A. Semantic query optimization for query plans of heterogeneous multidatabase systems. TKDE 12 6 (2000) 959-978
10. Kashyap V., and Sheth A. Semantic and schematic similarity between database objects: a context-based approach. VLDB J. 5 (1996)
11. R. Krishnamurthy, W Litwen, W. Kent, Language features for interoperability of databases with schematic discrepancies, in: SIGMOD, 1991, pp. 40-49.
12. L.V.S. Lakshmanan, F. Sadri, S.N. Subramanian, On efficiently implementing SchemaSQL on a SQL database system, in: VLDB, 1999, pp. 471-482.
13. Lakshmanan L.V.S., Sadri F., and Subramanian S.N. SchemaSQL-an extension to SQL for multidatabase interoperability. TODS (2001)
14. M.L. Lee, T.W. Ling, Resolving constraint conflicts in the integration of ER schemas, in: International Conference on Conceptual Modeling (ER), 1997, pp. 394-407.
15. Lee M.L., and Ling T.W. A methodology for structural conflicts resolution in the integration of entity-relationship schemas. Knowledge Inform. Syst. 5 (2003) 225-247
16. T.W. Ling, M.L. Lee, Issues in an entity-relationship based federated database system, in: CODAS, 1996, pp. 60-69.
17. N.M. Mattos, Integrating information for on demand computing, in: VLDB, 2003.
18. R.J. Miller, Using schematically heterogeneous structures, in: SIGMOD, 1998, pp. 189-200.
19. Reddy M.P., Prasad B.E., and Gupta A. Formulating global integrity constraints during derivation of global schema. Data Knowledge Eng. (1995) 241-268
20. Sciore E., Siegel M., and Rosenthal A. Using semantic values to facilitate interoperability among heterogeneous information systems. TODS 19 2 (1994)
21. Sheth A.P., and Gala S.K. Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Comput. Surveys (1990)
22. Spaccapietra S., Parent C., and Dupont Y. Model independent assertions for integration of heterogeneous schemas. VLDB (1992)
23. M.W.W. Vermeer, P.M.G. Apers, The role of integrity constraints in database interoperation, in: VLDB, 1996.