計(jì)算機(jī)畢業(yè)設(shè)計(jì)外文翻譯---sql server的簡(jiǎn)介

1、<p><b>　　文獻(xiàn)翻譯</b></p><p>　　題 目 SQL Server的簡(jiǎn)介</p><p>　　院、系(部) 計(jì)算機(jī)學(xué)院</p><p>　　專業(yè)及班級(jí) 計(jì)網(wǎng)0801班</p><p>　　姓 名 </p>

2、<p>　　指 導(dǎo) 教 師 </p><p>　　日 期 </p><p>　　SQL Server Introduction</p><p>　　1. SQL Server Relational Database Introduction</p><p>　　1．SQL

3、Server is the development and promotion of Microsoft's relational database system (DBMS), it was originally proposed by Microsoft, Sybase and Ashton-Tate three companies jointly developed and launched in 1988, the fi

4、rst OS / 2 version. </p><p>　　2．Relational database (RDBMS) Management System features: </p><p>　　The maintenance of the relationship between the database data; </p><p>　　Guarantee

5、the correctness of data storage; </p><p>　　When system failures occur when all the data back to the line to ensure a consistent state </p><p>　　3．RDBMS: SQL Server, Oracle, DB / 2, Sybase, Infor

6、mix </p><p>　　4．Non-RDBMS (File-based): Foxpro, Access</p><p>　　2. The Version of SQL Server 2000 </p><p>　　Common version of SQL Server 2000 are: </p><p>　　Enterprise

7、 Edition (Enterprise Edition) </p><p>　　Support all the functions of SQL Server 2000. The version number of products for large and medium-sized database server, and can support large-scale Web site, enterpri

8、se OLTP (online transaction processing) and large-scale data warehouse systems OLAP (Online Analytical Processing) performance required. </p><p>　　Standard Edition (Standard Edition) </p><p>　　P

9、ractical scope of the work of small groups or departments. It supports most features of SQL Server2000. However, do not have to support large databases, data warehouses and web site functionality. Also, do not support al

10、l the functions of relational database engine. </p><p>　　Personal Edition (Personal Edition) </p><p>　　Mainly applied to mobile users because they are often disconnected from the network, and ru

11、n the application still needs the support of SQL Server 2000. In addition to transaction processing functions other than reproduction, to support all SQL Server 2000 Standard Edition features support. </p><p&g

12、t;　　Developers Edition (Developer Edition) </p><p>　　Apply to the version of application development and support in addition to graphical language settings other than the SQL Server2000 all other functions.

13、This version is mainly applied to applications programmers in the development, it will be SQL Server 2000 as its data storage area. Although the development of full-featured version, but only have been authorized to deve

14、lop and test a system, rather than a product server.</p><p>　　2.1 SQL Server Features </p><p>　　1. Integration with the Internet: </p><p>　　SQL Server 2000 database engine full supp

15、ort of XML (Extensive Markup Language, Extensible Markup Language), enables users to easily publish the data in the database to the Web page. </p><p>　　2. Scalability and availability: </p><p>　

16、　Across from the laptop running Windows 95/98 computers running the Windows 2000 and other large-scale multi-processor platform. In addition, the Joint server, view the index and so on, making SQL Server 2000 Enterprise

17、Edition can upgrade to the largest Web site of the performance levels required. </p><p>　　3. Enterprise-level database functions: </p><p>　　SQL Server 2000 distributed query by invoking the data

18、 from different databases, and these for the user is completely transparent; distributed database will ensure that any updates to distributed data integrity; copy will enable us to the maintenance of multiple data Copies

19、 of these users to work independently, and then changes into the release database; SQL Server 2000 relational database engine can fully protect data integrity, management of complications can also modify the database to

20、minimi</p><p>　　4. Easy installation, deployment and use: </p><p>　　SQL Server 2000 from a series of management and development tools, these tools made in a number of sites on the SQL Server ins

21、tallation, deployment, management and use easier. Developers can more quickly deliver SQL Server applications, and only require minimal installation and management of these applications can be achieved. </p><p

22、>　　5. Data Warehouse: </p><p>　　Data Warehouse is included in SQL Server 2000 for analysis of aggregate data access and analysis for online analytical processing tool. This feature is only in Oracle and o

