RESOLVING IN-MEMORY FOREIGN KEYS IN TRANSMITTED DATA PACKETS FROM SINGLE-PARENT HIERARCHIES

• US 20140214902A1
• Filed: 01/30/2013
• Published: 07/31/2014
• Est. Priority Date: 01/30/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: MEHTA, DHAVAL MANHARLAL, HUANG, JIANYING
• Granted Patent: US 9,177,005 B2
• Time in Patent Office: Days
• US Class Current: 707/803
• CPC Class Codes: G06F 16/144 Query formulation
• CPC Class Codes: G06F 16/148 File search processing
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06F 16/2228 Indexing structures
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/83 Querying
• CPC Class Codes: G06F 16/955 using information identifiers, e.g. uniform resource locators [URL]

Abstract

A method of creating multi-parent relationships from single-parent data may include receiving a data set that includes a plurality of objects organized in a hierarchy. The method may also include parsing the data set to locate at least two objects in the plurality of objects. Each of the at least two objects may be associated with an identifier. The method may additionally include creating a data record to represent information associated with the at least two objects. The data record may be associated with a plurality of parent data records.

Claims

1. A method of creating multi-parent relationships from single-parent data, the method comprising:

receiving a data set that includes a plurality of objects organized in a hierarchy;

parsing the data set to locate at least two objects in the plurality of objects, wherein each of the at least two objects are associated with an identifier; and

creating a data record to represent information associated with the at least two objects, wherein the data record is associated with a plurality of parent data records.

2. The method of claim 1 further comprising:

ascertaining that the plurality of objects includes;

a first object;

a second object that is associated with the identifier and is a child of the first object according to the hierarchy;

a third object; and

a fourth object that is associated with the identifier and is a child of the third object according to the hierarchy;

ascertaining, based on the identifier, that the second object and the fourth object represent the same information;

creating a second data record from the second object;

creating a first data record from the first object, wherein the first data record references the second data record as a child record; and

creating a third data record from the third object, wherein the third data record references the second data record as a child record.

3. The method of claim 2 further comprising:

discarding the fourth object without requiring a corresponding fourth data record to be created.

4. The method of claim 3 wherein information represented by the second object is different than information represented by the fourth object.

5. The method of claim 4 wherein the information represented by the fourth object is empty.

6. The method of claim 1 wherein the hierarchy comprises a single-parent hierarchy.

7. The method of claim 1 wherein:

the data record is part of a plurality of data records created from the plurality of objects; and

the plurality of data records is arranged in a multi-parent hierarchy.

8. The method of claim 1 wherein the data set comprises an XML format.

9. The method of claim 8 wherein the identifier comprises a value associated with an XML element.

10. The method of claim 1 wherein:

the data record is part of a plurality of data records created from the plurality of objects; and

each of the plurality of data records comprises an entry in one or more relational databases.

11. The method of claim 1 wherein:

the data set is received by an application that is a part of a suite of Enterprise Software Suite (ESS) applications;

the data set is sent from a client system that is part of the ESS; and

the ESS comprises a financial application, a human resource application, and an access manager.

12. The method of claim 1 wherein the data record is referenced by a foreign key in each of the plurality of parent data records.

13. The method of claim 1 wherein the data set comprises:

information related to an organization,

contact information,

account information, and

an address.

14. A computer-readable memory comprising a sequence of instructions which, when executed by one or more processors, causes the one or more processors to create multi-parent relationships from single-parent data by:

receiving a data set that includes a plurality of objects organized in a hierarchy;

parsing the data set to locate at least two objects in the plurality of objects, wherein each of the at least two objects are associated with an identifier; and

creating a data record to represent information associated with the at least two objects, wherein the data record is associated with a plurality of parent data records.

15. The computer-readable memory according to claim 14, wherein the instructions further cause the one or more processors to create multi-parent relationships from single-parent data by:

ascertaining that the plurality of objects includes;

a first object;

a second object that is associated with the identifier and is a child of the first object according to the hierarchy;

a third object;

a fourth object that is associated with the identifier and is a child of the third object according to the hierarchy;

ascertaining, based on the identifier, that the second object and the fourth object represent the same information;

creating a second data record from the second object;

creating a first data record from the first object, wherein the first data record references the second data record as a child record; and

creating a third data record from the third object, wherein the third data record references the second data record as a child record.

16. The computer-readable memory according to claim 14, wherein the hierarchy comprises a single-parent hierarchy.

17. The computer-readable memory according to claim 14, wherein:

the data record is part of a plurality of data records created from the plurality of objects; and

the plurality of data records is arranged in a multi-parent hierarchy.

18. A system comprising:

one or more processors; and

a memory communicatively coupled with and readable by the one or more processors and comprising a sequence of instructions which, when executed by the one or more processors, cause the one or more processors to create multi-parent relationships from single-parent data by;

receiving a data set that includes a plurality of objects organized in a hierarchy;

parsing the data set to locate at least two objects in the plurality of objects, wherein each of the at least two objects are associated with an identifier; and

creating a data record to represent information associated with the at least two objects, wherein the data record is associated with a plurality of parent data records.

19. The system of claim 18 wherein the instructions further cause the one or more processors to create multi-parent relationships from single-parent data by:

ascertaining that the plurality of objects includes;

a first object;

a second object that is associated with the identifier and is a child of the first object according to the hierarchy;

a third object; and

a fourth object that is associated with the identifier and is a child of the third object according to the hierarchy;

ascertaining, based on the identifier, that the second object and the fourth object represent the same information;

creating a second data record from the second object;

creating a first data record from the first object, wherein the first data record references the second data record as a child record; and

creating a third data record from the third object, wherein the third data record references the second data record as a child record.

20. The system of claim 18 wherein the hierarchy comprises a single-parent hierarchy.