Materialized views

R Chirkova, J Yang - Foundations and Trends® in …, 2012 - nowpublishers.com
Materialized views are queries whose results are stored and maintained in order to facilitate
access to data in their underlying base tables. In the SQL setting, they are now considered a …

Materialized view maintenance: issues, classification, and open challenges

A Sebaa, A Tari - International Journal of Cooperative Information …, 2019 - World Scientific
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 …

Incremental view maintenance over array data

W Zhao, F Rusu, B Dong, K Wu, P Nugent - Proceedings of the 2017 …, 2017 - dl.acm.org
Science applications are producing an ever-increasing volume of multi-dimensional data
that are mainly processed with distributed array databases. These raw arrays …

Frequency-adaptive join for shared nothing machines

M Bamha, G Hains - Progress in computer research, 2001 - books.google.com
Although many skew-handling algorithms have been proposed for simple join operations,
they remain generally inefficient in the case of e-join and in the case of multi-join. A new …

An optimal skew-insensitive join and multi-join algorithm for distributed architectures

M Bamha - Database and Expert Systems Applications: 16th …, 2005 - Springer
The development of scalable parallel database systems requires the design of efficient
algorithms for the join operation which is the most frequent and expensive operation in …

System, method, and computer-readable medium for dynamic detection and management of data skew in parallel join operations

Y Xu, P Kostamaa, M Sirek - US Patent 7,941,424, 2011 - Google Patents
BACKGROUND A database is a collection of stored data that is logically related and that is
accessible by one or more users or appli cations. A popular type of database is the relational …

Semantics of an exception mechanism for bulk synchronous parallel ml

L Gesbert, F Loulergue - Eighth International Conference on …, 2007 - ieeexplore.ieee.org
Bulk Synchronous Parallel ML is a high-level language for programming parallel algorithms.
Built upon OCaml and using the BSP model, it provides a safe setting for their …

[PDF][PDF] Semantics and implementation of minimally synchronous parallel ML

F Loulergue, F Gava, M Arapinis, F Dabrowski - International Journal of …, 2004 - lacl.fr
This paper presents a new functional parallel language: Minimally Synchronous Parallel ML
(MSPML). The execution time can be estimated, dead-locks and indeterminism are avoided …

Correction strategy for view maintenance anomaly after schema and data updating concurrently

Z Shu, S Li, Y Zuo, X Zhou… - Proceedings of the Ninth …, 2005 - ieeexplore.ieee.org
During maintaining the materialized view in the data warehouse, how to efficiently handle
the concurrent updates is an important and intractable problem. The paper discusses typical …

Parallel Maintenance of Materialized Views in Large-Scale Analytic Platforms

A Sebaa - International Journal of Organizational and Collective …, 2022 - igi-global.com
Speeding up queries processing is an important issue in database management.
Materialized views are largely used to address this issue. They have been proven …