Generation of cube metadata and query statement based on an enhanced star schema
US9754010B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Oct 10, 2013 |
| Grant date | Sep 5, 2017 |
| Priority date | — |
| Expiry date | Jun 23, 2034 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/283
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method for generating cube metadata based on an enhanced star schema may be provided. In some embodiments, the method may include extracting dimension references from a factless fact table in an enhanced star schema. The enhanced star schema may include a fact table, a plurality of dimension tables of the fact table and the factless fact table. In some embodiments, a hierarchy reference may be constructed based on the dimension references. In some embodiments, cube metadata may be generated by combining the hierarchy reference with measures obtained from the fact table and a hierarchy obtained from the dimension tables in the enhanced star schema.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.