Download
database change notifications primitives for efficient database query result caching n.
Skip this Video
Loading SlideShow in 5 Seconds..
Database Change Notifications: Primitives for Efficient Database Query Result Caching PowerPoint Presentation
Download Presentation
Database Change Notifications: Primitives for Efficient Database Query Result Caching

Database Change Notifications: Primitives for Efficient Database Query Result Caching

104 Vues Download Presentation
Télécharger la présentation

Database Change Notifications: Primitives for Efficient Database Query Result Caching

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. 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/

  2. 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

  3. 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

  4. ? Questions ? Come and see the Demo!!!