| US 7,493,344 B2 | ||
| Method and system for dynamic data merge in databases | ||
| Joe Wald, Houston, Tex. (US); and Muralidhar Prabhakaran, Houston, Tex. (US) | ||
| Assigned to Schlumberger Technology Corporation, Houston, Tex. (US) | ||
| Filed on Apr. 03, 2006, as Appl. No. 11/397,947. | ||
| Claims priority of provisional application 60/667351, filed on Apr. 01, 2005. | ||
| Prior Publication US 2006/0224638 A1, Oct. 05, 2006 | ||
| Int. Cl. G06F 17/30 (2006.01) | ||
| U.S. Cl. 707—104.1 [707/1; 707/3; 707/6; 707/10] | 8 Claims |
| 1. A method to merge incoming data with data in a data store having a plurality of tables, comprising:
loading an incoming entity into a staging area in a server, wherein the staging area comprises a replica of the plurality
of tables;
identifying a first match attribute of the incoming entity from a match table, wherein the first match attribute is associated
with a first rank;
identifying a second match attribute of the incoming entity from the match table, wherein the second match attribute is a
match entity and is associated with a second rank;
identifying a third match attribute of the match entity from the match table; and
generating a plurality of match rules based on the first match attribute and the third match attribute, wherein an order of
the plurality of match rules is based on the first rank and the second rank;
executing the plurality of match rules according to the order to identify an entity in the datastore matching the incoming
entity; and
updating the entity in the datastore based on the incoming entity.
|