Patent ID: 8392471

Claim:
A system for updating data in a multidimensional database having a plurality of dimensions, each dimension having a hierarchy, the system comprising at least one information processing apparatus coupled to at least one computer over a communication network, the at least one information processing apparatus having data update engine associated therewith, the information processing apparatus operable therewith to: receive from the at least one computing device a request to update data in the multidimensional database, the multidimensional database comprising at least one of an atomic value and an aggregate value, wherein the request is transmitted in the form of a message comprising an initiate update instruction, followed by a first set of data to be updated, and terminated with an execute update instruction; translate the first set of data to be updated into a first system of linear equations made up of linear combinations of atomic values; process the request to update the data in the multidimensional database; and update the first set of data at any level within a hierarchy of at least one dimension of the multidimensional database using at least one non-iterative linear programming algorithm, the first set of data updated in a manner that preserves a second set of data in the multidimensional database previously identified to remain unchanged.