Query optimizer is at the heart of the database systems. Cost-based optimizer studied in this
paper is adopted in almost all current database systems. A cost-based optimizer introduces …

In this paper, we propose a simple, yet fast and effective approach to determine good join
orders for arbitrary selectproject-join queries. Our scheme comprises three building …

Obviously, the complexity of mathematical database cost models increases with the
evolution of the database technology brought by emerging hardware and the new …

A major challenge for many database management tasks including admission control, query
scheduling, progress monitoring and self‐driving data storage systems is to enhance …

Cardinality estimation is a high-profile technique in database management systems with a
serious impact on query performance. Thus, a lot of traditional approaches such as …

Index structures such as B-trees and bloom filters are the well-established petrol engines of
database systems. However, these structures do not fully exploit patterns in data distribution …

As the demand for data intensive pipelines has grown and the diversity of settings has
expanded, generalizability of database management systems has suffered. The execution of …