Edge deployed database proxy driver

• US 7,426,515 B2
• Filed: 01/15/2002
• Issued: 09/16/2008
• Est. Priority Date: 01/15/2002
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hind, John R., Li, Yongcheng
• Primary Examiner(s): ABEL JALIL, NEVEEN
• Application Number:
  US10/047,860
• Publication Number:
  US 20030135505A1
• Time in Patent Office: 2,436 Days
• Field of Search: 707/1, 707/100, 707/101, 707/4, 709/321, 709/328, 709/212
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

An edge-deployed database proxy. A database access system which has been configured with the database proxy can include a universal database connectivity driver having a first exposed interface through which access to a database server can be provided; a database proxy driver registered with the universal database connectivity driver; and, a database driven application programmatically linked to the database proxy driver. Significantly, the database proxy driver can have a second exposed interface which conforms with the first exposed interface of the universal database connectivity driver. The database proxy driver further can have a configuration for invoking at least one auxiliary task in addition to providing access to the database server through the first exposed interface of the universal database connectivity driver.

Claims

1. A database access method within a database proxy driver, the method comprising:

receiving a database connectivity request, from a database driven application, through a corresponding second exposed interface;

forwarding said database connectivity requests, to an universal database connectivity driver, through a corresponding first exposed interface which matches a prototype of said second exposed interface; and

,

performing at least one auxiliary task in addition to forwarding said database connectivity request.

2. The database access method of claim 1, further comprising performing each of the receiving, forwarding and performing steps in an edge device.

3. The database access method of claim 2, wherein said performing step comprises performing a load balancing task.

4. The database access method of claim 2, wherein said performing step comprises performing a database caching task.

5. The database access method of claim 1, further comprising:

collecting meta-data for each received database connectivity request; and

,

modifying operation of said auxiliary task based upon an analysis of said collected meta-data.

6. The database access method of claim 5, wherein said modifying step comprises generating rules which direct database connectivity requests to particular instances of a database server which are most likely to respond quickly based upon database latency patterns inherent in said collected meta-data.

7. The database access method of claim 6, wherein said modifying step comprises selectively caching result sets in a database cache based upon request frequency patterns inherent in said collected meta-data.