Architecting a Low-Latency Schemaless SQL Engine

In this talk we'll walk through the journey of building Rockset, a data system for low-latency queries for search and analytics. Rockset enables SQL queries on schemaless datasets. What are some of the challenges when adapting SQL to principles of strong dynamic typing? We will also discuss the idea of full converged indexing -- building both columnar store and inverted indexes on all the fields in the entire dataset. Indexes make queries faster, but also increase storage costs and write latencies. When are the tradeoffs worth it? Finally, we'll talk about the challenges and opportunities of designing data systems in the cloud native world. Can we build a stateful system that autoscales based on load?