A solution for synchronous incremental maintenance of materialized views based on SQL recursive query

Abstract

6 aggregate functions. There is also a special type of query called recursive query. In SQL, it goes with Common Table Expression (CTE). There is the kind of view as virtual by default because the query that the view is based on will be executed from the scratch each time when the view is accessed. The query

A new solution for asynchronous incremental maintenance of materialized views

“…Most of the works are devoted to the synchronous incremental update [2][3][4][5][6][7], a little number of them are dedicated to the asynchronous incremental update of MV [8][9][10]. The works [5,11] build and provide experiments on triggers in programming languages PL/pgSQL and C, implementing the same incremental update algorithms in a synchronous manner on the same MV based on the same query with the same base tables with the clustered indices on primary keys and foreign keys.…”

“…The work [5] suggests a sequence of optimizations to the incremental update algorithm relative to [11]. The work [2] proposes a solution for synchronous incremental of recursive materialized view based on SQL query. Although it may be more effective if the incremental update code is embedded into a database management system, solution using triggers has its advantages because it is almost independent of database management system versions and has higher mobility.…”

“…The source code in C is synthesized similarly as in the works [2,5], will be compiled and linked, then saved in the form of dynamic link library (.dll). The MV manager uses generated SQL script and compiled trigger functions code in .dll to register trigger.…”