References & Citations
Computer Science > Databases
Title: Offset-value coding in database query processing
(Submitted on 30 Sep 2022 (v1), last revised 17 Feb 2023 (this version, v3))
Abstract: Recent work shows how offset-value coding speeds up database query execution, not only sorting but also duplicate removal and grouping (aggregation) in sorted streams, order-preserving exchange (shuffle), merge join, and more. It already saves thousands of CPUs in Google's Napa and F1 Query systems, e.g., in grouping algorithms and in log-structured merge-forests.
In order to realize the full benefit of interesting orderings, however, query execution algorithms must not only consume and exploit offset-value codes but also produce offset-value codes for the next operator in the pipeline. Our research has sought ways to produce offset-value codes without comparing successive output rows one-by-one, column-by-column. This short paper introduces a new theorem and, based on its proof and a simple corollary, describes in detail how order-preserving algorithms (from filter to merge join and even shuffle) can compute offset-value codes for their outputs. These computations are surprisingly simple and very efficient.
Submission history
From: Thanh Do [view email][v1] Fri, 30 Sep 2022 18:28:39 GMT (188kb,D)
[v2] Tue, 10 Jan 2023 19:20:17 GMT (3067kb,D)
[v3] Fri, 17 Feb 2023 18:45:26 GMT (303kb,D)
Link back to: arXiv, form interface, contact.