System and method for efficient database transactions

1. A computer implemented method of processing a transaction from a remote client device with a database stored within a database server containing data stored in a raw storage format, the database server having a processor, computer-readable storage medium maintaining database management software, and a storage device for maintaining the database, the method comprising the steps of:

receiving a request from the remote client device to access the database stored within the database server;

generating at least one statement based on the request, the at least one statement comprising a command for execution by the database server;

receiving client data related to the transaction from an in-memory record created by and stored on the remote client device, the in-memory record storing the client data in the raw storage format of the database such that the client data received is in the raw storage format of the database; and

executing by the database server the at least one statement using the client data as received.

2. The computer implemented method according to claim 1 , wherein the request comprises a request to update the database.

3. The computer implemented method according to claim 2 , wherein the at least one statement comprises an UPDATE statement.

4. The computer implemented method according to claim 1 , wherein the request comprises a request to insert data into the database.

5. The computer implemented method according to claim 4 , wherein the at least one statement comprises an INSERT statement.

6. The computer implemented method according to claim 1 , further comprising the step of exposing an API to the remote client device, wherein the API enables the remote client device to send the client data to the database server in the raw storage format of the database.

7. The computer implemented method according to claim 1 , wherein the remote client device comprises an application for requesting and utilizing database data and a database driver for communicating with the database server in the raw storage format.

8. A computer implemented method of processing transactions with a database stored within a database server containing data stored in a raw storage format, the database server having a processor, computer-readable storage medium maintaining database management software, and a storage device for maintaining the database, the method comprising the steps of:

receiving a request from a remote client device to execute a transaction with the database, the request comprising a statement defining a type of the transaction and providing client data related to the request, wherein the client data is provided from an in-memory record created by and stored on the remote client device, the in-memory record storing the client data in the raw storage format of the database such that the client data provided is in the raw storage format of the database; and

executing the transaction in accordance with the statement.

9. The computer implemented method according to claim 8 , wherein the statement comprises an INSERT transaction.

10. The computer implemented method according to claim 8 , wherein the raw storage format comprises a raw record format.

11. The computer implemented method according to claim 8 , wherein the statement comprises an INSERT transaction for a record in the database, and wherein the raw storage format comprises a raw record format for the database.

12. The computer implemented method according to claim 8 , wherein the statement comprises an UPDATE transaction.

13. A computer implemented method performed by a remote client device for accessing a database stored within a database server containing data stored in a raw storage format, the database server having a processor, computer-readable storage medium maintaining database management software, and a storage device for maintaining the database, the method comprising the steps of:

creating an in-memory record of client data related to a transaction of the remote client device with the database for storage on the remote client device, the in-memory record storing the client data in the raw storage format of the database;

generating a request to access the database to initiate the transaction;

formulating at least one statement based on the request, the at least one statement comprising a command for execution by the database server;

calling an API; and

sending the client data from the in-memory record of the remote client device to the database server in accordance with the API, the client data being sent in the raw storage format of the database.

14. The computer implemented method according to claim 13 , wherein the request comprises a request to update data within the database.

15. The computer implemented method according to claim 14 , wherein the at least one statement comprises an UPDATE statement.

16. The computer implemented method according to claim 13 , wherein the request comprises a request to insert data into the database.

17. The computer implemented method according to claim 16 , wherein the at least one statement comprises an INSERT statement.

18. A computer implemented method performed by a remote client device for accessing a remote database stored within a database server containing data stored in a raw storage format, the database server having a processor, computer-readable storage medium maintaining database management software, and a storage device for maintaining the remote database, the method comprising the steps of:

creating an in-memory record of client data related to a transaction of the remote client device with the remote database for storage on the remote client device, the in-memory record storing the client data in the raw storage format of the remote database; and

transmitting a request to the database server electrically connected with the remote database to execute the transaction with the remote database, the request comprising a statement defining a type of the transaction and including the in-memory record of the client data related to the transaction such that the client data is provided to the database server in the raw storage format of the remote database.

19. The computer implemented method according to claim 18 , wherein the statement comprises an INSERT statement.

20. The computer implemented method according to claim 18 , wherein the raw storage format comprises a raw record format.

21. The computer implemented method according to claim 18 , wherein the statement comprises an INSERT transaction for a record in the remote database, and wherein the raw storage format comprises a raw record format for the remote database.

22. The computer implemented method according to claim 18 , wherein the statement comprises an UPDATE statement.

23. A database management system comprising:

a database, the database containing data in a raw storage format; and

a server electrically connected to the database, the server comprising:

an interface for receiving a request from a remote client device to execute a transaction with the database; and

a processor configured to:

generate at least one statement based on the request, the at least one statement comprising a command for execution by the server;

receive client data from an in-memory record created by and stored on the remote client device, the in-memory record storing the client data in the raw storage format of the database such that the client data received is in the raw storage format of the database; and

execute the at least one statement using the client data, as received.

24. The system according to claim 23 , wherein the processor is configured to receive the client data by returning an API to the remote client device, wherein the API enables the remote client device to send the client data to the server in the raw storage format of the database.