Dimensions Based Data Clustering and Zone Maps
Summary: Dimension-based clustering of fact tables with zone maps on dimension columns enables cross-table data pruning for star/snowflake schemas. Extends zone-map pruning from local-column clustering to dimension-aware pruning, aligning with Oracle 12c support. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Mohamed Ziauddin
- 2. Andrew Witkowski
- 3. You Jung Kim
- 4. Dmitry Potapov
- 5. Janaki Lahorani
- 6. Murali Krishna
Incoming Citations (Sorted by Pagerank)
Showing 9 of 9 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,377 | Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics | 2021 | CIDR | 0.00012296941 |
| 2,916 | Quantifying TPC-H Choke Points and Their Optimizations | 2020 | VLDB | 7.9068048e-05 |
| 6,496 | GOLAP: A GPU-in-Data-Path Architecture for High-Speed OLAP | 2024 | SIGMOD | 5.0413077e-05 |
| 7,743 | Efficient Data Ingestion and Query Processing for LSM-Based Storage Systems | 2019 | VLDB | 4.6626575e-05 |
| 8,502 | Conditional Cuckoo Filters | 2021 | SIGMOD | 4.4972336e-05 |
| 10,277 | Efficient Query Repair for Aggregate Constraints | 2026 | VLDB | 4.1945683e-05 |
| 10,385 | Optimizing Block Skipping for High-Dimensional Data with Learned Adaptive Curve | 2025 | SIGMOD | 4.1945683e-05 |
| 10,404 | Dynamic Pruning for Recursive Joins | 2025 | SIGMOD | 4.1945683e-05 |
| 10,935 | Automated Clustering Recommendation With Database Zone Maps | 2024 | SIGMOD | 4.1945683e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 9 of 9 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 21 | C-Store: A Column-oriented DBMS | 2005 | VLDB | 0.00086087497 |
| 368 | Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing | 1998 | VLDB | 0.000254931 |
| 468 | Materialized Views In Oracle | 1998 | VLDB | 0.00022411821 |
| 497 | Column-Stores vs. Row-Stores: How Different Are They Really? | 2008 | SIGMOD | 0.00021716559 |
| 1,063 | Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines | 1990 | VLDB | 0.00014362773 |
| 2,504 | Enhanced Subquery Optimizations in Oracle | 2009 | VLDB | 8.6351917e-05 |
| 2,795 | Efficient Execution of Joins in a Star Schema | 2002 | SIGMOD | 8.1128059e-05 |
| 3,153 | Horizontal Data Partitioning In Database Design | 1982 | SIGMOD | 7.4707022e-05 |
| 4,891 | Distributed Architecture of Oracle Database In-memory | 2015 | VLDB | 5.8516672e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 5,186 | Query Optimization in Oracle 12c Database In-Memory | 2015 | VLDB | 5.6400929e-05 |
| 4,043 | What can Hierarchies do for Data Warehouses? | 1999 | VLDB | 6.5015013e-05 |
| 7,603 | Automated design of multidimensional clustering tables for relational databases | 2004 | VLDB | 4.6985903e-05 |
| 8,415 | Pruning in Snowflake: Working Smarter, Not Harder | 2025 | SIGMOD | 4.5197687e-05 |
| 773 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB | 0.00016870159 |
| 12,576 | Data Densification in a Relational Database System | 2004 | SIGMOD | 4.1945683e-05 |
| 7,045 | Processing Star Queries on Hierarchically-Clustered Fact Tables | 2002 | VLDB | 4.8528709e-05 |
| 3,028 | Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2 | 2003 | VLDB | 7.6816205e-05 |
| 2,045 | Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 | 2003 | SIGMOD | 9.6939983e-05 |
| 10,935 | Automated Clustering Recommendation With Database Zone Maps | 2024 | SIGMOD | 4.1945683e-05 |