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,551 | Optimal Histograms for Hierarchical Range Queries (Extended Abstract) | 2000 | PODS | 7.37979e-05 |
| 4,758 | Colorful XML: One Hierarchy Isn't Enough | 2004 | SIGMOD | 6.5924562e-05 |
| 5,786 | OLAP Dimension Constraints | 2002 | PODS | 6.1498351e-05 |
| 5,807 | The 3W Model and Algebra for Unified Data Mining | 2000 | VLDB | 6.1423731e-05 |
| 6,331 | Efficient Implementation of Large-Scale Multi-Structural Databases | 2005 | VLDB | 5.9727031e-05 |
| 6,554 | CURE for Cubes: Cubing Using a ROLAP Engine | 2006 | VLDB | 5.9004238e-05 |
| 12,395 | Relaxation in Text Search using Taxonomies | 2008 | VLDB | 5.1725247e-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,688 | Using Schematically Heterogeneous Structures | 1998 | SIGMOD | 0.00010094814 |
| 2,448 | Star-Cubing: Computing Iceberg Cubes by Top-Down and Bottom-Up Integration | 2003 | VLDB | 8.6328578e-05 |
| 3,888 | Hierarchical Cubes for Range-Sum Queries | 1999 | VLDB | 7.1039451e-05 |
| 11,414 | High-dimensional Data Cubes | 2022 | VLDB | 5.1725247e-05 |
| 3,551 | Optimal Histograms for Hierarchical Range Queries (Extended Abstract) | 2000 | PODS | 7.37979e-05 |
| 4,828 | Fast Algorithms For Hierarchical Range Histogram Construction | 2002 | PODS | 6.5574478e-05 |
| 963 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB | 0.00013010677 |
| 11,864 | Index-Assisted Hierarchical Computations in Main-Memory RDBMS | 2016 | VLDB | 5.1725247e-05 |
| 4,187 | Diamond in the Rough: Finding Hierarchical Heavy Hitters in Multi-Dimensional Data | 2004 | SIGMOD | 6.908669e-05 |
| 7,039 | Processing Star Queries on Hierarchically-Clustered Fact Tables | 2002 | VLDB | 5.7719387e-05 |