# US 11,308,031 B2 · Resolving in-memory foreign keys in transmitted data packets from single-parent hierarchies

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 11,308,031 B2
- Document ID: US11308031B2
- Status: Granted
- Kind: B2
- Application number: 16/241,850
- Filed: 2019-01-07
- Published: 2019-05-09
- Granted: 2022-04-19
- Earliest claimed: 2013-01-30
- Assignees: Oracle International Corporation
- Applicants: Oracle International Corporation
- Inventors: Dhaval Manharlal Mehta; Jianying Huang
- Web page: https://patentgrep.com/patent/US11308031B2

## CPC

- G06F 16/144: {Query formulation}
- G06F 16/148: {File search processing}
- G06F 16/2228: {Indexing structures}
- G06F 16/2282: {Tablespace storage structures; Management thereof}
- G06F 16/2455: Query execution
- G06F 16/955: using information identifiers, e.g. uniform resource locators [URL]
- G06F 16/20: of structured data, e.g. relational data
- G06F 16/83: Querying
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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

### Claim 1

A non-transitory computer-readable memory comprising instructions that, when executed by one or more processors, cause the one or more processors to perform operations comprising:
receiving a data set to be sent in a web service request, wherein the data set includes a plurality of objects organized in a multi-parent hierarchy;
identifying an object in the plurality of objects that has multiple parent objects in the plurality of objects;
generating a web service request that comprises multiple instances of the object; wherein the web service request is organized in a single-parent hierarchy and each of the multiple instances of the object is a child object of a corresponding one of the multiple parent objects, and each of the multiple instances of the object include an identifier that indicates that the multiple instances of the object represent a single object in the multi-parent hierarchy; and
sending the web service request to a web service interface.

### Claim 2 (depends on 1)

The non-transitory computer-readable medium of claim 1, wherein the identifier comprises a markup language tag.

### Claim 3 (depends on 1)

The non-transitory computer-readable medium of claim 1, wherein the web service request accepts a data format that does not support multi-parent hierarchies.

### Claim 4 (depends on 1)

The non-transitory computer-readable medium of claim 1, wherein the web service request is formatted in a markup language.

### Claim 5 (depends on 1)

The non-transitory computer-readable medium of claim 1, wherein identifying the object in the plurality of objects that has multiple parent objects in the plurality of objects comprises:
identifying a plurality of records in an input data set that are identical.

### Claim 6 (depends on 1)

The non-transitory computer-readable medium of claim 1, wherein identifying the object in the plurality of objects that has multiple parent objects in the plurality of objects comprises:
receiving an input indicating that a single input should be used to generate the object with the multiple parent objects.

### Claim 7

A method of receiving web service requests that reference common objects, the method comprising:
receiving a data set to be sent in a web service request, wherein the data set includes a plurality of objects organized in a multi-parent hierarchy;
identifying an object in the plurality of objects that has multiple parent objects in the plurality of objects;
generating a web service request that comprises multiple instances of the object; wherein the web service request is organized in a single-parent hierarchy and each of the multiple instances of the object is a child object of a corresponding one of the multiple parent objects, and each of the multiple instances of the object include an identifier that indicates that the multiple instances of the object represent a single object in the multi-parent hierarchy; and
sending the web service request to a web service interface.

### Claim 8 (depends on 7)

The method of claim 7, wherein the identifier comprises a markup language tag.

### Claim 9 (depends on 7)

The method of claim 7, wherein the web service request accepts a data format that does not support multi-parent hierarchies.

### Claim 10 (depends on 7)

The method of claim 7, wherein the web service request is formatted in a markup language.

### Claim 11 (depends on 7)

The method of claim 7, wherein identifying the object in the plurality of objects that has multiple parent objects in the plurality of objects comprises:
identifying a plurality of records in an input data set that are identical.

### Claim 12 (depends on 7)

The method of claim 7, wherein identifying the object in the plurality of objects that has multiple parent objects in the plurality of objects comprises:
receiving an input indicating that a single input should be used to generate the object with the multiple parent objects.

### Claim 13

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 a data set to be sent in a web service request, wherein the data set includes a plurality of objects organized in a multi-parent hierarchy;
identifying an object in the plurality of objects that has multiple parent objects in the plurality of objects;
generating a web service request that comprises multiple instances of the object; wherein the web service request is organized in a single-parent hierarchy and each of the multiple instances of the object is a child object of a corresponding one of the multiple parent objects, and each of the multiple instances of the object include an identifier that indicates that the multiple instances of the object represent a single object in the multi-parent hierarchy; and
sending the web service request to a web service interface.

### Claim 14 (depends on 13)

The system of claim 13, wherein the identifier comprises a markup language tag.

### Claim 15 (depends on 13)

The system of claim 13, wherein the web service request accepts a data format that does not support multi-parent hierarchies.

### Claim 16 (depends on 13)

The system of claim 13, wherein the web service request is formatted in a markup language.

### Claim 17 (depends on 13)

The system of claim 13, wherein identifying the object in the plurality of objects that has multiple parent objects in the plurality of objects comprises:
identifying a plurality of records in an input data set that are identical.