Maintenance of data cubes and summary tables in a warehouse
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Efficient view maintenance at data warehouses
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Partitioned auxiliary views for self-maintainable data warehouse
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
Design and selection of materialized views in a data warehousing environment: a case study
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Self maintenance of multiple views in data warehousing
Proceedings of the eighth international conference on Information and knowledge management
Obsolescent materialized views in query processing of enterprise information systems
Proceedings of the eighth international conference on Information and knowledge management
Efficient refreshment of materialized views with multiple sources
Proceedings of the eighth international conference on Information and knowledge management
How to roll a join: asynchronous incremental view maintenance
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
Incremental Design of a Data Warehouse
Journal of Intelligent Information Systems - Data warehousing and knowledge discovery
A general framework for the view selection problem for data warehouse design and evolution
Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP
Tracing the lineage of view data in a warehousing environment
ACM Transactions on Database Systems (TODS)
Materialized view selection and maintenance using multi-query optimization
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Models and issues in data stream systems
Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Characterizing memory requirements for queries over continuous data streams
Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Discovering interesting inclusion dependencies: application to logical database tuning
Information Systems - Databases: Creation, management and utilization
Continuous queries over data streams
ACM SIGMOD Record
Aggregate Queries Over Conditional Tables
Journal of Intelligent Information Systems
View Maintenance and Analytical Processing at Data Warehouses
DNIS '00 Proceedings of the International Workshop on Databases in Networked Information Systems
Temporal View Self-Maintenance
EDBT '00 Proceedings of the 7th International Conference on Extending Database Technology: Advances in Database Technology
VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Issues in Developing Very Large Data Warehouses
VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Revisit on View Maintenance in Data Warehouses
WAIM '01 Proceedings of the Second International Conference on Advances in Web-Age Information Management
Multiple-View Self-Maintenance in Data Warehousing Environments
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Designing the Global Data Warehouse with SPJ Views
CAiSE '99 Proceedings of the 11th International Conference on Advanced Information Systems Engineering
Materialized View Maintenance Using Version Numbers
DASFAA '99 Proceedings of the Sixth International Conference on Database Systems for Advanced Applications
A Transactional Model for Data Warehouse Maintenance
ER '02 Proceedings of the 21st International Conference on Conceptual Modeling
Detecting Redundancy in Data Warehouse Evolution
ER '99 Proceedings of the 18th International Conference on Conceptual Modeling
A Randomized Approach for the Incremental Design of an Evolving Data Warehouse
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
Data Warehouse Design and Maintenance through View Normalization
DEXA '99 Proceedings of the 10th International Conference on Database and Expert Systems Applications
LeedsCQ: A Scalable Continual Queries System
DEXA '02 Proceedings of the 13th International Conference on Database and Expert Systems Applications
Self-maintainable Data Warehouse Views Using Differential Files
DEXA '02 Proceedings of the 13th International Conference on Database and Expert Systems Applications
Maintaining Materialized Views for Data Warehouses with Multiple Remote Sources
WAIM '00 Proceedings of the First International Conference on Web-Age Information Management
Monotonic complements for independent data warehouses
The VLDB Journal — The International Journal on Very Large Data Bases
On the computation of relational view complements
ACM Transactions on Database Systems (TODS)
Data warehousing: data cleaning and loading
Handbook of data mining and knowledge discovery
Aggregate view management in data warehouses
Handbook of massive data sets
Some issues in design of data warehousing systems
Data warehousing and web engineering
QC-trees: an efficient summary structure for semantic OLAP
Proceedings of the 2003 ACM SIGMOD international conference on Management of data
InterBase-KB: Integrating a Knowledge Base System with a Multidatabase System for Data Warehousing
IEEE Transactions on Knowledge and Data Engineering
DOLAP '03 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP
Journal of Computer Science and Technology
Parallel multisource view maintenance
The VLDB Journal — The International Journal on Very Large Data Bases
DSD: maintain data cubes more efficiently
Fundamenta Informaticae - Special issue on the 9th international conference on rough sets, fuzzy sets, data mining and granular computing (RSFDGrC 2003)
K2/Kleisli and GUS: experiments in integrated access to genomic data sources
IBM Systems Journal - Deep computing for the life sciences
Multiversion-based view maintenance over distributed data sources
ACM Transactions on Database Systems (TODS)
Asymmetric Batch Incremental View Maintenance
ICDE '05 Proceedings of the 21st International Conference on Data Engineering
Adaptive Caching for Continuous Queries
ICDE '05 Proceedings of the 21st International Conference on Data Engineering
Simultaneous scalability and security for data-intensive web applications
Proceedings of the 2006 ACM SIGMOD international conference on Management of data
Incremental maintenance of aggregate and outerjoin expressions
Information Systems
Research in data warehouse modeling and design: dead or alive?
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Load balancing and data placement for multi-tiered database systems
Data & Knowledge Engineering
Optimal Synchronization Policies for Data Warehouses
INFORMS Journal on Computing
Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Answering ad hoc aggregate queries from data streams using prefix aggregate trees
Knowledge and Information Systems
Incremental maintenance for non-distributive aggregate functions
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Improving parallelism of federated query processing
Data & Knowledge Engineering
International Journal of Computational Science and Engineering
End-to-end support for joins in large-scale publish/subscribe systems
Proceedings of the VLDB Endowment
Content-based filtering for efficient online materialized view maintenance
Proceedings of the 17th ACM conference on Information and knowledge management
Asynchronous view maintenance for VLSD databases
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
Evaluating maintenance policies for externally materialised multi-source views
BNCOD'03 Proceedings of the 20th British national conference on Databases
Adapting materialized views after redefinition in distributed environments
ER'00 Proceedings of the 19th international conference on Conceptual modeling
Online, non-blocking relational schema changes
EDBT'06 Proceedings of the 10th international conference on Advances in Database Technology
Using schema transformation pathways for incremental view maintenance
DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
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
Efficient update of data warehouse views with generalised referential integrity differential files
BNCOD'06 Proceedings of the 23rd British National Conference on Databases, conference on Flexible and Efficient Information Handling
Multi-source materialized views maintenance: multi-level views
ADBIS'06 Proceedings of the 10th East European conference on Advances in Databases and Information Systems
Non-blocking materialized view creation and transformation of schemas
ADBIS'06 Proceedings of the 10th East European conference on Advances in Databases and Information Systems
A survey of view selection methods
ACM SIGMOD Record
A comprehensive study of view maintenance approaches in data warehousing evolution
ACM SIGSOFT Software Engineering Notes
Challenges and conflicts integrating heterogeneous data warehouses in virtual organisations
International Journal of Networking and Virtual Organisations
DSD: Maintain Data Cubes More Efficiently
Fundamenta Informaticae - The 9th International Conference on Rough Sets, Fuzzy Sets, Data Mining and Granular Conputing (RSFDGrC 2003)
Database support for processing complex aggregate queries over data streams
Proceedings of the Joint EDBT/ICDT 2013 Workshops
Exploring optimization and caching for efficient collection operations
Automated Software Engineering
Hi-index | 0.00 |
A data warehouse stores materialized views over data from one or more sources in order to provide fast access to the integrated data, regardless of the availability of the data sources. Warehouse views need to be maintained in response to changes to the base data in the sources. Except for very simple views, maintaining a warehouse view requires access to data that is not available in the view itself. Hence, to maintain the view, one either has to query the data sources or store auxiliary data in the warehouse. We show that by using key and referential integrity constraints, we often can maintain a select-project-join view without going to the data sources or replicating the base relations in their entirety in the warehouse. We derive a set of auxiliary views together are self-maintainable—they can be maintained without going to the data sources or replicating all base data. In addition, our technique can be applied to simplify traditional materialized view maintenance by exploiting key and referential integrity constraints.