1、 河北科技师范学院 本科毕业 论文（设计） 外文翻译 数据库编程教学网站的开发 院（系、部） 名 称 ： 欧美学院信息技术系 专 业 名 称 ： 计算机科学与技术 学 生 姓 名 ： 王楠 学 生 学 号： 9210080324 指 导 教 师： 关健 2011 年 11 月 10 日 河北科技师范学院教务处 Microsoft SQL Server Microsoft SQL Server is a relational database server, developed by Microsoft: it is a software product whose primary functi
2、on is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for di
3、fferent workloads (ranging from small applications that store and retrieve data on the same computer, to millions of users and computers that access huge amounts of data from the Internet at the same time).True to its name, Microsoft SQL Servers primary query languages are T-SQL and ANSI SQL. Histor
4、y SQL Server 2005 (codename Yukon), released in October 2005, is the successor to SQL Server 2000. It included native support for managing XML data, in addition to relational data. For this purpose, it defined an xml data type that could be used either as a data type in database columns or as litera
5、ls in queries. XML columns can be associated with XSD schemas； XML data being stored is verified against the schema. XML is converted to an internal binary data type before being stored in the database. Specialized indexing methods were made available for XML data. XML data is queried using XQuery；
6、Common Language Runtime (CLR) integration was a main feature with this edition, enabling one to write SQL code as Managed Code by the CLR. SQL Server 2005 added some extensions to the T-SQL language to allow embedding XQuery queries in T-SQL. In addition, it also defines a new extension to XQuery, c
7、alled XML DML, that allows query-based modifications to XML data. SQL Server 2005 also allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests. When the data is accessed over web services, results are returned as X
8、ML. For relational data, T-SQL has been augmented with error handling features (try/catch) and support for recursive queries with CTEs (Common Table Expressions). SQL Server 2005 has also been enhanced with new indexing algorithms, syntax and better error recovery systems. Data pages are checksummed
9、 for better error resiliency, and optimistic concurrency support has been added for better performance. Permissions and access control have been made more granular and the query processor handles concurrent execution of queries in a more efficient way. Partitions on tables and indexes are supported
10、natively, so scaling out a database onto a cluster is easier. SQL CLR was introduced with SQL Server 2005 to let it integrate with the .NET Framework. SQL Server 2005 introduced MARS (Multiple Active Results Sets), a method of allowing usage of database connections for multiple purposes. SQL Server
11、2005 introduced DMVs (Dynamic Management Views), which are specialized views and functions that return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. SQL Server 2005 introduced Database Mirroring, but it was not fully su
12、pported until the first Service Pack release (SP1). In the initial release (RTM) of SQL Server 2005, database mirroring was available, but unsupported. In order to implement database mirroring in the RTM version, you had to apply trace flag 1400 at startup. Database mirroring is a high availability
13、option that provides redundancy and failover capabilities at the database level. Failover can be performed manually or can be configured for automatic failover. Automatic failover requires a witness partner and an operating mode of synchronous (also known as high-safety or full safety). Editions Mic
14、rosoft makes SQL Server available in multiple editions, with different feature sets and targeting different users. These editions are: Mainstream editions Datacenter SQL Server 2008 R2 Datacenter is the full-featured edition of SQL Server and is designed for datacenters that need the high levels of
15、application support and scalability. It supports 256 logical processors and virtually unlimited memory. Comes with StreamInsight Premium edition. Enterprise SQL Server Enterprise Edition includes both the core database engine and add-on services, with a range of tools for creating and managing a SQL
16、 Server cluster. It can manage databases as large as 524 petabytes and address 2 terabytes of memory and supports 8 physical processors. Standard SQL Server Standard edition includes the core database engine, along with the stand-alone services. It differs from Enterprise edition in that it supports fewer active instances (number of nodes in a cluster) and does not include some high-availability functions
