System and method for generating reports from a computer database

• US 5,710,900 A
• Filed: 10/12/1995
• Issued: 01/20/1998
• Est. Priority Date: 10/12/1995
• Status: Expired due to Term

• Current Assignee: NCR Corporation
• Original Assignee: NCR Corporation
• Inventors: O'Flaherty, Kenneth W., Georgantos, Michael A., Lettington, Drew T., Selfridge, Peter G., Schubert, Richard N., Lindsay, Marshall P., Hu, Yih-Shiuan, Meyer, Alan J., Anand, Tejwansh S., Knutson, James F.
• Primary Examiner(s): Bayerl, Raymond J.
• Assistant Examiner(s): KATBAB, ABDOLLAH
• Application Number:
  US08/542,268
• Time in Patent Office: 831 Days
• Field of Search: 395/155, 395/156, 395/157, 395/158, 395/159, 395/160, 395/161, 395/968, 395/339, 395/356, 395/603
• US Class Current: 715/764
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A system and method for generating a report for a user which allows the user to make decisions, without requiring the user to understand or interpret data itself. An application within the system includes a graphical user interface (GUI) which allows the user to select and specify the parameters for the report, display the report, print the report, and save the report. A folder management subsystem allows the user to create a folder object for storing the report within the database, store the report within the folder object, and retrieve the report from the folder object using the GUI. A business information setup subsystem allows the user to create data types and create and constrain relationships between the data types. An analyst definition subsystem allows the user to select an analyst representing a method of analysis to use in generating the report using the GUI. Finally, a viewer module displays the report.

Claims

1. An application for generating a report for a user regarding an enterprise of the user comprising:

a graphical user interface (GUI) which allows the user to select and specify parameters for the report, display the report, print the report, and save the report;

a folder management subsystem which allows the user to create a folder object for storing the report within a database, store the report within the folder object, and retrieve the report from the folder object using the GUI;

a business information setup subsystem which allows the user to create data types and create and constrain relationships between the data types;

an analyst definition subsystem which allows the user to select an analyst representing a method of analysis to use in generating the report using the GUI, wherein the analyst definition subsystem includes a report generator which selects and retrieves queries for the analyst from the database and executes the queries to retrieve data within the data types from the database to generate the report; and

a viewer module for displaying the report.

2. The application program as recited in claim 1, wherein the GUI comprises:

a first window having a first screen area for displaying a list of the folder objects including a folder object containing the report, a second screen area for displaying a list of analysts for creating reports including the analyst for creating the report, and a third screen area for displaying a list of reports including the report;

wherein each folder in the list of folders contains a different list of analysts and a different list of reports which appear when the folder is selected by an input device coupled to the computer and operated by the user;

a second window which appears when the analyst is selected by the input device to allow the user to view and modify the analyst; and

a third window which appears when the report is selected by the input device to allow the user to view the report.

3. The application program as recited in claim 2, wherein the GUI further comprises:

a fourth window which appears when HyperText Markup Language (HTML) in the report is selected by the input device.

4. The application program as recited in claim 3, wherein the GUI further comprises:

a fifth window which appears when a command to create the relationships and data types is selected by the input device.

5. The application program as recited in claim 1, wherein the GUI further comprises;

a sixth window which appears when a command to create the analyst is selected by the input device.

6. The application program as recited in claim 1, wherein the GUI further comprises:

a seventh window which appears when a command to schedule creation of the report is selected by the input device.

7. An application for generating a report for a user regarding an enterprise of the user comprising:

a graphical user interface (GUI) which allows the user to select and specify parameters for the report, display the report, print the report, and save the report;

a business information setup subsystem which allows the user to create data types and create and constrain relationships between the data types;

an analyst definition subsystem which allows the user to select an analyst representing a method of analysis to use in generating the report using the GUI, wherein the analyst definition subsystem includes a report generator which selects and retrieves queries for the analyst from the database and executes the queries to retrieve data within the data types from the database to generate the report; and

a viewer module for displaying the report.

8. A method of generating a report for a user regarding an enterprise of the user comprising:

storing data types and relationships between the data types in a database;

storing a plurality of queries in the database;

recording a definition of an analyst representing a method of analysis to be used in generating the report by a graphic user interface (GUI);

recording a selection of the analyst by a user;

choosing, retrieving, and executing queries for retrieving data within the data types for the analyst out of the plurality of queries from the database by a report generator; and

displaying the report which results from execution of the queries.