Integrity constraint integration in heterogeneous databases: An enhanced methodology for schema integration

Information Systems

Volumn 22, Issue 8, 1997, Pages 423-446

  Ramesh, Venkatar ^a   Ram, Sudha ^b  

^a INDIANA UNIVERSITY   (United States)

^b UNIVERSITY OF ARIZONA   (United States)

Author keywords

Heterogeneous database integration; Integrity constraints; Schema integration; Semantic query processing

Indexed keywords

COMPUTATIONAL LINGUISTICS; CONSTRAINT THEORY; DATA STRUCTURES; INFORMATION RETRIEVAL; KNOWLEDGE REPRESENTATION;

INTEGRITY CONSTRAINTS; SCHEMA INTEGRATION; SEMANTIC QUERY PROCESSING;

DATABASE SYSTEMS;

EID: 0031370818     PISSN: 03064379     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0306-4379(97)00027-6     Document Type: Article

References (24)

1. H. An and L.J. Menschen. Knowledge Based Semantic Query Optimization. International Symposium on Methodologies for Intelligent Systems, pp. 82-91 (1992).
2. C. Batini, M. Lenzerini and S.B. Navathe. A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys, 18(4):323-364 (1986).
3. E. Bertino and D. Musto. Query Optimization by using Knowledge about Data Semantics. Data and Knowledge Engineering, 9:121-155 (1992).
4. U.S. Chakravarthy, D. Fishman and J. Minker. Logic-Based Approach to Semantic Query Optimization. ACM Transactions on Database Systems, 15(2):162-207 (1990).
5. P.P. Chen. The Entity-Relationship Model: Toward a Unified View of Data ACM Transactions on Database Systems, 1(1): 9-36 (1976).
6. C.A. Draxler. A Powerful Prolog to SQL Compiler. CIS Centre for Information and Language Processing, Ludwig-Maximilians- Universität-München (1993).
7. W. Gotthard, P.C. Lockemann and A. Neufeld. System-Guided View Integration for Object-Oriented Databases. IEEE Transactions on Knowledge and Data Engineering, 4(1):1-22 (1992).
8. M. Hammer and D. McLeod. Semantic integrity in a relational data base system. Proceedings of the First VLDB Conference (1975).
9. S. Hayne and S. Ram. Multi-User View Integration (MUVIS): An Expert System for View Integration. Proceedings of the Sixth International Conference on Data Engineering , pp. 402-409 (1990).
10. J.J. King. QUIST: A System for Semantic Query Optimization in Relational Databases. Proceedings of the Seventh VLDB Conference, pp. 510-517 (1981).
11. T. Landers and R. Rosenberg. An overview of multibase. In H. Schneider, editor, Distributed Data Systems, pp. 153-184, North-Holland (1982).
12. J.A. Larson, S.B. Navathe and R. Elmasri. A Theory of Attribute Equivalence in Databases with Application to Schema Integration. IEEE Transaction on Software Engineering, 15(4):449-463 (1989).
13. L.F. Mackert and G.M. Lohman. R* Optimizer Validation and Performance Evaluation for Local Queries. Proceedings of ACM SIGMOD, , pp. 84-95 (1986).
14. M.J. Pan, S.K. Chang, and C.C. Yang. A Semantic Query Processing in Multidatabase Systems: A Logic-Based Approach. Proceedings of Future Trends in Distributed Computing Systems , pp. 318-324 (1992).
15. V. Ramesh and S. Ram. A Methodology for Interschema Relationship Identification in Heterogeneous Databases. Proceedings of the 28th Hawaii International Conference on System Sciences , pp. 263-272, Hawaii (1995).
16. M.P. Reddy, M. Seigel and A. Gupta. Towards an Active Schema Integration Architecture for Heterogeneous Database Systems. Proceedings of RIDE-IMS'93 - Research Issues in Data Engineering: Interoperability of Multidatabase Systems, pp. 178-183 (1993).
17. R. Reiter. Towards a Logical Reconstruction of Relational Database Theory. In On Conceptual Modeling, M.L.Brodie, J. Mylopoulos and J.W.Schmidt, editors, Springer Verlag, pp. 191-233 (1984).
18. M. Seigel, E. Sciore and S. Salveter. A Method for Automatic Rule Derivation to Support Semantic Query Optimization. ACM Transactions on Database Systems, 17:563-600 (1992).
19. S. Shekhar, B. Hamidzadeh, A. Kohli and M. Coyle. Learning Transformation Rules for Semantic Query Optimization: A Data-Driven Approach. IEEE Transactions on Knowledge and Data Engineering , 5(6):950-964 (1993).
20. S.T. Shenoy and Z.M. Ozsoyoglu. Design and Implementation of a Semantic Query Optimizer. IEEE Transactions on Knowledge and Data Engineering , 1(3):344-361 (1989).
21. A.P. Sheth and S. Gala. Attribute Relationships: An Impediment in Automating Schema Integration. Proceedings of the NSF Workshop on Heterogeneous Database Systems (1989).
22. P. Shoval and S. Zohn. A Binary-Relationship Integration Methodology. Data and Knowledge Engineering, 6: 225-250 (1991).
23. S. Spaccapietra, C. Parent and Y. Dupont. Independent Assertions for Integration of Heterogeneous Schemas. Very Large Database Journal, 1(1) (1992).
24. H.J.A. van Kuijk, F.H.E. Pjipers and P.M.G. Apers. Semantic Query Optimization in Distributed Databases. Proceedings of Advances in Computing and Information - ICCI'90, pp. 295-303 (1990).