探索数据库设计外文翻译

《探索数据库设计外文翻译》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、探索数据库设计外文翻译探索数据库设计外文翻译导读：ssuchasSQLServer,MicrosoftExcel,MicrosofticrosoftAccess,andOracle.?ODBCdatasourcessuchasSybaseandInformixusingtheOLEDBProviderforODBC.?ASCIIfixed-fieldlengthtextfilesandASCIIdelimitedtextfiles.Forexample,consideratrainingpanya

2、tionServicesDTSfacilitatestheimport,export,andtransformationofheterogeneousdata.ItsupportstransformationsbetoveandtransformdatabetixusingtheOLEDBProviderforODBC.?ASCIIfixed-fieldlengthtextfilesandASCIIdelimitedtextfiles.Forexample,consideratrainingpan

3、yanagerpopulatesanExcelspreadsheetportedtothecentraldatabaseusingtheDTSImportovedatafromavarietyofdatasourcesintodatamartsordataovetooredatas,theloakeitanattractivechoice.Formany,thefactthatmuchofthelegacydatatobeanalyzedmaybehousedinanOraclesystemost

4、cost-effectiveovingandmassagingthedatafromOracletoSQLServerislessplexandcanbepleyautomated.DTSintroducestheconceptofapackage,edasapartofatransformation.DTShasitsoodel()serverenginethatcanbeusedindependentofSQLServerandthatsupportsscriptingforeachcolum

5、nusingVisualBasic?andJScript?developmentsoftationcanincludedataqualitychecksandvalidation,aggregation,andduplicateelimination.Youcanalsobinemultiplecolumnsintoasinglecolumn,orbuildmultipleroasingleinput.UsingtheDTSsettingsusedbytheOLDDBprovidertoconne

6、cttothedatasourceordestination.?Copyanentiretable,ortheresultsofanSQLquery,suchasthoseinvolvingjoinsofmultipletablesordistributedqueries.DTSalsocancopyschemaanddatabete,datatype,size,precision,scale,andnullabilityofacolumnthesourcetothedestination,ati

7、onrulesthatgovernhonsofdifferentdatatypes,sizes,precisions,scales,andnullabilities.?ExecuteanActiveXscript(VisualBasicorJScript)thatcanmodify探索数据库设计外文翻译(2)导读：apabilitiesofspecificdatabasemanagementsystem(DBMS)orOLEDBdrivers.DTSusesthesourceobject’snam

8、easadefault.Hoarks(““)orsquarebrackets()aroundmultinnamesifthisissupportedbyyourDBMS.DataS)orOLEDBdrivers.DTSusesthesourceobject’snameasadefault.Hoarks(““)orsquarebrackets([])aroundmultinnamesifthisissupportedbyyourDBMS.DataDB2transactionserve