Database Change Notifications: Primitives for Efficient Database Query Result Caching Cesar Galindo-Legaria, Torsten Grabs, Christian Kleinerman, Florian WaasSQL Server EngineMicrosoft Corp. Redmond, WAUSAVLDB 2005, Trondheim, Norway http://www.microsoft.com/sql/2005/
Motivation HTTP HTTP HTTP SELECT price FROM books WHERE title = ‘T-SQL’ UPDATE booksSET price = 20.00WHERE title = ‘T-SQL’ • Three-tier architecture for web applications • Time-to-life based approaches for caching of read-mostly dynamic results at mid-tier for performance reasons • Problem: Outdated results in case of database updates Clients Mid-tier cache: Web serverfarm DBS 20.00
Demo Highlights HTTP Query Plan Update Plan Change Notification:- cache re-run query, or- send delta 20.00 UPDATE • “Non-materialized” indexed view for change detection • Query plan rewrite to register cached query results • Update rewrite to notify caches of changes in case of non-empty materialized view maintenance delta stream • Note: No DBMS installation necessary at the mid tier Clients Mid-tier cache: Web serverfarm 20.00 SELECT DBS
? Questions ? Come and see the Demo!!!