News & Events

Evolving Transactions in Oracle 23ai: New Advances in Concurrency and Consistency

Mar 28, 2025

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 stores. The Lock-free Reservations feature boosts concurrency of hot data, enhancing system efficiency. Sessionless Transactions enables lightweight and efficient transactions Read More

Building Novel Abstractions for a Declarative Cloud (Tianyu Li)

Mar 10, 2025

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, fault-tolerant “steps” that span component operations and messages. I will present DARQ, an efficient execution engine for such steps, and Read More

Redesigning Blockchains: SSD-optimized Verifiable Databases and Beyond (Daniel Lin-Kit Wong)

Mar 7, 2025

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, storage, and network bandwidth. We then discuss how we optimized the blockchain storage layer using our novel verifiable database, the Read More

SQL or Death? Seminar Series – Spring 2025

Jan 30, 2025

Pittsburgh, PA — The Carnegie Mellon University Database Research Group is pleased to announce its wildest seminar series yet starting February 2025. “SQL or Death?” is no-holds-barred exploration of replacements for SQL and techniques to make SQL even better than it is. The schedule features legendary database researchers and industry stalwarts. Each session will challenge conventional wisdom with the kind of intensity that makes even seasoned DBAs break into a cold sweat. Even the late, great Ol’ Dirty Bastard (ODB) Read More

[SQL Death] StarRocks Query Optimizer

Jan 23, 2025

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 colocate optimization, Partitioned Materialized Views auto union rewrite, and Low Cardinality global dictionary optimization, showcasing how they enhance query performance. Read More

[SQL Death] PRQL: Pipelined Relational Query Language

Jan 23, 2025

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 — the bloated dinosaur. PRQL incorporates the beauty of relational algebra while also embracing the best from libraries like dplyr, Pandas, Read More

[SQL Death] Pipe Syntax in SQL: SQL for the 21st Century

Jan 23, 2025

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 new languages. New language adoption is a significant obstacle for users, and none of the potential replacements have been successful Read More