Analytic database applications have an insatiable appetite for higher performance. In the past, a large part of this appetite was met by leveraging the gift of Moore’s Law. However, the slowing down of Moore’s Law now requires a new approach. Fortunately, the hardware landscape is currently undergoing a Cambrian explosion of new architectures. In this talk, I will describe how... Read More

Decades of research in the field of database management systems (DBMSs) have focused on improving system performance with impressive results. Modern analytical databases take advantage of innovative methods such as vectorization and compilation to improve single query performance, use supporting data structures such as indexes or views to reduce data access requirements, and support the execution of multiple queries in... Read More

Database management systems (DBMSs) have become more complex to meet increasingly demanding usage. To owners and operators, the need for a self-driving DBMS that can automatically tune and optimize itself without human intervention is apparent now more than ever. Such a self-driving DBMS considers a set of candidate actions to apply to reach a configuration that improves performance for a... Read More

For the final lecture in CMU's Introduction to Database Systems (Fall 2022) course, we are allowing anyone to call in with their database questions. The lecture will be livestreamed via Youtube and you will be able to ask your questions to Prof. Andy Pavlo directly. Livestream: https://youtu.be/MxOKUt6LeeU Audience Call-in: https://cmu.zoom.us/j/99783788428?pwd=R2ZSd2x0SUFnRlNIak5TVk5ubmFjQT09 (Must have Zoom account) Read More

CrateDB is a SQL, open-source, distributed database that makes storage and analysis of massive amounts of data simple and efficient. It offers effective data handling due to a high degree of scalability and availability, real-time query performance, and extensible data models. In this talk, we will discuss the fundamental concepts of CrateDB and highlight what makes it unique in comparison... Read More

We built SplinterDB to address two trends. The first is the modern storage hardware offers significantly higher bandwidth and lower latency. The second is that modern applications at VMware and elsewhere store fine-grain data, such as metadata. Current state-of-the-art key-value stores such as RocksDB fail to fully exploit the capabilities of these devices on these types of workloads. SplinterDB is... Read More

TigerBeetle is an open source distributed financial accounting database designed for mission critical safety and performance to track financial transactions at scale. TigerBeetle is coded to NASA’s Power of Ten Rules for Safety Critical Code. All memory is statically allocated at startup for predictable and efficient resource usage. Function arguments and return values are verified at runtime by over three... Read More

GAIA database is an unusual engine - it offers a direct access model and supports memory pointers, applications are able to create and navigate complex data structures like graphs with no or very little API overhead: the engine implements transactional memory view with full transactional durability - whatever you do in memory gets captures and persistent in an efficient transparent... Read More

EdgeDB is a new database built around an evolution of the relational model that we call "graph-relational". In the graph-relational model, data is represented as strongly typed objects containing set-valued scalar properties and links to other objects. Missing values are represented in the language as empty sets (no NULL!), and have consistent semantics. The query language, EdgeQL, supports convenient fetching... Read More

RisingWave is a cloud-native streaming database. Different from existing streaming systems, RisingWave fully leverages the modern cloud infrastructure to achieve high performance and scalability at a low cost. In this talk, I will walk you through the detailed designs of RisingWave, and discuss how we adopt some old ideas to build a next-generation streaming system. This talk is part of... Read More