Patent ID: 8341131

Claim:
A computer implemented method, comprising: receiving a plurality of input records from a plurality of sources, each input record including a plurality of relational database fields; detecting that a set of input records from different sources are related to each other; automatically selecting one of the set of input records as a master record in accordance with a record level rule; automatically modifying at least one relational database field in the master record based on a corresponding relational database field in another input record in accordance with a field level rule; appending a relational database field from another input record to the master record without deleting the value of the corresponding relational database field that is related to the appended relational database field in the master record; storing the modified master record; receiving an undo indication from a user; and responsive to the undo indication, restoring the master record to the unmodified state based on the appended relational database field, wherein each source is associated with a reliability score and the record level rule comprises automatically selecting the input record from the source having the best reliability score.