Database development 10 most important features（数据库开发10个最重要的特性）

1Database development 10 most important features(Research papers Download information) from a database developed in this paper about SQL Server2005’s 10 most important features. NET Framework host Use SQL Server2005, developers using similar language, such as Microsoft VisualC #. Net and Microsoft VisualBasic, will be able to create database objects. Developers will be able to create two new objects - user-defined classes and collections. XML technology In the use of local networks and the Internet case, a walk in the data between different applications when the Extensible Markup Language (XML) is an important criterion. SQL Server2005 will be self-supporting storage and query Extensible Markup Language file. ADO.NET2.0 version From the class of the new SQL support to Multiple Active Result Sets (MARS), SQL Server2005 in ADO.NET will promote access and manipulate data sets, to achieve 2greater scalability and flexibility. Enhanced Security SQL Server2005 in the new security model and the separation of the user, provide fine-grainAccess access, and allows for greater control of data access In addition, all system tables will be implemented as a view of the database system object more large degree of control. Transact-SQL performance enhancements SQL Server2005 for developing scalable database applications, providing a new language features. These enhancements include error handling, recursive query capabilities, relational operator PIVOT, APPLY, ROW_NUMBER ranking function, and other data columns, and so on. SQL Service Broker SQL Service Broker for large, business-wide application software, providing a distributed, asynchronous application framework. Notification Services Notification service enables businesses can create a rich notification applications to any device, to provide personalized and timely information, such as the stock 3market alerts, news subscriptions, package delivery alerts, airline fares. In SQL Server2005, the notification service and other technology more closely integrated together, these technologies including Analysis Services, SQLServerManagementStudio. Web Services Use SQL Server2005, developers will be able to develop Web services in the database layer, the SQL Server as a Hypertext Transfer Protocol (HTTP) listener and application software for the network service center to provide a new data access capabilities. Reporting Services Use SQL Server2005, Reporting Services reports can provide controlled release by VisualStudio2005. Enhanced full-text search SQL Server2005 will support rich text applications. Server functionality will be enhanced cataloging, cataloging objects for greater flexibility. Query performance and scalability will be greatly improved, and new management tools for the full function operation, providing a better understanding (source: IT network of experts compile: free download 4