METADATA AS COMMENTS FOR SEARCH PROBLEM DETERMINATION AND ANALYSIS

• US 20110029539A1
• Filed: 12/29/2009
• Published: 02/03/2011
• Est. Priority Date: 07/29/2009
• Status: Active Grant

• Current Assignee: Teradata Corporation
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Raichura, Ray
• Granted Patent: US 8,756,244 B2
• Time in Patent Office: Days
• US Class Current: 707/741
• CPC Class Codes: G06F 16/2453 Query optimisation

Abstract

Techniques for using metadata as comments to assist with search problem determination and analysis are provided. Before an action is taken on a search, contextual information is gathered as metadata about the action and actor requesting the action. The metadata is embedded in the search as comments and the comments are subsequently logged when the action is performed on the search. The comments combine with other comments previously recorded to permit subsequent analysis on searches.

Claims

1. A method implemented in a computer-readable storage medium and processed by a processor to perform the method, comprising:

detecting, via the processor, an action against a search query;

gathering, via the processor, contextual information for the search query in response to the action; and

retaining, via the processor, the contextual information as metadata that is carried as comments with the search query when the action is performed on the search query.

2. The method of claim 1, wherein detecting further includes identifying the action as a save operation initiated by a user to save the search query within a query interface tool.

3. The method of claim 1, wherein detecting further includes identifying the action as an execute query operation initiated to execute the search query against a database.

4. The method of claim 1, wherein gathering further includes identifying the contextual information as one or more of the following:

a service identifier for a service where the action was initiated, a user identifier for a user that is performing the action, an action identifier for identifying the action taken, and a date and time for when the action was taken.

5. The method of claim 1, wherein gathering further includes inspecting environment variables within a processing environment where the action is taken on the processor to gather at least some of the contextual information.

6. The method of claim 1, wherein gathering further includes identifying a session identifier having a user identifier as part of the contextual information when the action is taken.

7. The method of claim 1, wherein retaining further includes appending a comment syntax at the end of the search query and appending thereafter the metadata to ensure the search query retains the comments.

8. The method of claim 1, wherein retaining further includes appending the comments within memory having the search query to ensure that when the action is taken the comments are present with the search query.

9. The method of claim 1 further comprising, logging, via the processor, the search query and the comments in a log database for subsequent database mining and analysis.

10. A method implemented in a computer-readable storage medium and processed by a processor to perform the method, comprising:

retaining, via the processor, comments embedded in a query;

logging, via the processor, the comments before executing the query; and

executing, via the processor, the query.

11. The method of claim 10, wherein retaining further includes parsing the query for comment syntax and copying out the comments following the comment syntax from the query.

12. The method of claim 10, wherein retaining further includes augmenting the comments with additional contextual information present in a processing environment where the query is being executed.

13. The method of claim 10, wherein logging further includes indexing the comments into a database based on a user identification or action identification.

14. The method of claim 10, wherein logging further includes storing the comments into multiple database tables based on identifiers parsed from the comments, the identifiers including one or more of:

a user identifier, a source tool identifier where the query was initiated, an action identifier for an action taken on the query, a database table identifier for a database table being searched, and a query identifier that identifies the query.

15. The method of claim 10 further comprising, returning, via the processor, results to a requesting user of the query after the query is executed and providing a link with the query results that identifies for the user the comments that were logged.

16. A processor-implemented system, comprising:

a comment gathering service implemented in a computer-readable medium and to execute on a processor; and

a comment logger service implemented in a computer-readable medium and to execute on a processor;

the comment gathering service is configured to collect contextual information when an action is initiated on a search query and configured to add the contextual information as metadata represented in comments of the search query, the comment logger service is configured to strip the comments from the search query when the search query is executed against a database and log the comments for subsequent analysis.

17. The system of claim 16, wherein the comment gathering service is further configured to identify types of contextual information to collect based on a policy that is evaluated and used to configure the comment gathering service.

18. The system of claim 16, wherein comment gathering service is configured to pass the search query to a search query processor to perform a user-directed action on the search query once the metadata is acquired and integrated as the comments into the search query.

19. The system of claim 16, wherein the comment logger service is configured to store the comments in multiple database tables based on information parsed from the comments.

20. The system of claim 16, wherein the comment logger service is configured to gather additional contextual information to augment the comments, the additional contextual information logged with the comments.