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
- 1. H. V. Jagadish (University of Michigan)
- 2. Laks V. S. Lakshmanan (Indian Institute of Technology Mumbai)
- 3. Divesh Srivastava (AT&T)
BibTeX Citation
@article{jagadish_vldb99,
title = {{What can Hierarchies do for Data Warehouses?}},
author = {Jagadish, H. V. and Lakshmanan, Laks V. S. and Srivastava, Divesh},
journal = {PVLDB},
series = {{VLDB} '99},
year = {1999}
}Incoming Citations (Sorted by Pagerank)
Showing 7 of 7 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,575 | Optimal Histograms for Hierarchical Range Queries (Extended Abstract) | 2000 | PODS | 7.2946291e-05 |
| 4,822 | Colorful XML: One Hierarchy Isn't Enough | 2004 | SIGMOD | 6.4919484e-05 |
| 5,892 | OLAP Dimension Constraints | 2002 | PODS | 6.0488431e-05 |
| 5,895 | The 3W Model and Algebra for Unified Data Mining | 2000 | VLDB | 6.0486927e-05 |
| 6,452 | Efficient Implementation of Large-Scale Multi-Structural Databases | 2005 | VLDB | 5.8751532e-05 |
| 6,658 | CURE for Cubes: Cubing Using a ROLAP Engine | 2006 | VLDB | 5.8104851e-05 |
| 12,580 | Relaxation in Text Search using Taxonomies | 2008 | VLDB | 5.093636e-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 |
|---|---|---|---|---|
| 1 | 1,708 | Using Schematically Heterogeneous Structures | 1998 | SIGMOD |
| 2 | 2,496 | Star-Cubing: Computing Iceberg Cubes by Top-Down and Bottom-Up Integration | 2003 | VLDB |
| 3 | 3,954 | Hierarchical Cubes for Range-Sum Queries | 1999 | VLDB |
| 4 | 11,609 | High-dimensional Data Cubes | 2022 | VLDB |
| 5 | 3,575 | Optimal Histograms for Hierarchical Range Queries (Extended Abstract) | 2000 | PODS |
| 6 | 4,889 | Fast Algorithms For Hierarchical Range Histogram Construction | 2002 | PODS |
| 7 | 995 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB |
| 8 | 12,057 | Index-Assisted Hierarchical Computations in Main-Memory RDBMS | 2016 | VLDB |
| 9 | 4,258 | Diamond in the Rough: Finding Hierarchical Heavy Hitters in Multi-Dimensional Data | 2004 | SIGMOD |
| 10 | 7,162 | Processing Star Queries on Hierarchically-Clustered Fact Tables | 2002 | VLDB |