BI cloud services data modeling denormalized table introspection algorithm
US10437793B2 · kind B2 · utility
0Cited by
3References
27Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jul 24, 2015 |
| Grant date | Oct 8, 2019 |
| Priority date | — |
| Expiry date | Jul 3, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/258
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A computer implemented algorithm performs introspection of an uploaded denormalized table and identifies candidate fact and dimension tables. The cardinality values of columns in a candidate dimension table are analyzed to identify simple/complex primary key candidates. Unused columns are further analyzed for assignment to candidate fact and/or dimension tables.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.