MariaDB's query optimizer stems from MySQL's original implementation. It didn't come from a textbook, instead, it grew organically to meet the demands of the workloads we were targeting. This talk will discuss some of the uncommon choices we've made in MariaDB's new optimizer and what we've got (and lost) as a result. This talk is part of the SQL or... Read More

Oxide Computer Company builds private cloud computers–co-designing hardware and software that works together. Our choice to own so much of the design was to enable systemic control and observability: we collect data from the smallest hardware sensor to the distributed control plane software. This talk covers the Oximeter Query Language (OxQL), the domain-specific language used to query and analyze this... Read More

Oracle Database 23ai introduces groundbreaking enhancements that redefine transaction processing, ensuring greater concurrency, flexibility, and efficiency. This talk will explore four key features that impact database transactions: Logical Replication of JSON Relational Duality Views, Lock-Free Reservations, Sessionless Transactions, and Value-based Concurrency Control. Learn how we logically and consistently replicate data stored in JSON Relational Duality Views to heterogenous target data... Read More

StarRocks is a C++ analytical database that handles large-scale, high-concurrency, low-latency OLAP queries. In this presentation, Kaisen Kang, Tech Lead of the StarRocks Query Team, will provide an in-depth look at the StarRocks optimizer, the key optimizations, and design choices. The talk will focus on two key areas: Key Optimizations – A deep dive into three representative optimizations: Multi-left join... Read More

The past 50 years have seen a great evolution in programming languages — except in the world of databases. There, SQL still reigns supreme; but is it a shark, enduring due to its perfection, or a dinosaur, one impact away from extinction? We argue that SQL is an amalgamation of both: relational algebra — the shark; and the language —... Read More

As the cloud evolves in capability, it has also become increasingly complex and difficult to program. New abstractions are necessary to ensure next-generation cloud applications are correct, simple, and efficient. In this talk, I will first describe Resilient Composition, a new abstraction that ensures fault-tolerance in applications composed from independent, distributed components. The key insight is to rely on atomic,... Read More

In software we express our ideas through tools. In data, those tools think in rectangles. From spreadsheets to the data warehouses, to do any analytical calculation, you must first go through a rectangle.. Forcing data through a rectangle shapes the way we solve problems (for example, dimensional fact tables, OLAP Cubes). But really, most Data isn’t rectangular. Most data exists... Read More

Blockchains are decentralized ledgers that replace trusted central authorities with verifiable distributed consensus. This decentralization has resulted in blockchains effectively becoming ‘slow and expensive computers’, but there are huge opportunities for architectural optimization across the entire blockchain software stack. We begin this talk by outlining the scaling challenges from a systems researcher’s perspective, and discussing the bottlenecks faced in computation,... Read More

SQL has been extremely successful as the de facto standard language for working with data. Virtually all mainstream database-like systems use SQL as their primary query language. But SQL is an old language with significant design problems, making it difficult to learn, difficult to use, and difficult to extend. Many have observed these challenges with SQL, and proposed solutions involving... Read More

Apache Pinot is a distributed real-time OLAP database, part of a fast-growing segment designed for large-scale, user-facing analytics. Its primary query language is SQL, and it excels at low-latency queries, high throughput, and fresh data. Currently, Pinot supports two SQL dialects, and we are building a compatibility layer to enable pluggable time-series query languages, with Uber's M3 and PromQL as... Read More