Efficiently updating materialized views
SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
View maintenance in a warehousing environment
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
Building the data warehouse (2nd ed.)
Building the data warehouse (2nd ed.)
Making aggregate views self-maintainable
Data & Knowledge Engineering
Making views self-maintainable for data warehousing
DIS '96 Proceedings of the fourth international conference on on Parallel and distributed information systems
A case for dynamic view management
ACM Transactions on Database Systems (TODS)
Incremental Recomputation of Active Relational Expressions
IEEE Transactions on Knowledge and Data Engineering
An Improved Algorithm for the Incremental Recomputation of Active Relational Expressions
IEEE Transactions on Knowledge and Data Engineering
Multiple-View Self-Maintenance in Data Warehousing Environments
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
On the Independence of Data Warehouse from Databases in Maintaining Join Views
DaWaK '99 Proceedings of the First International Conference on Data Warehousing and Knowledge Discovery
Managing Time Consistency for Active Data Warehouse Environments
DaWaK '01 Proceedings of the Third International Conference on Data Warehousing and Knowledge Discovery
LeedsCQ: A Scalable Continual Queries System
DEXA '02 Proceedings of the 13th International Conference on Database and Expert Systems Applications
Monotonic complements for independent data warehouses
The VLDB Journal — The International Journal on Very Large Data Bases
On-Line Analytical Processing on Large Databases Managed by Computational Grids
DEXA '04 Proceedings of the Database and Expert Systems Applications, 15th International Workshop
Constructing search spaces for materialized view selection
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Selection of Views to Materialize in a Data Warehouse
IEEE Transactions on Knowledge and Data Engineering
Evaluating maintenance policies for externally materialised multi-source views
BNCOD'03 Proceedings of the 20th British national conference on Databases
Exploitation of referential integrity constraints for efficient update of data warehouse views
BNCOD'05 Proceedings of the 22nd British National conference on Databases: enterprise, Skills and Innovation
Efficiently compressing OLAP data cubes via R-tree based recursive partitions
ISMIS'12 Proceedings of the 20th international conference on Foundations of Intelligent Systems
| Hi-index | 0.00 |
Data warehouse (DW) views provide an efficient access to information integrated from source data. When changes are made to the source data, the corresponding views may be outdated. Thus, the maintenance of DW views is crucial for the currency of information. Recently, a method was proposed to use referential integrity differential files (RIDFs) to self-maintain DW views that contain select-project-joins over relations modelled in a star schema. However, it is not uncommon for applications to have relations that are modelled in other schemas such as a snowflake schema or a galaxy schema. In this paper, we generalise the concept of RIDFs; we propose a method that uses generalised RIDFs to self-maintain the DW views that contain joins over relations modelled in the star schema as well as non-star schemas. Our method computes new views by using only the old materialised views and files that keep the truly relevant tuples in the “delta”. Consequently, it avoids accessing the underlying source data, and hence leads to efficient update of DW views.