Query semantics for multi-fact data model analysis using shared dimensions
US12373467B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jan 26, 2024 |
| Grant date | Jul 29, 2025 |
| Priority date | — |
| Expiry date | Jan 26, 2044 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/9027
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A computing device receives user input specifying a first dimension data field and a second dimension data field. The device constructs a dimension subquery according to characteristics of the first dimension data field, the second dimension data field, a first object to which the first dimension data field belongs, and/or a second object to which the second dimension data field belongs, including determining a join type for combining (i) first data rows that include data values of the first dimension data field and (ii) second data rows that include data values of the second dimension data field. The device constructs the dimension subquery according to the determined join type, and executes the dimension subquery to retrieve first tuples. The device constructs measure subqueries and executes the measure subqueries to retrieve second tuples. The device forms extended tuples, and generates and displays the data visualization according to the extended tuples.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.