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)
Incoming Non-self Citations Over Time
Authors
- 1. Bishwaranjan Bhattacharjee (IBM)
- 2. Timothy Malkemus (IBM)
- 3. Sherman Lau (International Business Machines Toronto Laboratories)
- 4. Sean McKeough (International Business Machines Toronto Laboratories)
- 5. Jo-anne Kirton (International Business Machines Toronto Laboratories)
- 6. Robin Von Boeschoten (International Business Machines Toronto Laboratories)
- 7. John P Kennedy (International Business Machines Toronto Laboratories)
BibTeX Citation
@article{bhattacharjee_vldb07,
title = {{Efficient Bulk Deletes for Multi Dimensional Clustered Tables in DB2}},
author = {Bhattacharjee, Bishwaranjan and Malkemus, Timothy and Lau, Sherman and McKeough, Sean and Kirton, Jo-anne and Von Boeschoten, Robin and Kennedy, John P},
journal = {PVLDB},
series = {{VLDB} '07},
pages = {1197--1208},
year = {2007}
}Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 2,796 | Lethe: A Tunable Delete-Aware LSM Engine | 2020 | SIGMOD | 7.9849253e-05 |
| 3,302 | Efficient Index Compression in DB2 LUW | 2009 | VLDB | 7.4220659e-05 |
| 3,864 | Making Updates Disk-I/O Friendly Using SSDs | 2013 | VLDB | 6.9461754e-05 |
Previous
Page 1 / 1
Next
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 |
|---|---|---|---|---|
| 59 | Differential Files: Their Application To The Maintenance Of Large Data Bases | 1976 | SIGMOD | 0.00039478403 |
| 1,965 | A Generic Approach to Bulk Loading Multidimensional Index Structures | 1997 | VLDB | 9.2829035e-05 |
| 2,245 | Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 | 2003 | SIGMOD | 8.7628897e-05 |
| 3,867 | Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2 | 2003 | VLDB | 6.9438458e-05 |
| 5,072 | OODB Bulk Loading Revisited: The Partitioned-List Approach | 1995 | VLDB | 6.2747182e-05 |
| 6,597 | Efficient Search of Multidimensional B-Trees | 1995 | VLDB | 5.7220175e-05 |
| 8,379 | Bulk Loading into an OODB: A Performance Study | 1994 | VLDB | 5.3272571e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 7,079 | CMD: A Multidimensional Declustering Method for Parallel Database Systems | 1992 | VLDB |
| 2 | 1,131 | Simultaneous Optimization and Evaluation of Multiple Dimensional Queries | 1998 | SIGMOD |
| 3 | 2,659 | A Performance Analysis of Alternative Multi-Attribute Declustering Strategies | 1992 | SIGMOD |
| 4 | 7,055 | Increasing Buffer-Locality for Multiple Index Based Scans through Intelligent Placement and Index Scan Speed Control | 2007 | VLDB |
| 5 | 13,126 | Returning Modified Rows - SELECT Statements with Side Effects | 2004 | VLDB |
| 6 | 1,003 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB |
| 7 | 13,185 | An Efficient Method for Performing Record Deletions and Updates Using Index Scans | 2002 | VLDB |
| 8 | 7,838 | Automated design of multidimensional clustering tables for relational databases | 2004 | VLDB |
| 9 | 2,245 | Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 | 2003 | SIGMOD |
| 10 | 3,867 | Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2 | 2003 | VLDB |