Repository logo

Infoscience

  • English
  • French
Log In
Logo EPFL, École polytechnique fédérale de Lausanne

Infoscience

  • English
  • French
Log In
  1. Home
  2. Academic and Research Output
  3. Conferences, Workshops, Symposiums, and Seminars
  4. DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views
 
conference paper

DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views

Ahmad, Yanif
•
Kennedy, Oliver Andrzej  
•
Koch, Christoph  
Show more
2012
Proceedings of the 38th International Conference on Very Large Databases
38th International Conference on Very Large Databases

Applications ranging from algorithmic trading to scientific data analysis require realtime analytics based on views over databases that change at very high rates. Such views have to be kept fresh at low maintenance cost and latencies. At the same time, these views have to support classical SQL, rather than window semantics, to enable applications that combine current with aged or historical data. In this paper, we present viewlet transforms, a recursive finite differencing technique applied to queries. The viewlet transform materializes a query and a set of its higher-order deltas as views. These views support each other’s incremental maintenance, leading to a reduced overall view maintenance cost. The viewlet transform of a query admits efficient evaluation, the elimination of certain expensive query operations, and aggressive parallelization. We develop viewlet transforms into a workable query execution technique, present a heuristic and cost-based optimization framework, and report on experiments with a prototype dynamic data management system that combines viewlet transforms with an optimizing compilation technique. The system supports tens of thousands of complete view refreshes a second for a wide range of queries.

  • Files
  • Details
  • Metrics
Type
conference paper
Author(s)
Ahmad, Yanif
Kennedy, Oliver Andrzej  
Koch, Christoph  
Nikolic, Milos  
Date Issued

2012

Published in
Proceedings of the 38th International Conference on Very Large Databases
Subjects

dbtoaster

•

viewlet transform

•

higher order ivm

•

delta

Editorial or Peer reviewed

REVIEWED

Written at

EPFL

EPFL units
DATA  
Event nameEvent placeEvent date
38th International Conference on Very Large Databases

Istanbul, Turkey

August 27-31, 2012

Available on Infoscience
June 20, 2012
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/81965
Logo EPFL, École polytechnique fédérale de Lausanne
  • Contact
  • infoscience@epfl.ch

  • Follow us on Facebook
  • Follow us on Instagram
  • Follow us on LinkedIn
  • Follow us on X
  • Follow us on Youtube
AccessibilityLegal noticePrivacy policyCookie settingsEnd User AgreementGet helpFeedback

Infoscience is a service managed and provided by the Library and IT Services of EPFL. © EPFL, tous droits réservés