O'Reilly logo

Principles of Data Management - Facilitating information sharing Second edition by Keith Gordon

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required