A Storage Advisor for Hybrid-Store Databases

Summary: Proposes a storage advisor for hybrid-store databases (row/column) using a cost model to predict per-table query times and select the optimal store. Also handles horizontal and vertical partitioning across stores and validates gains on SAP HANA by measuring recommendation quality and performance. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 10412
Venue: VLDB
Year: 2012
Pagerank: 4.5296588e-05
Overall Rank: 8,389 | 41.64%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,807	H2O: A Hands-free Adaptive Store	2014	SIGMOD	0.00010487796
4,161	Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe?	2017	SIGMOD	6.3938006e-05

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
35	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.00076197749
52	Database Architecture Optimized for the new Bottleneck: Memory Access	1999	VLDB	0.00066474881
80	Weaving Relations for Cache Performance	2001	VLDB	0.00055721729
158	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00040071492
237	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00031726304
258	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.0003022091
286	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00028990057
464	A Case for Fractured Mirrors	2002	VLDB	0.0002245871
596	HYRISE—A Main Memory Hybrid Storage Engine	2011	VLDB	0.00019481482
1,053	A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database	2009	SIGMOD	0.00014429683
3,653	Database Tuning Advisor for Microsoft SQL Server 2005: Demo	2005	SIGMOD	6.8743355e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
4,578	SAP HANA Adoption of Non-Volatile Memory	2017	VLDB	6.0708028e-05
10,767	The HANA Native Query Engine for Lakehouse Systems	2025	VLDB	4.1945683e-05
9,008	Hybrid Row-Column Partitioning in Teradata	2016	VLDB	4.4100992e-05
10,415	SAP HANA Cloud: Data Management for Modern Enterprise Applications	2025	SIGMOD	4.1945683e-05
497	Column-Stores vs. Row-Stores: How Different Are They Really?	2008	SIGMOD	0.00021716559
5,881	Page As You Go: Piecewise Columnar Access In SAP HANA	2016	SIGMOD	5.2895336e-05
13,454	Storing and Processing Temporal Data in a Main Memory Column Store	2013	VLDB	-
1,700	Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads	2016	SIGMOD	0.00010858865
3,905	Native Store Extension for SAP HANA	2019	VLDB	6.6408563e-05
858	Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth	2012	SIGMOD	0.000158756