Incremental Maintenance of Aggregate Views

We propose an algorithm called CReaM to incrementally maintain materialized aggregate views with user-defined aggregates in response to changes to the database tables from which the view is derived. CReaM is optimal and guarantees the self-maintainability of aggregate views that are defined over a single database table. For aggregate views that are defined over multiple database tables and do not contain all of the non-aggregated attributes in the database tables, CReaM speeds up the time taken to update a view as compared to prior view maintenance techniques. The speed up in the time taken to update a materialized view with n tuples is either $\tfrac{n}{\log n}$ or logn depending on whether the materialized view is indexed or not. For other types of aggregate views, CReaM updates the view in no more time than that is required by prior view maintenance techniques to update the view.

[1]  Inderpal Singh Mumick,et al.  The Stanford Data Warehousing Project , 1995 .

[2]  Inderpal Singh Mumick,et al.  Incremental maintenance of aggregate and outerjoin expressions , 2006, Inf. Syst..

[3]  Volker Küchenhoff.  On the Efficient Computation of the Difference Between Concecutive Database States , 1991, DOOD.

[4]  Erik D. Demaine,et al.  Tight bounds for the partial-sums problem , 2004, SODA '04.

[5]  Jean-Marie Nicolas,et al.  An Outline of BDGEN: A Deductive DBMS , 1983, IFIP Congress.

[6]  Hamid Pirahesh,et al.  Incremental Maintenance for Non-Distributive Aggregate Functions , 2002, VLDB.

[7]  Inderpal Singh Mumick,et al.  Deriving Production Rules For Incremental View Maintenance , 1999 .

[8]  Frank Wm. Tompa,et al.  Efficiently updating materialized views , 1986, SIGMOD '86.

[9]  Salvatore J. Stolfo,et al.  Incremental evaluation of rules and its relationship to parallelism , 1991, SIGMOD '91.

[10]  Inderpal Singh Mumick,et al.  Incremental Maintenance Of Views With Duplicates , 1999 .

[11]  Mukesh K. Mohania,et al.  Making Aggregate Views Self-maintainable , 2000, Data Knowl. Eng..

[12]  Michael L. Fredman,et al.  A Lower Bound on the Complexity of Orthogonal Range Queries , 1981, JACM.

[13]  Inderpal Singh Mumick,et al.  Efficient Maintenance Of Materialized Mediated Views , 1999 .

[14]  Jeffrey D. Ullman,et al.  Principles Of Database And Knowledge-Base Systems , 1979 .

[15]  Eric K. Clemons,et al.  Efficiently monitoring relational databases , 1979, ACM Trans. Database Syst..

[16]  H. V. Jagadish,et al.  Maintenance and Self Maintenance of Outer-Join Views , 1997, NGITS.

[17]  Jeffrey D. Ullman,et al.  Principles of Database and Knowledge-Base Systems, Volume II , 1988, Principles of computer science series.

[18]  John V. Harrison,et al.  Maintenance of Materialized Views in a Deductive Database: An Update Propagation Approach , 1992, Workshop on Deductive Databases, JICSLP.

[19]  Per-Åke Larson,et al.  Updating derived relations: detecting irrelevant and autonomously computable updates , 1986, VLDB.

[20]  V. S. Subrahmanian,et al.  Maintaining views incrementally , 1993, SIGMOD Conference.

[21]  Kenneth A. Ross,et al.  Supporting multiple view maintenance policies , 1997, SIGMOD '97.

[22]  Frank Wm. Tompa,et al.  Maintaining materialized views without accessing base data , 1988, Inf. Syst..

[23]  Alon Itai,et al.  Maintenance of views , 1984, SIGMOD '84.

[24]  Michael Stonebraker,et al.  Implementation of integrity constraints and views by query modification , 1975, SIGMOD '75.

[25]  Inderpal Singh Mumick,et al.  Maintenance of data cubes and summary tables in a warehouse , 1997, SIGMOD '97.

[26]  Gio Wiederhold,et al.  Incremental Recomputation of Active Relational Expressions , 1991, IEEE Trans. Knowl. Data Eng..

[27]  Marilyn Bohl,et al.  Information processing , 1971 .

[28]  Michael L. Fredman,et al.  The Complexity of Maintaining an Array and Computing Its Partial Sums , 1982, JACM.

[29]  Jack Minker,et al.  Logic and Databases: A Deductive Approach , 1984, CSUR.

[30]  Guozhu Dong,et al.  Incremental Evaluation of Datalog Queries , 1992, ICDT.

[31]  Levent V. Orman.  Differential Relational Calculus for Integrity Maintenance , 1998, IEEE Trans. Knowl. Data Eng..

[32]  Nam Huyn.  Efficient View Self-Maintenance , 1996, VIEWS.

[33]  H. V. Jagadish,et al.  Data Integration using Self-Maintainable Views , 1996, EDBT.

[34]  Michael R. Genesereth,et al.  Reformulating Aggregate Queries Using Views , 2013, SARA.

[35]  Dallan Quass,et al.  Maintenance Expressions for Views with Aggregation , 1996, VIEWS.

[36]  Kenneth A. Ross,et al.  Monotonic aggregation in deductive databases , 1992, J. Comput. Syst. Sci..