优秀论文 审核通过 未经允许 切勿外传

SQL_Server简介毕业论文中英文资料外文翻译文献

1.SQLServerRelationalDatabaseIntroduction1．SQLServeristhedevelopmentandpromotionofMicrosoft'srelationaldatabasesystem(DBMS),itwasoriginallyproposedbyMicrosoft,SybaseandAshton-Tatethreecompaniesjointlydevelopedandlaunchedin1988,thefirstOS2version.2．Relationaldatabase(RDBMS)

ManagementSystemfeatures：

Themaintenanceoftherelationshipbetweenthedatabasedata;Guaranteethecorrectnessofdatastorage;Whensystemfailuresoccurwhenallthedatabacktothelinetoensureaconsistentstate3．RDBMS：

SQLServer,Oracle,DB2,Sybase,Informix4．Non-RDBMS(File-based)：

Foxpro,Access2.TheVersionofSQLServer2000CommonversionofSQLServer2000are：

EnterpriseEdition(EnterpriseEdition)

SupportallthefunctionsofSQLServer2000.Theversionnumberofproductsforlargeandmedium-sizeddatabaseserver,andcansupportlarge-scaleWebsite,enterpriseOLTP(onlinetransactionprocessing)

andlarge-scaledatawarehousesystemsOLAP(OnlineAnalyticalProcessing)

performancerequired.StandardEdition(StandardEdition) Practicalscopeoftheworkofsmallgroupsordepartments.ItsupportsmostfeaturesofSQLServer2000.However,donothavetosupportlargedatabases,datawarehousesandwebsitefunctionality.Also,donotsupportallthefunctionsofrelationaldatabaseengine.PersonalEdition(PersonalEdition)

Mainlyappliedtomobileusersbecausetheyareoftendisconnectedfromthenetwork,andruntheapplicationstillneedsthesupportofSQLServer2000.Inadditiontotransactionprocessingfunctionsotherthanreproduction,tosupportallSQLServer2000StandardEditionfeaturessupport.DevelopersEdition(DeveloperEdition)

ApplytotheversionofapplicationdevelopmentandsupportinadditiontographicallanguagesettingsotherthantheSQLServer2000allotherfunctions.Thisversionismainlyappliedtoapplicationsprogrammersinthedevelopment,itwillbeSQLServer2000asitsdatastoragearea.Althoughthedevelopmentoffull-featuredversion,butonlyhavebeenauthorizedtodevelopandtestasystem,ratherthanaproductserver.32.1SQLServerFeatures1.IntegrationwiththeInternet：

SQLServer2000databaseenginefullsupportofXML(ExtensiveMarkupLanguage,ExtensibleMarkupLanguage),enablesuserstoeasilypublishthedatainthedatabasetotheWebpage.2.Scalabilityandavailability：

AcrossfromthelaptoprunningWindows9598computersrunningtheWindows2000andotherlarge-scalemulti-processorplatform.Inaddition,theJointserver,viewtheindexandsoon,makingSQLServer2000EnterpriseEditioncanupgradetothelargestWebsiteoftheperformancelevelsrequi

red.3.Enterprise-leveldatabasefunctions：

SQLServer2000distributedquerybyinvokingthedatafromdifferentdatabases,andthesefortheuseriscompletelytransparent;distributeddatabasewillensurethatanyupdatestodistributeddataintegrity;copywillenableustothemaintenanceofmultipledataCopiesoftheseuserstoworkindependently,andthenchangesintothereleasedatabase;SQLServer2000relationaldatabaseenginecanfullyprotectdataintegrity,managementofcomplicationscanalsomodifythedatabasetominimizeoverhead.4.Easyinstallation,deploymentanduse：

SQLServer2000fromaseriesofmanagementanddevelopmenttools,thesetoolsmadeinanumberofsitesontheSQLServerinstallation,deployment,managementanduseeasier.DeveloperscanmorequicklydeliverSQLServerapplications,andonlyrequireminimalinstallationandmanagementoftheseapplicationscanbeachieved.5.DataWarehouse：

DataWarehouseisincludedinSQLServer2000foranalysisofaggregatedataaccessandanalysisforonlineanalyticalprocessingtool.ThisfeatureisonlyinOracleandotherDBMSinthemoreexpensivecan.2.1.1NewFeaturesofSQLServer2000ComprehensiveSQLServer7.0extendstheperformance,reliabilityandeaseofuse.Increaseinaseriesoffunctions,asfollows：

1.Inregardtothestrengtheningofrelationaldatabase2.Enhancedgraphicalmanagement3.Enhancethejointdatabaseserver42.2ToolsandutilitiesofSQLServer2000SQLServer2000thereareeighttoolsare：

1.EnterpriseManager;2.ServiceManager;3.QueryAnalyzer;4.Profiler;5.importandexportdata;6.theservernetworktool;7.theclientne