A new solution for asynchronous incremental maintenance of materialized views

Nguyen Tran Quoc Vinn, Tran Trong Nhan, Le Van Khanh, Tran Dang Hung, Abeer Alsadoon, PW Chandana Prasad, Pham Duong Thu Hang

Research output: Contribution to journalArticlepeer-review

42 Downloads (Pure)


Materialized views can help improve query execution speed dramatically using full or part of stored precalculated query results. Incremental maintenance takes materialized views up-to-date adjusting them accordingly to the changes in related base tables. It is often more effective than a full refresh replacing materialized view tables by the new query execution result. Asynchronous maintenance, which brings the materialized views to the actual state, is not a constituent of the transaction making changes in the base tables. Most of the published works are dedicated to synchronous incremental updating of views, algorithms for which require accessing the pre-update state of base tables and cannot be applied directly to asynchronous updates which are performed on the post-update state. A few works are devoted to asynchronous maintenance of views, either restrict changes in only one of base tables or assume there is only one base table, which is impractical, either is wrong, either provides too high level and complex incremental update algorithms or can be implemented only if the database management system supports data versioning at the table and row levels. In this paper, we propose a solution for the asynchronous incremental update of views which can be implemented with any database management systems. We collect changes in base tables, access the pre-update state of base tables exploiting the condensing process and apply the pre-update incremental maintenance algorithms for asynchronous maintenance on the post-update state of base tables considering the specifics of asynchronous maintenance. It is applicable for SPJ queries with inner joins, queries with inner joins and aggregations. We also build a prototype and provide experiments on automatic generating source codes in C to collect changes in base tables and to perform the asynchronous incremental update of materialized views in PostgreSQL

Original languageEnglish
Pages (from-to)6-13
Number of pages8
JournalEastern-European Journal of Enterprise Technologies
Issue number103
Publication statusPublished - Feb 2020


Dive into the research topics of 'A new solution for asynchronous incremental maintenance of materialized views'. Together they form a unique fingerprint.

Cite this