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,653 | Optimal Histograms for Hierarchical Range Queries (Extended Abstract) | 2000 | PODS | 7.1149642e-05 |
| 4,965 | Colorful XML: One Hierarchy Isn't Enough | 2004 | SIGMOD | 6.3225096e-05 |
| 6,030 | OLAP Dimension Constraints | 2002 | PODS | 5.8911268e-05 |
| 6,034 | The 3W Model and Algebra for Unified Data Mining | 2000 | VLDB | 5.8906344e-05 |
| 6,589 | Efficient Implementation of Large-Scale Multi-Structural Databases | 2005 | VLDB | 5.7233473e-05 |
| 6,818 | CURE for Cubes: Cubing Using a ROLAP Engine | 2006 | VLDB | 5.6589988e-05 |
| 9,920 | Relaxation in Text Search using Taxonomies | 2008 | VLDB | 5.0983269e-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,736 | Using Schematically Heterogeneous Structures | 1998 | SIGMOD |
| 2 | 2,550 | Star-Cubing: Computing Iceberg Cubes by Top-Down and Bottom-Up Integration | 2003 | VLDB |
| 3 | 4,056 | Hierarchical Cubes for Range-Sum Queries | 1999 | VLDB |
| 4 | 11,967 | High-dimensional Data Cubes | 2022 | VLDB |
| 5 | 3,653 | Optimal Histograms for Hierarchical Range Queries (Extended Abstract) | 2000 | PODS |
| 6 | 5,031 | Fast Algorithms For Hierarchical Range Histogram Construction | 2002 | PODS |
| 7 | 1,003 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB |
| 8 | 12,400 | Index-Assisted Hierarchical Computations in Main-Memory RDBMS | 2016 | VLDB |
| 9 | 4,353 | Diamond in the Rough: Finding Hierarchical Heavy Hitters in Multi-Dimensional Data | 2004 | SIGMOD |
| 10 | 7,305 | Processing Star Queries on Hierarchically-Clustered Fact Tables | 2002 | VLDB |