外文翻译--数据仓库技术.doc
附录1外文原文DatawarehousetechniqueThedatawarehousesaysallThedatawarehouseisanenvironment,notaproduct.Itprovidesthedecisionthatcustomerusedforcurrenthistorydatasupports,thesedataisverydifficultintraditionaloperationtypedatabaseorcantget,saymoretangibly,thedatawarehouseisakindofsystemconstruction.Datawarehousethanitcustomerrelationthemanagementisaconceptthatisbeenfamiliarwithbyperson,itis1991theUnitedStatesaninformationengineeringlearnswhathouseW.H.InmonDoctorputforward,itsdefinitionis"thedatawarehouseisasupportdecisiontheprocessfacestothetopicof,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博士提出的,将其定义为“数据仓库是支持决策过程的面向主题的、集成的、随时间而改变的、持久的数据集合”。数据仓库的技术体系结构·数据获取模块:用于从源文件和源数据库中获取数据,并进行清洁,传输,将它加到数据仓库数据库中。·数据管理模块:用于管理数据仓库的运行。·数据传递模块:用于向其他仓库和外部系统中分配数据仓库数据。·中间件模块:用于向最终用户工具提供访问数据仓库数据库的方法。·数据访问模块:用于为企业的最终用户提供访问和分析数据仓库数据的工具。·设计模块:用于设计数据仓库数据库。·信息目录模块:用于为管理者和用户提供有关存储在数据仓库数据库中的数据的内容和含义信息。如何建立数据仓库目前,企业内部的计算机系统相互独立,有的系统的数据规则性(合法性)需要从其它系统中得到认定,各类数据缺乏集成性,作为趋势,数据仓库技术是使这些数据集成起来的最有力的方式之一,数据仓库的建立能在逻辑上实现各类系统互动操作,这就为建设现代化学院奠定基础,也为学院领导层科学决策提供强有力的保证。建立数据仓库的过程中需要以下步骤:1对最终业务需求建立数据模型。数据模型的设计不仅仅考虑对最初主题,还要兼顾学院其他管理决策主题的需求和各种数据、报表查询主题的需求。2确定主题进行数据建模。根据决策需求确定主题,选择数据源,进行逻辑结构设计。