System and method for generating reports from a computer database

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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: GEORGANTOS, MICHAEL A, HU, YIH-SHIUAN, KNUTSON, JAMES F, LINDSAY, MARSHALL P, MEYER, ALAN J, ANAND, TEJWANSH S, SCHUBERT, RICHARD N, O'FLAHERTY, KENNETH W, LETTINGTON, DREW T, SELFRIDGE, PETER G
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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.