23、ther DBMS in the more expensive can.</p><p>　　2.1.1 New Features of SQL Server 2000 </p><p>　　Comprehensive SQL Server 7.0 extends the performance, reliability and ease of use. Increase in a ser

24、ies of functions, as follows: </p><p>　　1. In regard to the strengthening of relational database </p><p>　　2. Enhanced graphical management </p><p>　　3. Enhance the joint database s

25、erver</p><p>　　2.2 Tools and utilities of SQL Server 2000 </p><p>　　SQL Server 2000 there are eight tools are: </p><p>　　1. Enterprise Manager;</p><p>　　2. Service Mana

26、ger;</p><p>　　3. Query Analyzer;</p><p>　　4. Profiler; </p><p>　　5 .import and export data;</p><p>　　6. the server network tool ;</p><p>　　7. the client ne

27、twork;</p><p>　　8. to use tools, online help documentation.</p><p>　　2.2.1 Enterprise Manager</p><p>　　Enterprise Manager is based on a new known as the Microsoft Management Console

28、 (Microsoft Management Console) management of the public server environment, SQL Server 2000 it is one of the most important management tool. </p><p>　　Enterprise Manager can not only configure the system en

29、vironment and management of SQL Server, but also because it can be stacked to display the form of a list of all SQL Server objects, so all the SQL Server object the establishment and management were able to pass through

30、it to complete. </p><p>　　With business management to complete the operation: </p><p>　　1. The management of SQL Server server; the establishment and management of databases; the establishment a

31、nd management of tables, views, stored procedures, trigger procedures, roles, rules, default values, such as database objects, as well as user-defined data types; backup databases and transaction logs, </p><p&

32、gt;　　To restore database; copied database; set task scheduling; set the alarm; to provide inter-server control of the drag-and-drop operation; manage user accounts; the establishment of Transact-SQL command statements, a

33、s well as management and control of SQL Mail. </p><p>　　2. In Enterprise Manager contains two windows, the left side of the window as a "tree" shown in the active window, the contents of the right

34、side of the window is displayed. </p><p>　　3. The left window click the plus sign to expand all the sub-project contains. </p><p>　　4. An item by checking the node, you can see the right side of

35、 the window contains the contents of the project.</p><p>　　2.2.2 Service Manager (Service Manager)</p><p>　　SQL Server Service Manager is a server-side when the actual work of the most useful ut

36、ilities, service manager to start, pause, continue and stop the database server in real-time services, the type of service provided, including: SQL Server, SQL Server Agent, Microsoft Search and Distributed Transaction C

37、oordinator and so on. </p><p>　　SQL server 簡(jiǎn)介</p><p>　　1．SQL Server關(guān)系數(shù)據(jù)庫(kù)簡(jiǎn)介 </p><p>　　1．SQL Server是由Microsoft開(kāi)發(fā)和推廣的關(guān)系數(shù)據(jù)庫(kù)系統(tǒng)（DBMS)，它最初是由Microsoft、Sybase和Ashton-Tate三家公司共同開(kāi)發(fā)的，并于1988年推出了

38、第一個(gè)OS/2版本。 </p><p>　　2．關(guān)系數(shù)據(jù)庫(kù)（RDBMS)管理系統(tǒng)功能： </p><p>　　維護(hù)數(shù)據(jù)庫(kù)數(shù)據(jù)之間的關(guān)系； </p><p>　　保證數(shù)據(jù)存儲(chǔ)的正確性； </p><p>　　當(dāng)出現(xiàn)系統(tǒng)故障的時(shí)候，將所有數(shù)據(jù)恢復(fù)到能夠保證一致行的某種狀態(tài) </p><p>　　3．RDBMS：SQL Se

