Optimal update policies for distributed materialized views
Management Science
Implementing data cubes efficiently
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Data & Knowledge Engineering
Materialized view selection under the maintenance time constraint
Data & Knowledge Engineering
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
View selection for designing the global data warehouse
Data & Knowledge Engineering - Data warehousing
View selection using randomized search
Data & Knowledge Engineering
Currency-Based Updates to Distributed Materialized Views
Proceedings of the Sixth International Conference on Data Engineering
Concurrency Control Theory for Deferred Materialized Views
ICDT '97 Proceedings of the 6th International Conference on Database Theory
Selection of Views to Materialize in a Data Warehouse
ICDT '97 Proceedings of the 6th International Conference on Database Theory
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Algorithms for Materialized View Design in Data Warehousing Environment
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
A Framework for Designing Materialized Views in Data Warehousing Environment
ICDCS '97 Proceedings of the 17th International Conference on Distributed Computing Systems (ICDCS '97)
Incremental data integration based on hierarchical metadata registry with data visibility
Information Sciences: an International Journal
Selection of Views to Materialize in a Data Warehouse
IEEE Transactions on Knowledge and Data Engineering
Building the Data Warehouse
Information Sciences: an International Journal
Probability, Statistics, and Queueing Theory with Computer Science Applications
Probability, Statistics, and Queueing Theory with Computer Science Applications
Introduction to Probability Models, Ninth Edition
Introduction to Probability Models, Ninth Edition
Data warehouse enhancement: A semantic cube model approach
Information Sciences: an International Journal
A cubic-wise balance approach for privacy preservation in data cubes
Information Sciences: an International Journal
Attribute value reordering for efficient hybrid OLAP
Information Sciences: an International Journal
An evolutionary approach to materialized views selection in a datawarehouse environment
IEEE Transactions on Systems, Man, and Cybernetics, Part C: Applications and Reviews
A/sup */ search: an efficient and flexible approach to materialized view selection
IEEE Transactions on Systems, Man, and Cybernetics, Part C: Applications and Reviews
Fuzzy random renewal reward process and its applications
Information Sciences: an International Journal
Extending OCL for OLAP querying on conceptual multidimensional models of data warehouses
Information Sciences: an International Journal
An efficient method for maintaining data cubes incrementally
Information Sciences: an International Journal
XML materialized views and schema evolution in VIREX
Information Sciences: an International Journal
Dynamic View Management System for Query Prediction to View Materialization
International Journal of Data Warehousing and Mining
Hi-index | 0.07 |
Data warehouses are built to reply query searches efficiently from integrated data of various systems. To improve the performance of the system, the issue of materializing views within data warehouses must be explored. This involves to pre-compute a set of selected views which are fact and dimension tables, under given resource and quality constraints. The quality constraints include query processing time, data maintenance time and the freshness of data when queries are placed. Then there is the policy of updating, which treats the time issue of data reloading in data warehouses. A model is proposed to determine the view selection and update policy when the arrival of queries follows Poisson processes with the constraints of system response time, storage space and query dependent currency of data (on systems capable of periodic and query-triggered updates). To the best of the researchers' knowledge, no other research has considered all these factors in their models. A two-phase greedy algorithm was developed to determine the optimal update policy for the view selection problem. Numerous experiments were performed to explore the sensitivity of the proposed model under various constraints and system parameter settings. The results show that the model has reasonable responses to the tunings and that the proposed algorithm can rapidly find acceptable solutions.