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.8149304e-05
Overall Rank
4,355 | 69.74%
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,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