Speculative begin transaction

• US 9,619,508 B2
• Filed: 07/12/2011
• Issued: 04/11/2017
• Est. Priority Date: 07/12/2011
• Status: Active Grant

• Current Assignee: Meta Platforms, Inc. (f/k/a Facebook, Inc.)
• Original Assignee: Meta Platforms, Inc. (f/k/a Facebook, Inc.)
• Inventors: Peek, Daniel Nota
• Primary Examiner(s): Winder, Patrice
• Assistant Examiner(s): De Rodrig, Angela Widhalm
• Application Number:
  US13/181,396
• Publication Number:
  US 20130018988A1
• Time in Patent Office: 2,100 Days
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: H04L 41/00 Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
• CPC Class Codes: H04L 41/024 using relational databases for representation of network management data, e.g. managing via structured query language [SQL]

Abstract

Speculative processing of begin transaction database messages may include receiving a begin transaction message from a database client, transmitting an acknowledgement of the begin transaction message to the database client prior to forwarding the begin transaction message to the database server, forwarding the begin transaction message to the database server, and receiving an acknowledgement of the begin transaction message from the database server. In some implementations, the acknowledgement of the begin transaction message to the database client is transmitted substantially without delay after receiving the begin transaction message from the database client.

Claims

1. A non-transitory computer readable medium comprising instructions, the instructions operable when executed by a processor to:

receive a begin transaction message from a database client, wherein the begin transaction is the first in a series of logically related messages sent to a database server;

transmit an acknowledgement of the begin transaction message to the database client, prior to forwarding the begin transaction message to the database server, the begin transaction message establishing an active connection to the database server;

forward the begin transaction message to the database server; and

receive an acknowledgement of the begin transaction message from the database server.

2. The non-transitory computer readable medium of claim 1, wherein the acknowledgement of the begin transaction message to the database client is transmitted substantially without delay after receiving the begin transaction message from the database client.

3. The non-transitory computer readable medium of claim 1, wherein the instructions are further operable when executed by the processor to:

receive a database query from the database client;

if the acknowledgement of the begin transaction message from the database server is received, forward the database query to the database server.

4. The non-transitory computer readable medium of claim 3, wherein the instructions are further operable when executed by the processor to:

receive, from the database server, database results in response to the database query;

forward the database results to the database client.

5. The non-transitory computer readable medium claim of claim 3, wherein the instructions are further operable when executed by the processor to, if the acknowledgement of the begin transaction message from the database server is not received, terminate the connection with the database client.

6. The non-transitory computer readable medium of claim 1, wherein the database client is a web server.

7. The non-transitory computer readable medium of claim 1, wherein the database server is a Structured Query Language (SQL) database.

8. A apparatus, comprising:

an interface for receiving begin transaction messages;

a memory for storing begin transaction messages;

a processor communicatively coupled to the interface and the memory, the processor operable to;

receive a begin transaction message from a database client, wherein the begin transaction is the first in a series of logically related messages sent to a database server;

transmit an acknowledgement of the begin transaction message to the database client, prior to forwarding the begin transaction message to the database server, the begin transaction message establishing an active connection to the database server;

forward the begin transaction message to the database server; and

receive an acknowledgement of the begin transaction message from the database server.

9. The apparatus of claim 8, wherein the acknowledgement of the begin transaction message to the database client is transmitted substantially without delay after receiving the begin transaction message from the database client.

10. The apparatus of claim 8, wherein the processor is further operable to:

receive a database query from the database client;

if the acknowledgement of the begin transaction message from the database server is received, forward the database query to the database server.

11. The apparatus of claim 10, wherein the processor is further operable to:

receive, from the database server, database results in response to the database query;

forward the database results to the database client.

12. The apparatus of claim 10, wherein the processor is further operable to, if the acknowledgement of the begin transaction message from the database server is not received, terminate the connection with the database client.

13. The apparatus of claim 8, wherein the database client is a web server.

14. The apparatus of claim 8, wherein the database server is a Structured Query Language (SQL) database.

15. A method, comprising:

receiving a begin transaction message from a database client, wherein the begin transaction is the first in a series of logically related messages sent to a database server;

transmitting an acknowledgement of the begin transaction message to the database client, prior to forwarding the begin transaction message to the database server, the begin transaction message establishing an active connection to the database server;

forwarding the begin transaction message to the database server; and

receiving an acknowledgement of the begin transaction message from the database server.

16. The method of claim 15, wherein the acknowledgement of the begin transaction message to the database client is transmitted substantially without delay after receiving the begin transaction message from the database client.

17. The method of claim 15, wherein the instructions are further operable when executed by the processor to:

receive a database query from the database client;

if the acknowledgement of the begin transaction message from the database server is received, forward the database query to the database server.

18. The method of claim 17, further comprising:

receiving, from the database server;

database results in response to the database query;

forwarding the database results to the database client.

19. The method of claim 17, further comprising if the acknowledgement of the begin transaction message from the database server is not received, terminating the connection with the database client.

20. The method of claim 15, wherein the database client is a web server.