外文翻譯---數(shù)據(jù)倉庫技術(shù)

1、<p>　　附錄1 外文原文 </p><p>　　Data warehouse technique</p><p>　　The data warehouse says all</p><p>　　The data warehouse is an environment, not a product. It provides the decision t

2、hat 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 ware

3、house 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, </p><

4、;p>　　The technique system construction of the data warehouse</p><p>　　The data of obtains mold piece: Used for obtaining the data from the source document with the source database, combine the proceeding

5、sweep, delivering, adding it to data warehouse database inside.</p><p>　　· Data management mold piece: Used for the movement of the management data warehouse.</p><p>　　· Delivers mold

6、piece: Used for the other warehouse in direction with assign the data warehouse data in the exterior system.</p><p>　　· The data is in the center a mold piece: The end customer in direction tool that us

7、ed for the method provides the interview data warehouse database.</p><p>　　· Data interview mold piece: Used for providing the interview for the end customer of the business enterprise with the tool of

8、the analysis data warehouse data.</p><p>　　· Design mold piece: Used for the design data warehouse database.</p><p>　　· Information catalogue mold piece: Used for governor to provide w

9、ith the customer relevant saving contents in data warehouse data in the database with meaning information.</p><p>　　How to establish the data warehouse</p><p>　　Current, the internal calculator

10、in business enterprise system is mutually independent, the data rule( legitimacy) demand of the system that have is affirmed from the other system, various data lacks to gather sex, conduct and actions trend, the data wa

11、rehouse technique is an one of the most emollient way to makes these data gathered get ups, the data warehouse establishes can at logical realize various system interaction operation, this lay the foundation for the mod

12、ern college in developments</p><p>　　1. Establish the data model to the end business need. The design of the data model not only consider only to the first topic, but also looks after both sides the need of

13、the other management in college decision topic to searches the need of the topic with every kind of data, statement.</p><p>　　2. The certain topic proceeding data sets up the mold. According to the decision

14、need certain topic, choice data source, proceed logic construction design.</p><p>　　3. The database of the design data warehouse. Put great emphasis on the saving construction in physics that apply in the to

15、pic development data warehouse inside data.</p><p>　　4. Definition data source. According to the topic data model, choose different operation type database as the data source.</p><p>　　5. Establ

16、ish the model for a data. The model made sure into the data scope of the data warehouse, and with provision of relevant data. Complete a data, can let customer known, the data warehouse inside has actually what data, the

17、 data gathers the level of structure with how detailed degree is, can provide what information, how these information are carried calculates with organizes etc..</p><p>　　6. Take( Extract), convert( Transm

18、it), add from the operation type database inside take out the data that carry( Load) the database inside arrive the data warehouse.</p><p>　　7. Choice data interview analysis tool, the customer will use the

19、saving information within these toolses interview data warehouse, realizing decision support need.</p><p>　　The data scoops out the technique</p><p>　　Along with the database technical develop c

20、ontinuously and extensive application in each profession in system in management in database, the backlog enlarges in the nasty play in amount of data in the database, but among them can use directly however opposite les

21、s in amount of information.</p><p>　　People have been hoping can to conceal in the superficial information in these data, proceed many level of structures analyze, for the purpose of better land utilization

22、acquire the benefit to operate in the business with these data, increase the information of the social competition ability. </p><p>　　Current every kind of database management system although can realizes ef

23、ficiently the data record into and search, statistics to wait the function, can't discover relation existed in the data with regulation, resulted in like this and then a kind of data Bang and knowledge needy keep bo

24、th of phenomenon. According to the inquisition, the data collections increase with saving with every year 130% speed, but in the data only have 2% data to is analyzed availably. This exploitation that scoop out </p>

25、;<p>　　附錄2 外文資料譯文</p><p><b>　　數(shù)據(jù)倉庫技術(shù)</b></p><p><b>　　數(shù)據(jù)倉庫概述</b></p><p>　　數(shù)據(jù)倉庫是一個環(huán)境，而不是一件產(chǎn)品。它提供用戶用于決策支持的當(dāng)前歷史數(shù)據(jù)，這些數(shù)據(jù)在傳統(tǒng)的操作型數(shù)據(jù)庫中很難或不能得到，更確切地說，數(shù)據(jù)倉庫是一種體系結(jié)

26、構(gòu)。數(shù)據(jù)倉庫較之客戶關(guān)系管理是一個被人熟知的概念，它是1991年美國著名信息工程學(xué)家W.H.Inmon博士提出的，將其定義為 “數(shù)據(jù)倉庫是支持決策過程的面向主題的、集成的、隨時間而改變的、持久的數(shù)據(jù)集合”。</p><p>　　數(shù)據(jù)倉庫的技術(shù)體系結(jié)構(gòu)</p><p>　　·數(shù)據(jù)獲取模塊：用于從源文件和源數(shù)據(jù)庫中獲取數(shù)據(jù)，并進(jìn)行清潔,傳輸，將它加到數(shù)據(jù)倉庫數(shù)據(jù)庫中。</p&g

