SQL server 简介-----外文翻译.docVIP

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-Tate 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 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 version 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 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 all the functions of relational database engine. ?Personal Edition (Personal Edition) ?Mainly 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 Edition (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 th