Back to results
US 7,127,456 B1Granted
System and method for logging database queries
AssigneeNCR Corporation
InventorsDouglas P. Brown, Delynn Anne Kelly, Diana Lynn Thomas
Life of this patent
Estimating the term…
Abstract
A method for logging database queries includes receiving a request to log a plurality of database queries. Each database query is associated with an execution time. The method also includes summarizing at least some of the database queries in a log based at least partially on the execution time associated with each of the database queries.
Claims22
A computer-implemented method for logging database queries, comprising:
- receiving a request to log a plurality of database queries, each database query associated with an execution time period;
- initializing a plurality of counters, each counter associated with a range of execution time periods;
- for each database query, incrementing the counter having an associated time range that includes the execution time of the database query;
- and
- for each counter, logging information aggregated from all of the database queries that caused the counter to be incremented, whereby none of the database queries are fully logged.
2 more elements
A computer-implemented method for logging database queries, comprising:
- receiving a request to log a plurality of database queries, each database query associated with an execution time period;
- for each database query, comparing the execution time of the database query to a threshold time specified in the request;
- and
- summarizing the database query when the execution time is less than the threshold time.
1 more element
A system for logging database queries, comprising:
- a memory operable to store a table;
- and
- one or more processors collectively operable to:
- receive a request to log a plurality of database queries, each database query associated with an execution time period;
- for each database query, compare the execution time of the database query to a threshold time specified in the request;
- and
- summarize the database query in the table when the execution time is less than the threshold time.
4 more elements
A system for logging database queries, comprising:
- a memory operable to store and facilitate retrieval of information;
- one or more processors collectively operable to:
- receive a request to log a plurality of database queries, each database query associated with an execution time period;
- initialize a plurality of counters, each counter associated with range of execution time periods;
- for each database query, increment the counter having an associated time range that includes the execution time of the database query;
- and
- for each counter, log information aggregated from all of the database queries that caused the counter to be incremented, whereby none of the database queries are fully logged.
4 more elements
A computer-implemented method for logging database queries, comprising:
- receiving a request to log a plurality of database queries, each database query associated with an execution time period;
- initializing a plurality of counters, each counter associated with a range of execution time periods;
- for each database query, incrementing the counter having an associated time range that includes the execution time of the database query;
- storing the counters in one of a plurality of logs;
- summarizing at least some of the database queries in a cache;
- and
- updating at least one of the plurality of logs with at least a portion of the contents of the cache.
4 more elements
A computer-implemented method for logging database queries, comprising:
- receiving a request to log a plurality of database queries, each database query associated with an execution time period;
- for each database query, comparing the execution time of the database query to a threshold time;
- summarizing the database query in one of the plurality of logs when the execution time is less than the threshold time;
- and
- fully logging the database query in another of the plurality of logs when the execution time of the database query is greater than the threshold time, wherein fully logging a database query comprises writing an entry to a cache, the entry written in a file system format such that a processing module can receive the entry and write the entry to a log without reformatting the entry.
2 more elements
A system for logging database queries, comprising:
- a cache;
- a memory operable to store a plurality of tables;
- and
- one or more processors collectively operable to:
- receive a request to log a plurality of database queries, each database query associated with an execution time period;
- initialize a plurality of counters, each counter associated with range of execution time periods;
- update at least one of the Plurality of tables with at least a portion of contents of the cache;
- for each database query, increment the counter having an associated time range that includes the execution time of the database query;
- and
- store the counters in one of the plurality of tables.
7 more elements
A system for logging database queries, comprising:
- a memory operable to store a plurality of tables;
- and
- one or more processors collectively operable to:
- receive a request to log a plurality of database queries, each database query associated with an execution time period;
- for each database query, compare the execution time of the database query to a threshold time;
- summarize the database query in one of the plurality of tables when the execution time is less than the threshold time;
- and
- fully log the database query in another of the plurality of tables when the execution time of the database query is greater than the threshold time, wherein fully logging a database query comprises writing an entry to a cache, the entry written in a file system format such that a processing module can receive the entry and write the entry to a log without reformatting the entry.
5 more elements
Dependencies are inferred from the claim text.