39、rver，Oracle，DB/2,Sybase，Informix </p><p>　　4．Non-RDBMS(File-based）：Foxpro，Access </p><p>　　2、SQL Server 2000的版本 </p><p>　　SQL Server 2000常見(jiàn)版本有： </p><p>　　企業(yè)版（Enterprise

40、 Edition） </p><p>　　支持所有SQL Server 2000的功能。該版本多用于大中型產(chǎn)品數(shù)據(jù)庫(kù)服務(wù)器，并且可以支持大型網(wǎng)站，企業(yè)OLTP（聯(lián)機(jī)事務(wù)處理）和大型數(shù)據(jù)倉(cāng)庫(kù)系統(tǒng)OLAP(聯(lián)機(jī)分析處理）所要求的性能。 </p><p>　　標(biāo)準(zhǔn)版（Standard Edition） </p><p>　　實(shí)用范圍是小型的工作組或部門。它支持大多數(shù)的SQ

41、L Server2000功能。但是，不具有支持大型數(shù)據(jù)庫(kù)，數(shù)據(jù)倉(cāng)庫(kù)和網(wǎng)站的功能。而且，不支持所有的關(guān)系數(shù)據(jù)庫(kù)引擎的功能。 </p><p>　　個(gè)人版（Personal Edition） </p><p>　　主要適用于移動(dòng)用戶，因?yàn)樗麄兘?jīng)常從網(wǎng)絡(luò)上斷開(kāi)，而運(yùn)行的應(yīng)用程序卻仍然需要SQL Server 2000的支持。除了事務(wù)處理復(fù)制功能以外，能夠支持所有SQL Server 2000標(biāo)準(zhǔn)

42、版支持的特性。 </p><p>　　開(kāi)發(fā)者版（Developer Edition） </p><p>　　適用于應(yīng)用程序開(kāi)發(fā)的版本，支持除圖形化語(yǔ)言設(shè)置以外的SQL Server2000的所有其它功能。該版本主要適用于程序員在開(kāi)發(fā)應(yīng)用程序時(shí)，將SQL Server 2000作為其數(shù)據(jù)存儲(chǔ)區(qū)。雖然開(kāi)發(fā)版的功能齊備，但是只被授權(quán)為一個(gè)開(kāi)發(fā)和測(cè)試系統(tǒng)，而不是一個(gè)產(chǎn)品服務(wù)器。 </p>

43、;<p>　　2.1 SQL Server特點(diǎn) </p><p>　　1．與因特網(wǎng)的集成： </p><p>　　SQL Server 2000的數(shù)據(jù)庫(kù)引擎全面支持XML（Extensive Markup Language，擴(kuò)展標(biāo)記語(yǔ)言），能使用戶很容易地將數(shù)據(jù)庫(kù)中的數(shù)據(jù)發(fā)布到Web頁(yè)面上。 </p><p>　　2．可伸縮性與可用性： </p&

44、gt;<p>　　可跨越從運(yùn)行Windows 95/98的膝上型電腦到運(yùn)行Windows 2000的大型多處理器等多種平臺(tái)使用。另外，對(duì)聯(lián)合服務(wù)器，索引視圖等的支持，使得SQL Server 2000企業(yè)版可以升級(jí)到最大Web站點(diǎn)所需的性能級(jí)別。 </p><p>　　3．企業(yè)級(jí)數(shù)據(jù)庫(kù)功能： </p><p>　　SQL Server 2000分布式查詢可以引用來(lái)自不同數(shù)據(jù)庫(kù)

45、的數(shù)據(jù)，而且這些對(duì)于用戶來(lái)說(shuō)是完全透明的；分布式數(shù)據(jù)庫(kù)將保證任何分布式數(shù)據(jù)更新時(shí)的完整性；復(fù)制可以使我們能夠維護(hù)多個(gè)數(shù)據(jù)復(fù)本，這些用戶能夠自主地進(jìn)行工作，然后再將所做的修改合并到發(fā)布數(shù)據(jù)庫(kù)；SQL Server 2000關(guān)系數(shù)據(jù)庫(kù)引擎能夠充分保護(hù)數(shù)據(jù)完整性，還可以將管理并發(fā)修改數(shù)據(jù)庫(kù)開(kāi)銷到最小。 </p><p>　　4．易于安裝，部署和使用： </p><p>　　SQL Server

