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: 9954
Venue: VLDB
Year: 2009
Pagerank: 7.1724434e-05
Overall Rank: 3,358 | 76.67%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,815	SSD Bufferpool Extensions for Database Systems	2010	VLDB	0.00010439702
3,362	Turbocharging DBMS Buffer Pool Using SSDs	2011	SIGMOD	7.1681058e-05
3,979	Making Updates Disk-I/O Friendly Using SSDs	2013	VLDB	6.5641036e-05
5,126	Data Management Over Flash Memory	2011	SIGMOD	5.6739907e-05
5,333	Hybrid Storage Management for Database Systems	2013	VLDB	5.5627592e-05
5,731	Flash-Based Extended Cache for Higher Throughput and Faster Recovery	2012	VLDB	5.3476002e-05
5,848	MaSM: Efficient Online Updates in Data Warehouses	2011	SIGMOD	5.3023051e-05
6,922	Towards Cost-Effective Storage Provisioning for DBMSs	2012	VLDB	4.8878659e-05
7,239	hStorage-DB: Heterogeneity-aware Data Management to Exploit the Full Capability of Hybrid Storage Systems	2012	VLDB	4.7870862e-05
7,513	System Co-Design and Data Management for Flash Devices	2011	VLDB	4.7135369e-05
7,713	Query Centric Partitioning and Allocation for Partially Replicated Database Systems	2017	SIGMOD	4.6662571e-05
8,993	PR-Join: A Non-Blocking Join Achieving Higher Early Result Rate with Statistical Guarantees	2010	SIGMOD	4.4105266e-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
80	Weaving Relations for Cache Performance	2001	VLDB	0.00055735291
347	Design of Flash-Based DBMS: An In-Page Logging Approach	2007	SIGMOD	0.0002656744
492	A Case for Flash Memory SSD in Enterprise Database Applications	2008	SIGMOD	0.0002178745
495	Automatic SQL Tuning in Oracle 10g	2004	VLDB	0.00021712703
1,061	Flashing Up the Storage Layer	2008	VLDB	0.0001435824
2,834	Automatic Physical Design Tuning: Workload as a Sequence	2006	SIGMOD	8.0468556e-05
3,661	Database Tuning Advisor for Microsoft SQL Server 2005: Demo	2005	SIGMOD	6.8680306e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
5,824	StatAdvisor: Recommending Statistical Views	2009	VLDB	5.311975e-05
13,087	Performance Analysis Of Three Related Assignment Problems	1979	SIGMOD	4.1905499e-05
6,922	Towards Cost-Effective Storage Provisioning for DBMSs	2012	VLDB	4.8878659e-05
8,631	Parallel I/O Aware Query Optimization	2014	SIGMOD	4.4763867e-05
4,115	Towards Effective and Efficient Free Space Management	1996	SIGMOD	6.4326063e-05
5,333	Hybrid Storage Management for Database Systems	2013	VLDB	5.5627592e-05
5,229	Optimizing Databases by Learning Hidden Parameters of Solid State Drives	2020	VLDB	5.6140339e-05
1,815	SSD Bufferpool Extensions for Database Systems	2010	VLDB	0.00010439702
3,362	Turbocharging DBMS Buffer Pool Using SSDs	2011	SIGMOD	7.1681058e-05
5,475	Workload-Aware Storage Layout for Database Systems	2010	SIGMOD	5.4870223e-05