Towards Cost-Effective Storage Provisioning for DBMSs

Summary: Defines TOC-based storage provisioning for DBMSs with mixed SSD/HDD I/O, to minimize total cost under SLAs (hardware amortization + energy). Presents DOT, a heuristic integrated into PostgreSQL, showing TOC savings on TPC-H/TPC-C workloads. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 10665
Venue: VLDB
Year: 2012
Pagerank: 5.6029996e-05
Overall Rank: 7,525 | 48.38%
DOI: 10.14778/2095686.2095687

Incoming Non-self Citations Over Time

Authors

1. Ning Zhang (University of Wisconsin)
2. Junichi Tatemura (NEC Corporation)
3. Jignesh M. Patel (University of Wisconsin)
4. Hakan Hacigumus (NEC Corporation)

BibTeX Citation

@article{zhang_vldb12,
        title = {{Towards Cost-Effective Storage Provisioning for DBMSs}},
        author = {Zhang, Ning and Tatemura, Junichi and Patel, Jignesh M. and Hacigumus, Hakan},
        journal = {PVLDB},
        series = {{VLDB} '12},
        volume = {5},
        number = {4},
        pages = {274--285},
        doi = {10.14778/2095686.2095687},
        url = {https://doi.org/10.14778/2095686.2095687},
        year = {2012}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
12,254	DBMS Metrology: Measuring Query Time	2013	SIGMOD	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
488	Design of Flash-Based DBMS: An In-Page Logging Approach	2007	SIGMOD	0.00017615543
512	Tree Indexing on Solid State Drives	2010	VLDB	0.00017196795
561	A Case for Flash Memory SSD in Enterprise Database Applications	2008	SIGMOD	0.00016525248
768	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD	0.00014173242
861	Automatic Virtual Machine Configuration for Database Workloads	2008	SIGMOD	0.00013543212
961	Lazy-Adaptive Tree: An Optimized Index Structure for Flash Devices	2009	VLDB	0.00012941098
999	Flashing Up the Storage Layer	2008	VLDB	0.00012740138
1,455	Query Processing Techniques for Solid State Drives	2009	SIGMOD	0.00010733981
1,490	SSD Bufferpool Extensions for Database Systems	2010	VLDB	0.00010595269
2,722	Automatic Physical Design Tuning: Workload as a Sequence	2006	SIGMOD	8.206711e-05
2,814	Cooperative Expendable Micro-Slice Servers (CEMS): Low Cost, Low Power Servers for Internet-Scale Services	2009	CIDR	8.0972113e-05
3,055	An Object Placement Advisor for DB2 Using Solid State Storage	2009	VLDB	7.8079566e-05
5,135	Workload-Aware Storage Layout for Database Systems	2010	SIGMOD	6.3523987e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,303	hStorage-DB: Heterogeneity-aware Data Management to Exploit the Full Capability of Hybrid Storage Systems	2012	VLDB
2	7,589	Cost-Intelligent Data Analytics in the Cloud	2024	CIDR
3	883	Analyzing the Energy Efficiency of a Database Server	2010	SIGMOD
4	2,344	Towards Cost-Optimal Query Processing in the Cloud	2021	VLDB
5	8,410	Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems	2022	VLDB
6	5,135	Workload-Aware Storage Layout for Database Systems	2010	SIGMOD
7	3,891	Storage Workload Estimation for Database Management Systems	2007	SIGMOD
8	5,398	A Cost Model for Clustered Object-Oriented Databases	1995	VLDB
9	3,055	An Object Placement Advisor for DB2 Using Solid State Storage	2009	VLDB
10	4,790	A Characterization of the Sensitivity of Query Optimization to Storage Access Cost Parameters	2003	SIGMOD