Converting Data Objects from Single- to Multi-Source Database Environment

• US 20150293948A1
• Filed: 04/15/2014
• Published: 10/15/2015
• Est. Priority Date: 04/15/2014
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Sonwane, Tejram Jagannath, Balasubramanian, Makesh
• Granted Patent: US 9,619,537 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/256 in federated or virtual databases

Abstract

Embodiments relate to converting data object(s) from a single-source database environment into a multi-source database environment. An engine is configured to receive a single-source database universe from a repository. The engine analyzes that universe to identify details thereof for conversion, including but not limited to connections, tables, views, alias tables, etc. A new multi-source connection is registered, and then the multi-source universe is re-generated through a universe conversion algorithm, an automatic function mapping algorithm, and a query generation algorithm. Embodiments avoid labor intensive manual re-creation of the universe, and may be implemented as an automatic conversion wizard also updating dependent report queries per new multi-source query patterns. Particular embodiments converting a single-source database environment available from SAP AG, may utilize a Software Design Kit (SDK) to create a migration plug-in as part of an Information Design Tool (IDT).

Claims

1. A computer-implemented method comprising:

causing an engine to receive a single-source universe database comprising a plurality of details;

causing the engine to analyze the single-source universe database to create a configuration file identifying a detail to be changed;

causing the engine to register a new multi-source connection with a repository; and

causing the engine to reference the configuration file to create a multi-source universe database including the multi-source connection and a changed detail.

2. A method as in claim 1 wherein:

the single-source universe database is analyzed to identify a data object by a native database function; and

the multi-source universe database comprises a corresponding function.

3. A method as in claim 2 wherein creating the multi-source universe database further comprises re-generating a business layer including a new object definition compatible with the multi-source universe database.

4. A method as in claim 1 wherein creating the multi-source universe further comprises generating a query.

5. A method as in claim 1 wherein a connection of the single-source universe database is analyzed to identify vendor and version information.

6. A method as in claim 1 wherein creating the multi-source universe database further comprises re-generating a data foundation from a software development kit available from a vendor of the multi-source universe database.

7. A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:

causing an engine to receive a single-source universe database comprising a plurality of details;

causing the engine to analyze the single-source universe database to create a configuration file identifying a detail to be changed;

causing the engine to register a new multi-source connection with a repository; and

causing the engine to reference the configuration file to create a multi-source universe database including the multi-source connection and a changed detail.

8. A non-transitory computer readable storage medium as in claim 7 wherein:

the single-source universe database is analyzed to identify a data object by a native database function; and

the multi-source universe database comprises a corresponding function.

9. A non-transitory computer readable storage medium as in claim 8 wherein creating the multi-source universe database further comprises re-generating a business layer including a new object definition compatible with the multi-source universe database.

10. A non-transitory computer readable storage medium as in claim 7 wherein creating the multi-source universe further comprises generating a query.

11. A non-transitory computer readable storage medium as in claim 7 wherein a connection of the single-source universe database is analyzed to identify vendor and version information.

12. A non-transitory computer readable storage medium as in claim 7 wherein creating the multi-source universe database further comprises re-generating a data foundation from a software development kit available from a vendor of the multi-source universe database.

13. A computer system comprising:

one or more processors;

a software program, executable on said computer system, the software program configured to;

cause an engine to receive a single-source universe database comprising a plurality of details;

cause the engine to analyze the single-source universe database to create a configuration file identifying a detail to be changed;

cause the engine to register a new multi-source connection with a repository; and

cause the engine to reference the configuration file to create a multi-source universe database including the multi-source connection and a changed detail.

14. A computer system as in claim 13 wherein:

the single-source universe database is analyzed to identify a data object by a native database function; and

the multi-source universe database comprises a corresponding function.

15. A computer system as in claim 14 wherein creating the multi-source universe database further comprises re-generating a business layer including a new object definition compatible with the multi-source universe database.

16. A computer system as in claim 13 wherein creating the multi-source universe further comprises generating a query.

17. A computer system as in claim 13 wherein a connection of the single-source universe database is analyzed to identify vendor and version information.

18. A computer system as in claim 13 wherein creating the multi-source universe database further comprises re-generating a data foundation from a software development kit available from a vendor of the multi-source universe database.