Materialized View Selection in a Multidimensional Database

Summary: Materialized View Selection in a Multidimensional Database proposes scalable MV selection by pruning the lattice to relevant elements. A statistical analysis further narrows the search, boosting efficiency beyond prior approaches. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h6e7d65e3d07db8e3
Venue: VLDB
Year: 1997
Pagerank: 0.00015213935
Overall Rank: 644 | 95.68%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Elena Baralis (Polytechnic University of Turin)
2. Stefano Paraboschi (Polytechnic University of Milan)
3. Ernest Teniente (Polytechnic University of Catalonia)

BibTeX Citation

@article{baralis_vldb97,
        title = {{Materialized View Selection in a Multidimensional Database}},
        author = {Baralis, Elena and Paraboschi, Stefano and Teniente, Ernest},
        journal = {PVLDB},
        series = {{VLDB} '97},
        pages = {156},
        year = {1997}
}

Incoming Citations (Sorted by Pagerank)

Showing 24 of 24 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035351639
403	Bottom-Up Computation of Sparse and Iceberg CUBEs	1999	SIGMOD	0.0001910396
949	DynaMat: A Dynamic View Management System for Data Warehouses	1999	SIGMOD	0.00012902181
957	Materialized View Selection for Multidimensional Datasets	1998	VLDB	0.00012861484
1,036	Fine-grained Partitioning for Aggressive Data Skipping	2014	SIGMOD	0.00012377471
1,764	Caching Multidimensional Queries Using Chunks	1998	SIGMOD	9.6965217e-05
2,256	Dwarf: Shrinking the PetaCube	2002	SIGMOD	8.7438759e-05
2,544	Star-Cubing: Computing Iceberg Cubes by Top-Down and Bottom-Up Integration	2003	VLDB	8.3179863e-05
4,376	Optimization of Run-time Management of Data Intensive Web Sites	1999	VLDB	6.6286338e-05
4,569	COLT: Continuous On-Line Database Tuning	2006	SIGMOD	6.5298888e-05
5,200	Extending Practical Pre-Aggregation in On-Line Analytical Processing	1999	VLDB	6.2326019e-05
5,714	An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees	1998	SIGMOD	6.0202342e-05
5,839	Shrinking the Warehouse Update Window	1999	SIGMOD	5.9746195e-05
6,853	Utilizing IDs to Accelerate Incremental View Maintenance	2015	SIGMOD	5.6647271e-05
7,029	The Case for Deep Query Optimisation	2020	CIDR	5.6174811e-05
7,755	Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse	1999	SIGMOD	5.4590631e-05
8,192	TI: An Efficient Indexing Mechanism for Real-Time Search on Tweets	2011	SIGMOD	5.3804626e-05
9,467	Context-sensitive Ranking for Document Retrieval	2011	SIGMOD	5.1718701e-05
9,585	Materializing Views with Minimal Size To Answer Queries	2003	PODS	5.1571823e-05
10,012	Iceberg-cube Computation with PC Clusters	2001	SIGMOD	5.0979044e-05
11,917	High-dimensional Data Cubes	2022	VLDB	4.9793485e-05
12,932	BIwTL: A Business Information Warehouse Toolkit and Language for Warehousing Simplification and Automation	2007	SIGMOD	4.9793485e-05
13,118	Consistency Based Snapshot Management in Data Grids	2003	VLDB	4.9793485e-05
13,149	Proxy-Server Architectures for OLAP	2001	SIGMOD	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
11	Implementing Data Cubes Efficiently	1996	SIGMOD	0.00071084324
214	On the Computation of Multidimensional Aggregates	1996	VLDB	0.00024656893
398	View Maintenance in a Warehousing Environment	1995	SIGMOD	0.00019152162
655	Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies	1996	VLDB	0.00015070228
744	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.00014309622

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,127	Simultaneous Optimization and Evaluation of Multiple Dimensional Queries	1998	SIGMOD
2	238	Complexity of Answering Queries Using Materialized Views	1998	PODS
3	3,392	A Formal Perspective on the View Selection Problem	2001	VLDB
4	957	Materialized View Selection for Multidimensional Datasets	1998	VLDB
5	553	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD
6	8,561	Materialized View Selection for XQuery Workloads	2012	SIGMOD
7	11	Implementing Data Cubes Efficiently	1996	SIGMOD
8	88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB
9	1,706	Algorithms for Materialized View Design in Data Warehousing Environment	1997	VLDB
10	923	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD