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: 9953
Venue: VLDB
Year: 2009
Pagerank: 7.1837096e-05
Overall Rank: 3,354 | 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,817	SSD Bufferpool Extensions for Database Systems	2010	VLDB	0.00010435936
3,365	Turbocharging DBMS Buffer Pool Using SSDs	2011	SIGMOD	7.1728897e-05
3,980	Making Updates Disk-I/O Friendly Using SSDs	2013	VLDB	6.5664429e-05
5,126	Data Management Over Flash Memory	2011	SIGMOD	5.6793656e-05
5,331	Hybrid Storage Management for Database Systems	2013	VLDB	5.5665225e-05
5,724	Flash-Based Extended Cache for Higher Throughput and Faster Recovery	2012	VLDB	5.3518469e-05
5,848	MaSM: Efficient Online Updates in Data Warehouses	2011	SIGMOD	5.3021155e-05
6,920	Towards Cost-Effective Storage Provisioning for DBMSs	2012	VLDB	4.8925595e-05
7,247	hStorage-DB: Heterogeneity-aware Data Management to Exploit the Full Capability of Hybrid Storage Systems	2012	VLDB	4.790684e-05
7,514	System Co-Design and Data Management for Flash Devices	2011	VLDB	4.7180617e-05
7,715	Query Centric Partitioning and Allocation for Partially Replicated Database Systems	2017	SIGMOD	4.6699261e-05
8,205	PR-Join: A Non-Blocking Join Achieving Higher Early Result Rate with Statistical Guarantees	2010	SIGMOD	4.5593375e-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.00055721729
345	Design of Flash-Based DBMS: An In-Page Logging Approach	2007	SIGMOD	0.00026677681
493	A Case for Flash Memory SSD in Enterprise Database Applications	2008	SIGMOD	0.00021837534
496	Automatic SQL Tuning in Oracle 10g	2004	VLDB	0.00021728655
1,060	Flashing Up the Storage Layer	2008	VLDB	0.00014370687
2,828	Automatic Physical Design Tuning: Workload as a Sequence	2006	SIGMOD	8.0548516e-05
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
5,815	StatAdvisor: Recommending Statistical Views	2009	VLDB	5.3165295e-05
13,074	Performance Analysis Of Three Related Assignment Problems	1979	SIGMOD	4.1945683e-05
6,920	Towards Cost-Effective Storage Provisioning for DBMSs	2012	VLDB	4.8925595e-05
8,631	Parallel I/O Aware Query Optimization	2014	SIGMOD	4.4806824e-05
4,125	Towards Effective and Efficient Free Space Management	1996	SIGMOD	6.4332935e-05
5,331	Hybrid Storage Management for Database Systems	2013	VLDB	5.5665225e-05
5,225	Optimizing Databases by Learning Hidden Parameters of Solid State Drives	2020	VLDB	5.6194324e-05
1,817	SSD Bufferpool Extensions for Database Systems	2010	VLDB	0.00010435936
3,365	Turbocharging DBMS Buffer Pool Using SSDs	2011	SIGMOD	7.1728897e-05
5,465	Workload-Aware Storage Layout for Database Systems	2010	SIGMOD	5.4919488e-05