Maintaining foreign key references across domains
Disclosed herein are system, method, and computer program product embodiments for creating an enterprise data model that defines entities and relationships between the entities spanning multiple environments and for deploying and maintaining artifacts across the environments using metadata specified in the enterprise data model. By embedding metadata that describes foreign key references within an enterprise data model, a unifying enterprise data model may manage artifacts across multiple domains while implementing a physical, cross-domain, data architecture. Such an enterprise data model may provide an organization with a 360-degree view of the information harnessed across the organization's technical landscape and may allow the organization to easily rollout a comprehensive data warehousing solution.
1. A computer implemented method, comprising:
defining, by one or more processors, an enterprise data model comprising a first entity, a second entity, and metadata that describes a foreign key reference between the first entity and the second entity and that describes an approach for maintaining the foreign key reference between the first entity and the second entity, wherein the first entity is located in a first domain and the second entity is located in a second domain, and wherein the metadata specifies that attributes in the second entity are to be duplicated in the first entity;
deploying, by the one or more processors, first components of the enterprise data model in the first domain based on the enterprise data model;
generating, by the one or more processors, an artifact based on the metadata that maintains the foreign key reference between the first entity and the second entity based on the approach, wherein the artifact comprises a data model script that creates first attributes in the first entity corresponding to second attributes in the second entity and a publisher-to-subscriber replication pattern that replicates the second attributes to the first attributes; and
implementing, by the one or more processors, the artifact in the first domain and the second domain.
2. The method of claim 1 , wherein the metadata specifies that attributes in the second entity are to be queried in real-time using an API call and wherein the artifact comprises an API specification providing for data-lookup from the first entity to the second entity.
3. The method of claim 1 , wherein the metadata specifies that a recreated entity of the second entity is to be created in the first domain and wherein the artifact comprises a data model script that creates the recreated entity and a publisher-to-subscriber replication pattern that replicates the second entity to the recreated entity.
4. The method of claim 1 , further comprising:
receiving, by the one or more processors, additional information about the enterprise data model comprising a third entity, a second metadata that describes a foreign key reference between the second entity and the third entity; and
deploying, by the one or more processors, second components of the enterprise data model in the second domain by automatically generating the artifact using the second entity and the second metadata.
5. The method of claim 1 , further comprising:
receiving, by the one or more processors, a change to the enterprise data model; and
updating, by the one or more processors, the deployed first components based on the change.
6. The method of claim 1 , wherein the artifact is a table in a database.
7. The method of claim 1 , wherein the enterprise data model describes a customer relationship management system.
8. The method of claim 1 , further comprising:
providing, by the one or more processors, an online tool that presents a model of the first entity and the second entity, builds the enterprise data model, and generates the metadata.
9. The method of claim 1 , further comprising:
deploying, by the one or more processors, the enterprise data model in a centralized data warehouse; and
importing, by the one or more processors, data from the first entity and the second entity into the centralized data warehouse.
10. The method of claim 1 , wherein the publisher-to-subscriber replication pattern that replicates the second attributes to the first attributes adheres to domain-specific security protocols and access requirements.
11. A system, comprising:
a memory; and
at least one processor coupled to the memory and configured to:
define an enterprise data model comprising a first entity, a second entity, and metadata that describes a foreign key reference between the first entity and the second entity and that describes an approach for maintaining the foreign key reference between the first entity and the second entity, wherein the first entity is located in a first domain and the second entity is located in a second domain and wherein the metadata specifies that attributes in the second entity are to be duplicated in the first entity;
deploy first components of the enterprise data model in the first domain based on the enterprise data model;
generate an artifact based on the metadata that maintains the foreign key reference between the first entity and the second entity based on the approach, wherein the artifact comprises a data model script that creates first attributes in the first entity corresponding to second attributes in the second entity and a publisher-to-subscriber replication pattern that replicates the second attributes to the first attributes; and
implement the artifact in the first domain and the second domain.
12. The system of claim 11 , wherein the metadata specifies that attributes in the second entity are to be queried in real-time using an API call and wherein the artifact comprises an API specification providing for data-lookup from the first entity to the second entity.
13. The system of claim 11 , wherein the metadata specifies that a recreated entity of the second entity is to be created in the first domain and wherein the artifact comprises a data model script that creates the recreated entity and a publisher-to-subscriber replication pattern that replicates the second entity to the recreated entity.
14. The system of claim 11 , the at least one processor further configured to:
deploy the enterprise data model in a centralized data warehouse; and
import data from the first entity and the second entity into the centralized data warehouse.
15. The system of claim 11 , wherein the publisher-to-subscriber replication pattern that replicates the second attributes to the first attributes adheres to domain-specific security protocols and access requirements.
16. A non-transitory computer-readable device having instructions stored thereon that, when executed by at least one computing device, cause the at least one computing device to perform operations comprising:
defining an enterprise data model comprising a first entity, a second entity, and metadata that describes a foreign key reference between the first entity and the second entity and that describes an approach for maintaining the foreign key reference between the first entity and the second entity, wherein the first entity is located in a first domain and the second entity is located in a second domain, and wherein the metadata specifies that attributes in the second entity are to be duplicated in the first entity;
deploying first components of the enterprise data model in the first domain based on the enterprise data model;
generating an artifact based on the metadata that maintains the foreign key reference between the first entity and the second entity based on the approach, wherein the artifact comprises a data model script that creates first attributes in the first entity corresponding to second attributes in the second entity and a publisher-to-subscriber replication pattern that replicates the second attributes to the first attributes; and
implementing the artifact in the first domain and the second domain.
17. The non-transitory computer-readable device of claim 16 , wherein the publisher-to-subscriber replication pattern that replicates the second attributes to the first attributes adheres to domain-specific security protocols and access requirements.
18. The non-transitory computer-readable device of claim 17 , wherein the metadata specifies that attributes in the second entity are to be queried in real-time using an API call and wherein the artifact comprises an API specification providing for data-lookup from the first entity to the second entity.
19. The non-transitory computer-readable device of claim 17 , wherein the metadata specifies that a recreated entity of the second entity is to be created in the first domain and wherein the artifact comprises a data model script that creates the recreated entity and a publisher-to-subscriber replication pattern that replicates the second entity to the recreated entity.
20. The non-transitory computer-readable device of claim 17 , the operations further comprising:
deploying the enterprise data model in a centralized data warehouse; and
importing data from the first entity and the second entity into the centralized data warehouse.