Data integration using self-maintainable views

Abstract

In this paper we define the concept of self-maintainable views — these are views that can be maintained using only the contents of the view and the database modifications, without accessing any of the underlying databases. We derive tight conditions under which several types of select-project-join are self-maintainable upon insertions, deletions and updates. Self-Maintainability is a desirable property for efficiently maintaining large views in applications where fast response and high availability are important. One example of such an environment is data warehousing wherein views are used for integrating data from multiple databases.