Using schematically heterogeneous structures
- 1 June 1998
- proceedings article
- Published by Association for Computing Machinery (ACM)
- Vol. 27 (2) , 189-200
- https://doi.org/10.1145/276304.276322
Abstract
Schematic heterogeneity arises when information that is represented as data under one schema, is represented within the schema (as metadata) in another. Schematic heterogeneity is an important class of heterogeneity that arises frequently in integrating legacy data in federated or data warehousing applications. Traditional query languages and view mechanisms are insufficient for reconciling and translating data between schematically heterogeneous schemas. Higher order query languages, that permit quantification over schema labels, have been proposed to permit querying and restructuring of data between schematically disparate schemas. We extend this work by considering how these languages can be used in practice. Specifically, we consider a restricted class of higher order views and show the power of these views in integrating legacy structures. Our results provide insights into the properties of restructuring transformations required to resolve schematic discrepancies. In addition, we show how the use of these views permits schema browsing and new forms of data independence that are important for global information systems. Furthermore, these views provide a framework for integrating semi-structured and unstructured queries, such as keyword searches, into a structured querying environment. We show how these views can be used with minimal extensions to existing query engines. We give conditions under which a higher order view is usable for answering a query and provide query translation algorithms.Keywords
This publication has 20 references indexed in Scilit:
- The many forms of a single factPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2003
- DataWeb: customizable database publishing for the WebIEEE MultiMedia, 1997
- Semantic and schematic similarities between database objects: a context-based approachThe VLDB Journal, 1996
- The GMAP: a versatile tool for physical data independenceThe VLDB Journal, 1996
- RETRIEVING AND INTEGRATING DATA FROM MULTIPLE INFORMATION SOURCESInternational Journal of Cooperative Information Systems, 1993
- Relations with relation names as argumentsPublished by Association for Computing Machinery (ACM) ,1992
- First order normal form for relational databases and multidatabasesACM SIGMOD Record, 1991
- A comparative analysis of methodologies for database schema integrationACM Computing Surveys, 1986
- Relative Information Capacity of Simple Relational Database SchemataSIAM Journal on Computing, 1986
- Access path selection in a relational database management systemPublished by Association for Computing Machinery (ACM) ,1979