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,356 | Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics | 2021 | CIDR | 0.00012409986 |
| 2,914 | Quantifying TPC-H Choke Points and Their Optimizations | 2020 | VLDB | 7.9197583e-05 |
| 6,492 | GOLAP: A GPU-in-Data-Path Architecture for High-Speed OLAP | 2024 | SIGMOD | 5.0364695e-05 |
| 7,743 | Efficient Data Ingestion and Query Processing for LSM-Based Storage Systems | 2019 | VLDB | 4.6581858e-05 |
| 8,499 | Conditional Cuckoo Filters | 2021 | SIGMOD | 4.4929219e-05 |
| 10,289 | Efficient Query Repair for Aggregate Constraints | 2026 | VLDB | 4.1905499e-05 |
| 10,396 | Optimizing Block Skipping for High-Dimensional Data with Learned Adaptive Curve | 2025 | SIGMOD | 4.1905499e-05 |
| 10,415 | Dynamic Pruning for Recursive Joins | 2025 | SIGMOD | 4.1905499e-05 |
| 10,938 | Automated Clustering Recommendation With Database Zone Maps | 2024 | SIGMOD | 4.1905499e-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 |
|---|---|---|---|---|
| 20 | C-Store: A Column-oriented DBMS | 2005 | VLDB | 0.00086163998 |
| 367 | Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing | 1998 | VLDB | 0.00025518228 |
| 470 | Materialized Views In Oracle | 1998 | VLDB | 0.00022386815 |
| 496 | Column-Stores vs. Row-Stores: How Different Are They Really? | 2008 | SIGMOD | 0.00021705611 |
| 1,063 | Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines | 1990 | VLDB | 0.00014352292 |
| 2,503 | Enhanced Subquery Optimizations in Oracle | 2009 | VLDB | 8.6306662e-05 |
| 2,802 | Efficient Execution of Joins in a Star Schema | 2002 | SIGMOD | 8.1073885e-05 |
| 3,160 | Horizontal Data Partitioning In Database Design | 1982 | SIGMOD | 7.4649653e-05 |
| 4,887 | Distributed Architecture of Oracle Database In-memory | 2015 | VLDB | 5.8498783e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 5,184 | Query Optimization in Oracle 12c Database In-Memory | 2015 | VLDB | 5.6360141e-05 |
| 4,050 | What can Hierarchies do for Data Warehouses? | 1999 | VLDB | 6.4952391e-05 |
| 7,591 | Automated design of multidimensional clustering tables for relational databases | 2004 | VLDB | 4.6986414e-05 |
| 769 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB | 0.00016862794 |
| 8,410 | Pruning in Snowflake: Working Smarter, Not Harder | 2025 | SIGMOD | 4.5154358e-05 |
| 7,042 | Processing Star Queries on Hierarchically-Clustered Fact Tables | 2002 | VLDB | 4.8483133e-05 |
| 12,585 | Data Densification in a Relational Database System | 2004 | SIGMOD | 4.1905499e-05 |
| 3,031 | Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2 | 2003 | VLDB | 7.675808e-05 |
| 2,092 | Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 | 2003 | SIGMOD | 9.5635999e-05 |
| 10,938 | Automated Clustering Recommendation With Database Zone Maps | 2024 | SIGMOD | 4.1905499e-05 |