Mapping of data from XML to SQL
First Claim
1. A computer implemented method for converting a dataset into at least one table, said method comprising:
- identifying at least one hierarchical structure in said dataset; and
converting said dataset associated with said at least one identified hierarchical structure by;
determining a node element set for said at least one identified hierarchical structure of said dataset, wherein at least one node element in said node element set is a discrete level of said at least one identified hierarchical structure of said dataset;
determining one or more nodes of said dataset, each of said one or more nodes being an instance of a node element from said node element set;
allocating to said instance of said node element a unique node identifier; and
generating said at least one table, said at least one table containing one or more records, each record corresponding to a respective one of said allocated node identifiers;
wherein said node element set is selected to reduce the need for at least one downstream application to assemble data from an elemental level;
wherein said at least one table is as required by said at least one downstream application;
wherein said dataset comprises a plurality of predefined portions of text-based data, at least one of said plurality of predefined portions of text-based data being associated with at least one attribute for organizing at least one of said plurality of predefined portions of text-based data; and
wherein said plurality of predefined portions of text-based data comprise at least one modified and stored predefined portion of text based data associated with at least one attribute for organizing at least one of said plurality of predefined portions of text based data and said at least one modified and stored predefined portion of text-based data.
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 and 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
37 Claims
-
1. A computer implemented method for converting a dataset into at least one table, said method comprising:
-
identifying at least one hierarchical structure in said dataset; and converting said dataset associated with said at least one identified hierarchical structure by; determining a node element set for said at least one identified hierarchical structure of said dataset, wherein at least one node element in said node element set is a discrete level of said at least one identified hierarchical structure of said dataset; determining one or more nodes of said dataset, each of said one or more nodes being an instance of a node element from said node element set; allocating to said instance of said node element a unique node identifier; and generating said at least one table, said at least one table containing one or more records, each record corresponding to a respective one of said allocated node identifiers; wherein said node element set is selected to reduce the need for at least one downstream application to assemble data from an elemental level; wherein said at least one table is as required by said at least one downstream application; wherein said dataset comprises a plurality of predefined portions of text-based data, at least one of said plurality of predefined portions of text-based data being associated with at least one attribute for organizing at least one of said plurality of predefined portions of text-based data; and wherein said plurality of predefined portions of text-based data comprise at least one modified and stored predefined portion of text based data associated with at least one attribute for organizing at least one of said plurality of predefined portions of text based data and said at least one modified and stored predefined portion of text-based data. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 34)
-
-
12. An apparatus for converting a dataset into at least one table, said apparatus comprising:
-
at least one processor for identifying at least one hierarchical structure in said dataset; and a converter for converting said dataset associated with said at least one identified hierarchical structure, said converter comprising; at least one processor for determining a node element set for said at least one identified hierarchical structure of said dataset, wherein at least one node element in said node element set is a discrete level of said at least one identified hierarchical structure of said dataset; at least one processor for determining one or more nodes of said dataset, each of said one or more nodes being an instance of a node element from said node element set; an allocator for allocating to said instance of said node element a unique node identifier; and a generator for generating said at least one table, said at least one table containing one or more records, each record corresponding to a respective one of said allocated node identifiers; wherein said node element set is selected to reduce the need for at least one downstream application to assemble data from an elemental level; wherein said at least one table is as required by said at least one downstream application; wherein said dataset comprises a plurality of predefined portions of text-based data, at least one of said plurality of predefined portions of text-based data being associated with at least one attribute for organizing at least one of said plurality of predefined portions of text-based data; and wherein said plurality of predefined portions of text-based data comprise at least one modified and stored predefined portion of text based data associated with at least one attribute for organizing at least one of said plurality of predefined portions of text based data and said at least one modified and stored predefined portion of text-based data. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 35, 37)
-
-
23. A computer program product having a computer readable storage medium having a computer program recorded therein for converting a dataset into at least one table, said computer program product comprising:
-
computer program code for identifying at least one hierarchical structure in said dataset; computer program code for converting said dataset associated with said at least one identified hierarchical structure, said computer program code comprising; computer program code for determining a node element set for said at least one identified hierarchical structure of said dataset, wherein at least one node element in said node element set is a discrete level of said at least one identified hierarchical structure of said dataset; computer program code for determining one or more nodes of said dataset, each of said one or more nodes being an instance of a node element from said node element set; computer program code for allocating to said instance of said node element a unique node identifier; and computer program code for generating said at least one table, said at least one table containing one or more records, each record corresponding to a respective one of said allocated node identifiers; wherein said node element set is selected to reduce the need for at least one downstream application to assemble data from an elemental level; wherein said at least one table is as required by at least one downstream application; wherein said dataset comprises a plurality of predefined portions of text-based data, at least one of said plurality of predefined portions of text-based data being associated with at least one attribute for organizing at least one of said plurality of predefined portions of text-based data; and wherein said plurality of predefined portions of text-based data comprise at least one modified and stored predefined portion of text based data associated with at least one attribute for organizing at least one of said plurality of predefined portions of text based data and said at least one modified and stored predefined portion of text-based data. - View Dependent Claims (24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 36)
-
Specification