Managing data transaction requests

• US 8,738,592 B2
• Filed: 10/15/2012
• Issued: 05/27/2014
• Est. Priority Date: 07/03/2003
• Status: Active Grant

• Current Assignee: PayPal, Inc. (PayPal Holdings, Inc.)
• Original Assignee: eBay Inc.
• Inventors: Grossfeld, Elena, Widjojo, Surjatini, Lockert, Thorsten, Seitz, Greg, Wigginton, Kenneth Randall, Kasten, Christopher J.
• Primary Examiner(s): Corrielus, Jean M
• Application Number:
  US13/651,997
• Publication Number:
  US 20130041919A1
• Time in Patent Office: 589 Days
• Field of Search: 707/964, 707/966, 707/968, 707/969, 707/770, 707/826, 707/959, 707/703, 709/203, 709/204, 709/215
• US Class Current: 707/703
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 9/505 considering the load
• CPC Class Codes: Y10S 707/966 Distributed
• CPC Class Codes: Y10S 707/968 Partitioning
• CPC Class Codes: Y10S 707/969 Horizontal partitioning

Abstract

In various embodiments, a system, method, and related computer-readable storage medium to process data transactions are provided. In one example, a system is arranged to process data transactions in a data store including a plurality of databases. The system includes a computer interface module to receive a data transaction request from at least one requesting computer and a data access layer having one or more processors to identify at least one database in the plurality of databases. The data access layer is to define an abstraction layer between a computer interface module and the plurality of databases. Other embodiments are disclosed.

Claims

1. A system, comprising:

a computer interface module to receive a data transaction request from at least one requesting computer; and

a data access layer having one or more processors to identify at least one database in a plurality of databases, the data access layer to define an abstraction layer between the computer interface module and the plurality of databases, the data access layer comprising a plurality of logical hosts and a plurality of physical hosts, the data access layer being further to derive at least one of the plurality of logical hosts from the data transaction request, and map the data transaction request to at least one of the plurality of physical hosts to identify at least one of the plurality of databases.

2. The system of claim 1, wherein the data access layer comprises at least one logical table and at least one physical table, the data access layer being further to:

identify at least one of the plurality of logical tables from the data transaction request; and

map the data transaction request to at least one of the plurality of physical tables to identify a corresponding logical host.

3. The system of claim 1, further comprising a data dependent routing module to generate a query to at least one of the plurality of databases that is identified based on content of the data in the data transaction request.

4. The system of claim 3, wherein the data dependent routing module is to:

identify a data type from the data transaction request; and

map the data transaction request to an associated physical host based on at least one rule.

5. The system of claim 4, wherein the at least one rule includes at least one attribute used to identify the physical host.

6. The system of claim 3, wherein data associated with a user is split across the plurality of databases and the data dependent routing module is further to identify at least one of the plurality of databases from the data transaction request.

7. The system of claim 3, wherein the data transaction request is an object-oriented request and the data dependent routing module is to map the object-oriented request to a physical host to identify an associated database of the plurality of databases.

8. The system of claim 1, wherein the system is part of a network-based commerce facility and the data transaction request is a request associated with items listed in the network-based commerce facility, the data transaction request to be communicated between any one of a plurality of client machines and the system via the Internet.

9. A method, comprising:

receiving a data transaction request from at least one requesting computer;

using a data access layer that defines an abstraction layer to identify, using one or more processors, at least one database from a plurality of databases, the data access layer comprising a plurality of logical hosts and a plurality of physical hosts;

defining an abstraction layer between the at least one requesting computer and the plurality of databases;

deriving at least one of the plurality of logical hosts from the data transaction request; and

mapping the at least one of the plurality of logical hosts to at least one of the plurality of physical hosts that identifies at least one of the plurality of databases.

10. The method of claim 9, wherein the data access layer comprises at least one logical table and at least one physical table, the method further comprising:

identifying one of the at least one logical tables from the data transaction request; and