27、t;<p>　　·數(shù)據(jù)管理模塊：用于管理數(shù)據(jù)倉庫的運行。</p><p>　　·數(shù)據(jù)傳遞模塊：用于向其他倉庫和外部系統(tǒng)中分配數(shù)據(jù)倉庫數(shù)據(jù)。</p><p>　　·中間件模塊：用于向最終用戶工具提供訪問數(shù)據(jù)倉庫數(shù)據(jù)庫的方法。</p><p>　　·數(shù)據(jù)訪問模塊：用于為企業(yè)的最終用戶提供訪問和分析數(shù)據(jù)倉庫數(shù)據(jù)的工具。

28、</p><p>　　·設(shè)計模塊：用于設(shè)計數(shù)據(jù)倉庫數(shù)據(jù)庫。</p><p>　　·信息目錄模塊：用于為管理者和用戶提供有關(guān)存儲在數(shù)據(jù)倉庫數(shù)據(jù)庫中的數(shù)據(jù)的內(nèi)容和含義信息。</p><p><b>　　如何建立數(shù)據(jù)倉庫</b></p><p>　　目前，企業(yè)內(nèi)部的計算機(jī)系統(tǒng)相互獨立，有的系統(tǒng)的數(shù)據(jù)規(guī)則性（

29、合法性）需要從其它系統(tǒng)中得到認(rèn)定，各類數(shù)據(jù)缺乏集成性，作為趨勢，數(shù)據(jù)倉庫技術(shù)是使這些數(shù)據(jù)集成起來的最有力的方式之一，數(shù)據(jù)倉庫的建立能在邏輯上實現(xiàn)各類系統(tǒng)互動操作，這就為建設(shè)現(xiàn)代化學(xué)院奠定基礎(chǔ)，也為學(xué)院領(lǐng)導(dǎo)層科學(xué)決策提供強(qiáng)有力的保證。建立數(shù)據(jù)倉庫的過程中需要以下步驟：</p><p>　　1．對最終業(yè)務(wù)需求建立數(shù)據(jù)模型。數(shù)據(jù)模型的設(shè)計不僅僅考慮對最初主題，還要兼顧學(xué)院其他管理決策主題的需求和各種數(shù)據(jù)、報表查詢主題的

30、需求。</p><p>　　2．確定主題進(jìn)行數(shù)據(jù)建模。根據(jù)決策需求確定主題，選擇數(shù)據(jù)源，進(jìn)行邏輯結(jié)構(gòu)設(shè)計。</p><p>　　3．設(shè)計數(shù)據(jù)倉庫之?dāng)?shù)據(jù)庫。著重于應(yīng)用于主題開發(fā)數(shù)據(jù)倉庫中數(shù)據(jù)的物理存儲結(jié)構(gòu)。</p><p>　　4．定義數(shù)據(jù)源。根據(jù)主題數(shù)據(jù)模型，選擇不同的操作型數(shù)據(jù)庫為數(shù)據(jù)源。</p><p>　　5．為元數(shù)據(jù)建立模型。模型確定

31、了進(jìn)入數(shù)據(jù)倉庫的數(shù)據(jù)范圍，以及與數(shù)據(jù)有關(guān)的規(guī)定。完備的元數(shù)據(jù)，能讓用戶知道，數(shù)據(jù)倉庫中究竟有什么數(shù)據(jù)，數(shù)據(jù)匯總層次和詳細(xì)程度如何，能提供什么信息，這些信息是如何運算和組織等。</p><p>　　6．從操作型數(shù)據(jù)庫中抽取（Extract）、轉(zhuǎn)換（Transmit）、加載（Load）數(shù)據(jù)到數(shù)據(jù)倉庫之?dāng)?shù)據(jù)庫中。</p><p>　　7．選擇數(shù)據(jù)訪問分析工具，用戶將使用這些工具訪問數(shù)據(jù)倉庫中的存

32、儲信息，實現(xiàn)決策支持需求[11]。</p><p><b>　　數(shù)據(jù)挖掘技術(shù)</b></p><p>　　隨著數(shù)據(jù)庫技術(shù)的不斷發(fā)展及數(shù)據(jù)庫管理系統(tǒng)在各個行業(yè)的廣泛應(yīng)用，積累在數(shù)據(jù)庫中的數(shù)據(jù)量急劇增大，但其中可直接使用的信息量卻相對較少。人們一直希望能夠?qū)﹄[藏在這些數(shù)據(jù)表面的信息，進(jìn)行多層次分析，以便更好地利用這些數(shù)據(jù)獲得利于商業(yè)運作，提高社會競爭力的信息。目前的各種數(shù)