SQL-Server簡介畢業(yè)論文中英文資料外文翻譯文獻(xiàn)

SQL-Server簡介畢業(yè)論文中英文資料外文翻譯文獻(xiàn)SQL-Server簡介畢業(yè)論文中英文資料外文翻譯文獻(xiàn)/SQL-Server簡介畢業(yè)論文中英文資料外文翻譯文獻(xiàn)SQL_Server簡介畢業(yè)論文中英文資料外文翻譯文獻(xiàn)1.SQLServerRelationalDatabaseIntroduction1．SQLServeristhedevelopmentandpromotionofMicrosoft'srelationaldatabasesystem(DBMS),itwasoriginallyproposedbyMicrosoft,SybaseandAshton-Tatethreecompaniesjointlydevelopedandlaunchedin1988,thefirstOS/2version.2．Relationaldatabase(RDBMS)ManagementSystemfeatures：Themaintenanceoftherelationshipbetweenthedatabasedata;Guaranteethecorrectnessofdatastorage;Whensystemfailuresoccurwhenallthedatabacktothelinetoensureaconsistentstate3．RDBMS：SQLServer,Oracle,DB/2,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：AcrossfromthelaptoprunningWindows95/98computersrunningtheWindows2000andotherlarge-scalemulti-processorplatform.Inaddition,theJointserver,viewtheindexandsoon,makingSQLServer2000EnterpriseEditioncanupgradetothelargestWebsiteoftheperformancelevelsrequired.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.theclientnetwork;8.tousetools,onlinehelpdocumentation.2.2.1EnterpriseManagerEnterpriseManagerisbasedonanewknownastheMicrosoftManagementConsole(MicrosoftManagementConsole)managementofthepublicserverenvironment,SQLServer2000itisoneofthemostimportantmanagementtool.EnterpriseManagercannotonlyconfigurethesystemenvironmentandmanagementofSQLServer,butalsobecauseitcanbestackedtodisplaytheformofalistofallSQLServerobjects,soalltheSQLServerobjecttheestablishmentandmanagementwereabletopassthroughittocomplete.Withbusinessmanagementtocompletetheoperation：1.ThemanagementofSQLServerserver;theestablishmentandmanagementofdatabases;theestablishmentandmanagementoftables,views,storedprocedures,triggerprocedures,roles,rules,defaultvalues,suchasdatabaseobjects,aswellasuser-defineddatatypes;backupdatabasesandtransactionlogs,Torestoredatabase;copieddatabase;settaskscheduling;setthealarm;toprovideinter-servercontrolofthedrag-and-dropoperation;manageuseraccounts;theestablishmentofTransact-SQLcommandstatements,aswellasmanagementandcontrolofSQLMail.2.InEnterpriseManagercontainstwowindows,theleftsideofthewindowasa"tree"shownintheactivewindow,thecontentsoftherightsideofthewindowisdisplayed.3.Theleftwindowclicktheplussigntoexpandallthesub-projectcontains.4.Anitembycheckingthenode,youcanseetherightsideofthewindowcontainsthecontentsoftheproject.52.2.2ServiceManager(ServiceManager)SQLServerServiceManagerisaserver-sidewhentheactualworkofthemostusefulutilities,servicemanagertostart,pause,continueandstopthedatabaseserverinreal-timeservices,thetypeofserviceprovided,including：SQLServer,SQLServerAgent,MicrosoftSearchandDistributedTransactionCoordinatorandsoon.SQLserver簡介簡介簡介簡介1．．．．SQLServer關(guān)系數(shù)據(jù)庫簡介關(guān)系數(shù)據(jù)庫簡介關(guān)系數(shù)據(jù)庫簡介關(guān)系數(shù)據(jù)庫簡介1．SQLServer是由Microsoft開發(fā)和推廣的關(guān)系數(shù)據(jù)庫系統(tǒng)（DBMS)，它最初是由Microsoft、Sybase和Ashton-Tate三家公司共同開發(fā)的，并于1988年推出了第一個OS/2版本。2．關(guān)系數(shù)據(jù)庫（RDBMS)管理系統(tǒng)功能：維護(hù)數(shù)據(jù)庫數(shù)據(jù)之間的關(guān)系；保證數(shù)據(jù)存儲的正確性；當(dāng)出現(xiàn)系統(tǒng)故障的時候，將所有數(shù)據(jù)恢復(fù)到能夠保證一致行的某種狀態(tài)3．RDBMS：SQLServer，Oracle，DB/2,Sybase，Informix4．Non-RDBMS(File-based）：Foxpro，Access2、、、、SQLServer2000的版本的版本的版本的版本SQLServer2000常見版本有：企業(yè)版（EnterpriseEdition)支持所有SQLServer2000的功能。該版本多用于大中型產(chǎn)品數(shù)據(jù)庫服務(wù)器，并且可以支持大型網(wǎng)站，企業(yè)OLTP（聯(lián)機(jī)事務(wù)處理）和大型數(shù)據(jù)倉庫系統(tǒng)OLAP(聯(lián)機(jī)分析處理）所要求的性能。標(biāo)準(zhǔn)版（StandardEdition)實用范圍是小型的工作組或部門。它支持大多數(shù)的SQLServer2000功能。但是，不具有支持大型數(shù)據(jù)庫，數(shù)據(jù)倉庫和網(wǎng)站的功能。而且，不支持所有的關(guān)系數(shù)據(jù)庫引擎的功能。個人版（PersonalEdition)主要適用于移動用戶，因為他們經(jīng)常從網(wǎng)絡(luò)上斷開，而運(yùn)行的應(yīng)用程序卻仍然需要SQLServer2000的支持。除了事務(wù)處理復(fù)制功能以外，能夠支持所有SQLServer2000標(biāo)準(zhǔn)版支持的特性。開發(fā)者版（DeveloperEdition)適用于應(yīng)用程序開發(fā)的版本，支持除圖形化語言設(shè)置以外的SQLServer2000的所有其它功能。該版本主要適用于程序員在開發(fā)應(yīng)用程序時，將SQLServer2000作為其數(shù)據(jù)存儲區(qū)。雖然開發(fā)版的功能齊備，但是只被授權(quán)為一個開發(fā)和測試系統(tǒng)，而不是一個產(chǎn)品服務(wù)器。2.1SQLServer特點(diǎn)特點(diǎn)特點(diǎn)特點(diǎn)1．與因特網(wǎng)的集成：7SQLServer2000的數(shù)據(jù)庫引擎全面支持XML（ExtensiveMarkupLanguage，擴(kuò)展標(biāo)記語言），能使用戶很容易地將數(shù)據(jù)庫中的數(shù)據(jù)發(fā)布到Web頁面上。2．可伸縮性與可用性：可跨越從運(yùn)行Windows95/98的膝上型電腦到運(yùn)行Windows2000的大型多處理器等多種平臺使用。另外，對聯(lián)合服務(wù)器，索引視圖等的支持，使得SQLServer2000企業(yè)版可以升級到最大Web站點(diǎn)所需的性能級別。3．企業(yè)級數(shù)據(jù)庫功能：SQLServer2000分布式查詢可以引用來自不同數(shù)據(jù)庫的數(shù)據(jù)，而且這些對于用戶來說是完全透明的；分布式數(shù)據(jù)庫將保證任何分布式數(shù)據(jù)更新時的完整性；復(fù)制可以使我們能夠維護(hù)多個數(shù)據(jù)復(fù)本，這些用戶能夠自主地進(jìn)行工作，然后再將所做的修改合并到發(fā)布數(shù)據(jù)庫；SQLServer2000關(guān)系數(shù)據(jù)庫引擎能夠充分保護(hù)數(shù)據(jù)完整性，還可以將管理并發(fā)修改數(shù)據(jù)庫開銷到最小。4．易于安裝，部署和使用：SQLServer2000由一系列的管理和開發(fā)工具組成，這些工具使得在多個站點(diǎn)上進(jìn)行SQLServer的安裝，部署，管理和使用變得更加容易。開發(fā)人員可以更加快速地交付SQLServer應(yīng)用程序，而且只需要進(jìn)行最少的安裝和管理就可以實現(xiàn)這些應(yīng)用程序。5．?dāng)?shù)據(jù)倉庫：數(shù)據(jù)倉庫是SQLServer2000中包含的用于分析取和分析匯總數(shù)據(jù)以進(jìn)行聯(lián)機(jī)分析處理的工具。這個功能只在Oracle和其他更昂貴的DBMS中才有。2.1.1SQLServer2000新特性新特性新特性新特性全面擴(kuò)展了SQLServer7.0的性能，可靠性和易用性。增加了一系列的功能，具體如下：1．在關(guān)系數(shù)據(jù)庫方面的增強(qiáng)2．圖形管理增強(qiáng)3．增強(qiáng)的聯(lián)合數(shù)據(jù)庫服務(wù)器2.2SQLServer