首页> 外文期刊>Programming and Computer Software >Synchronous incremental update of materialized views for PostgreSQL
【24h】

Synchronous incremental update of materialized views for PostgreSQL

机译:PostgreSQL的物化视图的同步增量更新

获取原文
获取原文并翻译 | 示例

摘要

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.
机译:物化视图在面向SQL的数据库中在逻辑上是多余的存储查询结果。这项技术可以显着提高数据库系统的性能。尽管物化视图的想法是在1980年代提出的,但到目前为止,只有三个数据库管理系统,即DB2,Oracle,SQL Server,已经成功地完全开发了物化视图。障碍在于构建一个模块,该模块可以自动增量更新实例化视图,该模块对应于基表中的数据更改。本文提出了一种算法,该算法通过内部联接来增量更新实例化视图,着重于具有聚合功能的实例,并构建一个程序,该程序将自动在PL / pgSQL中生成用于触发器的代码,该程序可以对PostgreSQL中的实例化视图进行同步增量更新。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号