1、 文献翻译 题 目 SQL Server 的简介 院、系 (部 ) 计算机学院 专业及班级 计网 0801 班 姓 名 指 导 教 师 日 期 2 SQL Server Introduction 1. SQL Server Relational Database Introduction 1 SQL Server is the development and promotion of Microsofts relational database system (DBMS), it was originally proposed by Microsoft, Sybase and Ashton-T
2、ate three companies jointly developed and launched in 1988, the first OS / 2 version. 2 Relational database (RDBMS) Management System features: The maintenance of the relationship between the database data； Guarantee the correctness of data storage； When system failures occur when all the data back
3、to the line to ensure a consistent state 3 RDBMS: SQL Server, Oracle, DB / 2, Sybase, Informix 4 Non-RDBMS (File-based): Foxpro, Access 2. The Version of SQL Server 2000 Common version of SQL Server 2000 are: Enterprise Edition (Enterprise Edition) Support all the functions of SQL Server 2000. The v
4、ersion number of products for large and medium-sized database server, and can support large-scale Web site, enterprise OLTP (online transaction processing) and large-scale data warehouse systems OLAP (Online Analytical Processing) performance required. Standard Edition (Standard Edition) Practical s
5、cope 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 all the functions of relational database engine. Personal Edition (Personal Edition) Mainly
6、applied to mobile users because they are often disconnected from the network, and run 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. Developers Edit
7、ion (Developer Edition) Apply to the version of application development and support in addition to graphical language settings other than the SQL Server2000 all other functions. This version is mainly applied to applications programmers in the development, it will be SQL Server 2000 as its data stor
8、age area. Although the development of full-featured version, but only have been authorized to develop and test a system, rather than a product server. 3 2.1 SQL Server Features 1. Integration with the Internet: SQL Server 2000 database engine full support of XML (Extensive Markup Language, Extensibl
9、e Markup Language), enables users to easily publish the data in the database to the Web page. 2. Scalability and availability: 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
10、 and so on, making SQL Server 2000 Enterprise Edition can upgrade to the largest Web site of the performance levels required. 3. Enterprise-level database functions: SQL Server 2000 distributed query by invoking the data from different databases, and these for the user is completely transparent； dis
11、tributed database will ensure that any updates to distributed data integrity； copy will enable us to the maintenance of multiple data Copies of these users to work independently, and then changes into the release database； SQL Server 2000 relational database engine can fully protect data integrity,
12、management of complications can also modify the database to minimize overhead. 4. Easy installation, deployment and use: SQL Server 2000 from a series of management and development tools, these tools made in a number of sites on the SQL Server installation, deployment, management and use easier. Dev
13、elopers can more quickly deliver SQL Server applications, and only require minimal installation and management of these applications can be achieved. 5. Data Warehouse: Data Warehouse is included in SQL Server 2000 for analysis of aggregate data access and analysis for online analytical processing t
14、ool. This feature is only in Oracle and other DBMS in the more expensive can. 2.1.1 New Features of SQL Server 2000 Comprehensive SQL Server 7.0 extends the performance, reliability and ease of use. Increase in a series of functions, as follows: 1. In regard to the strengthening of relational database 2. Enhanced graphical management 3. Enhance the joint database server
