BUSINESS INTELLIGENCE DATA EXTRACTION ON DEMAND

• US 20090164486A1
• Filed: 12/21/2007
• Published: 06/25/2009
• Est. Priority Date: 12/21/2007
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Foeldesi, Gabi, Haerle, Peter
• Granted Patent: US 8,407,183 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

Methods and apparatus, including computer program products, for business intelligence data extraction on demand. In general, a first request is sent from a first system to a second system for a query of a data structure to include indications of updates at the second system to data at both the first and second systems. An indication of an update at the second system is received in response to the first request, where the indication includes an identification of updated data. A second request is sent to a database data structure of the second system for data corresponding to the updated data. The updated data is received at the first system in response to the second request. Data is updated at the first system in accordance with the updated data in response to the receiving the updated data.

Claims

1. A computer-implemented method comprising:

sending a first request from a first system to a second system for a query of a first data structure to comprise indications of updates at the second system to data at both the first and second systems;

receiving an indication of an update at the second system in response to the first request, the indication comprising an identification of a second data structure updated;

sending a second request to a database data structure of the second system for data corresponding to the updated second data structure;

receiving the data corresponding to the updated second data structure at the first system in response to the second request; and

updating data corresponding to the second data structure at the first system in accordance with the data corresponding to the updated second data structure in response to the receiving the data corresponding to the updated second data structure.

2. The method of claim 1, wherein the first system is a business intelligence system comprising an OLAP (online analytical processing) data source from which reports are generated and the second system is an OLTP (online transaction processing) data source.

3. The method of claim 1, wherein the first data structure is a database data structure.

4. The method of claim 3, wherein the database data structure is a table.

5. The method of claim 3, wherein the first data structure is part of the database data structure where the updated second data structure is stored.

6. The method of claim 1, wherein the first request is triggered as part of a periodic set of requests.

7. The method of claim 1, further comprising:

storing in the first data structure an indication of the update in response to a change to the updated second data structure at the second system; and

removing the indication of the update in the first data structure in response to the first system receiving the data corresponding to the updated second data structure.

8. The method of claim 1, wherein the receiving the data comprises receiving a delta update to the object.

9. The method of claim 1, wherein the receiving the data comprises receiving the updated second data structure.

10. The method of claim 1, wherein the second data structure is a data source providing data for a full upload.

11. The method of claim 1, wherein the second data structure is a data source storing delta updates of data objects.

12. A computer program product, tangibly embodied on a computer-readable medium, the product comprising instructions to cause a data processing apparatus to perform operations comprising:

sending a first request from a first system to a second system for a query of a first data structure to comprise indications of updates at the second system to data at both the first and second systems;

receiving an indication of an update at the second system in response to the first request, the indication comprising an identification of a second data structure updated;

sending a second request to a database data structure of the second system for data corresponding to the updated second data structure;

receiving the data corresponding to the updated second data structure at the first system in response to the second request; and

updating data corresponding to the second data structure at the first system in accordance with the data corresponding to the updated second data structure in response to the receiving the data corresponding to the updated second data structure.

13. The product of claim 12, wherein the first system is a business intelligence system comprising an OLAP (online analytical processing) data source from which reports are generated and the second system is an OLTP (online transaction processing) data source.

14. The product of claim 12, wherein the first data structure is a database data structure.

15. The product of claim 12, wherein the first request is triggered as part of a periodic set of requests.

16. A computer program product, tangibly embodied on a computer-readable medium, the product comprising instructions to cause a data processing apparatus to perform operations comprising:

periodically sending a first request from a business intelligence (BI) system to an online transaction processing (OLTP) system for a query of indications of updates at the OLTP system to data at both the BI and OLTP systems;

receiving a list identifying a plurality of updates at the BI system in response to the first request;

sending a second request to the OLTP system for the updates in response to receiving the list identifying the plurality of updates and the list not being empty;

receiving the data corresponding to the updates at the BI system in response to the second request; and

updating the BI system in accordance with the data corresponding to the updates in response to the receiving the data corresponding to the updates.