System and method for generating reports from a computer database
US5721903A · kind A · utility
Assignee
Inventors
Key dates
| Filing date | Oct 12, 1995 |
| Grant date | Feb 24, 1998 |
| Priority date | — |
| Expiry date | Oct 12, 2015 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99943
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.