Patent ID: 8161070

Claim:
A non-transitory computer-readable storage medium containing instructions to configure a processor to perform a method, the method comprising: receiving at a delta handler of a server system absolute data from a client system, the absolute data including measure data and dimension data and containing no indication of any differences between the absolute data and corresponding data currently stored in one or more fact tables of a repository of the server system; creating at least one dimension identifier configured to associate at least a portion of the absolute data with one or more dimensions of at least one dimension table of the repository of the server system; inserting the at least one created dimension identifier into one or more of the at least one dimension table of the repository; writing the absolute data into a temporary fact table, including replacing the dimension data of the absolute data with the at least one created dimension identifier and one or more other dimension identifiers of the at least one dimension table of the repository; joining the temporary fact table to at least one of the one or more fact tables of the repository containing the corresponding data to determine one or more deltas, the one or more deltas indicating one or more differences between the absolute data received at the delta handler and the corresponding data currently stored in the repository; and posting, by the delta handler, the one or more deltas to at least one of one or more fact tables of the repository containing the corresponding data.