Hippo: Accelerating Transaction Processing for Approximate Query Processing Engine with Sampling Semantics

Approximate query processing provides an aggregated value of large-scale data or speeds up machine learning pre-processing through sampling operations. Existing work has assumed that all data is stored in storage, and it requires scanning the entire data space followed by sampling for the approximation. Our work changes this assumption. We present Hippo, a concurrency control protocol that invalidates unnecessary data items on insert operations. Our algorithm is naturally integrated with the deterministic concurrency control protocol, and it never aborts transactions, which is essentially different from optimistic or pessimistic protocols. In our evaluation, the proposed protocol demonstrated performance improvements of up to 235 times compared to the CLMD concurrency control protocol.

Authors

Institutions

Publication Details

Published
2024-11-26
DOI
https://doi.org/10.1109/candarw64572.2024.00048
Primary Topic
Advanced Database Systems and Queries
Type
article
Field-Weighted Citation Impact
0.00

Funders

Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Hippo: Accelerating Transaction Processing for Approximate Query Processing Engine with Sampling Semantics

Hideyuki Kawashima
Advanced Database Systems and Queries
article

Hippo: Accelerating Transaction Processing for Approximate Query Processing Engine with Sampling Semantics

Hideyuki Kawashima
article en

Abstract

Approximate query processing provides an aggregated value of large-scale data or speeds up machine learning pre-processing through sampling operations. Existing work has assumed that all data is stored in storage, and it requires scanning the entire data space followed by sampling for the approximation. Our work changes this assumption. We present Hippo, a concurrency control protocol that invalidates unnecessary data items on insert operations. Our algorithm is naturally integrated with the deterministic concurrency control protocol, and it never aborts transactions, which is essentially different from optimistic or pessimistic protocols. In our evaluation, the proposed protocol demonstrated performance improvements of up to 235 times compared to the CLMD concurrency control protocol.

Keio University Shonan Fujisawa (JP)
New Energy and Industrial Technology Development Organization, Research and Development
Openalex Percentile: Top 72%
Advanced Database Systems and Queries
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.