46、2000由一系列的管理和開(kāi)發(fā)工具組成，這些工具使得在多個(gè)站點(diǎn)上進(jìn)行SQL Server的安裝，部署，管理和使用變得更加容易。開(kāi)發(fā)人員可以更加快速地交付SQL Server應(yīng)用程序，而且只需要進(jìn)行最少的安裝和管理就可以實(shí)現(xiàn)這些應(yīng)用程序。 </p><p><b>　　5．?dāng)?shù)據(jù)倉(cāng)庫(kù)： </b></p><p>　　數(shù)據(jù)倉(cāng)庫(kù)是SQL Server 2000中包含的用于分析取

47、和分析匯總數(shù)據(jù)以進(jìn)行聯(lián)機(jī)分析處理的工具。這個(gè)功能只在Oracle和其他更昂貴的DBMS中才有。 </p><p>　　2.1.1 SQL Server 2000新特性 </p><p>　　全面擴(kuò)展了SQL Server 7.0的性能，可靠性和易用性。增加了一系列的功能，具體如下： </p><p>　　1．在關(guān)系數(shù)據(jù)庫(kù)方面的增強(qiáng) </p><p

48、><b>　　2．圖形管理增強(qiáng) </b></p><p>　　3．增強(qiáng)的聯(lián)合數(shù)據(jù)庫(kù)服務(wù)器 </p><p>　　2.2 SQL Server 2000工具和實(shí)用程序 </p><p>　　SQL Server 2000有8個(gè)工具，分別是：</p><p><b>　　1．企業(yè)管理器； </b>

49、</p><p><b>　　2．服務(wù)管理器；</b></p><p><b>　　3．查詢分析器；</b></p><p><b>　　4．事件探查器； </b></p><p>　　5．導(dǎo)入和導(dǎo)出數(shù)據(jù)； </p><p>　　6．服務(wù)器網(wǎng)絡(luò)使用工具；

50、 </p><p>　　7．客戶端網(wǎng)絡(luò)使用工具； </p><p><b>　　8．聯(lián)機(jī)幫助文檔。</b></p><p>　　2.2.1 企業(yè)管理器 </p><p>　　企業(yè)管理器是基于一種新的被稱為微軟管理控制臺(tái)（Microsoft Management Console)的公共服務(wù)器管理環(huán)境，它是SQL Serve

51、r 2000中最重要的一個(gè)管理工具。 </p><p>　　企業(yè)管理器不僅能夠配置系統(tǒng)環(huán)境和管理SQL Server，而且由于它能夠以層疊列表的形式來(lái)顯示所有的SQL Server對(duì)象，因而所有SQL Server對(duì)象的建立與管理都可以通過(guò)它來(lái)完成。 </p><p>　　用企業(yè)管理可以完成的操作：</p><p>　　1．管理SQL Server服務(wù)器；建立與管理

52、數(shù)據(jù)庫(kù)；建立與管理表、視圖、存儲(chǔ)過(guò)程、觸發(fā)程序、角色、規(guī)則、默認(rèn)值等數(shù)據(jù)庫(kù)對(duì)象，以及用戶定義的數(shù)據(jù)類型；備份數(shù)據(jù)庫(kù)和事務(wù)日志、恢復(fù)數(shù)據(jù)庫(kù)；復(fù)制數(shù)據(jù)庫(kù)；設(shè)置任務(wù)調(diào)度；設(shè)置警報(bào)；提供跨服務(wù)器的拖放控制操作；管理用戶賬戶；建立Transact-SQL命令語(yǔ)句以及管理和控制SQL Mail。 </p><p>　　2．在企業(yè)管理器中包含兩個(gè)窗口，左側(cè)的窗口是以“樹(shù)狀目錄”顯示的活動(dòng)窗口，右側(cè)是顯示內(nèi)容的窗口。 </

53、p><p>　　3．單擊左側(cè)窗口中的加號(hào)，可以展開(kāi)各個(gè)項(xiàng)目包含的子項(xiàng)目。 </p><p>　　4．通過(guò)選中的某個(gè)項(xiàng)目的節(jié)點(diǎn)，可以在右側(cè)的窗口中看到該項(xiàng)目包含的內(nèi)容。 </p><p>　　2.2.2服務(wù)管理器（Service Manager） </p><p>　　SQL Server服務(wù)管理器是在服務(wù)器端實(shí)際工作時(shí)最有用的實(shí)用程序，服務(wù)管理器