IP Library › Granted Patent US 10,289,725
Granted Patent B2
US 10,289,725 · App. 14/553,322 · Granted May 14, 2019

Enterprise data warehouse model federation

Inventors: Patrick Winkler (Heidelberg, DE); Klaus Nagel (Heidelberg, DE); Jascha Kanngiesser (Karlsruhe, DE)
Assignee: SAP SE
G06F17/30563G06F17/30292G06F17/30569G06F17/30575
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,289,725
App. No.
14/553,322
Granted
May 14, 2019
Kind
B2
Abstract

The present disclosure describes methods, systems, and computer program products for providing data warehouse model federation. One computer-implemented method includes receiving a request to transform a first semantically enriched model to a second semantically enriched model, wherein the first semantically enriched model operates in a first data warehouse and the second semantically enriched model operates in a second data warehouse; identifying a set of data associated with the first semantically enriched model, wherein the set of data is stored in the first data warehouse; providing access to the set of data associated with the first semantically enriched model from the second data warehouse; creating the second semantically enriched model based on the first semantically enriched model using an interface of the second data warehouse; and deploying the second semantically enriched model in the second data warehouse.

Claims (64)

1. A method, comprising:

receiving a request to transform a first semantically enriched model to a second semantically enriched model, wherein the first semantically enriched model is stored and operates in a first data warehouse and the second semantically enriched model operates in a second data warehouse;

identifying a set of data associated with the first semantically enriched model, wherein the set of data is stored in the first data warehouse;

creating the second semantically enriched model in the first data warehouse based on the first semantically enriched model by using an interface of the second data warehouse to calculate parameters used to create the second semantically enriched model, wherein the interface of the second data warehouse is configured by an interface of the first data warehouse to provide access from the second data warehouse to the set of data associated with the first semantically enriched model stored in the first data warehouse, wherein the interface of the second data warehouse is different from the interface of the first data warehouse, wherein the interface of the first data warehouse provides access to the first semantically enriched model, and wherein creating the second semantically enriched model comprises:

creating a first definition of the first semantically enriched model;

identifying a first data type in the first definition that is not compatible with the interface of the second data warehouse;

transforming the first data type into a second data type that is compatible with the interface of the second data warehouse;

creating a second definition based on the first definition, wherein the second definition comprises the second data type; and

creating the second semantically enriched model based on the second definition using the interface of the second data warehouse; and

deploying, from the first data warehouse and into the second data warehouse, the second semantically enriched model, wherein the interface of the second data warehouse provides access to the second semantically enriched model deployed in the second data warehouse, and provides no access to the first semantically enriched model stored in the first data warehouse.

2. The method of claim 1 , further comprising:

identifying a first security policy associated with the first semantically enriched model;

creating a second security policy based on the first security policy and the interface of the second data warehouse; and

deploying the second security policy in the second data warehouse.

3. The method of claim 1 , further comprising:

determining that the first semantically enriched model is updated;

updating the second semantically enriched model based on the updated first semantically enriched model; and

deploying the updated second semantically enriched model in the second data warehouse.

4. The method of claim 1 , wherein providing access to the set of data comprises replicating the set of data in the second data warehouse.

5. The method of claim 1 , wherein providing access to the set of data comprises providing a virtual access to the set of data from the second data warehouse.

6. The method of claim 1 , wherein the first and the second definition is formatted according to Extensible Markup Language (XML).

7. A system, comprising:

a memory; and

at least one hardware processor interoperably coupled with the memory and configured to:

receive a request to transform a first semantically enriched model to a second semantically enriched model, wherein the first semantically enriched model is stored and operates in a first data warehouse and the second semantically enriched model operates in a second data warehouse;

identify a set of data associated with the first semantically enriched model, wherein the set of data is stored in the first data warehouse;

create the second semantically enriched model in the first data warehouse based on the first semantically enriched model by using an interface of the second data warehouse to calculate parameters used to create the second semantically enriched model, wherein the interface of the second data warehouse is configured by an interface of the first data warehouse to provide access from the second data warehouse to the set of data associated with the first semantically enriched model stored in the first data warehouse, wherein the interface of the second data warehouse is different from the interface of the first data warehouse, wherein the interface of the first data warehouse provides access to the first semantically enriched model, and wherein creating the second semantically enriched model comprises:

