Indexes are models: a\btree-Index can be seen as a model to map a key to the position of a
record within a sorted array, a Hash-Index as a model to map a key to a position of a record …

We live in the golden age of distributed computing. Public cloud platforms now offer virtually
unlimited compute and storage resources on demand. At the same time, the Software-as-a …

Index structures are one of the most important tools that DBAs leverage to improve the
performance of analytics and transactional workloads. However, building several indexes …

This paper describes the system architecture of the Vertica Analytic Database (Vertica), a
commercialization of the design of the C-Store research prototype. Vertica demonstrates a …

Database systems tend to achieve only low IPC (instructions-per-cycle) efficiency on modern
CPUs in compute-intensive application areas like decision support, OLAP and multimedia …

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse solution that
makes it simple and cost-effective to efficiently analyze large volumes of data using existing …

In the last two decades, interactive visualization and analysis have become a central tool in
data-driven decision making. Concurrently to the contributions in data visualization …

This work aims at reducing the main-memory footprint in high performance hybrid OLTP &
OLAP databases, while retaining high query performance and transactional throughput. For …

The TPC-D benchmark was developed almost 20 years ago, and even though its current
existence as TPC-H could be considered superseded by TPC-DS, one can still learn from it …

Modern query engines are increasingly being required to process enormous datasets in
near real-time. While much can be done to speed up the data access, a promising technique …