Synchronous incremental update of materialized views for PostgreSQL

详细信息    查看全文

• 作者：Nguyen Tran Quoc Vinh
• 关键词：materialized views ; synchronous incremental updates ; triggers ; automatic synthesis of source code ; PostgreSQL
• 刊名：Programming and Computer Software
• 出版年：2016
• 出版时间：September 2016
• 年：2016
• 卷：42
• 期：5
• 页码：307-315
• 全文大小：159 KB
• 刊物类别：Computer Science
• 刊物主题：Computer Science, general
  Software Engineering, Programming and Operating Systems
  Operating Systems
  Software Engineering
  Artificial Intelligence and Robotics
  Russian Library of Science
  
• 出版者：MAIK Nauka/Interperiodica distributed exclusively by Springer Science+Business Media LLC.
• ISSN：1608-3261
• 卷排序：42

文摘

Materialized views are logically excess stored query results in SQL-oriented databases. This technology can significantly improve the performance of database systems. Although the idea of materialized views came up in the 1980s, only three database management systems, i.e. DB2, Oracle, SQL Server, have been successfully developed completely enough with materialized views so far. The barrier lies in building a module that can incrementally update the materialized views automatically, which corresponds to data changes in the base tables. This paper presents the algorithm to incrementally update the materialized views with inner join, focusing on one with aggregate functions, and building of a program that automatically generates codes inPL/pgSQL for triggers, which can undertake synchronous incremental updates of the materialized views in PostgreSQL.