Patent ID: 6282544
Filing Date: 2001-08-28
Classification: G06F,G06Q,Y10S

Abstract:
A method of generating a plurality of output data marts from a first data mart, said first data mart comprising input fact data and at least one dimension table, said method comprising:generating aggregated fact data including a plurality of records representative of said fact data summarized at one or more levels other than the level of the input fact data;distributing said aggregated fact data to said plurality of output data marts, wherein certain aggregated fact data records are distributed to more than one of said data marts, and wherein the set of fact data records distributed to at least some of the output data marts are not identical;providing at least one data structure specifying levels or level cross products required by each output data mart;establishing the aggregate fact data records which need to be generated from said input fact data; andgenerating each required aggregate fact data record, and for each generated aggregate fact data record:1) establishing from said at least one data structure which of said output data marts requires said aggregated fact data record; and2) providing each of said output data marts which requires said aggregate fact data record with said aggregated fact data record.