System for Processing Relational Database Data

• US 20080040363A1
• Filed: 06/29/2007
• Published: 02/14/2008
• Est. Priority Date: 07/13/2006
• Status: Abandoned Application

• Current Assignee: Siemens Medical Solutions USA Incorporated (Siemens AG)
• Original Assignee: Siemens Medical Solutions USA Incorporated (Siemens AG)
• Inventors: Tauscher, Margaret
• Application Number:
  US11/771,283
• Publication Number:
  US 20080040363A1
• Time in Patent Office: Days
• US Class Current: 707/100
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/84 Mapping; Conversion

Abstract

A system assigns a branch number to each record derived from a database and generates XML using this branch number to sequence parent/child records so that output XML is nested properly, regardless of how many levels exist for each branch in order to organize a set of hierarchical data with an unknown tree depth and structure. A system processes hierarchically structured data in a relational database using a database processor. The database processor processes hierarchically structured data in a database to provide, a) a level identifier for an individual data item in the structured data indicating a level of hierarchy associated with the individual data item and b) a branch identifier indicating a sequential order of processing of the individual data item in the structured data. A data processor populates executable application data with multiple level and branch identifiers. The executable application is used for providing a representation of a structure of the hierarchically structured data.

Claims

1. A system for processing hierarchically structured data in a relational database, comprising:

a database processor for processing hierarchically structured data in a repository to provide,

a) a level identifier for an individual data item in said structured data indicating a level of hierarchy associated with said individual data item and

b) a branch identifier indicating a sequential order of processing of said individual data item in said structured data; and

a data processor for populating executable application data with a plurality of level and branch identifiers, said executable application being used for providing a representation of a structure of said hierarchically structured data.

2. A system according to claim 1, wherein

said executable application is an XML (Extensible Markup Language) application.

3. A system according to claim 2, wherein

said XML application is processed by an XSL (Extensible Stylesheet Language) application in providing a displayable image presenting a tree structure of said hierarchically structured data comprising said representation of said structure of said hierarchically structured data.

4. A system according to claim 1, including

a repository of said executable application data comprising information associating a plurality of data items and associated attributes comprising said hierarchically structured data with said level identifier and said branch identifier.

5. A system according to claim 4, wherein

said information is stored in temporary tables.

6. A system according to claim 4, wherein

said data processor generates XML data representing said hierarchically structured data using said branch identifier in ordering data items of said hierarchically structured data.

7. A system according to claim 6, wherein

said data processor generates XML data representing said hierarchically structured data using said level identifier in ordering data items of said hierarchically structured data.

8. A system for processing hierarchically structured data in a relational database, comprising:

a database processor for processing hierarchically structured data in a repository to provide,

a) a plurality of level identifiers associated with individual data items in said hierarchically structured data indicating a level of hierarchy associated with said individual data items and

b) a plurality of branch identifiers indicating a sequential order of processing of said individual data items in said hierarchically structured data; and

a data processor for generating XML data representing said hierarchically structured data using said branch identifier in ordering data item branches of said hierarchically structured data.

9. A system according to claim 8, wherein

said data processor generates said XML data using said level identifier in ordering data item branches of said hierarchically structured data.

10. A system for processing hierarchically structured data in a relational database, comprising:

a repository of information associating a plurality of data items and associated attributes comprising hierarchically structured data with a plurality of level identifiers and branch identifiers.

a database processor for processing hierarchically structured data in said repository to provide,

a) said plurality of level identifiers associated with individual data items in said hierarchically structured data indicating a level of hierarchy associated with said individual data items and

b) said plurality of branch identifiers indicating a sequential order of processing of said individual data items in said hierarchically structured data; and

a data processor for generating data representing said hierarchically structured data using said level and branch identifiers in ordering data item branches of said hierarchically structured data.

11. A system according to claim 10, wherein

said data representing said hierarchically structured data comprises XML data.