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 …

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 …

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 …

Graph cube: on warehousing and OLAP multidimensional networks

P Zhao, X Li, D Xin, J Han - Proceedings of the 2011 ACM SIGMOD …, 2011 - dl.acm.org
We consider extending decision support facilities toward large sophisticated networks, upon
which multidimensional attributes are associated with network entities, thereby forming the …

A formal perspective on the view selection problem

R Chirkova, AY Halevy, D Suciu - The VLDB Journal, 2002 - Springer
The view selection problem is to choose a set of views to materialize over a database
schema, such that the cost of evaluating a set of workload queries is minimized and such …

Index selection for databases: A hardness study and a principled heuristic solution

S Chaudhuri, M Datar… - IEEE transactions on …, 2004 - ieeexplore.ieee.org
We study the index selection problem: Given a workload consisting of SQL statements on a
database, and a user-specified storage constraint, recommend a set of indexes that have the …

OLAP-технологии: обзор решаемых задач и исследований

Ю Кудрявцев - Бизнес-информатика, 2008 - cyberleninka.ru
OLAP-технологии: обзор решаемых задач и исследований – тема научной статьи по
компьютерным и информационным наукам читайте бесплатно текст научно-исследовательской …

View selection using randomized search

P Kalnis, N Mamoulis, D Papadias - Data & Knowledge Engineering, 2002 - Elsevier
An important issue in data warehouse development is the selection of a set of views to
materialize in order to accelerate On-line analytical processing queries, given certain space …

A case for dynamic view management

Y Kotidis, N Roussopoulos - ACM Transactions on Database Systems …, 2001 - dl.acm.org
Materialized aggregate views represent a set of redundant entities in a data warehouse that
are frequently used to accelerate On-Line Analytical Processing (OLAP). Due to the complex …