APPENDIX HXML AND RELATIONAL DATABASES
INTRODUCTION
As described in Chapter 17, the latest SQL standard includes a new part known as SQL/XML. This part introduces an XML datatype and facilities that provide for the composition of XML using data extracted from a relational database and, conversely, for the storage of data extracted from an XML document in a relational database. The XML datatype can be used in the same way as any other datatype, i.e. as a datatype for a column, as a variable or as a parameter for a function.
REPRESENTING DATA FROM A DATABASE AS XML
The facilities that enable data to be extracted and then represented as XML offer a range of alternatives. The specimen data stored in the relational database tables shown in Figure ...
Get Principles of Data Management, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
