Intermediary SQL Caching Device for Database Response Latency

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Database servers face challenges in efficiently responding to increasing information requests and data sizes in data communication networks, leading to performance bottlenecks.

Innovation Solution

Implementing an intermediary device that caches SQL query responses, using policies to determine cache storage and retrieval, and employing hashing techniques to manage cache memory, allowing for offline caching and efficient data retrieval.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Speed

If database servers handle increasing information requests directly, then data access completeness is maintained, but response time increases and server performance deteriorates

Engineering Contradiction:

Improveresponse timeVSAvoidserver performance

Core Design Contradiction:

SpeedVSProductivity

Solution Approach 1:

The patent introduces an intermediary device (cache appliance) positioned between clients and database servers. This intermediary intercepts SQL queries, determines whether responses can be served from cache, and manages cache operations independently of the database server, thereby reducing server load and improving response time without compromising data access completeness

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The system performs preliminary actions by caching SQL query responses before they are needed again. The intermediary device stores responses in cache memory during initial queries, so that subsequent identical queries can be served immediately from cache without contacting the database server, significantly reducing response time

Inventive Principle:

Principle #10Preliminary action

2Speed

If an intermediary caching device is introduced, then response time improves and server load reduces, but system complexity increases

Engineering Contradiction:

Improvedata access speedVSAvoidsystem architecture complexity

Core Design Contradiction:

SpeedVSDevice complexity

Solution Approach 1:

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The intermediary device autonomously determines whether SQL queries can be served from cache using policy-based decision-making. The system self-manages cache operations including storing responses, retrieving cached data, and invalidating cache entries without requiring complex coordination with the database server, simplifying the overall system architecture

Inventive Principle:

Principle #25Self-service

3Productivity

If cache policies are implemented to control cache behavior, then data retrieval efficiency improves, but policy management complexity increases

Engineering Contradiction:

Improvedata retrieval efficiencyVSAvoidpolicy management complexity

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The patent implements policy-based cache control that dynamically changes cache behavior parameters based on query characteristics and system conditions. Policies define conditions for caching responses, cache expiration, and cache invalidation, allowing the system to adapt cache parameters automatically without manual intervention, thereby improving data retrieval efficiency while keeping policy management tractable

Inventive Principle:

Principle #35Parameter changes

Data Source

PatentUS10095739B2Systems and methods for caching of SQL responses using integrated caching

Publication Date: 2018.10.09 CITRIX SYSTEMS INC

AI summary

Systems and methods of the present disclosure provide for caching, by a device intermediary to a client and a database, a result of a structured query language (SQL) query request. In some embodiments, the device intermediary to a plurality of clients and a database receives a SQL response from the database to a first SQL query request of a client of the plurality of clients. The device may maintain a cache of SQL responses from the database. The device may identify that the first SQL query request matches a rule of a policy for caching SQL responses from the database. The policy may include a cache action to take when the rule is matched. The device may perform, responsive to the policy, on the SQL response the cache action identified by the policy.