Abstract
We revisit the classical change propagation framework for query evaluation under updates. The standard framework takes a query plan and materializes the intermediate views, which incurs high polynomial costs in both space and time, with the join operator being the culprit. In this paper, we propose a new change propagation framework without joins, thus naturally avoiding this polynomial blowup. Meanwhile, we show that the new framework still supports constant-delay enumeration of both the deltas and the full query results, the same as in the standard framework. Furthermore, we provide a quantitative analysis of its update cost, which not only recovers many recent theoretical results on the problem, but also yields an effective approach to optimizing the query plan. The new framework is also easy to be integrated into an existing streaming database system. Experimental results show that our system prototype, implemented using Flink DataStream API, significantly outperforms other systems in terms of space, time, and latency.
Original language | English |
---|---|
Pages (from-to) | 1046-1058 |
Number of pages | 13 |
Journal | Proceedings of the VLDB Endowment |
Volume | 16 |
Issue number | 5 |
DOIs | |
Publication status | Published - 1 Jan 2023 |
Event | 49th International Conference on Very Large Data Bases, VLDB 2023 - Sheraton Vancouver Wall Centre, Vancouver, Canada Duration: 28 Aug 2023 → 1 Sept 2023 https://vldb.org/2023/ (Link to conference website) https://vldb.org/2023/?program-structure (Link to conference programme) |
Scopus Subject Areas
- Computer Science (miscellaneous)
- Computer Science(all)