Patent ID: 9110961
Filing Date: 2015-08-18
Classification: G06F

Abstract:
1. A method for updating table data in an information warehouse via a single query language command, the method comprising the steps of: 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, performing a full outer join between the at least one warehouse table and the at least one source table, without requiring an executing of each of a series of bath flow commands, based on the command matching conditions defined by the single query language command statement by: 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: 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: wherein the single query language command statement mapping instructions define matching conditions, delete instructions, archive instructions, and update instructions.