外文翻译--数据仓库技术.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外文资料译文数据仓库技术数据仓库概述数据仓库是一个环境，而不是一件产品。它提供用户用于决策支持的当前历史数据，这些数据在传统的操作型数据库中很难或不能得到，更确切地说，数据仓库是一种体系结构。数据仓库较之客户关系管理是一个被人熟知的概念，它是1991年美国著名信息工程学家W.H.Inmon博士提出的，将其定义为“数据仓库是支持决策过程的面向主题的、集成的、随时间而改变的、持久的数据集合”。数据仓库的技术体系结构数据获取模块：用于从源文件和源数据库中获取数据，并进行清洁,传输，将它加到数据仓库数据库中。数据管理模块：用于管理数据仓库的运行。数据传递模块：用于向其他仓库和外部系统中分配数据仓库数据。中间件模块：用于向最终用户工具提供访问数据仓库数据库的方法。数据访问模块：用于为企业的最终用户提供访问和分析数据仓库数据的工具。设计模块：用于设计数据仓库数据库。信息目录模块：用于为管理者和用户提供有关存储在数据仓库数据库中的数据的内容和含义信息。如何建立数据仓库目前，企业内部的计算机系统相互独