Automatic conversion of data models using data model annotations

A computer-implemented method comprising:

• receiving a conceptual data model comprising a first entity type having an inheritance relationship with at least a second entity type and at least a third entity type, the first, at least a second, and at least a third entity types arranged in a graph data structure comprising a root node and at least one leaf node;
• determining a path between the root note and the at least one leaf node, the path comprising the first, at least a second, and at least a third entity types;
• determining whether a first annotation between the first entity type and the at least a second entity type is to generate a parent entity type or a child entity type;
• determining whether a second annotation between the first entity type and the at least a third entity type is to generate a parent entity type or a child entity type;
• based on annotation types for the first and second annotations, determining a selected entity type of the first, at least a second, and at least a third entity types for which a corresponding entity type should be generated in a physical data model, other entities types of the first, at least a second, and at least a third entity types being unselected entity types;
• and
• in the physical data model, including in the corresponding entity type at least a portion of attributes of the unselected entity types.

One or more computer-readable storage media comprising:

• computer-executable instructions that, when executed, cause a computing device to receive a conceptual data model for a plurality of annotated entity types;
• computer-executable instructions that, when executed, cause a computing device to determine that at least a first annotated entity type and at least a second annotated entity type of the plurality of annotated entity types are related by inheritance;
• computer-executable instructions that, when executed, cause a computing device to create a first, denormalized, entity type in a physical data model comprising at least a portion of attributes of the at least a first annotated entity type and the at least a second annotated entity type;
• computer-executable instructions that, when executed, cause a computing device to determine that at least a third annotated entity type and at least a fourth annotated entity type of the plurality of annotated entity types are related by a header/item relationship;
• computer-executable instructions that, when executed, cause a computing device to create a second, denormalized, entity type in a physical data model comprising at least a portion of attributes of the at least a third annotated entity type and the at least a fourth annotated entity type;
• computer-executable instructions that, when executed, cause a computing device to determine that at least a firth annotated entity type and at least a sixth annotated entity type of the plurality of annotated entity types are related by a one-to-one cardinality relationship;
• computer-executable instructions that, when executed, cause a computing device to create a third, denormalized, entity type in a physical data model comprising at least a portion of attributes of the at least a fifth annotated entity type and the at least a sixth annotated entity type;
• computer-executable instructions that, when executed, cause a computing device to determine that a seventh annotated entity type of the plurality of annotated entity types is to be associated with versioning attributes;
• computer-executable instructions that, when executed, cause a computing device to cause the versioning attributes to be added to a fourth entity type of the physical data model that comprises attributes of the seventh annotated entity type;
• computer-executable instructions that, when executed, cause a computing device to determine that an eighth annotated entity type of the plurality of annotated entity types is to be associated with data governance attributes;
• and
• computer-executable instructions that, when executed, cause a computing device to cause the data governance attributes to be added to a fifth entity type of the physical data model that comprises attributes of the eighth annotated entity type.