×

Mapping of data from XML to SQL

  • US 8,204,913 B2
  • Filed: 03/06/2008
  • Issued: 06/19/2012
  • Est. Priority Date: 09/04/2001
  • Status: Expired due to Fees
First Claim
Patent Images

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 all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×