Related Communities:

• Moscow ACM SIGMOD Chapter
• ADBIS
• RCDL
• RVO
• Ontological Modeling

Перспективные методы реализации инкрементального обновления материализованных представлений в современных реляционных системах управления базами данных

Author(s):	Ступников С. А., Скворцов Н. А., Брюхов Д. О.
Published:	Системы и средства информатики, 2025. Т. 35. Вып. 1. С. 95–110.
Abstract:
The paper reviews advanced methods for implementing incremental view maintenance in academic and industrial relational database management systems (DBMS). The main directions of materialized views application, the general statement of the incremental maintenance problem, classic methods for view maintenance, basic industrial implementations in the most common DBMS, implementations in modern DBMS, and their distinguishing features are considered. The main directions of academic research, their differences in the problem statement, subsets of the view definition language, and practical or theoretical orientation are considered. Practical-oriented investigations improve industrial DBMS and perform an experimental evaluation of the approach with various scaling options. Theoretical investigations focus on the subsets of the view definition language for which the best update strategies are possible and on the formal proof of the complexity of algorithms. The most andromising methods and ways of implementation in modern DBMS are distinguished.
Download: