The Cascades framework was an academic project introduced 25 years ago as a foundation for modern query optimizers. It provides extensibility, memoization-based dynamic programming, an algebraic representation of logical and physical operator trees, and manipulation of such trees using transformation rules to enable cost-based query optimization. Cascades provides a clean framework/skeleton for optimizer development, but it needs to be instantiated... Read More

In-Memory OLTP (formerly known as Hekaton) is a key feature in the In-Memory offerings of Microsoft's SQL Server 2014 product. In this talk we will discuss the hardware trends, user scenarios, and history that prompted its key architectural pillars of main-memory optimization, lock/latch-free concurrency control and SQL compilation to native code, as well as how the technology is integrated into... Read More