MAPPING OF DATA FROM XML TO SQL
0 Assignments
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
61 Claims
-
1-39. -39. (canceled)
-
40. A method for mapping a dataset at least partially encoded with a markup language into one or more relational database tables, the method comprising:
-
identifying at least one hierarchical structure associated with said encoded dataset; determining a node element set for said hierarchical structure, wherein said node element set comprises one or more nodes that are one or more levels of said hierarchical structure; identifying at least one node of said encoded dataset, which node is part of said node element set; allocating to said node of said encoded dataset a unique node identifier; and generating a relational database table containing one or more records, said one or more records corresponding to a respective one or more of said allocated node identifiers; wherein said encoded dataset includes one or more predefined portions of text-based data, said one or more predefined portions being at least partially encoded using a markup language, and being associated with one or more of a plurality of attributes for organizing said one or more predefined portions; wherein said one or more predefined portions include at least one modified and stored predefined portion, said at least one modified predefined portion being associated with one or more attributes for organizing said one or more predefined portions and said modified predefined portion. - View Dependent Claims (41, 42, 43, 44, 45, 46, 47, 48, 49, 50)
-
-
51. A computer program product having a non-transitory computer readable medium, said non-transitory computer readable medium having a computer program recorded therein for mapping a dataset at least partially encoded with a markup language into one or more relational database tables, said computer program product comprising:
-
computer program code for identifying at least one hierarchical structure associated with said encoded dataset; computer program code for determining a node element set for said hierarchical structure, wherein said node element set comprises one or more nodes that are one or more levels of said hierarchical structure; computer program code for identifying at least one node of said encoded dataset, which node is part of said node element set; computer program code for allocating to said node of said encoded dataset a unique node identifier; and computer program code for generating a relational database table containing one or more records, said one or more records corresponding to a respective one or more of said allocated node identifiers; wherein said encoded dataset includes one or more predefined portions of text-based data, said one or more predefined portions being at least partially encoded using a markup language, and being associated with one or more of a plurality of attributes for organizing said one or more predefined portions; wherein said one or more predefined portions include at least one modified and stored predefined portion, said at least one modified predefined portion being associated with one or more attributes for organizing said one or more predefined portions and said modified predefined portion. - View Dependent Claims (52, 53, 54, 55, 56, 57, 58, 59, 60, 61)
-
Specification