Advanced Data System Concepts

Describe the design principles and advantages of in-memory database systems.

Explain how cache-conscious B+ trees are optimized for main-memory performance.

Explain the purpose of materialized views as a query optimization technique.

Describe strategies for materialized view maintenance (e.g., immediate vs. deferred refresh).

Describe the concept of adaptive indexing, where indexes are built incrementally during query processing.

Explain the use of approximate query processing (AQP) with sketches, using Count-Min Sketch as an example.