Presentation Overview: This presentation describes 3 options for deserializing XML into a relational database. These options include deserializing into database table columns of data type XML, deserializing into conventional relational tables, and deserializing into a soft schema. In the latter approach, XML and corresponding XSD documents are treated as object graphs and class graphs respectively. Treating XSD documents as class graphs enables a clever use of XSD documents in support of a very powerful class of queries called polymorphic queries. Polymorphic queries provide the ability to write queries over collections of heterogeneous XML documents without having to hard-code knowledge accounting for the structural differences between the various XML documents. This presentation also includes a description of how to apply natural language processing (NLP) to the names or values of object graph nodes in order to associate object graph nodes with industry-standard ontology nodes.

Slide Presentation: Processing XML in a RDBMS

Prerequisite Video Presentation: Support of OOP Directly in a RDBMS

Demonstration: Importing XML into TCSQL
Demonstration: Importing XSD into TCSQL
Demonstration: Instantiation of an XSD Class