Patent ID: 8626703

Claim:
A method implemented by a computing device, the method comprising: receiving, by the computing device and from a data warehouse, a request for incremental data associated with a particular period of time, wherein the incremental data comprises data that is created, changed or deleted in an enterprise resource planning (ERP) system over the particular period of time; creating, by the computing device, one or more temporary tables based on the request; extracting, by the computing device, incremental data from tracking tables of the ERP system; storing, by the computing device, the extracted incremental data in the one or more temporary tables; generating, by the computing device, a function call to join the one or more temporary tables with one or more regular tables, wherein the one or more regular tables include data associated with the incremental data stored in the one or more temporary tables; retrieving, by the computing device, data from the joined one or more temporary tables and the one or more regular tables; and storing, by the computing device, the retrieved data in the data warehouse, wherein, in response to the function call to join the one or more temporary tables with one or more regular tables, the method further comprises: retrieving the incremental data from the one or more temporary tables; retrieving, from the one or more regular tables, particular data associated with the incremental data; and combining the incremental data with the particular data.