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

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.

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.

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.