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: 12466
Venue: VLDB
Year: 2020
Pagerank: 5.5107319e-05
Overall Rank: 7,991 | 45.18%
DOI: 10.14778/3380750.3380755

Incoming Non-self Citations Over Time

Authors

1. Utku Sirin (EPFL)
2. Anastasia Ailamaki (EPFL; RAW Labs)

BibTeX Citation

@article{sirin_vldb20,
        title = {{Micro-architectural Analysis of OLAP: Limitations and Opportunities}},
        author = {Sirin, Utku and Ailamaki, Anastasia},
        journal = {PVLDB},
        series = {{VLDB} '20},
        volume = {13},
        number = {6},
        pages = {840--853},
        doi = {10.14778/3380750.3380755},
        url = {https://doi.org/10.14778/3380750.3380755},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,644	CoroBase: Coroutine-Oriented Main-Memory Database Engine	2021	VLDB	7.2306862e-05
3,647	Maximizing Persistent Memory Bandwidth Utilization for OLAP Workloads	2021	SIGMOD	7.2271935e-05
5,422	GPU Database Systems Characterization and Optimization	2024	VLDB	6.2245373e-05
8,880	Entropy-Learned Hashing: Constant Time Hashing with Controllable Uniformity	2022	SIGMOD	5.3524255e-05
11,361	Predicting Query Execution time for JIT Compiled Database Engines	2023	CIDR	5.093636e-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
109	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.000331207
165	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00027693424
241	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023654664
649	Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask	2018	VLDB	0.00015320656
1,460	MonetDB/XQuery: A Fast XQuery Processor Powered by a Relational Engine	2006	SIGMOD	0.00010710674
1,747	SQL Server Column Store Indexes	2011	SIGMOD	9.8494706e-05
2,156	Quickstep: A Data Platform Based on the Scaling-Up Approach	2018	VLDB	9.0635624e-05
2,679	Database Servers on Chip Multiprocessors: Limitations and Opportunities	2007	CIDR	8.2675008e-05
2,767	Exploiting Coroutines to Attack the "Killer Nanoseconds"	2018	VLDB	8.1507611e-05
2,890	Interleaving with Coroutines: A Practical Approach for Robust Index Joins	2018	VLDB	7.9880033e-05
3,638	Fast Queries Over Heterogeneous Data Through Engine Customization	2016	VLDB	7.2338361e-05
4,866	Micro-architectural Analysis of In-memory OLTP	2016	SIGMOD	6.4720641e-05
6,276	Profiling R on a Contemporary Processor	2015	VLDB	5.9291284e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,292	Compacting Transactional Data in Hybrid OLTP&OLAP Databases	2012	VLDB
2	157	OLTP Through the Looking Glass, and What We Found There	2008	SIGMOD
3	5,686	OLTPShare: The Case for Sharing in OLTP Workloads	2018	VLDB
4	11,622	Workload Interference Analysis for HTAP*	2021	CIDR
5	8,072	Operational Analytics Data Management Systems	2016	VLDB
6	1,964	OLTP on Hardware Islands	2012	VLDB
7	11,273	OLAP on Modern Chiplet-Based Processors	2024	VLDB
8	966	A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database	2009	SIGMOD
9	4,866	Micro-architectural Analysis of In-memory OLTP	2016	SIGMOD
10	13,405	Micro-architectural Analysis of OLAP Systems on Persistent Memory	2022	CIDR