US 2004/0002939 A1 · Schemaless dataflow within an XML storage solution

Abstract

A relational database management system having an XML storage implementation to reduce overhead associated with consuming data from multiple data providers, where each having proprietary database schemas. The XML storage solution allows data from any arbitrary relational database schema to be loaded, rearranged and retrieved. The present invention is directed to an implementation of an edge table such that large volumes of XML data of any structure can be stored effectively. The edge table may be designed as one large XML document where the schema information is stored separately from the instances, and relationships and constraints are expressed using foreign keys. The edge table further provides for full type support and validation. Indices and clustering provide efficient data access and query execution.

Claims20

Dependent claims

In a database management system, a tabular structure for storing XML data comprising:

a schema table for storing an XSD schema;
an instance table for storing a structure of XML instance data related to said XSD schema;
and
a content table for storing content from an instance document associated with said XSD schema,
wherein said XSD schema is enforced on said content and said XML instance data via a foreign key.

2 more elements

Dependencies are inferred from the claim text.

Schemaless dataflow within an XML storage solution

Life of this patent

Schemaless dataflow within an XML storage solution

Life of this patent

Abstract

Claims20