US 2015/0088939 A1 · MERGING DATA FROM A SOURCE LOCATION INTO A TARGET LOCATION

Abstract

In an example, data from a source location is merged into a target location containing existing data, in which both the source location and the target location contain tuples of data. For each tuple in the source location, during a single operation, a determination is made as to whether there is a matched tuple in the target location that satisfies a predetermined condition. For each matched tuple that satisfies the predetermined condition, the matched tuple in the target location is updated with a count value that is equal to a count of the matched tuple in the source location and the target location. In addition, for each tuple that does not have a matched tuple that satisfies the predetermined condition, the unmatched tuple is inserted into the target location.

Claims15

Dependent claims

A method for merging data from a source location into a target location containing existing data, wherein both the source location and the target location contain tuples of data, said method comprising:

for each tuple in the source location, during a single operation,
determining, by a processor, whether there is a matched tuple in the target location that satisfies a predetermined condition;
for each matched tuple that satisfies the predetermined condition, updating the matched tuple in the target location with a count value that is equal to a count of the matched tuple in the source location and the target location;
and
for each tuple that does not have a matched tuple that satisfies the is predetermined condition, inserting the unmatched tuple into the target location.

2 more elements

An apparatus for merging data from a source location into a target location containing existing data, wherein both the source location and the target location contain tuples of data, and wherein the target location comprises a column-based database, said apparatus comprising:

a module to,
scan both the source location and the target location to determine the tuples contained in each of the source location and the target location;
right outer join the source location and the target location to determine which tuples from the source location are to be inserted into the target location and which tuples in the target location are to be updated;
for each of the tuples in the target location that are to be updated, update the tuples in the target location with a count value that is equal to a count of the tuple in the source location and the target location;
and
for each of the tuples in the source location that are to be inserted into the target location, insert the tuples into the target location;
and
a processor to implement the module.

5 more elements

Dependencies are inferred from the claim text.

Merging data from a source location into a target location

Life of this patent

Merging data from a source location into a target location

Life of this patent

Abstract

Claims15