A Storage Advisor for Hybrid-Store Databases

Summary: Storage advisor for hybrid row/column stores, using a workload- and data-aware cost model to recommend placements. Uniquely explores horizontal and vertical partitioning across stores, improving SAP HANA query performance. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 10600
Venue: VLDB
Year: 2012
Pagerank: 5.4230061e-05
Overall Rank: 8,452 | 42.02%
DOI: 10.14778/2367502.2367518

Incoming Non-self Citations Over Time

Authors

1. Philipp Rösch (SAP)
2. Lars Dannecker (SAP)
3. Gregor Hackenbroich (SAP)
4. Franz Färber (SAP)

BibTeX Citation

@article{rosch_vldb12,
        title = {{A Storage Advisor for Hybrid-Store Databases}},
        author = {Rösch, Philipp and Dannecker, Lars and Hackenbroich, Gregor and Färber, Franz},
        journal = {PVLDB},
        series = {{VLDB} '12},
        volume = {5},
        number = {12},
        pages = {1748--1759},
        doi = {10.14778/2367502.2367518},
        url = {https://doi.org/10.14778/2367502.2367518},
        year = {2012}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,367	H2O: A Hands-free Adaptive Store	2014	SIGMOD	0.00011014419
3,598	Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe?	2017	SIGMOD	7.2718988e-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
14	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.0006312782
29	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.00052093615
49	Weaving Relations for Cache Performance	2001	VLDB	0.00043781096
87	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035281619
156	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00028636811
184	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.00026256101
199	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00025612088
394	A Case for Fractured Mirrors	2002	VLDB	0.00019306179
428	HYRISE—A Main Memory Hybrid Storage Engine	2011	VLDB	0.00018633493
966	A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database	2009	SIGMOD	0.00012920281
3,777	Database Tuning Advisor for Microsoft SQL Server 2005: Demo	2005	SIGMOD	7.1347483e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,133	SAP HANA Adoption of Non-Volatile Memory	2017	VLDB
2	10,997	The HANA Native Query Engine for Lakehouse Systems	2025	VLDB
3	9,159	Hybrid Row-Column Partitioning in Teradata	2016	VLDB
4	9,772	SAP HANA Cloud: Data Management for Modern Enterprise Applications	2025	SIGMOD
5	345	Column-Stores vs. Row-Stores: How Different Are They Really?	2008	SIGMOD
6	5,921	Page As You Go: Piecewise Columnar Access In SAP HANA	2016	SIGMOD
7	13,655	Storing and Processing Temporal Data in a Main Memory Column Store	2013	VLDB
8	1,199	Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads	2016	SIGMOD
9	3,367	Native Store Extension for SAP HANA	2019	VLDB
10	575	Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth	2012	SIGMOD