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

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

Materialized views are excessively stored query execution results in the database. They can be used to partially or completely answer queries which will be further appeared instead of re-executing query from the scratch. There is a large number of published works that address the maintenance, especi...

Full description

Bibliographic Details
Main Authors: Nguyen Tran Quoc Vinh, Dang Thanh Hao, Pham Duong Thu Hang, Abeer Alsadoon, PW Chandana Prasad, Nguyen Viet Anh
Format: Article
Language:English
Published: PC Technology Center 2019-10-01
Series:Eastern-European Journal of Enterprise Technologies
Subjects:
materialized view
sql recursive query
cte
incremental update
source code generating
Online Access:http://journals.uran.ua/eejet/article/view/180226

Internet

http://journals.uran.ua/eejet/article/view/180226

Similar Items