System and method for processing web service transactions using timestamp data

• US 9,336,265 B2
• Filed: 08/06/2013
• Issued: 05/10/2016
• Est. Priority Date: 08/06/2013
• Status: Active Grant

• Current Assignee: Walmart Apollo, LLC (WalMart Inc.)
• Original Assignee: Wal-Mart Stores Texas LLC (WalMart Inc.)
• Inventors: Frerking, John Randy
• Primary Examiner(s): Thai, Hanh
• Application Number:
  US13/960,266
• Publication Number:
  US 20150046744A1
• Time in Patent Office: 1,008 Days
• Field of Search: 707/638, 707662-663, 707/666, 707/689
• US Class Current: 1/1
• CPC Class Codes: G06F 11/2023 Failover techniques
• CPC Class Codes: G06F 11/2028 eliminating a faulty processor or activating a spare
• CPC Class Codes: G06F 11/2094 Redundant storage or storage space G06F11/2056 takes precedence
• CPC Class Codes: G06F 11/2097 maintaining the standby controller/processing unit updated initialisation or re-synchronisation thereof G06F11/1658 and subgroups
• CPC Class Codes: G06F 11/3055 Monitoring arrangements for monitoring the status of the computing system or of the computing system component, e.g. monitoring if the computing system is on, off, available, not available error or fault processing without redundancy G06F11/0703; error detection or correction by redundancy in data representation G06F11/08; error detection or correction by redundancy in operation G06F11/14; error detection or correction by redundancy in hardware G06F11/16
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/24 Querying
• CPC Class Codes: G06F 2201/835 Timestamp

Abstract

A system is provided that is adapted to service web-based service requests. In one implementation, a caching service is provided for storing and servicing web service requests. In one implementation, virtual computer systems may be used to service requests in a more reliable manner. Different operating modes may be configured for backup redundancy and the caching service may be scaled to meet service requests for a particular application. Also, methods are provided for exchanging timestamp information among web service transaction systems to reduce the amount of processing capability and bandwidth for ensuring database consistency.

Claims

1. A system for processing web service transactions, the system comprising:

a plurality of servers, each server comprising a processor adapted to receive and process one or more web service requests, and a memory to store a plurality of timestamps, the plurality of servers comprising;

a first and a second server, each configured to compare a timestamp of the first server and a timestamp of the second server in order to determine if a database record has expired;

wherein the database record is store in a logical storage coupled to the first server, and wherein the timestamp of the first server and the timestamp of the second server are both associated with the database record; and

wherein the first server deletes the database record if it is determined that the timestamp of the first server, and the timestamp of the second server, have both expired.

2. The system according to claim 1, wherein the first and second servers are located in a first and a second datacenter, respectively.

3. The system according to claim 1, wherein the comparing of timestamps is responsive to a determination by one of the first or the second servers that at least one of the first or the second timestamps is close to an expiration time.

4. The system according to claim 1, further comprising a request handler element adapted to distribute a web service request to at least one of the plurality of servers for processing.

5. The system according to claim 4, further comprising a component configured to monitor processing of web service requests by the at least one of the plurality of servers.

6. The system according to claim 5, further comprising a component to determine a failover of the processing of at least one web service request to another one of the plurality of servers upon failure of the at least one server.

7. The system according to claim 1, wherein the web service requests include at least one of a group comprising:

a representational state transfer (REST) service request; and

a simple object access protocol (SOAP) service request.

8. The system according to claim 1, wherein the plurality of servers are operable in at least one of a group of operating modes, the group comprising:

an active/single mode;

an active/standby mode;

and an active/active mode.

9. A method for processing web service transactions, the method comprising acts of:

receiving and processing, by a first servers, a web service requests related to a database record stored on both a database associated with the first server and a database associated with a second server, wherein the first server comprises a processor to process the web service requests and a memory to store a timestamp of the first server, wherein the method further comprises acts of;

determining if the database record has expired by comparing the timestamp of the first server with a timestamp of the second server, wherein the time stamp of the first server is associated with the database record stored on the database associated with the first server, and wherein the timestamp of the second server is associated with the database record stored on the database associated with the second server; and

deleting, by the first server, the database record stored on the database associated with the first server if it is determined that the timestamp of the first server and the timestamp of the second server have both expired.

10. The method according to claim 9, further comprising an act of updating the timestamp of the first server responsive to a determination that the timestamp of the second server has not expired.

11. The method according to claim 9, further comprising an act of locating the first and second servers in a first and a second datacenter, respectively.

12. The method according to claim 9, wherein the act of determining if the database record has expired is responsive to an act of determining, by one of the first and second servers, that at least one of the first or the second timestamp s is close to an expiration time.

13. The method according to claim 9, further comprising an act of distributing, by a request handler element, a web service request to one of the first or the second servers for processing.

14. The method according to claim 13, further comprising an act of monitoring processing of the web service requests by the one of the first or the second servers.

15. The method according to claim 14, further comprising an act of determining a failover of the processing of the web service request to the second servers upon failure of the first server.

16. The method according to claim 9, wherein the web service requests includes at least one of a group comprising:

a representational state transfer (REST) service request; and

a simple object access protocol (SOAP) service request.

17. The method according to claim 9, wherein the first and the second servers are operable in at least one of a group of operating modes, the group comprising:

an active/single mode;

an active/standby mode; and

an active/active mode.