Proceedings of the VLDB Endowment · 2022 · 34 citations · 20 references
ComputingComputer ScienceComputer SystemsData ManagementData StructuresDatabasesData Storage SystemsDatabase ManagementHash TablesQuery ProcessingRange SearchingBenchmark DatasetsData DistributionData Distribution AnalysisExecution Time AnalysisFalse Positive Rate EvaluationQuery Performance OptimizationRange QueriesRange Query Support
We present Sparse Numerical Array-Based Range Filters (SNARF), a learned range filter that efficiently supports range queries for numerical data. SNARF creates a model of the data distribution to map the keys into a bit array which is stored in a compressed form. The model along with the compressed bit array which constitutes SNARF are used to answer membership queries. We evaluate SNARF on multiple synthetic and real-world datasets as a stand-alone filter and by integrating it into RocksDB. For range queries, SNARF provides up to 50x better false positive rate than state-of-the-art range filters, such as SuRF and Rosetta, with the same space usage. We also evaluate SNARF in RocksDB as a filter replacement for filtering requests before they access on-disk data structures. For RocksDB, SNARF can improve the execution time of the system up to 10x compared to SuRF and Rosetta for certain read-only workloads.
20
Benchmarking cloud serving systems with YCSB
Brian F. Cooper, Adam Silberstein, Erwin Tam et al. · 2010 · 3.6K citations
Monotone Piecewise Cubic Interpolation
F.N. Fritsch, R.E. Carlson · SIAM Journal on Numerical Analysis · 1980 · 2.4K citations
Network Applications of Bloom Filters: A Survey
Andrei Broder, Michael Mitzenmacher · Internet Mathematics · 2004 · 2K citations · Full text
The log-structured merge-tree (LSM-tree)
Patrick E. O׳Neil, E.T. Cheng, Dieter Gawlick et al. · Acta Informatica · 1996 · 1.3K citations
M. Mitzenmacher · IEEE/ACM Transactions on Networking · 2002 · 524 citations