US5692181A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for generating reports from a computer database
Assignee: AT7T GLOBAL INFORMATION SOLUTIONS
•
Filing: 1995-10-12
•
Granted: 1997-11-25
•
Expires: 2015-10-12
Abstract
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.
Inventors
- 👤 Tejwansh S. Anand
- 👤 Michael A. Georgantos
- 👤 Yih-Shiuan Hu
- 👤 James F. Knutson
- 👤 Drew T. Lettington
- 👤 Marshall P. Lindsay
- 👤 Alan J. Meyer
- 👤 Kenneth W. O'Flaherty
- 👤 Richard N. Schubert
- 👤 Peter G. Selfridge
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-27 07:25
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/252; G06F16/28; G06F16/283; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 2
Claim 1
Independent Claim
260 words
A method of creating data types and relationships between the data types and data within a database for generating a report for a user regarding an enterprise of the user, comprising 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 allows a user to define the 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; recording a business concept by the application program, the business concept being chosen by the user by operating an input device coupled to the computer; recording an attribute associated with the business concept by the application program, the attribute being chosen by the user by operating the input device; 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, the mapping being chosen by the user by operating the input device, and creating an attribute table based upon the mapping; displaying a list of business indicators by the computer; recording a mapping of one of the business indicators to the column, the mapping being chosen by the user by operating the input device, and creating a business indicator table based upon the mapping; and joining the attribute table with the business indicator table to produce an additional table; wherein the application program uses the additional table to create the report.
Claim 2
Independent Claim
260 words
A method of creating data types and relationships between the data types and data within a database for generating a report for a user regarding an enterprise of the user, comprising 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 allows a user to define the 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; recording a business concept by the application program, the business concept being chosen by the user by operating an input device coupled to the computer; recording an attribute associated with the business concept by the application program, the attribute being chosen by the user by operating the input device; 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, the mapping being chosen by the user by operating the input device, and creating an attribute table based upon the mapping; displaying a list of business indicators by the computer; recording a mapping of one of the business indicators to the column, the mapping being chosen by the user by operating the input device, and creating a business indicator table based upon the mapping; and joining the attribute table with the business indicator table to produce an additional table; wherein the application program uses the additional table to create the report.
References Cited (Backward Citations)
US5189608A
Cited
US5287493A
Cited
US5261093A
Cited
US5557791A
Cited
US5630122A
Cited
US5455945A
Cited
US5519859A
Cited
US5603025A
Cited
US5555365A
Cited
US5600829A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2000-11-24 | 2001-05-26 | 2001-11-25 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2004-11-24 | 2005-05-26 | 2005-11-25 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2008-11-24 | 2009-05-26 | 2009-11-25 | $7700.00 | Window Closed / Lapsed |