System and methods for modeling a report query database

Details System and methods for modeling a report query database System and methods for modeling a report query database

2005-09-23

2009-06-09

Alam, Hosain (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C709S210000, C709S213000

Reexamination Certificate

active

07546312

ABSTRACT:
A Decision Support System (DSS) coalescer offloads and transforms data from an online statistical gathering database to a report query database adapted for report generation. The coalescer generates and populates a query database structured for query data retrieval, in contrast to realtime access transaction storage as in the online database. Configurations transform the online database into a star join schema (table structure) that centralizes database “facts” in a central table and forms associations to database “dimensions” upon which a query is likely to be based. The facts refer to items which tend to change regularly over time, such as sales volumes and unit shipped. Conversely, the dimensions include more static values such as time (e.g. days, weeks, and quarters) and geographic regions, such as states and countries. The resulting query model (schema) includes relatively small dimensions tables associated with (i.e. having a schema association to) a relatively larger fact table.

REFERENCES:
patent: 5428776 (1995-06-01), Rothfield
patent: 5511190 (1996-04-01), Sharma et al.
patent: 5701453 (1997-12-01), Maloney et al.
patent: 5848408 (1998-12-01), Jakobsson et al.
patent: 5918232 (1999-06-01), Pouschine et al.
patent: 6442566 (2002-08-01), Atman et al.
patent: 7289997 (2007-10-01), Kita et al.
patent: 2004/0122844 (2004-06-01), Malloy et al.
patent: 2005/0119996 (2005-06-01), Ohata et al.
patent: 2006/0026180 (2006-02-01), Kres
patent: 2006/0031187 (2006-02-01), Pyrce et al.
patent: 2006/0085166 (2006-04-01), Ochi et al.

Affiliated with

Also associated with

Rating

System and methods for modeling a report query database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and methods for modeling a report query database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and methods for modeling a report query database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4102499