APPENDIX HXML AND RELATIONAL DATABASES
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 ...