Affiliation:
1. Johns Hopkins University
2. École Polytechnique Fédérale de Lausanne
Abstract
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.
Subject
General Earth and Planetary Sciences,Water Science and Technology,Geography, Planning and Development
Cited by
42 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献
1. Scalable Spreadsheet-Driven End-User Applications with Incremental Computation;Proceedings of the 2023 ACM SIGPLAN International Symposium on New Ideas, New Paradigms, and Reflections on Programming and Software;2023-10-18
2. Asymptotically Better Query Optimization Using Indexed Algebra;Proceedings of the VLDB Endowment;2023-07
3. S/C: Speeding up Data Materialization with Bounded Memory;2023 IEEE 39th International Conference on Data Engineering (ICDE);2023-04
4. Transactional Panorama: A Conceptual Framework for User Perception in Analytical Visual Interfaces;Proceedings of the VLDB Endowment;2023-02
5. Change Propagation Without Joins;Proceedings of the VLDB Endowment;2023-01