Method and apparatus for organizing, visualizing and using measured or modeled system statistics

• US 20060041539A1
• Filed: 06/14/2005
• Published: 02/23/2006
• Est. Priority Date: 06/14/2004
• Status: Active Grant

• Current Assignee: HyPerformix, Inc. (Broadcom, Inc.)
• Original Assignee: HyPerformix, Inc. (Broadcom, Inc.)
• Inventors: Matchett, Douglas K., Wise, Timothy E., Lehr, Ted, Palmer, Annette S.
• Granted Patent: US 7,596,546 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06Q 10/0639 Performance analysis of employees; Performance analysis of enterprise or organisation operations
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

An apparatus and methodology to acquire and organize measured or modeled statistical data into optimal reports with a performance engineering mode of use and a design mode of use. In a performance engineering mode of use, the engineer may select from a set of performance questions, and guided by the apparatus and largely automated, create well-defined answers to the performance questions of interest. A series of template manipulations whereby report objects that are embedded within templates may be defined, reused, modified and improved upon to optimize reports and to aid in a report building process in a design mode of use. Methods are taught for the automatic selection and population of data tables. Column selection and column header information is optimized for relevance to the report design or system question at hand. The automatic joining of data from a variety of data sources is taught that allows for the rapid construction of specific reports from within multiple data tables of different types, structures and formats.

Claims

1. A computer system to optimize data into reports comprising:

a memory;

a processor connected to the memory and programmed to instantiate;

a virtual database object for collecting data;

a report definition object, in communication with the virtual database object to submit a query to the virtual database and receive modified data;

a query generation object in communication with the report definition object to define the query; and

a report view object in communication with the report definition object to display a result related to the query.

2. The computer system of claim 1 wherein:

the query generation object further comprises;

a report wizard object user interface allowing control over generation of the query.

3. The computer system of claim 1 wherein the query generation object comprises:

a tree view object user interface generating the query according to a predetermined statement.

4. The computer system of claim 3 wherein the predetermined statement is related to network performance optimization.