Finding a good join order is crucial for query performance. In this paper, we introduce the
Join Order Benchmark (JOB) and experimentally revisit the main components in the classic …

Finding a good join order is crucial for query performance. In this paper, we introduce the
Join Order Benchmark that works on real-life data riddled with correlations and introduces …

After four decades of research, today's database systems still suffer from poor query
execution plans. Bad plans are usually caused by poor cardinality estimates, which have …

Effective query optimization is a core feature of any database management system. While
most query optimization techniques make use of simple metadata, such as cardinalities and …

This article provides an overview of recent developments in mainmemory database systems.
With growing memory sizes and memory prices dropping by a factor of 10 every 5 years …

viii Preface reason for this change is that sequential processors have ceased to get
proportional performance improvements from increased circuit complexity. Although the …

Well-chosen secondary indexes are highly relevant for database performance. For complex
workloads, current index selection algorithms are either not fast or not highly competitive …

Resource disaggregation is a new architecture for data centers in which resources like
memory and storage are decoupled from the CPU, managed independently, and connected …

The journey of SAP HANA started as an in-memory appliance for complex, analytical
applications. The success of the system quickly motivated SAP to broaden the scope from …

Database architecture, while having been studied for four decades now, has delivered only
a few designs with well-understood properties. These few are followed by most actual …