On the computation of relational view complements
Open Access
- 1 June 2003
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 28 (2) , 175-208
Abstract
Views as a means to describe parts of a given data collection play an important role in many database applications. In dynamic environments where data is updated, not only information provided by views, but also information provided by data sources yet missing from views turns out to be relevant: Previously, this missing information has been characterized in terms of view complements ; recently, it has been shown that view complements can be exploited in the context of data warehouses to guarantee desirable warehouse properties such as independence and self-maintainability. As the complete source information is a trivial complement for any view, a natural interest for "small" or even "minimal" complements arises. However, the computation of minimal complements is still not very well understood. In this article, it is shown how to compute reasonably small (and in special cases even minimal) complements for a large class of relational views.Keywords
This publication has 12 references indexed in Scilit:
- Lineage tracing for general data warehouse transformationsThe VLDB Journal, 2003
- Monotonic complements for independent data warehousesThe VLDB Journal, 2001
- A methodological framework for data warehouse design1998
- Unique complements and decompositions of database schemataJournal of Computer and System Sciences, 1994
- Updates of Relational ViewsJournal of the ACM, 1984
- On complementary and independent mappings on databases1984
- Update semantics of relational viewsACM Transactions on Database Systems, 1981
- Computable queries for relational data basesJournal of Computer and System Sciences, 1980
- Equivalences Among Relational Expressions with the Union and Difference OperatorsJournal of the ACM, 1980
- Universality of data retrieval languages1979