Scalable mechanism for resolving cell-level access from sets of dimensional access rules
US8538990B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 4, 2011 |
| Grant date | Sep 17, 2013 |
| Priority date | — |
| Expiry date | Dec 15, 2031 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F2221/2141
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods and apparatus, including computer program products, implementing and using techniques for resolving cell-level access in a multi-dimensional data structure based on one or more sets of dimensional access rules. A business hierarchy is provided with nodes arranged in a tree structure. An online analytical processing database has several data cubes, where at least some have the business hierarchy as one of their dimensions. One or more rule-based access tables are provided for controlling access to cells of each data cube. Groups of nodes with identical access settings are identified in the business hierarchy. A single access block is generated per node group. Each access block is a serializable access specification object that contains information for generating a complete cell-level mask of access settings for a single node of the business hierarchy. The mask is generated based on the information in the access blocks for each node in the hierarchy.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.