Extended handling of ambiguous joins
US8032520B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Oct 4, 2007 |
| Grant date | Oct 4, 2011 |
| Priority date | — |
| Expiry date | Oct 19, 2028 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24544
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system, method and article for handling ambiguous joins among a plurality of tables based on a query are disclosed. Metadata associated with the plurality tables is generated. The metadata comprises ambiguous join dimensions and special measures, where the ambiguous join dimensions provide a list of all dimensions used in conditions of the query that are ambiguous, and the special measures provide a list of measures that are affected by the ambiguous join dimensions. Data is aggregated in the plurality of tables according to an aggregation level expressed in the query and based on the metadata.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.