Automated Selection of Materialized Views and Indexes in SQL Databases

Theory of answering queries using views

ACM SIGMOD Record

Materialized view selection and maintenance using multi-query optimization

SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data

Optimizing queries using materialized views: a practical, scalable solution

SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data

Content integration for e-business

SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data

Materialized view and index selection tool for Microsoft SQL server 2000

SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data

Self-managing technology in IBM DB2 universal database

Proceedings of the tenth international conference on Information and knowledge management

The view-selection problem has an exponential-time lower bound for conjunctive queries and views

Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems

Automating physical database design in a parallel database

Proceedings of the 2002 ACM SIGMOD international conference on Management of data

Toward autonomic computing with DB2 universal database

ACM SIGMOD Record

A formal perspective on the view selection problem

The VLDB Journal — The International Journal on Very Large Data Bases

Rethinking Database System Architecture: Towards a Self-Tuning RISC-Style Database System

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases

Aggregate Maintenance for Data Warehousing in Informix Red Brick Vista

Proceedings of the 27th International Conference on Very Large Data Bases

A Formal Perspective on the View Selection Problem

Proceedings of the 27th International Conference on Very Large Data Bases

User-Optimizer Communication using Abstract Plans in Sybase ASE

Proceedings of the 27th International Conference on Very Large Data Bases

Reengineering of Database Applications to EJB Based Architecture

CAiSE '02 Proceedings of the 14th International Conference on Advanced Information Systems Engineering

Adaptive XML Shredding: Architecture, Implementation, and Challenges

Proceedings of the VLDB 2002 Workshop EEXTT and CAiSE 2002 Workshop DTWeb on Efficiency and Effectiveness of XML Tools and Techniques and Data Integration over the Web-Revised Papers

Characterizing Alert and Browse Services of Mobile Clients

ATEC '02 Proceedings of the General Track of the annual conference on USENIX Annual Technical Conference

A combinatorial algorithm for MAX CSP

Information Processing Letters

Answering queries using views: A survey

The VLDB Journal — The International Journal on Very Large Data Bases

Materializing views with minimal size to answer queries

Proceedings of the twenty-second ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems

Optimal indexing using near-minimal space

Proceedings of the twenty-second ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems

Some issues in design of data warehousing systems

Data warehousing and web engineering

Configuring buffer pools in DB2 UDB

CASCON '02 Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research

Automated data warehousing for rule-based CRM systems

ADC '03 Proceedings of the 14th Australasian database conference - Volume 17

Estimating compilation time of a query optimizer

Proceedings of the 2003 ACM SIGMOD international conference on Management of data

Dynamic sample selection for approximate query processing

Proceedings of the 2003 ACM SIGMOD international conference on Management of data

Materialized views in multidimensional databases

Multidimensional databases

Recent progress on selected topics in database research: a report by nine young Chinese researchers working in the United States

Journal of Computer Science and Technology

The Cougar Project: a work-in-progress report

ACM SIGMOD Record

Optimization in Data Cube System Design

Journal of Intelligent Information Systems

Integrating vertical and horizontal partitioning into automated physical database design

SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data

Index Selection for Databases: A Hardness Study and a Principled Heuristic Solution

IEEE Transactions on Knowledge and Data Engineering

Selection of Views to Materialize in a Data Warehouse

IEEE Transactions on Knowledge and Data Engineering

Views and queries: determinacy and rewriting

Proceedings of the twenty-fourth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems

Supporting executable mappings in model management

Proceedings of the 2005 ACM SIGMOD international conference on Management of data

Stacked indexed views in microsoft SQL server

Proceedings of the 2005 ACM SIGMOD international conference on Management of data

Automatic physical database tuning: a relaxation-based approach

Proceedings of the 2005 ACM SIGMOD international conference on Management of data

Goals and benchmarks for autonomic configuration recommenders

Proceedings of the 2005 ACM SIGMOD international conference on Management of data

Efficient computation of multiple group by queries

Proceedings of the 2005 ACM SIGMOD international conference on Management of data

QPipe: a simultaneously pipelined relational query engine

Proceedings of the 2005 ACM SIGMOD international conference on Management of data

Database tuning advisor for microsoft SQL server 2005: demo

Proceedings of the 2005 ACM SIGMOD international conference on Management of data

ULoad: choosing the right storage for your XML application

VLDB '05 Proceedings of the 31st international conference on Very large data bases

