专业 sql server2008 xml[外文翻译].doc

专业 SQL Server2008 XML[外文翻译]

英文：11800字      7页
中文：2843字       4页

Pro SQL Server2008 XML

SQL Server 2008’s native XML manipulation and querying facilities are particularly usefulin the following situations:
• You want to manipulate or share XML data while taking advantage of SQL Server’stransactional capabilities.
• You want to take advantage of SQL Server’s administrative functionality to back up,recover, or replicate your XML data.
• You need to ensure that your server-side XML data is valid and well-formed.
• You want your XML and relational data to interoperate.
• You want to take advantage of SQL Server’s XQuery and XPath capabilities.
• You want to optimize your queries of XML data using indexes and SQL Server’s query optimizer.
XML is a particularly good choice as a communication format for loosely coupled systemsor when trying to make legacy systems communicate with modern servers. It’s also an excellentchoice when storing data for applications that lend themselves to using data in a marked-upformat, such as document management and presentation applications. Modeling semistructured  data in an ad hoc fashion also lends itself well to using XML. There are many standard applications for XML already defined in almost every industry, so XML is often an excellent choice when standard communication formats and data sharing are high priorities.Whether, and when, to use XML is the subject of much debate among SQL Server professionals.There are situations where XML ......

专业 SQL Server2008 XML

　SQL Server 2008年的本土XML操纵和查询的设施是特别有用的，在下列情形之一:
你想利用SQL服务器控制XML数据的能力。
你想利用SQL服务器的备份功能进行备份,恢复,或复制你的XML数据。
你要确定你的服务器端的XML数据是有效和规范的。
你希望你的XML用关系型数据来实现。
你想利用SQL服务器的XPath功能。
你想要优化您查询XML数据使用索引和SQL查询优化。
XML是一份特别好的选择作为交流的松散耦合系统的格式或者当试图让遗留系统与现代服务器。它也是一个优秀的选择时,可广泛应用于各种存储数据,试图利用数据放在一个改过格式,如文档管理和演示应用程序。建模小于数据在一个特设时尚也只用来使用XML。有许多标准的应用已定义为XML的几乎每一个行业,所以XML经常是一个不错的选择当标准的通信格式和数据共享高优先权。无论什么时候使用XML的主题在SQL Server专业