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

附錄1外文原文DatawarehousetechniqueThedatawarehousesaysallThedatawarehouseisanenvironment,notaproduct.Itprovidesthedecisionthatcustomerusedforcurrenthistorydatasupports,thesedataisverydifficultintraditionaloperationtypedatabaseorcantget,saymoretangibly,thedatawarehouseisakindofsystemconstruction.Datawarehousethanitcustomerrelationthemanagementisaconceptthatisbeenfamiliarwithbyperson,itis1991theUnitedStatesaninformationengineeringlearnswhathouseW.H.InmonDoctorputforward,itsdefinitionisthedatawarehouseisasupportdecisiontheprocessfacestothetopicof,gatherof,atanytimebutchangeof,thelastlongdatagathers.ThetechniquesystemconstructionofthedatawarehouseThedataofobtainsmoldpiece:Usedforobtainingthedatafromthesourcedocumentwiththesourcedatabase,combinetheproceedingsweep,delivering,addingittodatawarehousedatabaseinside.Datamanagementmoldpiece:Usedforthemovementofthemanagementdatawarehouse.Deliversmoldpiece:Usedfortheotherwarehouseindirectionwithassignthedatawarehousedataintheexteriorsystem.Thedataisinthecenteramoldpiece:Theendcustomerindirectiontoolthatusedforthemethodprovidestheinterviewdatawarehousedatabase.Datainterviewmoldpiece:Usedforprovidingtheinterviewfortheendcustomerofthebusinessenterprisewiththetooloftheanalysisdatawarehousedata.Designmoldpiece:Usedforthedesigndatawarehousedatabase.Informationcataloguemoldpiece:Usedforgovernortoprovidewiththecustomerrelevantsavingcontentsindatawarehousedatainthedatabasewithmeaninginformation.HowtoestablishthedatawarehouseCurrent,theinternalcalculatorinbusinessenterprisesystemismutuallyindependent,thedatarule(legitimacy)demandofthesystemthathaveisaffirmedfromtheothersystem,variousdatalackstogathersex,conductandactionstrend,thedatawarehousetechniqueisanoneofthemostemollientwaytomakesthesedatagatheredgetups,thedatawarehouseestablishescanatlogicalrealizevarioussysteminteractionoperation,thislaythefoundationforthemoderncollegeindevelopments,alsoleadsforthecollegelayersciencedecisionofferingguaranteespowerfully.Theprocessthatestablishinthedatawarehouseneedsbelowstep:1.Establishthedatamodeltotheendbusinessneed.Thedesignofthedatamodelnotonlyconsideronlytothefirsttopic,butalsolooksafterbothsidestheneedoftheothermanagementincollegedecisiontopictosearchestheneedofthetopicwitheverykindofdata,statement.2.Thecertaintopicproceedingdatasetsupthemold.Accordingtothedecisionneedcertaintopic,choicedatasource,proceedlogicconstructiondesign.3.Thedatabaseofthedesigndatawarehouse.Putgreatemphasisonthesavingconstructioninphysicsthatapplyinthetopicdevelopmentdatawarehouseinsidedata.4.Definitiondatasource.Accordingtothetopicdatamodel,choosedifferentoperationtypedatabaseasthedatasource.5.Establishthemodelforadata.Themodelmadesureintothedatascopeofthedatawarehouse,andwithprovisionofrelevantdata.Completeadata,canletcustomerknown,thedatawarehouseinsidehasactuallywhatdata,thedatagathersthelevelofstructurewithhowdetaileddegreeis,canprovidewhatinformation,howtheseinformationarecarriedcalculateswithorganizesetc.6.Take(Extract),convert(Transmit),addfromtheoperationtypedatabaseinsidetakeoutthedatathatcarry(Load)thedatabaseinsidearrivethedatawarehouse.7.Choicedatainterviewanalysistool,thecustomerwillusethesavinginformationwithinthesetoolsesinterviewdatawarehouse,realizingdecisionsupportneed.ThedatascoopsoutthetechniqueAlongwiththedatabasetechnicaldevelopcontinuouslyandextensiveapplicationineachprofessioninsysteminmanagementindatabase,thebacklogenlargesinthenastyplayinamountofdatainthedatabase,butamongthemcanusedirectlyhoweveroppositelessinamountofinformation.Peoplehavebeenhopingcantoconcealinthesuperficialinformationinthesedata,proceedmanylevelofstructuresanalyze,forthepurposeofbetterlandutilizationacquirethebenefittooperateinthebusinesswiththesedata,increasetheinformationofthesocialcompetitionability.Currenteverykindofdatabasemanagementsystemalthoughcanrealizesefficientlythedatarecordintoandsearch,statisticstowaitthefunction,cantdiscoverrelationexistedinthedatawithregulation,resultedinlikethisandthenakindofdataBangandknowledgeneedykeepbothofphenomenon.Accordingtotheinquisition,thedatacollectionsincreasewithsavingwitheveryyear130%speed,butinthedataonlyhave2%datatoisanalyzedavailably.Thisexploitationthatscoopoutprovidedthevastspaceforthedata.Tothe2004,applytoattainUSD1,000,000,000inthedataoftheelectroniccommercemarketofscoopingoutthetool.附錄2外文資料譯文數(shù)據(jù)倉庫技術(shù)數(shù)據(jù)倉庫概述數(shù)據(jù)倉庫是一個環(huán)境，而不是一件產(chǎn)品。它提供用戶用于決策支持的當前歷史數(shù)據(jù)，這些數(shù)據(jù)在傳統(tǒng)的操作型數(shù)據(jù)庫中很難或不能得到，更確切地說，數(shù)據(jù)倉庫是一種體系結(jié)構(gòu)。數(shù)據(jù)倉庫較之客戶關(guān)系管理是一個被人熟知的概念，它是1991年美國著名信息工程學家W.H.Inmon博士提出的，將其定義為“數(shù)據(jù)倉庫是支持決策過程的面向主題的、集成的、隨時間而改變的、持久的數(shù)據(jù)集合”。數(shù)據(jù)倉庫的技術(shù)體系結(jié)構(gòu)數(shù)據(jù)獲取模塊：用于從源文件和源數(shù)據(jù)庫中獲取數(shù)據(jù)，并進行清潔,傳輸，將它加到數(shù)據(jù)倉庫數(shù)據(jù)庫中。數(shù)據(jù)管理模塊：用于管理數(shù)據(jù)倉庫的運行。數(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)容和含義信息。如何建立數(shù)據(jù)倉庫目前，企業(yè)內(nèi)部的計算機系統(tǒng)相互獨