Using Datacube Aggregates for Approximate Querying and Deviation Detection

IEEE Transactions on Knowledge and Data Engineering

Storing XML (with XSD) in SQL Databases: Interplay of Logical and Physical Designs

IEEE Transactions on Knowledge and Data Engineering

COLT: continuous on-line tuning

Proceedings of the 2006 ACM SIGMOD international conference on Management of data

Multiobjective genetic algorithms for materialized view selection in OLAP data warehouses

Proceedings of the 8th annual conference on Genetic and evolutionary computation

Answering queries using materialized views with minimum size

The VLDB Journal — The International Journal on Very Large Data Bases

Holes in joins

Journal of Intelligent Information Systems

To tune or not to tune?: a lightweight physical design alerter

VLDB '06 Proceedings of the 32nd international conference on Very large data bases

Efficient detection of empty-result queries

VLDB '06 Proceedings of the 32nd international conference on Very large data bases

Computing closest common subexpressions for view selection problems

DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP

Query optimization using restructured views

CIKM '06 Proceedings of the 15th ACM international conference on Information and knowledge management

Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more

Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more

Efficient approaches for materialized views selection in a data warehouse

Information Sciences: an International Journal

Optimized stratified sampling for approximate query processing

ACM Transactions on Database Systems (TODS)

Load balancing and data placement for multi-tiered database systems

Data & Knowledge Engineering

Efficient exploitation of similar subexpressions for query processing

Proceedings of the 2007 ACM SIGMOD international conference on Management of data

Self-tuning database technology and information services: from wishful thinking to viable engineering

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases

SMART: making DB2 (more) autonomic

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases

Physical design refinement: The ‘merge-reduce’ approach

ACM Transactions on Database Systems (TODS)

Primitives for workload summarization and implications for SQL

VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29

DB2 design advisor: integrated automatic physical database design

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30

Automated design of multidimensional clustering tables for relational databases

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30

Self-tuning database systems: a decade of progress

VLDB '07 Proceedings of the 33rd international conference on Very large data bases

To share or not to share?

VLDB '07 Proceedings of the 33rd international conference on Very large data bases

Efficient use of the query optimizer for automated physical design

VLDB '07 Proceedings of the 33rd international conference on Very large data bases

Deadline and QoS aware data warehouse

VLDB '07 Proceedings of the 33rd international conference on Very large data bases

Improving parallelism of federated query processing

Data & Knowledge Engineering

Robustness in automatic physical database design

EDBT '08 Proceedings of the 11th international conference on Extending database technology: Advances in database technology

Load distribution of analytical query workloads for database cluster architectures

EDBT '08 Proceedings of the 11th international conference on Extending database technology: Advances in database technology

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

A critical look at the TAB benchmark for physical design tools

ACM SIGMOD Record

Don't settle for less than the best: use optimization to make decisions

HOTOS'07 Proceedings of the 11th USENIX workshop on Hot topics in operating systems

Graph queries for data integration using xml

Cybernetics and Systems Analysis

Software to assess the quality of a measurement system

ICCOMP'05 Proceedings of the 9th WSEAS International Conference on Computers

Is it DSS or OLTP: automatically identifying DBMS workloads

Journal of Intelligent Information Systems

Index tuning for parameterized streaming groupby queries

SSPS '08 Proceedings of the 2nd international workshop on Scalable stream processing system

Enabling policy-based access control in BI applications

Data & Knowledge Engineering

Automatic optimization of parallel dataflow programs

ATC'08 USENIX 2008 Annual Technical Conference on Annual Technical Conference

Constrained physical design tuning

Proceedings of the VLDB Endowment

When is it time to rethink the aggregate configuration of your OLAP server?

Proceedings of the VLDB Endowment

View and index selection for query-performance improvement: quality-centered algorithms and heuristics

Proceedings of the 17th ACM conference on Information and knowledge management

Query optimization using restructured views: Theory and experiments

Information Systems

Towards materialized view selection for distributed databases

Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology

Improving the responsiveness of internet services with automatic cache placement

Proceedings of the 4th ACM European conference on Computer systems

Data warehouse access using multi-agent system

Distributed and Parallel Databases

An architecture for recycling intermediates in a column-store

Proceedings of the 2009 ACM SIGMOD International Conference on Management of data

A materialized view selection technique for XPath queries

ECC'08 Proceedings of the 2nd conference on European computing conference

Data mining-based materialized view and index selection in data warehouses

Journal of Intelligent Information Systems

