Think You Know SQL? 3 Common Misconceptions About SQL Databases, Speed and Scale
January 18, 10am PST
In this talk, we’ll discuss how modern SQL databases can be well-suited to handling real-time data streams, combining the benefits of NoSQL with the ease of SQL.
SQL has been around for a while. Since 1974, to be exact. SQL databases have long dominated the data landscape but faced a stiff challenge from NoSQL alternatives in the 2010s. Back then, the knock on SQL databases was that they would not be able to cope with the speed, scale and (lack of) structure associated with the ever-growing streams of data that needed to be processed.
Fast forward to 2021, and many concepts motivated by the NoSQL movement—scale-out architecture, use of commodity hardware, flexible schema—are indeed standards for large-scale data management today. However, SQL is still alive and well. Many data practitioners prefer working in SQL, which enjoys widespread familiarity and a well-developed ecosystem, so is there a way for SQL databases to meet the need for speed, scale and flexibility?
In this talk, we’ll bust 3 myths about SQL databases:
- SQL databases cannot support large streaming write rates
- SQL databases cannot handle the changing schemas of streaming data
- SQL databases cannot scale writes without impacting queries
We’ll discuss how modern SQL databases can be well-suited to handling real-time data streams, combining the benefits of NoSQL with the ease of SQL. Learn how you can build modern data applications on large-scale streaming data using a SQL database.
About the Speaker
Dhruba Borthakur is CTO and co-founder of Rockset, responsible for the company's technical direction. He was an engineer on the database team at Facebook, where he was the founding engineer of the RocksDB data store. Earlier at Yahoo, he was one of the founding engineers of the Hadoop Distributed File System. He was also a contributor to the open source Apache HBase project. Dhruba previously held various roles at Veritas Software, founded an e-commerce startup, Oreceipt.com, and contributed to Andrew File System (AFS) at IBM-Transarc Labs.