Resources Contact Us Home
Calculation engine for use in OLAP environments

Image Number 4 for United States Patent #7062479.

This invention addresses the need for dealing with complex planning calculations based on data warehouse or Planning Data Repository (PDR) data where some aggregated data or forecast data might be changed without directly manipulating the underlying data, and where there may be several relationships linking the data. The system is able to deal with complex relationships along more than one axis or dimension. A number of iterations are typically used involving both back-solving and `forward-solving`. The subset of cells that needs to be recalculated is identified before steps of back-solving and/or forward-solving using parent/child tables. The scanning of these tables looking for potential dependencies is much simpler and faster than to looking at the actual formulae or functions relating the cells. The step of creating the parent/child tables is carried out in advance of the actual calculation by parsing all the relationships (formulae and functions) and summarising the dependencies between cells in the parent/child tables.

  Recently Added Patents
Email certificates
Technique for manufacturing bit patterned media
Categorizing bit errors of solid-state, non-volatile memory
Inspection systems and methods for detecting defects on extreme ultraviolet mask blanks
Digital fine delay processing
Digital broadcasting transmission and reception system, and a signal processing method using turbo processing and turbo decoding
Biaxially oriented hydrolysis-stable polyester film comprising epoxidized fatty acid derivatives and a chain extender, and process for production thereof and use thereof
  Randomly Featured Patents
Temperature compensation of ferro-electric liquid crystal displays
Polyester film for metal plate laminate, film-laminated metal plate and metal container
Method of transmitting data in multiple antenna system
Input/output control device with memory device for storing variable-length data and method of controlling thereof
Golf club head with weighting member and method of manufacturing the same
System and method for replacing an ion source in a mass spectrometer
Compiler based cache allocation
Method and apparatus for grinding undulate cutting edges of knives in tobacco cutting machines
Biological growth plate scanner with automated intake
Liquid crystal display device and method of driving the same