Answering queries using views: A survey

AY Halevy - The VLDB Journal, 2001 - Springer
The problem of answering queries using views is to find efficient methods of answering a
query using a set of previously defined materialized views over the database, rather than …

A survey of view selection methods

I Mami, Z Bellahsene - Acm Sigmod Record, 2012 - dl.acm.org
Materialized view selection is a critical problem in many applications such as query
processing, data warehousing, distributed and semantic web databases, etc. We refer to the …

Database meets artificial intelligence: A survey

X Zhou, C Chai, G Li, J Sun - IEEE Transactions on Knowledge …, 2020 - ieeexplore.ieee.org
Database and Artificial Intelligence (AI) can benefit from each other. On one hand, AI can
make database more intelligent (AI4DB). For example, traditional empirical database …

[PDF][PDF] Automated selection of materialized views and indexes in SQL databases

S Agrawal, S Chaudhuri, VR Narasayya - VLDB, 2000 - cse.iitb.ac.in
Automatically selecting an appropriate set of materialized views and indexes for SQL
databases is a non-trivial task. A judicious choice must be cost-driven and influenced by the …

Selection of views to materialize in a data warehouse

H Gupta - Database Theory—ICDT'97: 6th International …, 1997 - Springer
A data warehouse stores materialized views of data from one or more sources, with the
purpose of efficiently implementing decision-support or OLAP queries. One of the most …

Efficient OLAP operations in spatial data warehouses

D Papadias, P Kalnis, J Zhang, Y Tao - … Redondo Beach, CA, USA, July 12 …, 2001 - Springer
Spatial databases store information about the position of individual objects in space. In
many applications however, such as traffic supervision or mobile communications, only …

Designing data marts for data warehouses

C Ghezzi - ACM Transactions on Software Engineering and …, 2001 - dl.acm.org
Data warehouses are databases devoted to analytical processing. They are used to support
decision-making activities in most modern business settings, when complex data sets have …

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 …

Selection of views to materialize in a data warehouse

H Gupta, IS Mumick - IEEE Transactions on Knowledge and …, 2005 - ieeexplore.ieee.org
A data warehouse stores materialized views of data from one or more sources, with the
purpose of efficiently implementing decision-support or OLAP queries. One of the most …

Materialized view selection and maintenance using multi-query optimization

H Mistry, P Roy, S Sudarshan… - Proceedings of the 2001 …, 2001 - dl.acm.org
Materialized views have been found to be very effective at speeding up queries, and are
increasingly being supported by commercial databases and data warehouse systems …