Kenneth Austin O'Flaherty

US Patent:

56921810, Nov 25, 1997

Filed:

Oct 12, 1995

Appl. No.:

8/542267

Inventors:

Tejwansh S. Anand - Roswell GA
Michael A. Georgantos - San Diego CA
Yih-Shiuan Hu - Alpharetta GA
James F. Knutson - Roswell GA
Drew T. Lettington - San Diego CA
Marshall P. Lindsay - San Diego CA
Alan J. Meyer - Riverside CA
Kenneth W. O'Flaherty - Del Mar CA
Richard N. Schubert - San Diego CA
Peter G. Selfridge - Watchung NJ

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 1730

US Classification:

395613

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. A method of creating data types and data relationships within a database for generating the report for the user includes the steps of organizing the data within the database into columns of tables, providing a computer coupled to the database that executes an application program that generates the report, recording a business concept by the application program, recording an attribute associated with the business concept by the application program, displaying a list of the columns of tables in the database by the computer, recording a mapping of the attribute to one of the columns in the list, displaying a list of business indicators by the computer, recording a mapping of one of the business indicators to the column, joining the attribute table with the business indicator table so that the application program can use the additional table to create the report.

US Patent:

57219036, Feb 24, 1998

Filed:

Oct 12, 1995

Appl. No.:

8/545048

Inventors:

Tejwansh S. Anand - Roswell GA
Michael A. Georgantos - San Diego CA
Yih-Shiuan Hu - Alpharetta GA
James F. Knutson - Roswell GA
Drew T. Lettington - San Diego CA
Marshall P. Lindsay - San Diego CA
Alan J. Meyer - Riverside CA
Kenneth W. O'Flaherty - Del Mar CA
Richard N. Schubert - San Diego CA
Peter G. Selfridge - Watchung NJ

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 1730

US Classification:

395605

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. A database management program executed by a server within a system for generating the report for the user includes a first subsystem for translating user requests for data, for generating dimensional queries for retrieving data from a database, and for processing user modifications to data types used in generating the report. A second subsystem coupled to the first subsystem reads data from the database, creates the data types, creates a mapping of the data types to the data, uses the mapping to translate user-initiated dimensional queries received from the first subsystem into Structured Query Language (SQL), and returns query results to the first subsystem. A third subsystem creates the report at a predetermined time.

US Patent:

57109001, Jan 20, 1998

Filed:

Oct 12, 1995

Appl. No.:

8/542268

Inventors:

Tejwansh S. Anand - Roswell GA
Michael A. Georgantos - San Diego CA
Yih-Shiuan Hu - Alpharetta GA
James F. Knutson - Roswell GA
Drew T. Lettington - San Diego CA
Marshall P. Lindsay - San Diego CA
Alan J. Meyer - Riverside CA
Kenneth W. O'Flaherty - Del Mar CA
Richard N. Schubert - San Diego CA
Peter G. Selfridge - Watchung NJ

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 300

US Classification:

395339

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.