mapping the logical table to one of the at least one physical tables which identifies a corresponding logical host.

11. The method of claim 9, further comprising generating a query to an identified one of the plurality of databases based on content of data in the data transaction request.

12. The method of claim 9, further comprising:

identifying a data type from the data transaction request; and

mapping the data transaction request to an associated database of the plurality of databases according to at least one rule.

13. The method of claim 12, further comprising:

making a determination if the data transaction request has an associated rule, and

based on the determination that the data transaction request has the associated rule;

retrieving the associated rule; and

mapping the data transaction request to a physical host based on the associated rule.

14. The method of claim 13, wherein mapping the data transaction request to a physical host includes:

mapping the data transaction request to a logical host based on the associated rule; and

mapping the logical host to a physical host identifying one of the plurality of databases.

15. The method of claim 12, wherein the at least one rule includes an attribute that is used in identifying a physical host.

16. The method of claim 12, further comprising changing the at least one rule in substantially real-time.

17. The method of claim 9, wherein data associated with a user is split across the plurality of databases, the method further comprising identifying at least one database associated with the user from the data transaction request.

18. The method of claim 9, wherein the data transaction request is an object-oriented request, the method further comprising mapping the object-oriented request to a physical host, the physical host identifying an associated database of the plurality of databases.

19. The method of claim 9, further comprising:

making a determination if the identified one of the plurality of databases is down; and

based on the determination that the identified database is down, mapping the data transaction request to an alternative one of the plurality of databases.

20. The method of claim 9, further comprising:

monitoring a status of the plurality of databases; and

using the data access layer to balance a load on the plurality of databases in response to the monitored status.

21. The method of claim 9, further comprising:

splitting a data transaction request to different databases of the plurality of databases; and

gathering results received from the different databases and presenting them to the requesting computer.

22. A machine-readable storage medium comprising instructions, the storage medium having no transitory components, the instructions, when executed by one or more processors, cause the machine to perform operations comprising:

receiving a data transaction request from at least one requesting computer;

using a data access layer that defines an abstraction layer to identify at least one database from a plurality of databases; and

defining an abstraction layer between the at least one requesting computer and the plurality of databases, the data access layer comprising a plurality of logical hosts and a plurality of physical hosts, the data access layer being further to derive at least one of the plurality of logical hosts from the data transaction request, and map the data transaction request to at least one of the plurality of physical hosts to identify at least one of the plurality of databases.

23. A system, comprising:

a computer interface module to receive a data transaction request from at least one requesting computer; and

a data access layer having one or more processors to identify at least one database in a plurality of databases, the data access layer to define an abstraction layer between the computer interface module and the plurality of databases, the data access layer comprising at least one logical table and at least one physical table, the data access layer being further to identify at least one of the plurality of logical tables from the data transaction request, and map the data transaction request to at least one of the plurality of physical tables to identify a corresponding logical host.

24. A method, comprising:

receiving a data transaction request from at least one requesting computer;

using a data access layer that defines an abstraction layer to identify, using one or more processors, at least one database from a plurality of databases, the data access layer comprising at least one logical table and at least one physical table;

defining an abstraction layer between the at least one requesting computer and the plurality of databases;

identifying one of the at least one logical tables from the data transaction request; and

mapping the logical table to one of the at least one physical tables which identifies a corresponding logical host.

25. A machine-readable storage medium comprising instructions, the storage medium having no transitory components, the instructions, when executed by one or more processors, cause the machine to perform operations comprising:

receiving a data transaction request from at least one requesting computer;

using a data access layer that defines an abstraction layer to identify at least one database from a plurality of databases, the data access layer comprising at least one logical table and at least one physical table;

defining an abstraction layer between the at least one requesting computer and the plurality of databases;

identifying one of the at least one logical tables from the data transaction request; and

mapping the logical table to one of the at least one physical tables which identifies a corresponding logical host.