Cross-references in service schema

• US 10,176,269 B1
• Filed: 12/18/2013
• Issued: 01/08/2019
• Est. Priority Date: 12/18/2013
• Status: Active Grant

• Current Assignee: Amazon Technologies, Inc. (Amazon.com, Inc.)
• Original Assignee: Amazon Technologies, Inc. (Amazon.com, Inc.)
• Inventors: Johnston, Simon Kurt, Rutter, Michael David, Donnelley, Samuel Ytzhak
• Primary Examiner(s): Gurmu, Muluemebet
• Application Number:
  US14/133,349
• Time in Patent Office: 1,847 Days
• Field of Search: 707770
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/955 using information identifiers, e.g. uniform resource locators [URL]
• CPC Class Codes: H04L 67/00 Network arrangements or protocols for supporting network services or applications user-to-user messaging H04L51/00; network arrangements, protocols or services for supporting real-time applications in data packet communications networks H04L65/00

Abstract

A system can include a schema for cross referencing independent yet related services. The schema can utilize reference properties and resource properties to partition data is separate services and allow for services to be added or removed without affecting the integrity of existing services. Embodiments described herein also avoid the need for complex transaction logic to maintain consistency between services. In some embodiments, the services can also utilize different database management systems.

Claims

1. A system comprising:

a first data store configured to store a plurality of primary service data records and a reference property that references a target service data record maintained in a second data store, the reference property comprising an instruction for accessing the target service data record, wherein the instruction is a service call to the target service data record;

a primary service computing device comprising a hardware processor, the primary service computing device in communication with the first data store and configured to;

receive a first request from a client device to access a selected primary service record of the plurality of primary service data records, the selected primary service record comprising the reference property; and

transmit a second request to the target service computing device requesting the target service data record using the instruction in the reference property;

a target service computing device comprising a hardware processor, the target service computing device in communication with the second data store, the target service computing device configured to respond to the second request with the target service data record responsive to the instruction of the reference property; and

a schema repository configured to store a schema index, wherein the primary service computing device implements a first schema and the target service computing device implements a second schema, wherein the schema index has an identifier associated with each of the first schema and the second schema;

wherein the primary service computing device is configured to transmit a response to the first request to the client device comprising the target service data record, wherein the client device associates the selected primary service record with the primary service computing device, and wherein the transmission of the second data request and the response to the second data request are executed without the client device communicating with the target service computing device and without the client device receiving an indication that the primary service computing device communicates with the target service computing device.

2. The system of claim 1, wherein the primary service computing device is associated with a first database management system and the target service computing device service is associated with a second database management system.

3. The system of claim 2, wherein the first database management system and the second database management system are separate systems.

4. A system comprising:

a data store configured to store a primary service data; and

a schema repository configured to store a schema index, wherein a first computing device implements a first schema and a second computing device implements a second schema, wherein the schema index has an identifier associated with each of the first schema and the second schema;

the first computing device in communication with the data store, the computing device configured to;

receive, from the second computing device, a first data request comprising a request for target service data stored in a data store of a computing system implementing a target service;

process the first data request to identify a reference property in a primary service schema associated with the target service data, wherein the reference property is used to access the target service data stored in the data store of the computing system implementing the target service, wherein the reference property comprises a service call for accessing the target service data from the target service;

transmit, to the computing system implementing the target service, a second data request for the target service data, wherein the second data request is performed based at least in part on the service call included in the reference property;

receive, in response to the second data request, the target service data from the computing system implementing the target service, wherein the second computing device associates the target service data with the first computing device, wherein the communicating with transmission of the second data request and receipt of the response to the second data request are executed without the second computing device communicating with the target service and without the second computing device receiving an indication that the first computing device communicates with the target service; and

transmit a response to the first data request to the second computing device, the response comprising the target service data.

5. The system of claim 4, wherein the first data request further comprises a request for primary service data, and wherein the computing device is further configured to retrieve, based at least in part on the primary service schema, the requested primary service data stored within the data store.

6. The system of claim 4, wherein the primary service data comprises country data associated with a plurality of countries.

7. The system of claim 6, wherein the country data comprises at least one of a country name, a country code, a population, and a language spoken in the country.

8. The system of claim 7, wherein the target service data comprises region data regarding regions that comprise a plurality of countries.

9. The system of claim 8, wherein the reference property facilitates identification of a region associated with each of the plurality of countries.

10. The system of claim 4, wherein the service call comprises a hypertext transfer protocol uniform resource identifier.

11. The system of claim 4, wherein the reference property used to access the target service data comprises a reference property name, a target service identifier, and the service call is a query to the target service.

12. A non-transitory physical computer storage comprising computer-executable instructions stored thereon that, when executed in one or more processors, are configured to execute operations comprising:

storing a schema index in a schema repository, wherein a first service implements a first schema and a second service implements a second schema, wherein the schema index has an identifier associated with each of the first schema and the second schema;

receiving a first request, at a first service, for data associated with a resource property defined within a schema of the first service from a client computing device;

determining whether the first data request comprises a request for second data associated with a reference property stored in a primary service schema, wherein the second data is stored within a data store of the second service that is separate from the first service, and wherein the reference property is used to access the second data stored in the data store of the second service, wherein the reference property comprises a service call for accessing the second data from the second service;

transmitting, based at least in part on the service call of the reference property, a second request to the second service for the second data; and

receiving, in response to the second request, a second response from the second service comprising the second data, wherein the client computing device associates the data associated with the resource property with the first service, wherein transmitting the second request and receiving the response to the second request are executed without the client computing device communicating the second service and without the client computing device receiving an indication that the first service communicates with the second service; and

transmitting, to the client computing device, a response to the first request, the response comprising the second data.

13. The non-transitory physical computer storage of claim 12, wherein the first service is associated with a first database management system and the second service is associated with a second database management system.

14. The non-transitory physical computer storage of claim 12, wherein the service call is a uniform resource identifier query.

15. The non-transitory physical computer storage of claim 12, wherein the reference property comprises a reference property name, a second service identifier, and the service call is a query to the second service.

16. A computer-implemented method comprising:

under control of a computer system comprising computer hardware,

storing a schema index in a schema repository, wherein a primary service implements a first schema and a target service implements a second schema, wherein the schema index has an identifier associated with each of the first schema and the second schema;

receiving a first data request from a client computing device;

determining, at a primary service, whether the first data request comprises a request for target service data associated with a reference property stored in a primary service schema, wherein the target service data is stored within a data store of a target service that is separate from the primary service, and wherein the reference property is used to access the target service data stored in the data store of the target service, wherein the reference property comprises a service call for accessing the target service data from the target service;

transmitting a second data request to the target service for the target service data based at least in part on the service call included in the reference property;

receiving the target service data from the target service in response to the second data request, wherein the client computing device associates the first data with the primary service, wherein transmitting the second data request and the receiving the response to the second data request are executed without the client computing device communicating with the target service and without the client computing device receiving an indication that the primary service communicates with the target service; and

transmitting, to the client computing device, a response to the first data request, the response comprising the target service data.

17. The computer-implemented method of claim 16, wherein the service call is a uniform resource locator query.

18. The computer-implemented method of claim 16, wherein the reference property comprises a reference property name, a target service identifier, and the service call is a query to the target service.

19. The computer-implemented method of claim 16, wherein the primary service is associated with a first database management system and the target service is associated with a second database management system.