Patent ID: 8868484
Filing Date: 2014-10-21
Classification: G06F

Abstract:
1. A method of updating rows in a data warehouse, said method comprising: receiving a first plurality of data elements; allocating respective unique identifier of a sequence of identifiers to each of said plurality of rows such that each row is uniquely identified by the respective allocated identifier; inserting in a target table a plurality of rows, said target table being located in said data warehouse, each of said plurality of rows including a respective data element of said first plurality of data elements and the corresponding unique allocated identifier, said plurality of rows being located in said target table according to an order defined based on said sequence of identifiers, wherein a first data element of said first plurality of data elements is stored in a first row of said plurality of rows, said first row being allocated a first identifier of said sequence of identifiers; receiving a second plurality of data elements as updates to respective rows, each of said second plurality of data elements being associated with corresponding unique identifier of said sequence of identifiers, wherein said second plurality of data elements includes a second data element associated with said first identifier, wherein said second plurality of data elements are received after said inserting of said first plurality of data elements; sorting said second plurality of data elements according to said order of the associated unique identifiers such that each of said second plurality of data elements has a corresponding position in a sorted sequence; and updating said plurality of rows of said target table with said second plurality of data elements sorted in said order, wherein updating of each row identified by an identifier comprises storing in the row, the corresponding one of the second plurality of data elements having the same identifier such that said first data element in said first row is modified to equal said second data element upon said updating, wherein said updating processes data elements in earlier positions of said sorted sequence before processing data elements in later positions of said sorted sequence such that rows having associated unique identifiers in earlier positions in said sequence of identifiers are updated before rows having associated unique identifiers in later positions in said sequence of identifiers.