Relational DBMS typically execute concurrent queries independently by invoking a set of
operator instances for each query. To exploit common data retrievals and computation in …

This paper discusses the PROMISE (Predicting User Behavior in Multidimensional
Information System Environments) approach, that deploys information about characteristic …

Cloud analytical databases employ a disaggregated storage model, where the elastic
compute layer accesses data persisted on remote cloud storage in block-oriented columnar …

Extract, transform and load (ETL) is the core process of data integration and is typically
associated with data warehousing. ETL tools extract data from a chosen source, transform it …

Database systems typically execute queries in isolation. Sharing recurring intermediate and
final results between successive query invocations is ignored or only exploited by caching …

In database systems, the cost of data storage and retrieval are important components of the
total cost and response time of the system. A popular mechanism to reduce the storage …

Today's data deluge enables organizations to collect massive data, and analyze it with an
ever-increasing number of concurrent queries. Traditional data warehouses (DW) face a …

Materialized view selection is one of the crucial decisions in designing a data warehouse for
optimal efficiency. Static selection of views may materialize certain views that are not …

A materialized view, or Materialized Query Table (MQT), is an auxiliary table with
precomputed data that can be used to significantly improve the performance of a database …

Decision support (DSS) workloads generally contain multiple large concurrent scan
operations. These are often executed as relational table scans which can take up a lot of I/O …