System and method for routing database requests to a database and a cache

• US 6,609,126 B1
• Filed: 11/15/2000
• Issued: 08/19/2003
• Est. Priority Date: 11/15/2000
• Status: Expired due to Term

• Current Assignee: MEC Management, LLC (Three Affiliated Tribes of the Fort Berthold Reservation, North Dakota)
• Original Assignee: Appfluent Technology Inc (Qlik Technologies)
• Inventors: Conley, Paul Alan, Smith, Erik Richard
• Primary Examiner(s): HOMERE, JEAN RAYMOND
• Application Number:
  US09/711,881
• Time in Patent Office: 1,007 Days
• Field of Search: 707/3, 707/10, 707/102, 707/8, 707/201, 709/219, 709/229
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24524 Access plan code generation and invalidation; Reuse of access plans
• CPC Class Codes: G06F 16/24539 using cached or materialised query results
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A system and method for routing database requests from application logic to a cache and a database, including receiving a database request from the application logic, determining whether the database request is informational or transactional, routing the database request to the cache if the database request is informational, and routing the database request to the database if the database request is transactional. A first example embodiment includes a database which is accessed using a first driver, a cache, and a second driver which determines whether database requests received from application logic are informational or transactional, where informational database requests are routed to the cache and transactional database requests are routed to the database using the first driver.

Claims

1. A method for processing database requests, comprising:

receiving a database request, the database request including a transaction isolation level;

determining whether the database request is informational or transactional;

determining whether the transaction isolation level of the database request is greater than an isolation threshold;

routing the database request to a device having a cache if the database request is informational or if the transaction isolation level is not greater than the isolation threshold; and

routing the database request to the database, without routing the database request through the device having the cache, if the database request is transactional, or if the transaction isolation level is greater than the isolation threshold.

2. A method for processing database requests, comprising:

receiving a database request, the database request including a concurrency setting;

determining whether the database request is informational or transactional;

determining whether the concurrency setting of the database request is less than a concurrency threshold;

routing the database request to a device having a cache if the database request is informational or if the concurrency setting is not less than the concurrency threshold; and

routing the database request to the database, without routing the database request through the device having the cache, if the database request is transactional, or if the concurrency setting is less than the concurrency threshold.

3. Computer executable software code, comprising:

code to receive a database request, the database request including a transaction isolation level;

code to determine whether the database request is informational or transactional;

code to determine whether the transaction isolation level of the database request is greater than an isolation threshold;

code to route the database request to a device having a cache if the database request is informational or if the transaction isolation level is not greater than the isolation threshold; and

code to route the database request to the database, without routing the database request through the device having the cache, if the database request is transactional, or if the transaction isolation level is greater than the isolation threshold.

4. Computer executable software code, comprising:

code to receive a database request, the database request including a concurrency setting;

code to determine whether the database request is informational or transactional;

code to determine whether the concurrency setting of the database request is less than a concurrency threshold;

code to route the database request to a device having a cache if the database request is informational or if the concurrency setting is not less than the concurrency threshold; and

code to route the database request to the database, without routing the database request through the device having the cache, if the database request is transactional, or if the concurrency setting is less than the concurrency threshold.