Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2
Summary: DB2 8.0 adds MDC by orthogonal attributes so similar rows reside in contiguous blocks. Extends block-oriented access, merges block/record indexes, and applies MDC to nested-loop and star-join processing, with star-schema experiments showing gains. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Bishwaranjan Bhattacharjee (International Business Machines T. J. Watson Research Center)
- 2. Sriram Padmanabhan (International Business Machines T. J. Watson Research Center)
- 3. Timothy Malkemus (International Business Machines T. J. Watson Research Center)
- 4. Tony Lai (International Business Machines Toronto Laboratories)
- 5. Leslie Cranston (International Business Machines Toronto Laboratories)
- 6. Matthew Huras (International Business Machines Toronto Laboratories)
BibTeX Citation
@article{bhattacharjee_vldb03,
title = {{Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2}},
author = {Bhattacharjee, Bishwaranjan and Padmanabhan, Sriram and Malkemus, Timothy and Lai, Tony and Cranston, Leslie and Huras, Matthew},
journal = {PVLDB},
series = {{VLDB} '03},
doi = {10.1016/B978-012722442-8/50090-2},
url = {https://doi.org/10.1016/B978-012722442-8/50090-2},
year = {2003}
}Incoming Citations (Sorted by Pagerank)
Showing 8 of 8 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,036 | Fine-grained Partitioning for Aggressive Data Skipping | 2014 | SIGMOD | 0.00012377471 |
| 1,132 | Qd-tree: Learning Data Layouts for Big Data Analytics | 2020 | SIGMOD | 0.00011898257 |
| 3,081 | Skipping-oriented Partitioning for Columnar Layouts | 2017 | VLDB | 7.6653727e-05 |
| 7,035 | Increasing Buffer-Locality for Multiple Index Based Scans through Intelligent Placement and Index Scan Speed Control | 2007 | VLDB | 5.6163837e-05 |
| 7,845 | Automated design of multidimensional clustering tables for relational databases | 2004 | VLDB | 5.4420146e-05 |
| 9,604 | Efficient Bulk Deletes for Multi Dimensional Clustered Tables in DB2 | 2007 | VLDB | 5.1535527e-05 |
| 10,238 | SOR: A Practical System for Ontology Storage, Reasoning and Search | 2007 | VLDB | 5.0543689e-05 |
| 12,852 | Effective and Efficient Semantic Web Data Management over DB2 | 2008 | SIGMOD | 4.9793485e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 1 of 1 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 2,233 | Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 | 2003 | SIGMOD | 8.7931449e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 644 | Materialized View Selection in a Multidimensional Database | 1997 | VLDB |
| 2 | 3,842 | Query Processing Method for Multi-Attribute Clustered Relations | 1990 | VLDB |
| 3 | 9,405 | Indexing Medium-dimensionality Data in Oracle | 1999 | SIGMOD |
| 4 | 7,285 | Processing Star Queries on Hierarchically-Clustered Fact Tables | 2002 | VLDB |
| 5 | 1,002 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB |
| 6 | 7,055 | CMD: A Multidimensional Declustering Method for Parallel Database Systems | 1992 | VLDB |
| 7 | 1,127 | Simultaneous Optimization and Evaluation of Multiple Dimensional Queries | 1998 | SIGMOD |
| 8 | 9,604 | Efficient Bulk Deletes for Multi Dimensional Clustered Tables in DB2 | 2007 | VLDB |
| 9 | 7,845 | Automated design of multidimensional clustering tables for relational databases | 2004 | VLDB |
| 10 | 2,233 | Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 | 2003 | SIGMOD |