ACM Home Page
Please provide us with feedback. Feedback
Digital Library logoTake a look at the new version of this page: [ beta version ]. Tell us what you think.
An overview of data warehousing and OLAP technology
Full text PdfPdf (102 KB)
Source ACM SIGMOD Record archive
Volume 26 ,  Issue 1  (March 1997) table of contents
Pages: 65 - 74  
Year of Publication: 1997
ISSN:0163-5808
Authors
Surajit Chaudhuri  Microsoft Research, Redmond
Umeshwar Dayal  Hewlett-Packard Labs, Palo Alto
Publisher
ACM  New York, NY, USA
Bibliometrics
Downloads (6 Weeks): 289,   Downloads (12 Months): 2147,   Citation Count: 264
Additional Information:

abstract   references   cited by   index terms   collaborative colleagues  

Tools and Actions: Review this Article  
DOI Bookmark: Use this link to bookmark this Article: http://doi.acm.org/10.1145/248603.248616
What is a DOI?

ABSTRACT

Data warehousing and on-line analytical processing (OLAP) are essential elements of decision support, which has increasingly become a focus of the database industry. Many commercial products and services are now available, and all of the principal database management system vendors now have offerings in these areas. Decision support places some rather different requirements on database technology compared to traditional on-line transaction processing applications. This paper provides an overview of data warehousing and OLAP technologies, with an emphasis on their new requirements. We describe back end tools for extracting, cleaning and loading data into a data warehouse; multidimensional data models typical of OLAP; front end client tools for querying and data analysis; server extensions for efficient query processing; and tools for metadata management and for managing the warehouse. In addition to surveying the state of the art, this paper also identifies some promising research issues, some of which are related to problems that the database research community has worked on for years, but others are only just beginning to be addressed. This overview is based on a tutorial that the authors presented at the VLDB Conference, 1996.


REFERENCES

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

 
1
 
2
2 http://www.olapcouncil.org
 
3
3 Codd, E. F., S. B. Codd, C. T. Salley, "Providing OLAP (On-Line Analytical Processing) to User Analyst: An IT Mandate." Available from Arbor Software's web site http://www.arborsoft.com/OLAP.html.
 
4
4 http://pwp.starnetinc.com/larryg/articles.html
 
5
5 Kimball, R. The Data Warehouse Toolkit. John Wiley, 1996.
6
7
 
8
8 Gupta, A., I. S. Mumick, "Maintenance of Materialized Views: Problems, Techniques, and Applications." Data Eng. Bulletin, Vol. 18, No. 2, June 1995.
9
 
10
10 Roussopoulos, N., et al., "The Maryland ADMS Project: Views R Us." Data Eng. Bulletin, Vol. 18, No. 2, June 1995.
11
12
13
 
14
15
 
16
17
18
 
19
 
20
 
21
22
 
23
 
24
 
25
 
26
 
27
27 Chaudhuri S., Shim K. "An Overview of Cost-based Optimization of Queries with Aggregates" IEEE Data Enginering Bulletin, Sep. 1995.
28
 
29
 
30
30 Agrawal S. et.al. "On the Computation of Multidimensional Aggregates" Proc. of VLDB Conf., 1996.
31
 
32
33
 
34
34 Wu, M-C., A. P. Buchmann. "Research Issues in Data Warehousing." Submitted for publication.

CITED BY  266

Collaborative Colleagues:
Surajit Chaudhuri: colleagues
Umeshwar Dayal: colleagues