System and methods for modeling a report query database
US7546312B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 23, 2005 |
| Grant date | Jun 9, 2009 |
| Priority date | — |
| Expiry date | Aug 30, 2026 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99944
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.