Reasoning in Data Integration Systems: why LAV and GAV are Siblings
نویسنده
چکیده
Data integration consists in providing a uniform access to a set of data sources, through a unified representation of the data called global schema; a mapping specifies the relationship between the global schema and the sources. Integrity constraints (ICs) are expressed on the global schema to better represent the domain of interest; in general, ICs are not satisfied by the data at the sources. In this paper we address the problem of query answering in GLAV data integration systems, where tuple-generating dependencies are expressed on the global schema. We solve the problem in an intensional fashion, by presenting a rewriting technique that, taking into account both the ICs and the mapping, allows us to compute the answers to a query, expressed over the global schema, by evaluating the rewritten query directly over the sources. Since the GLAV approach is a generalisation of the basic approaches LAV and GAV, we show that query answering under ICs can be done in the same way in LAV and GAV systems, thus proving that LAV and GAV are siblings, and not opposites.
منابع مشابه
Integration System based on both GAV and LAV query processing approaches
Data Integration is the process of combining data residing at different sources with associated local schemas to form a single virtual database with an associated global schema [1, 2]. This is to provide the user with a uniform query interface for multiple independent heterogeneous data sources [3, 4]. There are four main approaches of data integration. They are Global As view (GAV), Local As V...
متن کاملCombining the Best of Global-as-View and Local-as-View for Data Integration
Currently, there are two main basic approaches to data integration: Global-as-View (GaV) and Local-as-View (LaV). However, both GaV and LaV have their limitations. In a GaV approach, changes in information sources or adding a new information source requires revisions of a global schema and mappings between the global schema and source schemas. In a LaV approach, automating query reformulation h...
متن کاملData Integration by Bi-Directional Schema Transformation Rules
This paper presents a new approach to data integration which combines the previous approaches of local as view LAV and global as view GAV into a single method we term both as view BAV Our method is based on the use of reversible transforma tion sequences and combines the re spective advantages of GAV and LAV In particular in common with GAV querying processing on a global schema is simply a mat...
متن کاملOn the Expressive Power of Data Integration Systems
There are basically two approaches for designing a data integration system. In the global-as-view (GAV) approach, one maps the concepts in the global schema to views over the sources, whereas in the local-as-view (LAV) approach, one maps the sources into views over the global schema. The goal of this paper is to relate the two approaches with respect to their expressive power. The analysis is c...
متن کاملSurvey on methods for query rewriting and query answering using views
A Data Integration System is constituted by three main components: source schemas, a global schema and a mapping between the two. There exist two main approaches for specifying the mapping: in the local-as-view (LAV) approach the source structures are defined as views over the global schema; on the contrary in the global-as-view (GAV) approach each global concept is defined in terms of a view o...
متن کامل