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. Reports, Documentation, and Standards
  4. DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views
 
report

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

Koch, Christoph  
•
Ahmad, Yanif
•
Kennedy, Oliver Andrzej  
Show more
2013

Applications ranging from algorithmic trading to scientific data analysis require realtime analytics based on views over databases receiving thousands of updates each second. Such views have to be kept fresh at millisecond 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 article, we present the DBToaster system, which keeps materialized views of standard SQL queries continuously fresh as data changes very rapidly. This is achieved by a combination of aggressive compilation techniques and DBToaster's original recursive finite differencing technique which 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. This article provides a first description of the complete system, and a thorough experimental evaluation of its performance. DBToaster supports tens of thousands of complete view refreshes a second for a wide range of queries.

  • Files
  • Details
  • Metrics
Type
report
Author(s)
Koch, Christoph  
Ahmad, Yanif
Kennedy, Oliver Andrzej  
Nikolic, Milos  
Nötzli, Andres  
Lupei, Daniel  
Shaikhha, Amir  
Date Issued

2013

Subjects

incremental view maintenance

•

compilation

Written at

EPFL

EPFL units
DATA  
Available on Infoscience
February 12, 2013
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/88768
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