An
improved method of and a
system for managing data elements in a multidimensional
database (MDB) supported upon a
parallel computing platform using modular-arithmetic based address
data mapping (i.e. translation) processes on integer-encoded business dimensions. The
parallel computing platform has a plurality of processors and one or more storage volumes for physically storing data elements therein at integer-encoded physical addresses in Processor Storage Space (i.e.
physical address space in the one or more storage volumes associated with a given processor). The location of each
data element in the MDB is specified in MDB Space by integer-encoded business dimensions associated with the
data element. A data loading mechanism loads the integer-encoded business dimensions and associated data elements from a
data warehouse. The address
data mapping mechanism performs a two part
address mapping processing. The first step maps the integer-encoded business dimensions associated with each
data element to a given processor identifier (which uniquely identifies the processor amongst the plurality of processors of the
parallel computing platform). The second step maps the integer-encoded business dimensions associated with each data element into an integer-encoded physical data storage address in Processor Storage Space associated with the processor identified by the processor identifier generated in the first mapping step. The mapping performed in this second step is based upon size of the integer encoded business dimensions. The
data management mechanism manages the data elements stored in the storage volumes using the integer-encoded data storage addresses generated during the two-part address
data mapping process. The use of modular-arithmetic functions in the two-part address data mapping mechanism ensures that the data elements in the MDB are uniformly distributed among the plurality of processors for balanced loading and
processing. The present invention can be used to realize (i) an improved MDB for supporting on-line analytical
processing (OLAP) operations, (ii) an improved Internet URL
Directory for supporting on-line
information searching operations by Web-enabled
client machines, as well as (iii) diverse types of MDB-based systems for supporting real-
time control of processes in response to complex states of information reflected in the MDB.