WIPO logo
Mobile | Deutsch | Español | Français | 日本語 | 한국어 | Português | Русский | 中文 | العربية |
PATENTSCOPE

Search International and National Patent Collections
World Intellectual Property Organization
Search
 
Browse
 
Translate
 
Options
 
News
 
Login
 
Help
 
Machine translation
1. (US20120226656) Scalable mechanism for resolving cell-level access from sets of dimensional access rules

Application Number: 13040522 Application Date: 04.03.2011
Publication Number: 20120226656 Publication Date: 06.09.2012
Grant Number: 08538990 Grant Date: 17.09.2013
Publication Kind : B2
IPC:
G06F 15/16
G06F 17/20
Applicants: Bates Kirk Arthur
International Business Machines Corporation
Borgsmidt Rasmus
Bowen David Stephen Lawrence
Inventors: Bates Kirk Arthur
Borgsmidt Rasmus
Bowen David Stephen Lawrence
Agents: Mollborn Patents, Inc.
Mollborn Fredrik
Priority Data:
Title: (EN) Scalable mechanism for resolving cell-level access from sets of dimensional access rules
Abstract: front page image
(EN)

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.