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 …

Database management system (DBMS) configuration tuning is an essential aspect of any
data-intensive application effort. But this is historically a difficult task because DBMSs have …

© 2019 Conference on Innovative Data Systems Research (CIDR). All rights reserved.
Modern data processing systems are designed to be general purpose, in that they can …

In this paper, we address the problem of finding frequent itemsets in a database. Using the
closed itemset lattice framework, we show that this problem can be reduced to the problem …

In the last two decades, both researchers and vendors have built advisory tools to assist
database administrators (DBAs) in various aspects of system tuning and physical design …

Data Warehouses are the core of the modern systems for decision making. They store
integrated information extracted from various and heterogeneous data sources, making it …

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 …

In this paper we describe novel techniques that make it possible to build an industrial-
strength tool for automating the choice of indexes in the physical design of a SQL database …

Data warehousing systems enable enterprise managers to acquire and integrate information
from heterogeneous sources and to query very large databases efficiently. Building a data …

In addition to indexes and materialized views, horizontal and vertical partitioning are
important aspects of physical design in a relational database system that significantly impact …