Method and system for translating data associated with a relational database

• US 6,684,222 B1
• Filed: 11/09/2000
• Issued: 01/27/2004
• Est. Priority Date: 11/09/2000
• Status: Expired due to Term

• Current Assignee: Accenture Global Services Limited (Accenture PLC)
• Original Assignee: Accenture LLP (Accenture PLC)
• Inventors: Su, Eric C., Klug, Matthew C., Cornelius, Shawn S., Krahn, Richard R., Sweeney, Michael S., Huffman, Arnold Z.
• Primary Examiner(s): Choules, Jack M.
• Application Number:
  US09/710,132
• Time in Patent Office: 1,174 Days
• Field of Search: 707/102, 707/104.1, 707/100, 707/101, 715/513
• US Class Current: 1/1
• CPC Class Codes: G06F 16/30 of unstructured textual data document management systems G06F16/93
• CPC Class Codes: G06F 16/84 Mapping; Conversion
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A method and system for preparing hierarchical textual file for storage in a relational database allows the user to use readily available commands for querying and manipulating stored in a relational database. A generally tabular data structure contains data attribute fields associated with corresponding data element fields. Hierarchical textual file is accepted containing structured data elements. The data attributes are determined. The data attributes are associated with corresponding structured data elements of the accepted hierarchical textual file. The determined data attributes are stored in the generally tabular data structure of the relational database.

Claims

1. A method for preparing a hierarchical textual file for storage in a relational database, the method comprising the steps of:

defining a generally tabular data structure containing data attribute fields and data element fields, wherein the defining step includes storing hierarchical attributes as linked lists in columns of the table, different rows of the table associated with different levels of a hierarchy of data objects;

at least one row of the table representing one object of data in the hierarchy of the data objects;

accepting a hierarchical textual file containing structured data elements; and

determining the data attributes associated with corresponding structured data elements of the accepted hierarchical textual file; and

storing the determined data attributes in the generally tabular data structure of the relational database to preserve a hierarchical aspect of the hierarchical textual file.

2. The method of claim 1 wherein the defining step comprises defining the data structure to be compatible with standard storage and retrieval operations applicable to the relational database, the hierarchical textual file comprising an Extensible Mark up Language file.

3. The method according to claim 1 further comprising the step of querying the table of the relational database with a standard Structured Query Language command.

4. The method according to claim 1 further comprising the step of manipulating the table of the relational database with a standard Structured Query Language command.

5. The method of claim 1 wherein the defining step further comprises establishing a column of the table with the data attribute fields and rows of the table with the data element fields ranging from a first data element to an nth data element.

6. The method of claim 2 wherein the defining step includes specifying a node identifier as one of the data attribute fields, the node identifier identifying an order of a particular data element with respect to other data elements in the Extensible Mark up Language file.

7. A method for preparing a hierarchical textual file for storage in a relational database, the method comprising the steps of:

defining a generally tabular data structure containing data attribute fields and data element fields;

accepting a hierarchical textual file containing structured data elements;

determining the data attributes associated with corresponding structured data elements of the accepted hierarchical textual file; and

storing the determined data attributes in the generally tabular data structure of the relational database to preserve a hierarchical aspect of the hierarchical textual file;

wherein the defining step further comprises establishing the data attribute fields to include a node identifier, a parent node identifier, a tag, a value, and a field type;

an object identifier identifying the hierarchical textual file of a particular data element, a node identifier identifying an order of the particular data element with respect to other data elements in the hierarchical textual file, the parent node identifying a rank of the particular data element in a data hierarchy of the hierarchical textual file, a tag identifying a standard label for the particular data element, a value identifying a data value for the tag of the particular data element, and if applicable, a field type identifying a type of data for the value.

8. A method for preparing a hierarchical textual file for storage in a relational database, the method comprising the steps of:

defining a generally tabular data structure containing data attribute fields and data element fields, wherein the defining step includes specifying a parent node identifier as one of the data attribute fields, the parent node identifier identifying a rank of a particular data element in a data hierarchy applicable to Extensible Mark up Language files;

accepting an Extensible Mark up Language file as the hierarchical textual file containing structured data elements;

determining the data attributes associated with corresponding structured data elements of the accepted hierarchical textual file; and

storing the determined data attributes in the generally tabular data structure of the relational database to preserve a hierarchical aspect of the hierarchical textual file.

9. A method for preparing a hierarchical textual file for storage in a relational database, the method comprising the steps of:

defining a generally tabular data structure containing data attribute fields and data element fields, wherein the defining step includes specifying a tag identifying a standard label for a particular data element, specifying a data value for a particular tag of a data element, and specifying a field type identifying the data type for the value;

accepting an Extensible Mark up Language file as the hierarchical textual file containing structured data elements;

determining the data attributes associated with corresponding structured data elements of the accepted hierarchical textual file; and

storing the determined data attributes in the generally tabular data structure of the relational database to preserve a hierarchical aspect of the hierarchical textual file.

10. A method for manipulating data associated with a hierarchical textual file, the method comprising the steps of

defining a generally tabular data structure containing data attribute fields associated with corresponding data element fields, wherein the defining step includes storing hierarchical attributes as linked lists in columns of the table, different rows of the table associated with different levels of a hierarchy of data objects;

at least one row of the table representing one object of data in the hierarchy of the data objects;

accepting a hierarchical textual file containing structured data elements; and

determining the data attributes associated with corresponding structured data elements of the accepted hierarchical textual file;

storing the determined data attributes in the generally tabular data structure for storage in the relational database; and

processing the structured elements within the table by using standard commands applicable to a relational database environment.

11. The method of claim 10 wherein the defining step defines the data structure to be compatible with standard storage and retrieval operations applicable to the relational database, the hierarchical textual file comprising an Extensible Mark up Language file.

12. The method according to claim 10 wherein the processing step comprises querying the table of the relational database with a standard Structured Query Language command.

13. The method according to claim 10 wherein the processing step comprises manipulating the table of the relational database with a standard Structured Query Language command.

14. The method according to claim 10 further comprising the step of reconstructing the hierarchical textual file from the generally tabular data structure.

15. A system for preparing a hierarchical textual file for storage in a relational database, the system comprising:

a buffer memory for accepting and holding a hierarchical textual file containing structured data elements;

a processor for defining a generally tabular data structure containing data attribute fields associated with corresponding data element fields, the processor adapted to determine the data attributes associated with corresponding structured data elements of the accepted hierarchical textual file; and

a storage device coupled to the processor, the storage device storing the determined data attributes in the generally tabular data structure of the relational database, wherein the storage device stores hierarchical attributes as linked lists in columns of the generally tabular data structure, different rows of the generally tabular data structure associated with different levels of a hierarchy of data objects;

at least one row of the generally tabular data structure representing one object of data in the hierarchy of the data objects.