An overview of data warehousing and OLAP technology Export

@article{citeulike:620833, 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.}, address = {New York, NY, USA}, author = {Chaudhuri, Surajit and Dayal, Umeshwar}, citeulike-article-id = {620833}, citeulike-linkout-0 = {http://portal.acm.org/citation.cfm?id=248616}, citeulike-linkout-1 = {http://dx.doi.org/10.1145/248603.248616}, doi = {10.1145/248603.248616}, issn = {0163-5808}, journal = {SIGMOD Rec.}, month = {March}, number = {1}, pages = {65--74}, posted-at = {2009-08-18 15:24:25}, priority = {2}, publisher = {ACM}, title = {An overview of data warehousing and OLAP technology}, url = {http://dx.doi.org/10.1145/248603.248616}, volume = {26}, year = {1997} }

TY - JOUR ID - citeulike:620833 L3 - citeulike-article-id:620833 N2 - 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. IS - 1 JF - SIGMOD Rec. SN - 0163-5808 AD - New York, NY, USA EP - 74 TI - An overview of data warehousing and OLAP technology PB - ACM VL - 26 SP - 65 AU - Chaudhuri, Surajit AU - Dayal, Umeshwar PY - 1997/03// UR - http://dx.doi.org/10.1145/248603.248616 ER -