An Object Placement Advisor for DB2 Using Solid State Storage

Summary: Presents an Object Placement Advisor for DB2 using SSDs to speed hot, randomly accessed objects. Profile-driven selection via DP (dynamic programming) identifies tables, indexes, and views to place on SSD; experiments on TPC-H/TPC-C show gains with limited SSD capacity. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 10144
Venue: VLDB
Year: 2009
Pagerank: 7.8079566e-05
Overall Rank: 3,055 | 79.05%
DOI: 10.14778/1687553.1687557

Incoming Non-self Citations Over Time

Authors

1. Mustafa Canim (University of Texas)
2. George A. Mihaila (IBM)
3. Bishwaranjan Bhattacharjee (IBM)
4. Kenneth A. Ross (Columbia University)
5. Christian A. Lang (IBM)

BibTeX Citation

@article{canim_vldb09,
        title = {{An Object Placement Advisor for DB2 Using Solid State Storage}},
        author = {Canim, Mustafa and Mihaila, George A. and Bhattacharjee, Bishwaranjan and Ross, Kenneth A. and Lang, Christian A.},
        journal = {PVLDB},
        series = {{VLDB} '09},
        doi = {10.14778/1687553.1687557},
        url = {https://doi.org/10.14778/1687553.1687557},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,490	SSD Bufferpool Extensions for Database Systems	2010	VLDB	0.00010595269
3,095	Turbocharging DBMS Buffer Pool Using SSDs	2011	SIGMOD	7.7641876e-05
3,808	Making Updates Disk-I/O Friendly Using SSDs	2013	VLDB	7.1083217e-05
5,080	Hybrid Storage Management for Database Systems	2013	VLDB	6.3711674e-05
5,144	Data Management Over Flash Memory	2011	SIGMOD	6.3473454e-05
5,504	Flash-Based Extended Cache for Higher Throughput and Faster Recovery	2012	VLDB	6.1946862e-05
5,564	MaSM: Efficient Online Updates in Data Warehouses	2011	SIGMOD	6.1716245e-05
7,303	hStorage-DB: Heterogeneity-aware Data Management to Exploit the Full Capability of Hybrid Storage Systems	2012	VLDB	5.6504901e-05
7,525	Towards Cost-Effective Storage Provisioning for DBMSs	2012	VLDB	5.6029996e-05
7,585	Query Centric Partitioning and Allocation for Partially Replicated Database Systems	2017	SIGMOD	5.5912479e-05
7,935	System Co-Design and Data Management for Flash Devices	2011	VLDB	5.5181056e-05
9,017	PR-Join: A Non-Blocking Join Achieving Higher Early Result Rate with Statistical Guarantees	2010	SIGMOD	5.3311284e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
49	Weaving Relations for Cache Performance	2001	VLDB	0.00043781096
488	Design of Flash-Based DBMS: An In-Page Logging Approach	2007	SIGMOD	0.00017615543
524	Automatic SQL Tuning in Oracle 10g	2004	VLDB	0.00017120666
561	A Case for Flash Memory SSD in Enterprise Database Applications	2008	SIGMOD	0.00016525248
999	Flashing Up the Storage Layer	2008	VLDB	0.00012740138
2,722	Automatic Physical Design Tuning: Workload as a Sequence	2006	SIGMOD	8.206711e-05
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	5,514	StatAdvisor: Recommending Statistical Views	2009	VLDB
2	13,275	Performance Analysis Of Three Related Assignment Problems	1979	SIGMOD
3	7,525	Towards Cost-Effective Storage Provisioning for DBMSs	2012	VLDB
4	8,800	Parallel I/O Aware Query Optimization	2014	SIGMOD
5	5,115	Towards Effective and Efficient Free Space Management	1996	SIGMOD
6	5,080	Hybrid Storage Management for Database Systems	2013	VLDB
7	4,894	Optimizing Databases by Learning Hidden Parameters of Solid State Drives	2020	VLDB
8	1,490	SSD Bufferpool Extensions for Database Systems	2010	VLDB
9	3,095	Turbocharging DBMS Buffer Pool Using SSDs	2011	SIGMOD
10	5,135	Workload-Aware Storage Layout for Database Systems	2010	SIGMOD