数据仓库的基本概念（Basic concepts of data warehouse）.docVIP

数据仓库的基本概念（Basic concepts of data warehouse） 1., the concept of data warehouse began in the mid 80s of the last century, and it first appeared in the book data warehouse, which is called the father of data warehouse, WilliamH.Inmon. With the large data system research, management, maintenance and other aspects of the profound recognition and continuous improvement, after summing up, rich and concentrated for enterprise information experience, data warehouse provides a more precise definition of the data warehouse is a subject oriented in business management and decision making, and integration time related, can not modify the data collection. Data warehouse has no strict data theory foundation, nor mature basic model, and is more inclined to engineering, and has strong engineering. Usually, according to the key technology, it is divided into three basic aspects, such as data extraction, storage and management, and data performance. The focus and requirement of data warehouse is that the data can be extracted from the database accurately, safely and reliably, and then processed and converted into regular information for managers to analyze and use. Data warehouse is mainly used in decision support system, whose main purpose is to extract information and extend it to handle the application of decision support system (DSS) based on data warehouse. 2 data warehouse based decision support system (DSS) consists of three parts: Data Warehouse Technology (Data warehousing), OLAP (OLAP, On - Line Analytical Pro - cessing), data mining (Data Mining). OLAP (OLAP, On - Analytical Pro - cessing) is to enable the analysis of personnel, managers or executives from a variety of angles can be transformed from the original data, the real user understand and reflect the characteristics of the enterprise to information fast, consistent, interactive access, a kind of software the technology to obtain a more in-depth understanding of the data. The goal of OLAP is to satisfy decision suppo