Method of indexing data in a multidimensional database such as an OLAP product

摘要

A method of indexing data in a multidimensional database that comprises:- (a) Creating a multidimensional logical access model; (b) Creating a multidimensional data storage model in which data located in cells is stored and retrieved in blocks; (c) Gathering data access information derived from one or more user queries of the database; and (d) Reorganizing one or more selected cells in the multidimensional data storage model based on the data access information to reduce the cost of access to the one or more selected cells in response to a user query of the database.