Patent ID: 8463818

Claim:
A method for updating table data in an information warehouse via a single query language command, the method comprising: in response to a single query language command statement of a relational database computer language comprising table mapping instructions for updating at least one information warehouse table of an information warehouse database system with data from at least one source table, wherein the single query language command statement mapping instructions define matching conditions, delete instructions, archive instructions, and update instructions, a processing unit of a database management system: performing a full outer join between the at least one warehouse table and the at least one source table based on the command matching conditions defined by the single query language command statement by: for a data row in the at least one source table that does not have a corresponding matching row in the at least one warehouse table, inserting a row in the at least one warehouse table; for any first data row in the at least one warehouse table that does not have a corresponding matching row in the at least one source table: deleting the first data row if a value of a treat history parameter in the warehouse table system is set to delete; updating the first data row with update values if the warehouse table system treat history parameter is set to update; and updating the first data row with archive values and inserting a new table row into the at least one warehouse table that comprises existing values from the first data row if the warehouse table system treat history parameter is set to archive; and for any second data row in the at least one warehouse table that has a corresponding matching row in the at least one source table: updating the second data row with data from the corresponding matching row in the at least one source table; and inserting a new table row into the at least one warehouse table comprising existing values from the second data row if the warehouse table system treat history parameter is set to archive.