Database query and content transmission governor
OwnerVikram Dayalinventor
Life of this patent
Estimating the term…
Abstract
A database query management system including a report governor and an intermediate result status storage in communication with at least one client and a server; the server further including a database, a query engine, and a formatting engine; wherein the report governor can pause a query request if system resource usage has exceeded a predetermined threshold; can pause formatting of query results if system resource usage has exceeded a predetermined threshold; and can pause report transmission to the client if data transmission to client is exceeding a predetermined threshold; thereby preventing client and server timeouts and eliminate lost work time due to these timeouts.
Claims13
A database query management system comprising:
- i) a report governor and
- ii) an intermediate result status storage,
- running on a computer and in communication with at least one client and a server;
- wherein the server and the at least one client are in communication;
- the server further including a database, a query engine, and a formatting engine;
- and
- wherein the report governor:
- i) can pause a query request if system resource usage has exceeded a predetermined threshold and resume the query when system resource usage falls below a predetermined threshold
- ii) can pause formatting of query results if system resource usage has exceeded a predetermined threshold and resume formatting when system resource usage falls below a predetermined threshold;
- iii) can pause report transmission to the client if data transmission to client is exceeding a predetermined threshold and resume transmission when data transmission falls below a predetermined threshold;
- thereby preventing client and server timeouts and eliminate lost work time due to these timeouts.
A method for managing database queries comprising the steps of:
- receiving a query request from a client;
- monitoring system resources to determine if sufficient resources are available to execute the query, format the information, and transmit the report;
- if sufficient resources are available, forwarding the query to query engine;
- monitoring the system resource usage;
- pausing query if system resources use is above a predetermined level;
- storing query status;
- forwarding partial results to formatting engine;
- sending partial report to client;
- and
- continuing query when system resources use falls below a predetermined level.
Dependencies are inferred from the claim text.