View indexing in relational databases
ACM Transactions on Database Systems (TODS)
ACM Computing Surveys (CSUR)
Materialized view selection and maintenance using multi-query optimization
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Rewriting OLAP Queries Using Materialized Views and Dimension Hierarchies in Data Warehouses
Proceedings of the 17th International Conference on Data Engineering
fAST Refresh using Mass Query Optimization
Proceedings of the 17th International Conference on Data Engineering
A Scalable Algorithm for Answering Queries Using Views
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Automated Selection of Materialized Views and Indexes in SQL Databases
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Answering Queries with Aggregation Using Views
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Evaluation of Materialized View Indexing in Data Warehousing Environments
DaWaK 2000 Proceedings of the Second International Conference on Data Warehousing and Knowledge Discovery
Answering queries using views: A survey
The VLDB Journal — The International Journal on Very Large Data Bases
Transaction support for indexed summary views
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Selection of Views to Materialize in a Data Warehouse
IEEE Transactions on Knowledge and Data Engineering
Rewriting XPath queries using materialized views
VLDB '05 Proceedings of the 31st international conference on Very large data bases
Query evaluation using overlapping views: completeness and efficiency
Proceedings of the 2006 ACM SIGMOD international conference on Management of data
View matching for outer-join views
The VLDB Journal — The International Journal on Very Large Data Bases
View-based query processing: On the relationship between rewriting, answering and losslessness
Theoretical Computer Science
Computing queries from derived relations
VLDB '85 Proceedings of the 11th international conference on Very Large Data Bases - Volume 11
Exact and inexact methods for selecting views and indexes for OLAP performance improvement
EDBT '08 Proceedings of the 11th international conference on Extending database technology: Advances in database technology
The Computer Journal
Answering Keyword Queries on XML Using Materialized Views
ICDE '08 Proceedings of the 2008 IEEE 24th International Conference on Data Engineering
Data mining-based materialized view and index selection in data warehouses
Journal of Intelligent Information Systems
CORADD: correlation aware database designer for materialized views and indexes
Proceedings of the VLDB Endowment
Efficient processing of monotonic linear progressive queries via dynamic materialized views
Proceedings of the 2010 Conference of the Center for Advanced Studies on Collaborative Research
A materialized-view based technique to optimize progressive queries via dependency analysis
Proceedings of the 2011 Conference of the Center for Advanced Studies on Collaborative Research
Deferred maintenance of indexes and of materialized views
DNIS'11 Proceedings of the 7th international conference on Databases in Networked Information Systems
Hi-index | 0.00 |
Progressive queries (PQ) are a new type of query emerged from numerous data intensive applications. A user formulates a PQ in several steps using a set of inter-related step-queries (SQ). Efficiently processing PQs in a DBMS is crucial in supporting these applications. In our previous work, we introduced a materialized view based approach to efficiently processing PQs, where our focus was on selection of promising materialized views. The problem of how to efficiently find usable views to answer SQs for a PQ remained open. In this paper, we present a new index technique, which is called the dynamic materialized view index (DMVI), to rapidly discover usable views to answer a given SQ. The structure of the index and the strategies to construct, maintain and use the DMVI are discussed. The Experimental results demonstrate that our technique is quite promising in improving the performance of the materialized view based query processing for PQs.