资源描述:
《sql_server简介毕业论文中英文资料外文翻译文献》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、SQL_Server简介毕业论文中英文资料外文翻译文献1.SQLServerRelationalDatabaseIntroduction1.SQLServeristhedevelopmentandpromotionofMicrosoft'srelationaldatabasesystem(DBMS),itwasoriginallyproposedbyMicrosoft,SybaseandAshton-Tatethreecompaniesjointlydevelopedandlaunchedin1988,thefi
2、rstOS/2version.2.Relationaldatabase(RDBMS)ManagementSystemfeatures:Themaintenanceoftherelationshipbetweenthedatabasedata;Guaranteethecorrectnessofdatastorage;Whensystemfailuresoccurwhenallthedatabacktothelinetoensureaconsistentstate3.RDBMS:SQLServer,Oracle,DB
3、/2,Sybase,Informix4.Non-RDBMS(File-based):Foxpro,Access2.TheVersionofSQLServer2000CommonversionofSQLServer2000are:EnterpriseEdition(EnterpriseEdition)SupportallthefunctionsofSQLServer2000.Theversionnumberofproductsforlargeandmedium-sizeddatabaseserver,andcans
4、upportlarge-scaleWebsite,enterpriseOLTP(onlinetransactionprocessing)andlarge-scaledatawarehousesystemsOLAP(OnlineAnalyticalProcessing)performancerequired.StandardEdition(StandardEdition)Practicalscopeoftheworkofsmallgroupsordepartments.Itsupportsmostfeatureso
5、fSQLServer2000.However,donothavetosupportlargedatabases,datawarehousesandwebsitefunctionality.Also,donotsupportallthefunctionsofrelationaldatabaseengine.PersonalEdition(PersonalEdition)Mainlyappliedtomobileusersbecausetheyareoftendisconnectedfromthenetwork,an
6、druntheapplicationstillneedsthesupportofSQLServer2000.Inadditiontotransactionprocessingfunctionsotherthanreproduction,tosupportallSQLServer2000StandardEditionfeaturessupport.DevelopersEdition(DeveloperEdition)Applytotheversionofapplicationdevelopmentandsuppor
7、tinadditiontographicallanguagesettingsotherthantheSQLServer2000allotherfunctions.Thisversionismainlyappliedtoapplicationsprogrammersinthedevelopment,itwillbeSQLServer2000asitsdatastoragearea.Althoughthedevelopmentoffull-featuredversion,butonlyhavebeenauthoriz
8、edtodevelopandtestasystem,ratherthanaproductserver.32.1SQLServerFeatures1.IntegrationwiththeInternet:SQLServer2000databaseenginefullsupportofXML(ExtensiveMarkupLanguage,ExtensibleMarkupLa