DBToaster: higher-order delta processing for dynamic, frequently fresh views

Christoph Koch, Yanif Ahmad, Oliver Kennedy, Milos Nikolic, Andres Notzli, Daniel Lupei, Amir Shaikhha

Research output: Contribution to journalArticlepeer-review

Abstract

Applications ranging from algorithmic trading to scientific data analysis require real-time 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. DBToaster supports tens of thousands of complete view refreshes per second for a wide range of queries.
Original languageEnglish
Pages (from-to)253-278
Number of pages26
JournalVLDB Journal
Volume23
Issue number2
DOIs
Publication statusPublished - 9 Jan 2014

Fingerprint

Dive into the research topics of 'DBToaster: higher-order delta processing for dynamic, frequently fresh views'. Together they form a unique fingerprint.

Cite this