Micro-architectural Analysis of OLAP: Limitations and Opportunities

Summary: Micro-architectural analysis reveals OLAP hardware behavior. Traditional OLAP shows long instruction footprints; columnstores run with tight code yet suffer 25-82% CPU stalls, and concurrent queries raise utilization but cause interference. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 12279
Venue: VLDB
Year: 2020
Pagerank: 4.581825e-05
Overall Rank: 8,101 | 43.70%
DOI: 10.14778/3380750.3380755

Incoming Non-self Citations Over Time

Authors

1. Utku Sirin
2. Anastasia Ailamaki

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
4,184	CoroBase: Coroutine-Oriented Main-Memory Database Engine	2021	VLDB	6.3718449e-05
4,269	Maximizing Persistent Memory Bandwidth Utilization for OLAP Workloads	2021	SIGMOD	6.2950779e-05
6,068	GPU Database Systems Characterization and Optimization	2024	VLDB	5.2240241e-05
8,717	Entropy-Learned Hashing: Constant Time Hashing with Controllable Uniformity	2022	SIGMOD	4.4566937e-05
11,158	Predicting Query Execution time for JIT Compiled Database Engines	2023	CIDR	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
124	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.0004501099
241	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00031314629
417	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023734582
848	Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask	2018	VLDB	0.00015933538
1,787	MonetDB/XQuery: A Fast XQuery Processor Powered by a Relational Engine	2006	SIGMOD	0.00010543821
2,262	SQL Server Column Store Indexes	2011	SIGMOD	9.1629311e-05
2,777	Quickstep: A Data Platform Based on the Scaling-Up Approach	2018	VLDB	8.1346418e-05
2,782	Database Servers on Chip Multiprocessors: Limitations and Opportunities	2007	CIDR	8.1278531e-05
3,194	Exploiting Coroutines to Attack the "Killer Nanoseconds"	2018	VLDB	7.4068088e-05
3,225	Interleaving with Coroutines: A Practical Approach for Robust Index Joins	2018	VLDB	7.3487507e-05
4,319	Fast Queries Over Heterogeneous Data Through Engine Customization	2016	VLDB	6.2823814e-05
5,273	Micro-architectural Analysis of In-memory OLTP	2016	SIGMOD	5.5919449e-05
6,540	Profiling R on a Contemporary Processor	2015	VLDB	5.0168106e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,686	Compacting Transactional Data in Hybrid OLTP&OLAP Databases	2012	VLDB	6.839208e-05
215	OLTP Through the Looking Glass, and What We Found There	2008	SIGMOD	0.00033609709
6,062	OLTPShare: The Case for Sharing in OLTP Workloads	2018	VLDB	5.2267464e-05
11,427	Workload Interference Analysis for HTAP*	2021	CIDR	4.1905499e-05
7,864	Operational Analytics Data Management Systems	2016	VLDB	4.6284093e-05
2,437	OLTP on Hardware Islands	2012	VLDB	8.8206221e-05
11,069	OLAP on Modern Chiplet-Based Processors	2024	VLDB	4.1905499e-05
1,050	A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database	2009	SIGMOD	0.00014425459
5,273	Micro-architectural Analysis of In-memory OLTP	2016	SIGMOD	5.5919449e-05
13,216	Micro-architectural Analysis of OLAP Systems on Persistent Memory	2022	CIDR	-