System and method for performing intelligent analysis of a computer database

• US 5,832,496 A
• Filed: 10/31/1996
• Issued: 11/03/1998
• Est. Priority Date: 10/12/1995
• Status: Expired due to Term

• Current Assignee: NCR Corporation (NCR Voyix Corporation)
• Original Assignee: NCR Corporation (NCR Voyix Corporation)
• Inventors: Wikle, Glenn K., Ludwig, Jeffrey P., Anand, Tejwansh S., Lettington, Drew T., Schubert, Richard N., Lindsay, Marshall P.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Jung, David Yiuk
• Application Number:
  US08/742,006
• Time in Patent Office: 733 Days
• Field of Search: 707/1-206, 395/50-52, 345/326-358
• US Class Current: 1/1
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/986 Document structures and storage, e.g. HTML extensions
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A system and method for performing intelligent analysis and for generating a report for a user which allows the user to make decisions, without requiring the user to understand or interpret data itself. A database computer includes a database containing the data. The data includes a collection of information about an enterprise of the user. A server computer is coupled to the database computer and executes a database management program. A client computer is coupled to the server and executes an application program. The application program allows a user to define predetermined data types, to define relationships between the data types, to define parameters for the report, to define a method of analysis for the report, and to create the report. The report summarizes the data in terms of the data types, the data relationships, and the method of analysis.

Claims

1. A system for analyzing a database, comprising:

a) a database comprising data indicative of an organization;

b) a server computer coupled to the database, the server computer including;

i) means for defining a type of analysis to be performed on the data on a predetermined schedule including a trigger condition corresponding to a specified result of the analysis of the data in the database;

ii) means for querying the database data according to the predetermined schedule defined by the defining means and analyzing the data according to the type of analysis defined; and

iii) means for generating a report responsive to the querying means; and

c) a client computer coupled to the server, the client computer including;

i) means for receiving the report generated by the generating means; and

ii) means for displaying the report to a user of the client computer.

2. The system of claim 1, wherein the querying means comprises a SQL server.

3. The system of claim 1, wherein the querying means comprises a SQL server.

4. The system of claim 1, wherein defining means includes means for defining a business indicator representing methods and formulae of analysis of data in the database and causal associations with other business indicators.

5. The system of claim 1, wherein the predetermined schedule defined by the defining means is a predetermined regular schedule.

6. The system of claim 1, wherein the predetermined schedule defined by the defining means is a predetermined period of time defined by a user of the system.

7. The system of claim 1, wherein the report generated by the generating means is based on a dimension of data different than a dimension of data for which the analysis is performed.

8. The system of claim 1, wherein the generating means is responsive to the querying means such that a report is generated when the trigger condition is satisfied.

9. A system for analyzing a database, comprising:

a) a database comprising data indicative of an organization;

b) a server computer coupled to the database, the server computer including;

i) first means for receiving a request to analyze the data in the database;

ii) means for querying the data in the database responsive to the receipt of the request by the receiving means and for analyzing the data according to the request;

iii) means for generating a report responsive to the querying means, and corresponding to the request, wherein the report includes;

a) a summary of the data queried by the querying means, and

b) at least one hyperlink to a request to perform another type of analysis of the data; and

c) a client computer coupled to the server computer, the client computer comprising;

i) means for transmitting a request to analyze to the first receiving means;

ii) second means for receiving the report generated by the generating means; and

iii) means for displaying the report to a user of the system.

10. The system of claim 9, wherein the generating means generates a plurality of hyperlinks, wherein each of the plurality of hyperlinks points to request for performing another type of analysis of the data.

11. The system of claim 9, wherein the generating means includes means for generating at least one hyperlink that points to a request to perform a type of analysis of the data based on results of the analysis performed by the querying means.

12. In a computer system comprising a client computer, a server computer coupled to the client computer, and a database containing data coupled to the server computer, a system for analyzing the database, comprising the steps of:

a) defining a type of analysis to be performed on the data on a predetermined schedule including a trigger condition corresponding to a specified result in the analysis of the data in the database;

b) querying the database at the server computer according to the predetermined schedule and analyzing the data according to the type of analysis defined;

c) generating a report at the server computer responsive to the querying means;

d) transmitting the report to the client computer; and

e) displaying the report to a user of the client computer.

13. The method of claim 12, wherein the defining step wherein defining means includes defining a business indicator representing methods and formulae of analysis of data in the database and casual associations with other business indicators.

14. The method of claim 12, wherein the predetermined schedule is a predetermined regular schedule.

15. The method of claim 12, wherein the predetermined schedule is a predetermined period of time defined by a user of the computer system.

16. The method of claim 12, wherein the generating step includes the step of generating a report based on a dimension of data different than a dimension of data for which the analysis is performed.

17. The method of claim 12, wherein the report is generated when the trigger condition of the defining step is satisfied.