Data Warehousing and OLAP for Decision Support

Summary: Contrasts decision-support workloads with OLTP, arguing that data warehouses store historical, consolidated data from multiple sources in large, static repositories. Emphasizes multidimensional modeling, ETL integration, and heavy ad hoc analytics over millions of records, where query throughput and response time trump transaction throughput. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3037
Venue: SIGMOD
Year: 1997
Pagerank: 7.7762802e-05
Overall Rank: 3,079 | 78.88%
DOI: 10.1145/253260.253373

Incoming Non-self Citations Over Time

Authors

1. Surajit Chaudhuri (Microsoft)
2. Umeshwar Dayal (Hewlett Packard Enterprise)

BibTeX Citation

@inproceedings{chaudhuri_sigmod97,
        title = {{Data Warehousing and OLAP for Decision Support}},
        author = {Chaudhuri, Surajit and Dayal, Umeshwar},
        series = {{SIGMOD} '97},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/253260.253373},
        url = {https://dl.acm.org/doi/10.1145/253260.253373},
        year = {1997}
}

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
864	The Pyramid-Technique: Towards Breaking the Curse of Dimensionality	1998	SIGMOD	0.00013522522
1,680	Online Dynamic Reordering for Interactive Data Processing	1999	VLDB	0.00010024295
7,162	Processing Star Queries on Hierarchically-Clustered Fact Tables	2002	VLDB	5.6851725e-05
12,958	A Toolkit for Negotiation Support Interfaces to Multi-Dimensional Data	1997	SIGMOD	5.093636e-05

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

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,160	Graph Cube: On Warehousing and OLAP Multidimensional Networks	2011	SIGMOD
2	12,742	Bridging the Gap between OLAP and SQL	2005	VLDB
3	7,611	Real World Requirements for Decision Support - Implications for RDBMS	1995	SIGMOD
4	905	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD
5	14,151	Industrial Panel on Data Warehousing Technologies: Experiences, Challenges, and Directions	1999	VLDB
6	2,882	OLAP and Statistical Databases: Similarities and Differences	1997	PODS
7	8,957	What is the data warehousing problem? (Are materialized views the answer?)	1996	VLDB
8	966	A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database	2009	SIGMOD
9	4,561	Data Extraction and Transformation for the Data Warehouse	1995	SIGMOD
10	2,943	The Ins and Outs (and Everything in Between) of Data Warehousing	1996	SIGMOD