A database operation that inserts a new record if it does not exist or updates an existing record if it does, combining the behaviors of 'insert' and 'update' into a single operation, often used to maintain data integrity and consistency.

"The upsert operation added a new customer record if it didn't exist or updated the existing record with new information."