On Line Analytic Processing (OLAP)

• S. Chaudhuri, U. Dayal. An Overview of Data Warehousing and OLAP Technology. SIGMOD Record 26(1), 1997, pp. 65-74. We are reading this paper because it gives a good overview of what kinds of processes use OLAP, warehouses, and decision support in general. Read the rest of the paper, but it's fine to just skim sections 3 and 4. Note that SIGMOD Record is basically the SIGMOD newsletter. So there is a reviewing process, but it's not as rigorous as a conference/journal, nor is it as prestigious. This paper is based on a tutorial that the authors gave at VLDB.
• J. Gray, S. Chaudhuri, A. Bosworth, A. Layman, D. Reichart, M. Venkatrao, F. Pellow, H. Pirahesh. Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals Data Mining and Knowledge Discovery, 1997. We are reading this paper because it gives a good example if not the best example of how OLAP differs from traditional data processing. Read the whole paper, though you can skip sections 1.2, 3.1, 3.2, 4, and 5.

  Note that this paper is also available as a journal paper. However, it was easier to get you access to this version, which is why we're reading it. So, yes, it's a technical report, but it's basically a journal paper.

Rachel Pottinger
E-mail Address:
Office Location: ICICS 345
Phone: (604)822-0436
Fax:(604)822-5485
Postal/Courier address:
The Department of Computer Science
University of British Columbia
201-2366 Main Mall
Vancouver, B.C. V6T 1Z4
Canada