Calculation engine for use in OLAP environments

Details Calculation engine for use in OLAP environments Calculation engine for use in OLAP environments

2006-06-13

2006-06-13

Ali, Mohammad (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07062479

ABSTRACT:
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.

REFERENCES:
patent: 5276607 (1994-01-01), Harris et al.
patent: 5897629 (1999-04-01), Shinagawa et al.
patent: 5918232 (1999-06-01), Pouschine et al.
patent: 5978796 (1999-11-01), Malloy et al.
patent: 6385604 (2002-05-01), Bakalash et al.
patent: 6434557 (2002-08-01), Egilsson et al.
patent: 6581068 (2003-06-01), Bensoussan et al.
patent: 6622137 (2003-09-01), Ravid et al.
patent: 6651055 (2003-11-01), Kilmer et al.
patent: 2002/0099692 (2002-07-01), Shah et al.
patent: 0358492 (1990-03-01), None
patent: WO97/21176 (1997-06-01), None
patent: WO00/05658 (2000-02-01), None
http://web.archive.org/web/20011018140152/http://www.kem.ae.poznan.pl/Books/Excel-Solver/T1/T1.htm. Oct. 18, 2001.
“An Introduction to Database Systems,” by C.J. Date, 7thEdition, 2000, Chapter 21 Decision Support, pp. 694-729.
“CONTROL,” by KCI Computing, Inc. of Torrance, CA.
“e.Planning,” by Adaytum of Bloomington, MN.

Affiliated with

Also associated with

Rating

Calculation engine for use in OLAP environments does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Calculation engine for use in OLAP environments, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Calculation engine for use in OLAP environments will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3664036