arrow
Return

CrypQ: A Database Benchmark Based on Dynamic, Ever-Evolving Ethereum Data

delete2026-01-01
delete0
PRE
AI
V
Vincent Capol *
Y
Yuxi Liu
H
Haibo Xiu
J
Jun Yang
DOI:10.1007/978-3-031-93858-0_3delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
Modern database systems are expected to handle dynamic data whose characteristics may evolve over time. Many popular database benchmarks are limited in their ability to evaluate this dynamic aspect of the database systems. Those that use synthetic data generators often fail to capture the complexity and unpredictable nature of real data, while most real-world datasets are static and difficult to create high-volume, realistic updates for. This paper introduces CrypQ, a database benchmark leveraging dynamic, public Ethereum blockchain data. CrypQ offers a high-volume, ever-evolving dataset reflecting the unpredictable nature of a real and active cryptocurrency market. We detail CrypQ's schema, procedures for creating data snapshots and update sequences, and a suite of relevant SQL queries. As an example, we demonstrate CrypQ's utility in evaluating cost-based query optimizers on complex, evolving data distributions with real-world skewness and dependencies.
Keywords:
Benchmark
Query Optimization
Cardinality Estimation

Journal

P
PERFORMANCE EVALUATION AND BENCHMARKING, TPCTC 2024
IF:
0
Papers:
8
Citations:
0

Organization

D
duke university
Scholars:
8.2K
Papers: 3.3K
Citations: 2