Exposing multidimensional calculations through a relational database server
US8209280B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 26, 2004 |
| Grant date | Jun 26, 2012 |
| Priority date | — |
| Expiry date | Jun 5, 2026 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/283
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Accessing results of calculations on multidimensional data using relational database statements, such as SQL commands, involves a relational database server communicating with a multidimensional database server to cause the multidimensional database server to extract, and to perform calculations on, the multidimensional data. In response to a relational database statement in a language supported by the relational server, which includes an expression of an operation on the multidimensional data in a language supported by the multidimensional server, the multidimensional server extracts the required multidimensional data, performs the requested operation (e.g., an OLAP DML operation) on the data according to the specified expression, and provides results of the multidimensional operation to the relational database server. In one embodiment, the relational server passes information to the multidimensional server that uniquely identifies the location of the particular multidimensional data in the n-dimensional objects.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.