Cross system analytics for in memory data warehouse

• US 9,734,230 B2
• Filed: 09/12/2013
• Issued: 08/15/2017
• Est. Priority Date: 09/12/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Sarferaz, Siar
• Primary Examiner(s): Obisesan, Augustine K
• Application Number:
  US14/025,610
• Publication Number:
  US 20150074053A1
• Time in Patent Office: 1,433 Days
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A cross system analytics system includes sets of in memory database tables stored on random access memory of the system. Each set of tables corresponds to data from a different source system to provide separation of data from each source system. A separate in memory database schema for each set of tables corresponds to each source system. A replication system is coupled to provide replication of data from the source systems into the sets of in memory database tables. An analytics engine executes cross system views of data in the sets of tables to provide a cross system central and consistent view for reporting and analyzing data for an organization having multiple systems with different database schemas.

Claims

1. An in-memory cross system analytics system comprising:

one or more processors; and

a computer-readable medium coupled with the one or more processors, the computer-readable medium comprising instructions stored thereon that are executable by the one or more processors to cause the in-memory cross system analytics system to perform operations comprising;

storing a first set of in-memory database tables on random access memory of the in-memory cross system analytics system corresponding to data from a first source system within an organization to provide separation of data in the in-memory database from a second source system within the organization;

storing a second set of in-memory data based tables on random access memory of the in-memory cross system analytics system corresponding to data from the second source system within the organization to provide separation of data in the in-memory database from the first source system within the organization;

storing a first in-memory database schema for the first set of in-memory database tables corresponding to the first source system to provide separation of data from the second source system within the organization;

storing a second in-memory database schema for the second set of in-memory database tables corresponding to the second source system to provide separation of data from the first source system within the organization;

determining whether the first source system and the second source system share a common implementation template;

replicating data from the first source system into the first set of in-memory database tables according to a basic infrastructure based on a determination that the first source system and the second source system share a common implementation template and according to an advanced infrastructure based on a determination that the first source system and the second source system comprise non-harmonized data;

replicating data from the second source system into the second set of in-memory database tables according to a basic infrastructure based on a determination that the first source system and the second source system share a common implementation template and according to an advanced infrastructure based on a determination that the first source system and the second source system comprise non-harmonized data; and

generating a cross system central and consistent database view for reporting and analyzing data for the organization comprising the first source system and the second source system with different database schemas by executing cross system database views of the data in the first set of in-memory database tables corresponding to data from the first source system in the organization and data in the second set of in-memory database tables corresponding to data from the second source system in the organization.

2. The in-memory cross system analytics system of claim 1, wherein replicating data comprises harmonizing data prior to replication into the first set of in-memory database tables and the second set of in-memory database tables.

3. The in-memory cross system analytics system of claim 2, wherein harmonizing data comprises a duplicate check to enable identification and prevention of duplicate records.

4. The in-memory cross system analytics system of claim 2, wherein harmonizing data comprises structural mapping, value mapping, and key mapping.

5. The in-memory cross system analytics system of claim 2, wherein harmonizing data comprises utilizing a distribution model and routing infrastructure to distribute data based on the distribution model.

6. The in-memory cross system analytics system of claim 2, wherein harmonizing data comprises validation to ensure data quality.

7. The in-memory cross system analytics system of claim 1, wherein the cross system views expose a logical system for each source system, the logical system including attributes defining authorizations.

8. The in-memory cross system analytics system of claim 7, wherein the cross system central and consistent view is formed by union functions to join views and logical system representations from the first source system and the second source system to create the cross view with authorizations.

9. The in-memory cross system analytics system of claim 1, wherein the first source system and the second source system are of the same type with at least some of the same tables that are enhanced differently between the first sources system and the second source system.

10. The in-memory cross system analytics system of claim 9, wherein the different source systems of the same type cannot be replicated into one in memory database schema.

11. The in-memory cross system analytics system of claim 1, wherein initialization of data replication is based on database triggers and delta logging for tracking database changes.

12. A method comprising:

storing, by a computing device, a first set of in-memory database tables in random access memory of an in-memory database system corresponding to data from a first source system within an organization to provide separation of data in the in-memory database from a second source system within the organization;

