Tools for defining and using custom analysis modules

• US 8,032,566 B2
• Filed: 12/04/2006
• Issued: 10/04/2011
• Est. Priority Date: 12/04/2006
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Mannion, Leslie, Figge, Jason, Teeter, Claud, Carmer, David, Baril, Robert, Fu, Henry, Shelton, Scott, Chaves, Michael
• Primary Examiner(s): Robinson; Greta
• Application Number:
  US11/566,409
• Publication Number:
  US 20080134029A1
• Time in Patent Office: 1,765 Days
• Field of Search: 707/3, 707/100, 707/102, 707/104.1, 707802-805, 707/807, 707/999.003, 707/999.1, 707/999.102, 707/4, 345/520, 345/522, 345/530, 705/1, 705/10, 705/700, 705/730, 705/734, 705/739, 705/744, 705/746, 705/762, 705/780, 705/962, 705/968, 705/1.1, 715/730, 715/734, 715/735, 715/739, 715/744, 715/746, 715/762, 715/780, 715/962, 715/968, 715/243, 715/273, 715/700, 715/225, 715/226
• US Class Current: 707/807
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence

Abstract

Tools for defining and using custom analysis modules are presented. A generic graphical user interface (GUI) custom analysis tool is presented to a user. The generic GUI custom analysis tool is adapted to receive selections and inputs from the user that define many-to-many relationships in a data store and that include user-defined measures. The inputs are used to generate an instance of a custom analysis module that is capable of being processed against the data store. The instance of the custom analysis module may be stored, recalled, executed, and/or modified from the generic GUI custom analysis tool.

Claims

1. A method implemented in a computer-readable medium as instructions that are processed by a processing device to perform the method, comprising:

presenting a generic graphical user interface (GUI) analysis tool;

providing within the generic GUI analysis tool fields to receive one or more schema and segment relationships, an analysis type, a profile name, and one or more user-defined measures, the user-defined measures are sets of calculations performed against data produced from a customized analysis tool;

receiving selections or inputs for each of the fields, a selected analysis type causes dynamic changes in other ones of the fields provided in the GUI analysis tool to reflect what is used with that selected analysis type, and communicating the selections and inputs to a driver service that builds an instance of the customized analysis module that can be processed against a data store when a particular one of inputs that identifies the profile name is referenced, and wherein some fields are identified as mandatory and other fields are identified as optional, policy defines the fields identified as mandatory and the other fields identified as optional; and

processing the customized analysis module against the data store; and

simultaneously presenting results returned from the processing in an interactive graphic illustration with the generic GUI analysis tool, the interactive graphic illustration is a grid that a user interacts with in real-time to acquire additional details for the results.

2. The method of claim 1 further comprising, positioning the interactive graphic illustration relative to the generic GUI analysis tool within a display in one of the following locations of a screen shot of the display, a location that is situated vertically under or above the generic analysis tool within the screen shot, a location that is situated horizontally on a right side or a left side of the generic analysis tool within the screen shot, and a location defined by a user relative to a position of the generic analysis tool within the screen shot.

3. The method of claim 1 further comprising, permitting portions of the interactive graphic illustration to be selectable in order to present increased information associated with a selected portion of the interactive graphic illustration or to presented decreased information associated with the selected portion of the interactive graphic illustration, wherein the increase and decrease of information is relative to original information presented with the interactive graphic illustration.

4. The method of claim 1 further comprising, augmenting the interactive graphic illustration with metadata defining properties associated with and information on the interactive graphic illustration.

5. The method of claim 1, wherein providing within the GUI analysis tool fields to further include providing one or more additional fields representing a text description for the profile name, one or more temporal restrictions, schema name, schema element, date range, and a filter name.

6. The method of claim 1 further comprising, saving an association between the particular one of the inputs for the profile name and the customized analysis module for subsequent use, retrieval, and reference within the generic GUI analysis tool.