Patent ID: 7058621

Claim:
A computer implemented method to facilitate data fusion for building a final multi-dimensional cube data structure by extracting information from a database, which comprises a number of data tables containing values of a number of variables, each data table consisting of at least one data record including at least two of said values, said information being extracted by evaluation of at least one mathematical function operating on one or more selected calculation variables, said extracted information being partitioned on one or more selected classification variables, characterized by the steps of: initially assigning a different binary code to each unique value of each data variable in said database and storing the data records in binary-coded form in created internal table structures; identifying all data tables containing at least one value of one of said selected calculation or classification variables, such data tables being boundary tables; identifying all data tables that, directly or indirectly, have variables in common with said boundary tables and connect the same, such data tables being connecting tables; electing a starting table among said boundary and connecting tables; building a conversion structure that links values of each selected variable in said boundary tables to corresponding values of one or more connecting variables in said starting table; evaluating said mathematical function for each data record of said starting table, by using said conversion structure to convert each value of each connecting variable into at least one value of at least one corresponding selected variable; and generating said final data structure based on said evaluation, said final data structure containing an extracted result of said mathematical function for every unique value of each classification variable.