Mapping of data from XML to SQL
First Claim
1. A method for converting an XML encoded dataset into a minimal set of SQL tables including the steps of:
- identifying at least one hierarchical structure in said XML encoded dataset; and
converting an XML encoded dataset associated with each identified hierarchical structure, wherein for each identified hierarchical structure said converting step includes the further steps of;
determining a node element set for said identified hierarchical structure of said XML encoded dataset, wherein each node element in said node element set is a discrete level of said identified hierarchical structure of said dataset;
determining one or more nodes of said XML encoded dataset, each node being an instance of a node element;
allocating to each node a unique node identifier; and
generating an SQL node table containing one or more records, each record corresponding to a respective one of said allocated node identifiers.
1 Assignment
0 Petitions
Accused Products
Abstract
A method, an apparatus and a computer program product for converting an XML encoded dataset into a minimal set of SQL tables are provided. In the method, a hierarchical structure in the XML encoded dataset is identified. A node element set for the XML encoded dataset is determined, wherein each node element in the node element set is a discrete level of the hierarchical structure of the dataset. One or more nodes of the XML encoded dataset are determined, each node being an instance of a node element. A unique node identifier is allocated to each node. Then, an SQL node table containing one or more records is generated, each record corresponding to a respective one of the allocated node identifiers. An SQL ancestry table is optionally generated to define the inter-relationships among nodes of the identified hierarchical structure of the XML encoded dataset.
-
Citations
39 Claims
-
1. A method for converting an XML encoded dataset into a minimal set of SQL tables including the steps of:
-
identifying at least one hierarchical structure in said XML encoded dataset; and
converting an XML encoded dataset associated with each identified hierarchical structure, wherein for each identified hierarchical structure said converting step includes the further steps of;
determining a node element set for said identified hierarchical structure of said XML encoded dataset, wherein each node element in said node element set is a discrete level of said identified hierarchical structure of said dataset;
determining one or more nodes of said XML encoded dataset, each node being an instance of a node element;
allocating to each node a unique node identifier; and
generating an SQL node table containing one or more records, each record corresponding to a respective one of said allocated node identifiers. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. An apparatus for converting an XML encoded dataset into a minimal set of SQL tables, said apparatus including:
-
means for identifying at least one hierarchical structure in said XML encoded dataset; and
means for converting an XML encoded dataset associated with each identified hierarchical structure, said means including;
means for determining a node element set for said identified hierarchical structure of said XML encoded dataset, wherein each node element in said node element set is a discrete level of said identified hierarchical structure of said dataset;
means for determining one or more nodes of said XML encoded dataset, each node being an instance of a node element;
means for allocating to each node a unique node identifier; and
means for generating an SQL node table containing one or more records, each record corresponding to a respective one of said allocated node identifiers. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)
-
-
27. A computer program product having a computer readable medium having a computer program recorded therein for converting an XML encoded dataset into a minimal set of SQL tables, said computer program product including:
-
computer program code means for identifying at least one hierarchical structure in said XML encoded dataset;
computer program code means for converting an XML dataset associated with each identified hierarchical structure, said means including;
computer program code means for determining a node element set for said identified hierarchical structure of said XML encoded dataset, wherein each node element in said node element set is a discrete level of said identified hierarchical structure of said dataset;
computer program code means for determining one or more nodes of said XML encoded dataset, each node being an instance of a node element;
computer program code means for allocating to each node a unique node identifier, and program code means for generating an SQL node table containing one or more records, each record corresponding to a respective one of said allocated node identifiers. - View Dependent Claims (28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39)
-
Specification