×

Method for conditionally updating or inserting a row into a table

  • US 7,016,903 B1
  • Filed: 01/25/2001
  • Issued: 03/21/2006
  • Est. Priority Date: 01/25/2001
  • Status: Expired due to Term
First Claim
Patent Images

1. A computer-implemented method for applying a row from a source table to a destination table, the method comprising:

  • selecting a first column from a source table;

    selecting a second column from a destination table;

    performing an outer join operation on the source table and the destination table using the first and second columns, the outer join designating the source table as being preserved;

    updating each row in the destination table with a row from the results of the outer join operation containing a matching element in the first and second columns; and

    inserting into the destination table each row from the results of the outer join operation with a non-matching element in the first and second columns,the method performing no more than one scan per table.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×