專(zhuān)業(yè) SQL Server2008 XML[外文翻譯]

英文：11800字      7頁(yè)
中文：2843字       4頁(yè)

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 ......

專(zhuān)業(yè) SQL Server2008 XML

　SQL Server 2008年的本土XML操縱和查詢(xún)的設(shè)施是特別有用的，在下列情形之一:
你想利用SQL服務(wù)器控制XML數(shù)據(jù)的能力。
你想利用SQL服務(wù)器的備份功能進(jìn)行備份,恢復(fù),或復(fù)制你的XML數(shù)據(jù)。
你要確定你的服務(wù)器端的XML數(shù)據(jù)是有效和規(guī)范的。
你希望你的XML用關(guān)系型數(shù)據(jù)來(lái)實(shí)現(xiàn)。
你想利用SQL服務(wù)器的XPath功能。
你想要優(yōu)化您查詢(xún)XML數(shù)據(jù)使用索引和SQL查詢(xún)優(yōu)化。
XML是一份特別好的選擇作為交流的松散耦合系統(tǒng)的格式或者當(dāng)試圖讓遺留系統(tǒng)與現(xiàn)代服務(wù)器。它也是一個(gè)優(yōu)秀的選擇時(shí),可廣泛應(yīng)用于各種存儲(chǔ)數(shù)據(jù),試圖利用數(shù)據(jù)放在一個(gè)改過(guò)格式,如文檔管理和演示應(yīng)用程序。建模小于數(shù)據(jù)在一個(gè)特設(shè)時(shí)尚也只用來(lái)使用XML。有許多標(biāo)準(zhǔn)的應(yīng)用已定義為XML的幾乎每一個(gè)行業(yè),所以XML經(jīng)常是一個(gè)不錯(cuò)的選擇當(dāng)標(biāo)準(zhǔn)的通信格式和數(shù)據(jù)共享高優(yōu)先權(quán)。無(wú)論什么時(shí)候使用XML的主題在SQL Server專(zhuān)業(yè)