Efficient SQL access to multidimensional data
US8200612B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 6, 2004 |
| Grant date | Jun 12, 2012 |
| Priority date | — |
| Expiry date | Jun 12, 2028 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/283
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
In processing a query on multidimensional data in a multidimensional schema, a multidimensional database server performs various processes to limit the amount of data that is extracted from the database and presented to a relational database server in response to the request. A subset of data is identified to extract from the multidimensional data, based on the query. In various embodiments, cell-filtering, measure-filtering, and column-filtering criteria identified from the query are used to filter the subset of data, in order to return a minimized set of multidimensional data values from the subset of data. Therefore, computational resources are conserved with respect to further processing by the relational database server in response to the query.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.