System and method for routing database requests to a database and a cache
First Claim
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.
14 Assignments
0 Petitions
Accused Products
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.
-
Citations
4 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.
-
Specification