Asynchronous database API

• US 7,503,052 B2
• Filed: 04/14/2004
• Issued: 03/10/2009
• Est. Priority Date: 04/14/2004
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Divringi, Lale, Dockter, Blaine, Sundaresan, Sharad, Castro, Pablo
• Primary Examiner(s): An; Meng-Ai
• Assistant Examiner(s): WU, QING YUAN
• Application Number:
  US10/824,177
• Publication Number:
  US 20050234936A1
• Time in Patent Office: 1,791 Days
• Field of Search: 719/313, 719/328, 719/330, 707/1
• US Class Current: 719/328
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: H04L 67/06 specially adapted for file transfer, e.g. file transfer protocol [FTP]
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46
• CPC Class Codes: H04L 67/1097 for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

An asynchronous database API allows threads to call a database and continue to execute without spawning a thread to wait for the database and without polling the database. The API immediately returns to a caller without waiting for a database operation to complete or for any other external event. A call to an asynchronous database API can invoke an initialization method. The initialization method may validate the input parameters, build them into a message for a database operation, send the message to the database server, and return signal information to the client process thread. Signal information provides a client thread with a way to recognize a signal indicating the return of results from a database. Upon completion of a database operation, a thread can call a finalization method to perform any final step to process the database results and pass the formatted results to the thread.

Claims

1. A computer readable medium having stored thereon computer-executable instructions for providing an asynchronous database Application Programming Interface (“

API”

) that allows a client application to open a database connection asynchronously, said API comprising;

instructions for an initialization method that is configured to be invoked by a client thread to request a database operation, wherein upon invocation of said initialization method, said initialization method;

initiates a return communication with said client thread without waiting for any external event, said return communication allowing said client thread to continue executing without waiting for a response from a database server associated with said database operation;

validates input parameters for said database operation;

sets up said database operation by generating database instructions based on data passed to said initialization method; and

sends a request for said database operation to said database server;

instructions for signaling said client thread when said database operation is complete; and

instructions for a finalization method that is configured to be invoked by said client thread, in response to said signaling, to obtain any results of said database operation, wherein upon invocation of said finalization method, said finalization method;

prepares database results for said client thread; and

returns said database results to said client thread.

2. The computer readable medium of claim 1, wherein said return communication comprises an event object that can be signaled when said database operation completes.

3. The computer readable medium of claim 1, wherein said return communication comprises an object with a Boolean flag that can be signaled when said database operation completes.

4. The computer readable medium of claim 1, wherein said initialization method maintains a callback function for notifying said client thread when said database operation completes.

5. The computer readable medium of claim 1, wherein said API further comprises instructions for an execute Structured Query Language (“

SQL”

) statement method that allows said client thread to execute a SQL statement asynchronously.

6. A computer readable medium having stored thereon computer-executable instructions for providing an asynchronous database Application Programming Interface (“

API”

) allowing a client application to open a database connection asynchronously, said API comprising;

instructions for an initialization method, wherein said initialization method is configured to be invoked by a client thread to request a database operation, wherein upon invocation of said initialization method, said initialization method;

initiates a return communication with the client thread without waiting for any external event, said return communication allowing said client thread to continue executing without waiting for a response from a database server associated with said database operation;

validates input parameters for said database operation;

sets up said database operation by generating database instructions based on data passed to the initialization method, said database operation comprising at least one instruction to execute a Structured Query Language (“

SQL”

) statement; and

sends a request for said database operation to a database server;

instructions for signaling said client thread when said database operation is complete;

instructions for a finalization method that is configured to be invoked by said client thread, in response to said signaling, to obtain any results of said database operation, wherein upon invocation of said finalization method, said finalization method;

prepares database results for said client thread; and

returns said database results to said client thread.

7. The computer readable medium of claim 6, wherein said return communication comprises an event object that can be signaled when said database operation completes.

8. The computer readable medium of claim 6, wherein said return communication comprises an object with a Boolean flag that can be signaled when a database operation completes.

9. The computer readable medium of claim 6, further comprising instructions for a callback function for notifying said client thread when said database operation completes.

10. A computer-implemented method for allowing a client application to asynchronously access database services, said method comprising:

receiving, by an Application Programming Interface (API) software executing on a computer, a client thread invocation of an initialization method, wherein said client thread invocation comprises input parameters for a database operation;

initiating, by said initialization method without waiting for any external event, a return communication to said client thread, said return communication allowing said client thread to continue executing without waiting for a response from a database server associated with said database operation;

validating, by said initialization method, said input parameters;

setting up said database operation by generating database instructions based on said input parameters, said database operation comprising at least one instruction to execute a Structured Query Language (“

SQL”

) statement;

sending a request for said database operation to said database server;

signaling said client thread when said database operation is complete;

receiving, by said API, an invocation of a finalization method from said client thread in response to said signaling;

preparing, by said finalization method, database results for said client thread; and

returning, by said finalization method, said database results to said client thread.

11. The computer-implemented method of claim 10, wherein said return communication comprises an event object that can be signaled when said database operation completes.

12. The computer-implemented method of claim 10, wherein said return communication comprises an object with a Boolean flag that can be signaled when a database operation completes.

13. The computer-implemented method of claim 10, further comprising notifying said client thread when said database operation completes by sending a callback function to said client thread.