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

• US 20160004737A1
• Filed: 09/16/2015
• Published: 01/07/2016
• 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 10,176,206 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• 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]
• CPC Class Codes: G06F 17/30321 Indexing structures indexing structures for unstructured textual data G06F17/30619
• CPC Class Codes: G06F 17/30876 by using information identifiers, e.g. encoding URL in specific indicia, browsing history

Abstract

A web service interface may receive a web service request that describes multiple objects. Each of the multiple objects may be associated with a common object, such as in a parent-child relationship. The web service can identify the common object and the multiple relationships between objects, and instead of creating duplicate versions of the common object, the web service can create a single record representing the common object in, for example, a database. Records for each of the multiple objects referring to the common object can reference the common object record in the database using, for example, foreign keys.

Claims

1. A non-transitory computer-readable memory comprising instructions which, when executed by one or more processors, cause the one or more processors to perform operations comprising:

receiving, through a web services interface, a web service request that describes multiple objects that are each associated with a common object that is also described in the web service request;

in response to receiving the web service request through the web services interface, determining that the common object is associated with the multiple objects in the web service request; and

in response to determining that the common object is associated with the multiple objects in the web service request, creating, in a database that does not yet contain any record representing the common object;

a single common record that represents the common object, and

multiple records that represent the multiple objects and that refer to the single common record.

2. The non-transitory computer-readable medium of claim 1, wherein:

the single common record and the multiple records are created in the database in response to receipt, through the web services interface, of only one web service request.

3. The non-transitory computer-readable medium of claim 1, wherein creating the multiple records in the database comprises:

creating, in the database, records that contain a foreign key that refers to the single common record.

4. The non-transitory computer-readable medium of claim 1, wherein creating the multiple records in the database comprises creating, in the database:

a first record in a first database table that contains objects of a first object type; and

a second record in a second database table that contains objects of a second object type that differs from the first object type.

5. The non-transitory computer-readable medium of claim 1, wherein determining that the common object is associated with the multiple objects in the web service request comprises:

storing, in memory separate from the database, an identifier that is associated with the common object within the web service request;

determining that a first object of the multiple objects specifies a reference to the identifier within the web service request; and

determining that a second object of the multiple objects also specifies a reference to the identifier within the web service request.

6. The non-transitory computer-readable medium of claim 5, wherein the operations further comprise:

in response to completing processing of the web service request, extinguishing the identifier from the memory.

7. The non-transitory computer-readable medium of claim 6, wherein creating, in the database, the single common record that represents the common object comprises:

creating the single common record in the memory during a web service'"'"'s analysis of the web service request;

copying the single common record from the memory into the database at a conclusion of the analysis; and

discarding the single common record from the memory prior to receipt of a subsequent web service request through the web services interface.

8. The non-transitory computer-readable medium of claim 5, wherein the operations further comprise:

in response to locating, within the web service request, a first-occurring definition of the common object associated with the identifier, storing, in the memory, an association between the first-occurring definition and the identifier.

9. The non-transitory computer-readable medium of claim 8, wherein the operations further comprise:

in response to locating, within the web service request, an instance of the identifier that lacks the definition, accessing the association between the definition and the identifier previously stored in the memory to determine a definition for a web service request-specified object that is associated with the identifier.

10. The non-transitory computer-readable medium of claim 8, wherein the operations further comprise:

in response to locating, within the web service request, an instance of the identifier that is associated with a subsequent definition that differs from the first-occurring definition, accessing the association between the first-occurring definition and the identifier previously stored in the memory to determine a definition for a web service request-specified object that is associated with the identifier.

11. The non-transitory computer-readable medium of claim 8, wherein the operations further comprise:

in response to locating, within the web service request, an instance of the identifier that is associated with a subsequent definition that contains data that the first-occurring definition lacks, revising the definition previously associated with the identifier in the memory by adding the data to the definition associated with the identifier in the memory.

12. The non-transitory computer-readable medium of claim 8, wherein the operations further comprise:

in response to locating, within the web service request, instances of the identifier that are associated with different definitions, revising the definition previously associated with the identifier in the memory to be a definition associated with a majority of instances of the identifier within the web service request.

13. The non-transitory computer-readable medium of claim 5, wherein the operations further comprise:

locating, within a document, multiple duplicate instances of data that represent the common object; and

for each particular instance of the multiple duplicate instances, adding the identifier to the particular instance within the document.

14. The non-transitory computer-readable medium of claim 5, wherein the operations further comprise:

generating a document that defines the common object only once, associates a definition of the common object with the identifier, and refers to the identifier without reciting the definition in each particular object of the multiple objects.

15. The non-transitory computer-readable medium of claim 1, wherein the operations further comprise:

in response to locating, in the web service request, a first instance of a first markup language tag that is associated with a first value, creating, in a first database table that stores records corresponding to the first markup language tag, a first common object record that is associated with the first value; and

in response to locating, in the web service request, a second instance of the first markup language tag that is associated with a second value that differs from the first value, creating, in the first database table, a second common object record that is associated with the second value.

16. The non-transitory computer-readable medium of claim 15, wherein the operations further comprise:

in response to locating, in the web service request, an instance of a second markup language tag that differs from the first markup language tag and is associated with a particular value, creating, in a second database table that stores records corresponding to the second markup language tag, a particular common object record that is associated with the particular value.

17. The non-transitory computer-readable medium of claim 16, wherein:

the first markup language tag identifies, in the web service request, common objects that are of a location object class; and

the second markup language tag identifies, in the web service request, common objects that are of a contact object class.

18. The non-transitory computer-readable medium of claim 1, wherein:

the web service request describes an object hierarchy in which each particular object of the multiple objects is a parent to the common object.

19. A method of receiving web service requests that reference common objects, the method comprising:

receiving, through a web services interface, a web service request that describes multiple objects that are each associated with a common object that is also described in the web service request;

in response to receiving the web service request through the web services interface, determining that the common object is associated with the multiple objects in the web service request; and

in response to determining that the common object is associated with the multiple objects in the web service request, creating, in a database that does not yet contain any record representing the common object;

a single common record that represents the common object, and

multiple records that represent the multiple objects and that refer to the single common record.

20. A system comprising:

one or more processors; and

one or more memories comprising instructions which, when executed by the one or more processors, cause the one or more processors to perform operations comprising;

receiving, through a web services interface, a web service request that describes multiple objects that are each associated with a common object that is also described in the web service request;

in response to receiving the web service request through the web services interface, determining that the common object is associated with the multiple objects in the web service request; and

in response to determining that the common object is associated with the multiple objects in the web service request, creating, in a database that does not yet contain any record representing the common object;

a single common record that represents the common object, and

multiple records that represent the multiple objects and that refer to the single common record.