The data warehouse says all
The data warehouse is an environment, not a product. It provides the decision that customer used for current history data supports, these data is very difficult in traditional operation type database or can't get, say more tangibly, the data warehouse is a kind of system construction. Data warehouse than it customer relation the management is a concept that is been familiar with by person, it is 1991 the United States an information engineering learns what house W.H. Inmon Doctor put forward, its definition is" the data warehouse is a support decision the process faces to the topic of, gather of, at any time but change of, the last long data gathers".
The technique system construction of the data warehouse
The data of obtains mold piece: Used for obtaining the data from the source document with the source database, combine the proceeding sweep, delivering, adding it to data warehouse database inside.
• Data management mold piece: Used for the movement of the management data warehouse.
• Delivers mold piece: Used for the other warehouse in direction with assign the data warehouse data in the exterior system.
• The data is in the center a mold piece: The end customer in direction tool that used for the method provides the interview data warehouse database.
• Data interview mold piece: Used for providing the interview for the end customer of the business enterprise with the tool of the analysis data warehouse data.
• Design mold piece: Used for the design data warehouse database.
• Information catalogue mold piece: Used for governor to provide with the customer relevant saving contents in data warehouse data in the database with meaning information.
數(shù)據(jù)倉(cāng)庫(kù)概述
數(shù)據(jù)倉(cāng)庫(kù)是一個(gè)環(huán)境，而不是一件產(chǎn)品。它提供用戶用于決策支持的當(dāng)前歷史數(shù)據(jù)，這些數(shù)據(jù)在傳統(tǒng)的操作型數(shù)據(jù)庫(kù)中很難或不能得到，更確切地說(shuō)，數(shù)據(jù)倉(cāng)庫(kù)是一種體系結(jié)構(gòu)。數(shù)據(jù)倉(cāng)庫(kù)較之客戶關(guān)系管理是一個(gè)被人熟知的概念，它是1991年美國(guó)著名信息工程學(xué)家W.H.Inmon博士提出的，將其定義為 “數(shù)據(jù)倉(cāng)庫(kù)是支持決策過(guò)程的面向主題的、集成的、隨時(shí)間而改變的、持久的數(shù)據(jù)集合”。
數(shù)據(jù)倉(cāng)庫(kù)的技術(shù)體系結(jié)構(gòu)
•數(shù)據(jù)獲取模塊：用于從源文件和源數(shù)據(jù)庫(kù)中獲取數(shù)據(jù)，并進(jìn)行清潔,傳輸，將它加到數(shù)據(jù)倉(cāng)庫(kù)數(shù)據(jù)庫(kù)中。
•數(shù)據(jù)管理模塊：用于管理數(shù)據(jù)倉(cāng)庫(kù)的運(yùn)行。
•數(shù)據(jù)傳遞模塊：用于向其他倉(cāng)庫(kù)和外部系統(tǒng)中分配數(shù)據(jù)倉(cāng)庫(kù)數(shù)據(jù)。
•中間件模塊：用于向最終用戶工具提供訪問(wèn)數(shù)據(jù)倉(cāng)庫(kù)數(shù)據(jù)庫(kù)的方法。
•數(shù)據(jù)訪問(wèn)模塊：用于為企業(yè)的最終用戶提供訪問(wèn)和分析數(shù)據(jù)倉(cāng)庫(kù)數(shù)據(jù)的工具。
•設(shè)計(jì)模塊：用于設(shè)計(jì)數(shù)據(jù)倉(cāng)庫(kù)數(shù)據(jù)庫(kù)。
•信息目錄模塊：用于為管理者和用戶提供有關(guān)存儲(chǔ)在數(shù)據(jù)倉(cāng)庫(kù)數(shù)據(jù)庫(kù)中的數(shù)據(jù)的內(nèi)容和含義信息。