What can Hierarchies do for Data Warehouses?
Summary: Introduces SQL(H), a first-class extension to SQL for data warehouses that supports hierarchical and heterogeneous dimension hierarchies. Uses a hierarchical-join algorithm and dimension indexes to express and compute dimension-fact queries efficiently, addressing verbose SQL under star/snowflake schemas. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 7 of 7 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,716 | Colorful XML: One Hierarchy Isn't Enough | 2004 | SIGMOD | 6.8214504e-05 |
| 4,017 | Optimal Histograms for Hierarchical Range Queries (Extended Abstract) | 2000 | PODS | 6.524501e-05 |
| 5,276 | The 3W Model and Algebra for Unified Data Mining | 2000 | VLDB | 5.5905507e-05 |
| 5,694 | OLAP Dimension Constraints | 2002 | PODS | 5.3682155e-05 |
| 6,370 | Efficient Implementation of Large-Scale Multi-Structural Databases | 2005 | VLDB | 5.0935585e-05 |
| 6,736 | CURE for Cubes: Cubing Using a ROLAP Engine | 2006 | VLDB | 4.9459588e-05 |
| 12,387 | Relaxation in Text Search using Taxonomies | 2008 | VLDB | 4.1945683e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 0 of 0 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,511 | Using Schematically Heterogeneous Structures | 1998 | SIGMOD | 0.00011602872 |
| 2,190 | Star-Cubing: Computing Iceberg Cubes by Top-Down and Bottom-Up Integration | 2003 | VLDB | 9.3317645e-05 |
| 4,444 | Hierarchical Cubes for Range-Sum Queries | 1999 | VLDB | 6.1831691e-05 |
| 11,411 | High-dimensional Data Cubes | 2022 | VLDB | 4.1945683e-05 |
| 4,017 | Optimal Histograms for Hierarchical Range Queries (Extended Abstract) | 2000 | PODS | 6.524501e-05 |
| 3,619 | Fast Algorithms For Hierarchical Range Histogram Construction | 2002 | PODS | 6.9084829e-05 |
| 773 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB | 0.00016870159 |
| 11,856 | Index-Assisted Hierarchical Computations in Main-Memory RDBMS | 2016 | VLDB | 4.1945683e-05 |
| 4,334 | Diamond in the Rough: Finding Hierarchical Heavy Hitters in Multi-Dimensional Data | 2004 | SIGMOD | 6.2798179e-05 |
| 7,045 | Processing Star Queries on Hierarchically-Clustered Fact Tables | 2002 | VLDB | 4.8528709e-05 |