Materialized View Maintenance: Issues, Classification, and Open Challenges

Views materialization is a powerful technique for optimization of query evaluation. However, when data sources are updated, these materialized views (MVs) should be maintained in order to get appropriate queries’ answers. This work provides an overview of the research field of view maintenance, focusing on view maintenance issues and dimensions that cover the most important ones proposed in the literature review. We provide a classification and review the state-of-the-art of view maintenance approaches according to several parameters characterizing their algorithms, including information considered during the view maintenance process, principle used, and the execution mechanism. We provide the most important performance evaluation metrics of view maintenance process while performing a comparative study of some important approaches. Lastly, we give comprehensive perspectives on view maintenance in the different promising environments of MV applications.