storing, by the computing device, a second set of in-memory data based tables in random access memory of the in-memory database system corresponding to data from the second source system within the organization to provide separation of data in the in-memory database from the first source system within the organization;

storing, by the computing device, a first in-memory database schema for the first set of in-memory database tables corresponding to the first source system to provide separation of data from the second source system within the organization;

storing, by the computing device, a second in-memory database schema for the second set of in-memory database tables corresponding to the second source system to provide separation of data from the first source system within the organization;

determining, by the computing device, whether the first source system and the second source system share a common implementation template;

replicating, by the computing device, data from the first source system into the first set of in-memory database tables according to a basic infrastructure based on a determination that the first source system share a common implementation template and according to an advanced infrastructure based on a determination that the first source system and the second source system comprise non-harmonized data;

replicating, by the computing device, data from the second source system into the second set of in-memory database tables according to a basic infrastructure based on a determination that the first source system and the second source system share a common implementation template and according to an advanced infrastructure based on a determination that the first source system and the second source system comprise non-harmonized data; and

generating, by the computing device, a cross system central and consistent database view for reporting and analyzing data for the organization comprising the first source system and the second source system with different database schemas by executing cross system database views of data in the first set of in-memory database tables corresponding to data from the first source system in the organization and data in the second set of in-memory database tables corresponding to data from the second source system in the organization.

13. The method of claim 12, wherein replicating data comprises using an advanced data management replication server to harmonize data prior to replication into the sets of in memory database tables.

14. The method of claim 13, wherein the advanced data management replication server performs a duplicate check to enable identification and prevention of duplicate records.

15. The method of claim 13, wherein the advanced data management replication server includes structural mapping, value mapping, and key mapping, and further includes a distribution model and routing infrastructure to distribute data based on the distribution model.

16. The method of claim 12, wherein the cross system views expose a logical system for each source system, the logical system including attributes defining authorizations.

17. The method of claim 16, wherein the cross system views are formed by union functions to join views and logical system representations from multiple source systems to create the cross system view with authorizations.

18. The method of claim 12, wherein initialization of data replication is based on database triggers and delta logging for tracking database changes.

19. A non-transitory computer readable storage device having instructions for causing a computer to execute operations comprising:

storing a first set of in-memory database tables in random access memory of an in-memory database system corresponding to data from a first source system within an organization to provide separation of data in the in-memory database from a second source system within the organization;

storing a second set of in-memory data based tables in random access memory of the in-memory database system corresponding to data from the second source system within the organization to provide separation of data in the in-memory database from the first source system within the organization;

storing a first in-memory database schema for the first set of in-memory database tables corresponding to the first source system to provide separation of data from the second source system within the organization;

storing a second in-memory database schema for the second set of in-memory database tables corresponding to the second source system to provide separation of data from the first source system within the organization;

determining whether the first source system and the second source system share a common implementation template;

replicating data from the first source system into the first set of in-memory database tables according to a basic infrastructure based on a determination that the first source system and the second source system share a common implementation template and according to an advanced infrastructure based on a determination that the first source system and the second source system comprise non-harmonized data;

replicating data from the second source system into the second set of in-memory database tables according to a basic infrastructure based on a determination that the first source system and the second source system share a common implementation template and according to an advanced infrastructure based on a determination that the first source system and the second source system comprise non-harmonized data; and

generating a cross system central and consistent database view for reporting and analyzing data for the organization comprising the first source system and the second source system with different database schemas by executing cross system database views of data in the first set of in-memory database tables corresponding to data from the first source system in the organization and data in the second set of in-memory database tables corresponding to data from the second source system in the organization.

20. The non-transitory computer readable storage device of claim 19, wherein replicating data comprises:

using an advanced data management replication server to harmonize data prior to replication into the sets of in memory database tables.

21. The non-transitory computer readable storage device of claim 20, wherein the advanced data management replication server performs a duplicate check to enable identification and prevention of duplicate records, includes structural mapping, value mapping, and key mapping, and further includes a distribution model and routing infrastructure to distribute data based on the distribution model.

22. The non-transitory computer readable storage device of claim 19, wherein the cross system views expose a logical system for each source system, the logical system including attributes defining authorizations, and wherein the cross system views are formed by union functions to join views and logical system representations from multiple source systems to create the cross system view with authorizations.