Database interface architecture with time-based load balancing in a real-time environment

• US 20030065646A1
• Filed: 09/13/2002
• Published: 04/03/2003
• Est. Priority Date: 09/13/2001
• Status: Abandoned Application

• Current Assignee: JDA Software Group Incorporated (RedPrairie Holding Incorporated)
• Original Assignee: JDA Software Group Incorporated (RedPrairie Holding Incorporated)
• Inventors: Nayak, Trivikram, Purohit, Sudarshan, Manikhandan, A. B., Nandan, Sanjeev, Joseph, Paul G.
• Application Number:
  US10/243,623
• Publication Number:
  US 20030065646A1
• Time in Patent Office: Days
• US Class Current: 707/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

A database interface architecture is disclosed that operates in an asynchronous mode, provides for load balancing over time, and is optimized for high speed. Even when the system is under light load, data is inserted into the database in a timely manner by flushing the buffer after a configurable time interval, regardless of how full or empty the buffer is, thereby ensuring that data does not remain in the buffer during times of light or no load. The buffer can also be flushed by setting a flag whereby the buffer is flushed regardless of the timestamp on the buffer.

Claims

1. A method for load-dependent handling database transaction requests comprising:

receiving a database transaction request from a client;

placing said database transaction request in a buffer memory;

transferring the database transaction requests residing in the buffer memory into an intermediate storage device in response to a load-dependent transfer command supplied to the buffer memory; and

transmitting from the intermediate storage device selected ones of the database transaction requests to a database for updating corresponding records in the database.

2. The method of claim 1, wherein said load-dependent transfer command is supplied when an elapsed time since a previous transfer of database transactions from the buffer memory into the intermediate storage is greater than a predetermined time.

3. The method of claim 1, wherein said load-dependent transfer command is supplied if the buffer memory is full when placing said database transaction request in the buffer memory.

4. The method of claim 1, wherein said load-dependent transfer command is supplied by a housekeeping thread.

5. The method of claim 1, and further providing a configurable number of worker threads that handle placing the database transaction requests in the buffer memory.

6. The method of claim 5, wherein said load-dependent transfer command is supplied by a worker thread having NULL data.

7. The method of claim 1, and further providing a configurable number of database threads that handle transmitting the selected database transaction requests from the intermediate storage device to the database.

8. The method of claim 1, wherein transferring the database transaction requests further includes reading the database transaction requests from the buffer memory line-by-line.

9. The method of claim 1, wherein transferring the database transaction requests further includes reading the database transaction requests from the buffer memory all at once.

10. The method of claim 7, and further including configuring a database thread so as to one of mark and delete a corresponding record in the intermediate storage device after updating the record in the database.

11. A computer system for handling load-dependent database transaction requests, comprising

a network interface receiving transaction requests from a client;

a buffer memory receiving from the input port the transaction requests;

an intermediate storage connected to the buffer memory, said buffer memory transferring the database transaction requests residing in the buffer memory into an intermediate storage device in response to a load-dependent transfer command supplied to the buffer memory; and

a database interface for transmitting from the intermediate storage device selected ones of the database transaction requests to a database for updating corresponding records in the database.

12. The computer system of claim 11, wherein the buffer memory comprises a random access memory (RAM) and the intermediate storage comprises a disk storage.

13. A database server for handling database interactions between a client and a database over a network, comprising:

a network interface receiving records for a database interaction,

a buffer memory for temporarily storing the received records,

at least one worker thread for handling transfer of the received records to the buffer memory,

an intermediate storage device in data communication with the buffer memory, said buffer memory transferring the temporarily stored records residing in the buffer memory into the intermediate storage device in response to a load-dependent transfer command supplied to the buffer memory; and

at least one database thread different from the at least one worker thread, said at least one database thread monitoring the intermediately stored records in the intermediate storage device and, if a record in the database matches an intermediately stored record, processing the intermediately stored record for updating the matching record in the database.

14. The server of claim 13, wherein said load-dependent transfer command is supplied when a worker thread determines that an elapsed time since a previous transfer of records from the buffer memory into the intermediate storage is greater than a predetermined time.

15. The server of claim 13, wherein said load-dependent transfer command is supplied when a worker thread determines that the buffer memory is full when transferring said record into the buffer memory.

16. The server of claim 13, wherein said load-dependent transfer command is supplied by a housekeeping thread separate from a worker thread.

17. The server of claim 13, wherein said load-dependent transfer command is supplied by a worker thread having NULL data.

18. The server of claim 13, wherein said at least one database thread after updating marks in or deletes from the intermediate storage device the record that matches the record in the database.

19. A computer system for handling load-dependent database transaction requests, comprising computer instructions for:

placing a database transaction request received from a client into a buffer memory;

transferring the database transaction requests residing in the buffer memory into an intermediate storage device in response to a load-dependent transfer command supplied to the buffer memory; and

transmitting from the intermediate storage device selected ones of the database transaction requests to a database for updating corresponding records in the database.

20. A computer-readable medium storing a computer program executable by at least one server computer, the computer program comprising computer instructions for:

placing a database transaction request received from a client into a buffer memory;

transferring the database transaction requests residing in the buffer memory into an intermediate storage device in response to a load-dependent transfer command supplied to the buffer memory; and

transmitting from the intermediate storage device selected ones of the database transaction requests to a database for updating corresponding records in the database.