An Incremental View Maintenance Approach Using Version Store in Warehousing Environment

Data warehouse is a repository of information collected from multiple, possibly heterogeneous, autonomous and distributed databases. The information stored in the warehouse is in the form of materialized views. In data warehouses materialized views are used to pre-compute and store aggregated data such as sums and averages. Materialized views are the derived relation, which are stored as the relation in the database, when some update occurs in the parent relation all its child relations also gets updated by viewing to maintain the consistency and convergence [3]of the database. In this paper we present a new method of incremental view maintenance with the inclusion of some existing approaches [2][3]. We utilized the concept of version store [2] for older versions of tables that have been updated at the source.