Systematic Exploration of Efficient Query Plans for Automated Database Restructuring

ADBIS '09 Proceedings of the 13th East European Conference on Advances in Databases and Information Systems

SimulPh.D.: A Physical Design Simulator Tool

DEXA '09 Proceedings of the 20th International Conference on Database and Expert Systems Applications

Fragmenting very large XML data warehouses via K-means clustering algorithm

International Journal of Business Intelligence and Data Mining

Exact and inexact methods for solving the problem of view selection for aggregate queries

International Journal of Business Intelligence and Data Mining

A method of workload compression basing on characteristics for index selection

Proceedings of the ACM first international workshop on Data-intensive software management and mining

Declarative management in Microsoft SQL server

Proceedings of the VLDB Endowment

StatAdvisor: recommending statistical views

Proceedings of the VLDB Endowment

Exact cardinality query optimization for optimizer testing

Proceedings of the VLDB Endowment

Index interactions in physical design tuning: modeling, analysis, and applications

Proceedings of the VLDB Endowment

Constrained physical design tuning

The VLDB Journal — The International Journal on Very Large Data Bases

View materialization vs. indexing: balancing space constraints in data warehouse design

CAiSE'03 Proceedings of the 15th international conference on Advanced information systems engineering

Selection of materialized views: a cost-based approach

CAiSE'03 Proceedings of the 15th international conference on Advanced information systems engineering

Efficient materialized view selection dynamic improvement algorithm

FSKD'09 Proceedings of the 6th international conference on Fuzzy systems and knowledge discovery - Volume 7

Views and queries: Determinacy and rewriting

ACM Transactions on Database Systems (TODS)

Comet: batched stream processing for data intensive distributed computing

Proceedings of the 1st ACM symposium on Cloud computing

Fluxo: a system for internet service programming by non-expert developers

Proceedings of the 1st ACM symposium on Cloud computing

Feeding frenzy: selectively materializing users' event feeds

Proceedings of the 2010 ACM SIGMOD International Conference on Management of data

Querying data provenance

Proceedings of the 2010 ACM SIGMOD International Conference on Management of data

Mining information for constructing materialised views

International Journal of Information and Communication Technology

Saving space and time using index merging

Data & Knowledge Engineering

An architecture for recycling intermediates in a column-store

ACM Transactions on Database Systems (TODS)

Listen to the customer: model-driven database design

Proceedings of the Fourteenth International Database Engineering & Applications Symposium

Towards location-based social networking services

Proceedings of the 2nd ACM SIGSPATIAL International Workshop on Location Based Social Networks

Yet another algorithms for selecting bitmap join indexes

DaWaK'10 Proceedings of the 12th international conference on Data warehousing and knowledge discovery

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

Nectar: automatic management of data and computation in datacenters

OSDI'10 Proceedings of the 9th USENIX conference on Operating systems design and implementation

Selecting materialized views for RDF data

ICWE'10 Proceedings of the 10th international conference on Current trends in web engineering

Determinacy and query rewriting for conjunctive queries and views

Theoretical Computer Science

A query answering greedy algorithm for selecting materialized views

ICCCI'10 Proceedings of the Second international conference on Computational collective intelligence: technologies and applications - Volume Part II

Queries and materialized views on probabilistic databases

Journal of Computer and System Sciences

Ring gage's design using the computer

ACMOS'05 Proceedings of the 7th WSEAS international conference on Automatic control, modeling and simulation

TI: an efficient indexing mechanism for real-time search on tweets

Proceedings of the 2011 ACM SIGMOD International Conference on Management of data

Automated partitioning design in parallel database systems

Proceedings of the 2011 ACM SIGMOD International Conference on Management of data

The case for being lazy: how to leverage lazy evaluation in MapReduce

Proceedings of the 2nd international workshop on Scientific cloud computing

Feed following: the big data challenge in social applications

Databases and Social Networks

Compression aware physical database design

Proceedings of the VLDB Endowment

Selecting and using views to compute aggregate queries

Journal of Computer and System Sciences

Interaction-aware scheduling of report-generation workloads

The VLDB Journal — The International Journal on Very Large Data Bases

On simplifying integrated physical database design

ADBIS'11 Proceedings of the 15th international conference on Advances in databases and information systems

Automatic physical database tuning middleware for web-based applications

ADBIS'11 Proceedings of the 15th international conference on Advances in databases and information systems

