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ù)倉庫概述
數(shù)據(jù)倉庫是一個環(huán)境，而不是一件產(chǎn)品。它提供用戶用于決策支持的當(dāng)前歷史數(shù)據(jù)，這些數(shù)據(jù)在傳統(tǒng)的操作型數(shù)據(jù)庫中很難或不能得到，更確切地說，數(shù)據(jù)倉庫是一種體系結(jié)構(gòu)。數(shù)據(jù)倉庫較之客戶關(guān)系管理是一個被人熟知的概念，它是1991年美國著名信息工程學(xué)家W.H.Inmon博士提出的，將其定義為 “數(shù)據(jù)倉庫是支持決策過程的面向主題的、集成的、隨時間而改變的、持久的數(shù)據(jù)集合”。
數(shù)據(jù)倉庫的技術(shù)體系結(jié)構(gòu)
•數(shù)據(jù)獲取模塊：用于從源文件和源數(shù)據(jù)庫中獲取數(shù)據(jù)，并進(jìn)行清潔,傳輸，將它加到數(shù)據(jù)倉庫數(shù)據(jù)庫中。
•數(shù)據(jù)管理模塊：用于管理數(shù)據(jù)倉庫的運(yùn)行。
•數(shù)據(jù)傳遞模塊：用于向其他倉庫和外部系統(tǒng)中分配數(shù)據(jù)倉庫數(shù)據(jù)。
•中間件模塊：用于向最終用戶工具提供訪問數(shù)據(jù)倉庫數(shù)據(jù)庫的方法。
•數(shù)據(jù)訪問模塊：用于為企業(yè)的最終用戶提供訪問和分析數(shù)據(jù)倉庫數(shù)據(jù)的工具。
•設(shè)計模塊：用于設(shè)計數(shù)據(jù)倉庫數(shù)據(jù)庫。
•信息目錄模塊：用于為管理者和用戶提供有關(guān)存儲在數(shù)據(jù)倉庫數(shù)據(jù)庫中的數(shù)據(jù)的內(nèi)容和含義信息。