Automatic conversion of data models using data model annotations

US11762820B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Jan Portisch · Bruchsal, DE
• Bjoern Pantel · Wiesbaden, DE
• Benjamin Merkle · Pforzheim, DE
• Stephan Schub · Oftersheim, DE
• Sandra Bracholdt · Dielheim, DE
• Roland Kolata · Walldorf, DE
• Michael Hladik · Walldorf, DE
• Christoph Meinel · Heidelberg, DE

Key dates

• Filing date: Aug 12, 2022
• Grant date: Sep 19, 2023
• Expiry date: Aug 12, 2042

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/288
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

Techniques and solutions are described for converting data models between formats, such as between a conceptual data model and a physical data model for a database system, or between a conceptual data model and artefacts to be implemented in the database system. The conceptual data model is annotated with annotations that allow the physical data model or database artefacts to be automatically generated from the conceptual data model. The annotations can reflect relationships between entity types in the physical data model, such as inheritance relationships, header/item relationships, or one-to-one cardinality relationships. Annotations can also indicate attributes that should be added to entity types in the conceptual data model, such as attributes for versioning or data governance, that may not be used in the conceptual data model. Annotations can be used to determine how entity types in the conceptual data model will be denormalized in the physical data model.