dipLODocus[RDF]: short and long-tail RDF analytics for massive webs of data

ISWC'11 Proceedings of the 10th international conference on The semantic web - Volume Part I

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

Optimization of distributed queries in grid via caching

OTM'05 Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems

Self-adaptive statistics management for efficient query processing

WAIM'05 Proceedings of the 6th international conference on Advances in Web-Age Information Management

Data mining techniques in materialised project and selection view

PDCAT'04 Proceedings of the 5th international conference on Parallel and Distributed Computing: applications and Technologies

Physical design refinement: the "merge-reduce" approach

EDBT'06 Proceedings of the 10th international conference on Advances in Database Technology

Dynamic view selection for OLAP

DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery

Automatic selection of bitmap join indexes in data warehouses

DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery

An evolutionary approach to schema partitioning selection in a data warehouse

DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery

Selecting and using views to compute aggregate queries

ICDT'05 Proceedings of the 10th international conference on Database Theory

Designing views to efficiently answer real SQL queries

SARA'05 Proceedings of the 6th international conference on Abstraction, Reformulation and Approximation

Semi-automatic index tuning: keeping DBAs in the loop

Proceedings of the VLDB Endowment

Designing and using views to improve performance of aggregate queries (extended abstract)

DASFAA'05 Proceedings of the 10th international conference on Database Systems for Advanced Applications

A formal model for the problem of view selection for aggregate queries

ADBIS'05 Proceedings of the 9th East European conference on Advances in Databases and Information Systems

SPIDER: an autonomic computing approach to database security management

SDM'06 Proceedings of the Third VLDB international conference on Secure Data Management

Clustering-based materialized view selection in data warehouses

ADBIS'06 Proceedings of the 10th East European conference on Advances in Databases and Information Systems

PerfXplain: debugging MapReduce job performance

Proceedings of the VLDB Endowment

A survey of view selection methods

ACM SIGMOD Record

Holistic indexing: offline, online and adaptive indexing in the same kernel

PhD '12 Proceedings of the on SIGMOD/PODS 2012 PhD Symposium

Skew-aware automatic database partitioning in shared-nothing, parallel OLTP systems

SIGMOD '12 Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data

NoDB: efficient query execution on raw data files

SIGMOD '12 Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data

Materialized view selection for XQuery workloads

SIGMOD '12 Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data

Materialized views selection for answering queries

ICDEM'10 Proceedings of the Second international conference on Data Engineering and Management

Optimizing index deployment order for evolving OLAP

Proceedings of the 15th International Conference on Extending Database Technology

DBToaster: higher-order delta processing for dynamic, frequently fresh views

Proceedings of the VLDB Endowment

A storage advisor for hybrid-store databases

Proceedings of the VLDB Endowment

Evolution of data warehouses' optimization: a workload perspective

DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery

A dynamic view materialization scheme for sequences of query and update statements

DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery

Rewriting conjunctive queries determined by views

MFCS'07 Proceedings of the 32nd international conference on Mathematical Foundations of Computer Science

Materialised view construction in data warehouse for decision making

International Journal of Business Information Systems

DMVI: a dynamic materialized view index for efficiently discovering usable views for progressive queries

CASCON '12 Proceedings of the 2012 Conference of the Center for Advanced Studies on Collaborative Research

Deterministic view selection for data-analysis queries: properties and algorithms

ADBIS'12 Proceedings of the 16th East European conference on Advances in Databases and Information Systems

An integer programming approach for the view and index selection problem

Data & Knowledge Engineering

Optimizing adaptive multi-route query processing via time-partitioned indices

Journal of Computer and System Sciences

Dynamic View Management System for Query Prediction to View Materialization

International Journal of Data Warehousing and Mining

An automatic physical design tool for clustered column-stores

Proceedings of the 16th International Conference on Extending Database Technology

AppSleuth: a tool for database tuning at the application level

Proceedings of the 16th International Conference on Extending Database Technology

Generalized scale independence through incremental precomputation

Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data

Optimizing XML queries: Bitmapped materialized views vs. indexes

Information Systems

Processing analytical queries over encrypted data

Proceedings of the VLDB Endowment

Supporting distributed feed-following apps over edge devices

Proceedings of the VLDB Endowment

Optimizing Sample Design for Approximate Query Processing

International Journal of Knowledge-Based Organizations

An improved approach for automatic selection of multi-tables indexes in ralational data warehouses using maximal frequent itemsets

Intelligent Decision Technologies