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
Incoming Citations (Sorted by Pagerank)
Showing 8 of 8 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,477 | Fine-grained Partitioning for Aggressive Data Skipping | 2014 | SIGMOD | 0.00011770865 |
| 1,611 | Qd-tree: Learning Data Layouts for Big Data Analytics | 2020 | SIGMOD | 0.00011147324 |
| 3,737 | Skipping-oriented Partitioning for Columnar Layouts | 2017 | VLDB | 6.8033227e-05 |
| 7,087 | Increasing Buffer-Locality for Multiple Index Based Scans through Intelligent Placement and Index Scan Speed Control | 2007 | VLDB | 4.8379358e-05 |
| 7,603 | Automated design of multidimensional clustering tables for relational databases | 2004 | VLDB | 4.6985903e-05 |
| 9,275 | Efficient Bulk Deletes for Multi Dimensional Clustered Tables in DB2 | 2007 | VLDB | 4.3645459e-05 |
| 9,891 | SOR: A Practical System for Ontology Storage, Reasoning and Search | 2007 | VLDB | 4.2617199e-05 |
| 12,369 | Effective and Efficient Semantic Web Data Management over DB2 | 2008 | SIGMOD | 4.1945683e-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,045 | Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 | 2003 | SIGMOD | 9.6939983e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 681 | Materialized View Selection in a Multidimensional Database | 1997 | VLDB | 0.00018203591 |
| 3,064 | Query Processing Method for Multi-Attribute Clustered Relations | 1990 | VLDB | 7.6279403e-05 |
| 9,017 | Indexing Medium-dimensionality Data in Oracle | 1999 | SIGMOD | 4.4091374e-05 |
| 7,045 | Processing Star Queries on Hierarchically-Clustered Fact Tables | 2002 | VLDB | 4.8528709e-05 |
| 773 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB | 0.00016870159 |
| 4,740 | CMD: A Multidimensional Declustering Method for Parallel Database Systems | 1992 | VLDB | 5.9594889e-05 |
| 829 | Simultaneous Optimization and Evaluation of Multiple Dimensional Queries | 1998 | SIGMOD | 0.0001618536 |
| 9,275 | Efficient Bulk Deletes for Multi Dimensional Clustered Tables in DB2 | 2007 | VLDB | 4.3645459e-05 |
| 7,603 | Automated design of multidimensional clustering tables for relational databases | 2004 | VLDB | 4.6985903e-05 |
| 2,045 | Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 | 2003 | SIGMOD | 9.6939983e-05 |