Database Paper Browser

Back to papers

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)

Paper ID
8598
Venue
VLDB
Year
1999
Pagerank
6.4952391e-05
Overall Rank
4,050 | 71.86%
DOI
-

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,718 Colorful XML: One Hierarchy Isn't Enough 2004 SIGMOD 6.8148882e-05
4,018 Optimal Histograms for Hierarchical Range Queries (Extended Abstract) 2000 PODS 6.5250686e-05
5,280 The 3W Model and Algebra for Unified Data Mining 2000 VLDB 5.5851818e-05
5,707 OLAP Dimension Constraints 2002 PODS 5.363144e-05
6,368 Efficient Implementation of Large-Scale Multi-Structural Databases 2005 VLDB 5.0886655e-05
6,739 CURE for Cubes: Cubing Using a ROLAP Engine 2006 VLDB 4.9413138e-05
12,395 Relaxation in Text Search using Taxonomies 2008 VLDB 4.1905499e-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