creating a first definition of the first semantically enriched model;

identifying a first data type in the first definition that is not compatible with the interface of the second data warehouse;

transforming the first data type into a second data type that is compatible with the interface of the second data warehouse;

creating a second definition based on the first definition, wherein the second definition comprises the second data type; and

creating the second semantically enriched model based on the second definition using the interface of the second data warehouse; and

deploy, from the first data warehouse and into the second data warehouse, the second semantically enriched model, wherein the interface of the second data warehouse provides access to the second semantically enriched model deployed in the second data warehouse, and provides no access to the first semantically enriched model stored in the first data warehouse.

8. The system of claim 7 , wherein the at least one hardware processor is further configured to:

identify a first security policy associated with the first semantically enriched model;

create a second security policy based on the first security policy and the interface of the second data warehouse; and

deploy the second security policy in the second data warehouse.

9. The system of claim 7 , wherein the at least one hardware processor is further configured to:

determine that the first semantically enriched model is updated;

update the second semantically enriched model based on the updated first semantically enriched model; and

deploy the updated second semantically enriched model in the second data warehouse.

10. The system of claim 7 , wherein providing access to the set of data comprises replicating the set of data in the second data warehouse.

11. The system of claim 7 , wherein providing access to the set of data comprises providing a virtual access to the set of data from the second data warehouse.

12. The system of claim 7 , wherein the first and the second definition is formatted according to Extensible Markup Language (XML).

13. A non-transitory, computer-readable medium storing computer-readable instructions for data warehouse model federation, the instructions executable by a computer and configured to:

receive a request to transform a first semantically enriched model to a second semantically enriched model, wherein the first semantically enriched model is stored and operates in a first data warehouse and the second semantically enriched model operates in a second data warehouse;

identify a set of data associated with the first semantically enriched model, wherein the set of data is stored in the first data warehouse;

create the second semantically enriched model in the first data warehouse based on the first semantically enriched model by using an interface of the second data warehouse to calculate parameters used to create the second semantically enriched model, wherein the interface of the second data warehouse is configured by an interface of the first data warehouse to provide access from the second data warehouse to the set of data associated with the first semantically enriched model stored in the first data warehouse, wherein the interface of the second data warehouse is different from the interface of the first data warehouse, wherein the interface of the first data warehouse provides access to the first semantically enriched model, and wherein creating the second semantically enriched model comprises:

creating a first definition of the first semantically enriched model;

identifying a first data type in the first definition that is not compatible with the interface of the second data warehouse;

transforming the first data type into a second data type that is compatible with the interface of the second data warehouse;

creating a second definition based on the first definition, wherein the second definition comprises the second data type; and

creating the second semantically enriched model based on the second definition using the interface of the second data warehouse; and

deploy, from the first data warehouse and into the second data warehouse, the second semantically enriched model, wherein the interface of the second data warehouse provides access to the second semantically enriched model deployed in the second data warehouse, and provides no access to the first semantically enriched model stored in the first data warehouse.

14. The non-transitory, computer-readable medium of claim 13 , wherein the instructions are further configured to:

identify a first security policy associated with the first semantically enriched model;

create a second security policy based on the first security policy and the interface of the second data warehouse; and

deploy the second security policy in the second data warehouse.

15. The non-transitory, computer-readable medium of claim 13 , wherein the instructions are further configured to:

determine that the first semantically enriched model is updated;

update the second semantically enriched model based on the updated first semantically enriched model; and

deploy the updated second semantically enriched model in the second data warehouse.

16. The non-transitory, computer-readable medium of claim 13 , wherein providing access to the set of data comprises replicating the set of data in the second data warehouse.

17. The non-transitory, computer-readable medium of claim 13 , wherein providing access to the set of data comprises providing a virtual access to the set of data from the second data warehouse.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 25, 2014
From: WINKLER, PATRICK; NAGEL, KLAUS; KANNGIESSER, JASCHA
To: SAP SE
Reel/Frame 034470/0623 →
Continuity (1)
Related Publication 20160147850A1 · May 26, 2016