Efficient Bulk Deletes for Multi Dimensional Clustered Tables in DB2

Summary: DB2 UDB Viper 2's MDC Rollout enables online bulk deletes on multi-dimensional clustered tables via asynchronous secondary RID index updates. Shows order-of-magnitude improvements and documents design lessons for rollout with many secondary indexes. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9530
Venue: VLDB
Year: 2007
Pagerank: 4.3607717e-05
Overall Rank: 9,279 | 35.52%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,863	Efficient Index Compression in DB2 LUW	2009	VLDB	7.9982677e-05
3,363	Lethe: A Tunable Delete-Aware LSM Engine	2020	SIGMOD	7.1680649e-05
3,979	Making Updates Disk-I/O Friendly Using SSDs	2013	VLDB	6.5641036e-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
32	Differential Files: Their Application To The Maintenance Of Large Data Bases	1976	SIGMOD	0.00077553033
2,092	Multi-Dimensional Clustering: A New Data Layout Scheme in DB2	2003	SIGMOD	9.5635999e-05
2,139	A Generic Approach to Bulk Loading Multidimensional Index Structures	1997	VLDB	9.4618572e-05
3,031	Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2	2003	VLDB	7.675808e-05
4,753	OODB Bulk Loading Revisited: The Partitioned-List Approach	1995	VLDB	5.9393144e-05
6,473	Efficient Search of Multidimensional B-Trees	1995	VLDB	5.0427056e-05
7,877	Bulk Loading into an OODB: A Performance Study	1994	VLDB	4.6259513e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
6,832	CMD: A Multidimensional Declustering Method for Parallel Database Systems	1992	VLDB	4.9077892e-05
825	Simultaneous Optimization and Evaluation of Multiple Dimensional Queries	1998	SIGMOD	0.00016171735
2,460	A Performance Analysis of Alternative Multi-Attribute Declustering Strategies	1992	SIGMOD	8.7522298e-05
7,082	Increasing Buffer-Locality for Multiple Index Based Scans through Intelligent Placement and Index Scan Speed Control	2007	VLDB	4.8333334e-05
12,605	Returning Modified Rows – SELECT Statements with Side Effects	2004	VLDB	4.1905499e-05
769	Multi-Dimensional Database Allocation for Parallel Data Warehouses	2000	VLDB	0.00016862794
12,664	An Efficient Method for Performing Record Deletions and Updates Using Index Scans	2002	VLDB	4.1905499e-05
7,591	Automated design of multidimensional clustering tables for relational databases	2004	VLDB	4.6986414e-05
2,092	Multi-Dimensional Clustering: A New Data Layout Scheme in DB2	2003	SIGMOD	9.5635999e-05
3,031	Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2	2003	VLDB	7.675808e-05