We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Toward Implementing Incremental View Maintenance on PostgreSQL

Formale Metadaten

Titel
Toward Implementing Incremental View Maintenance on PostgreSQL
Serientitel
Anzahl der Teile
35
Autor
Lizenz
CC-Namensnennung 3.0 Unported:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen.
Identifikatoren
Herausgeber
Erscheinungsjahr
Sprache

Inhaltliche Metadaten

Fachgebiet
Genre
Abstract
Incremental View Maintenance (IVM) is a technique to maintain materialized views which computes and applies only the incremental changes to the materialized views to make refresh more efficient, but this is not implemented on PostgreSQL yet. In this talk, we will discuss what is necessary to implement IVM and our idea about the first version of IVM implementation on PostgreSQL. PostgreSQL has supported materialized views since 9.3. This feature is used to speed up query evaluation by storing the results of specified queries. One problem of materialized view is its maintenance. Materialized views have to be brought up to date when the underling base relations are updated. Incremental View Maintenance (IVM) is a technique to maintain materialized views which computes and applies only the incremental changes to the materialized views rather than recomputing the contents as the current REFRESH command does. This feature is not implemented on PostgreSQL yet. In this talk, after introducing some studies and discussions about IVM including our PoC (Proof of Concept) implementation, we will discuss what is necessary to implement this on PostgreSQL. For example, we have to decide how to extract changes on base tables, how to compute the delta to be applied to materialized views, when to maintain materialized views, and so on. Also, I will show our idea about the first version of IVM implementation on PostgreSQL.