Schemaless dataflow within an XML storage solution
First Claim
1. 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 Assignments
0 Petitions
Accused Products
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.
-
Citations
20 Claims
-
1. 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. In a relational database management system, a method of receiving data from multiple external data providers, comprising:
-
receiving XML data, including definitions of instances for each data provider;
maintaining an instance node identifier for each instance;
mapping said instance node identifier to an instance key defined by said definitions; and
storing said mapping in an edge table, wherein said XML data is maintained separately from relational data within said relational database management system. - View Dependent Claims (10, 11, 12)
-
-
13. A system for providing queryable data to users having a relational database management system including an XML data exchange structure for receiving content from multiple external sources, comprising:
-
a schema table for storing an XSD schema; and
an instance table for storing a structure of XML instance data related to said XML schema, wherein said XSD schema is applied to said XML instance data via a foreign key in said instance table that enforces a hierarchy of elements and attributes stored within said schema table. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20)
-
Specification