System and method for logging database queries

• US 7,127,456 B1
• Filed: 12/05/2002
• Issued: 10/24/2006
• Est. Priority Date: 12/05/2002
• Status: Expired due to Term

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation (NCR Voyix Corporation)
• Inventors: Thomas, Diana Lynn, Kelly, Delynn Anne, Brown, Douglas P.
• Primary Examiner(s): Wong, Don
• Assistant Examiner(s): DANG, THANH HA T
• Application Number:
  US10/310,341
• Time in Patent Office: 1,419 Days
• Field of Search: 707/3, 707/2, 707/5
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

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.

Claims

1. 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. The computer-implemented method of claim 1, wherein the aggregate information comprises information associated with at least some of one or more steps associated with each of the at least some database queries.

3. 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.

4. The computer-implemented method of claim 3, further comprising fully logging the database query when the execution time is greater than the threshold time.

5. The computer-implemented method of claim 3, wherein summarizing the database query comprises summarizing the database query in a cache;

and further comprising updating the log with at least a portion of contents of the cache in response to a triggering event.

6. The computer-implemented method of claim 5, wherein updating the log comprises communicating the at least a portion of contents of the cache to a selected one of a plurality of processing modules maintaining at least a portion of the log.

7. The computer-implemented method of claim 6, wherein:

the log comprises one or more data blocks; and

the selected processing module updates the log by at least one of updating an existing data block in a single operation and writing a new data block in a single operation.

8. The computer-implemented method of claim 6, wherein a parsing engine performs a step building process to generate a plurality of steps used to implement one of the queries;

and

communicating the at least a portion of the contents of the cache to the identified processing module comprises;

generating an express request comprising the at least a portion of contents of the cache, the express request generated by the parsing engine without performing the step building process; and

communicating the express request to the selected processing module.

9. The computer-implemented method of claim 5, wherein the triggering event comprises one of a timer elapsing, a specified time being reached, a specified interval of time elapsing, and a command from a user.

10. 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.

11. The system of claim 10, wherein the one or more processors are further collectively operable to fully log the database query when the execution time is greater than the threshold time.

12. The system of claim 10, further comprising a cache;

and wherein the one or more processors are further collectively operable to update the table with at least a portion of contents of the cache in response to a triggering event.

13. The system of claim 12, wherein the one or more processors are collectively operable to update the table by communicating the at least a portion of contents of the cache to a selected one of a plurality of processing modules maintaining at least a portion of the table.

14. The system of claim 13, wherein:

the table comprises one or more data blocks; and

the selected processing module updates the log by at least one of updating an existing data block in a single operation and writing a new data block in a single operation.

15. The system of claim 13, wherein:

the one or more processors are further collectively operable to perform a step building process to generate a plurality of steps used to implement one of the queries; and

the one or more processors are collectively operable to communicate the at least a portion of contents of the cache to the selected processing module by;

generating an express request comprising the at least a portion of contents of the cache, the express request generated without performing the step building process; and

communicating the express request to the selected processing module.

16. The system of claim 12, wherein the one or more processors are further collectively operable to fully log at least one of the database queries by writing an entry to the cache, the entry written in a file system format such that a processing module can receive the entry and write the entry to a second log without reformatting the entry.

17. The system of claim 10, wherein the one or more processors are collectively operable to summarize at least some of the database queries by summarizing at least some of one or more steps associated with each of the at least some database queries.

18. 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.

19. 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.

20. 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.

21. 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.

22. 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.