tailieunhanh - Pro XML Development with Java Technology 2006 phần 8

JAXP cung cấp các giao diện như DocumentBuilderFactory và DocumentBuilder cung cấp một giao diện chuẩn để phân biệt các bộ kiểm ngữ. Cũng có các phương pháp cho phép bạn điều chỉnh bộ kiểm ngữ có nhận thức được không gian tên hay không và nó sử dụng một DTD hay một lược đồ để kiểm soát văn bản XML. | CHAPTER 9 Storing XML in Relational Databases In the previous chapter you learned how to store an XML document in a native XML database. Native XML databases are of course limited to storing only XML documents. If you need to store an XML document along with other data a relational database is more appropriate. In a relational database you can store an XML document just like any other type of data within a column in a table row. In the absence of standards related to storing XML content in relational databases relational database vendors started adding vendor-specific data types utilities and APIs to provide XML-related support within their databases. Table 9-1 discusses some of the vendor-specific tools. Table 9-1. Database Tools for Storing XML Database Tool Database Description Oracle XML SQL Utility Oracle Stores an XML document that does not consist of subelements or attributes in a predefined database table. You can apply an XSLT to store an XML document with subelements and attributes. IBM DB2 XML Extender DB2 UDB Stores an XML document either as a BLOB-like object or as a set of collection called an XML collection. SQL extension and rowset function SQL Server 2000 Stores an XML document with a rowset function and retrieves an XML document with the SQL construct FOR XML. Result Set DTD Sybase Adaptive Server Stores and retrieves an XML document using a ResultSetXml class. Clearly a vendor-independent standard for storing and accessing XML content in relational databases was called for so the SQL 20031 international standard added the new Part 14 SQL XML XML-Related Specifications which is devoted to this issue. Overview The SQL 2003 standard provides a new XML data type for storing XML content. The XML data type is just like any other data type using the XML data type you can store an XML document within a column in 1. SQL 2003 Has Been Published http sigmod record issues 04O3 is a good reference for an overview of the