Abstract: A system and method for storing within, and retrieving from, a computer database values of a multidimensional array in which storage locations are allocated within each storage node of the database corresponding to a dimension of the array only for the database-pointers actually stored within the storage node. An indicium is stored with each database-pointer to identify the element of the array's dimension to which the database-pointer corresponds. In an alternative embodiment, a sub-storage area, with sub-storage locations allocated for each of the elements of the dimension to which the storage node corresponds, is associated with each storage node, and an indicium is stored within each sub-storage location indicating whether a database-pointer exists in the associated storage node corresponding to the associated element. A hierarchial table of calculation rules also is provided for determining values which are calculated from other values within the array.
Abstract: A system and method for connecting electronic spreadsheets through a local area network are provided in which the spreadsheet programs are separate from the databases upon which they operate. The databases are multidimensional with each cell or datum identified by a unique set of element identifiers. The system and method allow users to create and control their own spreadsheet models while working with one, consistent pool of information. Changes in data effected by one user are reflected in the spreadsheets of all users, thereby guaranteeing consistent results for an entire work group at all times. Access restriction parameters for each user for each element of each dimension of the database also are provided. Multiple levels of consolidation values for each dimension of the database are calculated and updated automatically.