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: 12278
Venue: VLDB
Year: 2020
Pagerank: 4.5860565e-05
Overall Rank: 8,096 | 43.68%
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.3779731e-05
4,281	Maximizing Persistent Memory Bandwidth Utilization for OLAP Workloads	2021	SIGMOD	6.2940039e-05
6,066	GPU Database Systems Characterization and Optimization	2024	VLDB	5.2290447e-05
8,720	Entropy-Learned Hashing: Constant Time Hashing with Controllable Uniformity	2022	SIGMOD	4.4609699e-05
11,155	Predicting Query Execution time for JIT Compiled Database Engines	2023	CIDR	4.1945683e-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.00045103515
241	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00031420034
418	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023729211
853	Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask	2018	VLDB	0.00015940507
1,795	MonetDB/XQuery: A Fast XQuery Processor Powered by a Relational Engine	2006	SIGMOD	0.00010526672
2,258	SQL Server Column Store Indexes	2011	SIGMOD	9.1678883e-05
2,772	Quickstep: A Data Platform Based on the Scaling-Up Approach	2018	VLDB	8.1401661e-05
2,778	Database Servers on Chip Multiprocessors: Limitations and Opportunities	2007	CIDR	8.1321802e-05
3,193	Exploiting Coroutines to Attack the "Killer Nanoseconds"	2018	VLDB	7.4089674e-05
3,219	Interleaving with Coroutines: A Practical Approach for Robust Index Joins	2018	VLDB	7.3550716e-05
4,326	Fast Queries Over Heterogeneous Data Through Engine Customization	2016	VLDB	6.288323e-05
5,272	Micro-architectural Analysis of In-memory OLTP	2016	SIGMOD	5.5937875e-05
6,542	Profiling R on a Contemporary Processor	2015	VLDB	5.0216639e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,689	Compacting Transactional Data in Hybrid OLTP&OLAP Databases	2012	VLDB	6.8396366e-05
215	OLTP Through the Looking Glass, and What We Found There	2008	SIGMOD	0.0003354907
6,060	OLTPShare: The Case for Sharing in OLTP Workloads	2018	VLDB	5.2305257e-05
11,424	Workload Interference Analysis for HTAP*	2021	CIDR	4.1945683e-05
7,866	Operational Analytics Data Management Systems	2016	VLDB	4.6321795e-05
2,445	OLTP on Hardware Islands	2012	VLDB	8.8057827e-05
11,066	OLAP on Modern Chiplet-Based Processors	2024	VLDB	4.1945683e-05
1,053	A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database	2009	SIGMOD	0.00014429683
5,272	Micro-architectural Analysis of In-memory OLTP	2016	SIGMOD	5.5937875e-05
13,202	Micro-architectural Analysis of OLAP Systems on Persistent Memory	2022	CIDR	-