In this thought-provoking podcast episode, we dive into the world of scalable OLTP (OnLine Transaction Processing) systems with the insightful Pat Helland. As a seasoned expert in the field, Pat shares his insights on the critical role of isolation semantics in the scalability of OLTP systems, emphasizing its significance as the "BIG DEAL." By examining the interface between OLTP databases and applications, particularly through the lens of RCSI (READ COMMITTED SNAPSHOT ISOLATION) SQL databases, Pat talks about the limitations imposed by current database architectures and application patterns on scalability.

Through a compelling thought experiment, Pat explores the asymptotic limits to scale for OLTP systems, challenging the status quo and envisioning a reimagined approach to building both databases and applications that empowers scalability while adhering to established to RCSI. By shedding light on how today's popular databases and common app patterns may unnecessarily hinder scalability, Pat sparks discussions within the database community, paving the way for new opportunities and advancements in OLTP systems. Join us as we delve into this conversation with Pat Helland, where every insight shared could potentially catalyze significant transformations in the realm of OLTP scalability.

Papers mentioned during the episode:

• Scalable OLTP in the Cloud: What’s the BIG DEAL?
• Autonomous Computing
• Decoupled Transactions
• Don't Get Stuck in the "Con" Game
• The Best Place to Build a Subway
• Building on Quicksand
• Side effects, front and center
• Immutability changes everything
• Is Scalable OLTP in the Cloud a solved problem?

You can find Pat on:

• Twitter/X
• LinkedIn
• Scattered Thoughts on Distributed Systems

Hosted on Acast. See acast.com/privacy for more information.