Patent ID: 7028046
Filing Date: 2006-04-11
Classification: G06F,Y10S

Abstract:
1. A method for providing access to data in a hierarchy, the hierarchy having one or more levels, the method comprising: for each level of the hierarchy, receiving a selection from an administrator as to whether the level is to be stored in a multi-dimension portion, a relational portion, or a blocked portion; transferring data for each level of the hierarchy selected to be stored in a multi-dimensional portion from a relational database to a multi-dimensional database; enabling access for users other than said administrator to the relational database for data at levels selected to be stored in a relational portion, while preventing access to data at levels selected to be stored in a blocked portion; and responding to multi-dimensional data requests by first accessing the multidimensional database and, if necessary, accessing the relational database by constructing queries to the relational database.