Using relational structures to create and support a cube within a relational database system
US8868544B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 25, 2003 |
| Grant date | Oct 21, 2014 |
| Priority date | — |
| Expiry date | Sep 18, 2026 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/283
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and mechanism for performing an operation based on multidimensional data in a relational database. A first query is submitted to a relational database engine of the relational database management system, thereby causing a relational cube to be generated. The first query includes instructions to select a portion of multidimensional data for inclusion in the relational cube. The first query includes instructions to group the selected portion of multidimensional data using at least two or more levels of granularity of at least one dimension. The first query also includes instructions to generate a materialized view. Based on a received request for an operation, a second query is submitted to the relational database engine for execution against the relational cube, thereby causing the operation to be performed.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.