Configurable Ontology to Data model Transformation

Patent Drawings

The gallery shows the Configurable Ontology to Data Model Transformation (CODT) patent drawings. Figures 1-23 are identical to the official United States Patent and Trademark publication, US12038939B2, but in color and without distracting numerals. You can click on an image to open the drawing full-size in a new tab.

FIG 1 illustrates an example of a source Ontology graph, target PowerDesigner Conceptual Data Model, and the transformation/mapping from source to target.
CODT Patent FIG 1 Ontology Graph to Conceptual Data Model mapping (color)
FIG 2 is a UML component diagram of the CODT system and the two external systems: the ontology platform and the Data Modeling Tool.
CODT Patent FIG 2 System UML Component diagram (color)
CODT Patent FIG 3 Metadata Sets Data Flow diagram (color)
FIG 4 is a Business Process Modeling Notation (BPMN) diagram providing an overview of the CODT method.
CODT Patent FIG 4 Method BPMN diagram (color)
FIG 5 is a screenshot of the query results in a text editor, Windows Notepad.
CODT Patent FIG 5 Ontology CSV Extract screenshot.
FIG 6 is an MS Excel screenshot of the Ontology Metadata Set.
CODT Patent FIG 6 Ontology MDS MS Excel screenshot (color).
FIG 7 shows the Classes sheet with the activated Queries & Connections pane
CODT Patent FIG 7 Ontology MDS Queries and Connections screenshot (color)
FIG 8 shows the Class query in the PowerQuery Editor.
CODT Patent FIG 8 Ontology MDS in PowerQuery screenshot (color)
FIG 9 is a CODT screenshot of the Entity-Relationship MDS.
CODT Patent FIG 9 Entity Relationship MDS Excel screenshot (color)
FIG 10 is s another screenshot of the Entity-Relationship MDS, showing the tEntity_Name tab, the data source for Entity.
FIG 10 is s another screenshot of the Entity-Relationship MDS, showing the tEntity_Name tab, the data source for Entity.
FIG 11 is a screenshot of the PowerDesigner_MDS in the CODT Excel implementation.
CODT Patent FIG 11 PowerDesigner MDS Excel screenshot (color)
FIG 12 is a screenshot of the PowerDesigner data modeling tool.
CODT Patent FIG 12 PowerDesigner Import screenshot (color)
FIG 13 is a data flow diagram to recap the Metadata Set transformation from an ontology to a data model.
CODT Patent FIG 13 Class Metadata Set Population Data Flow diagram (color).
FIG 14 is an entity-relationship diagram, a logical data model of the Ontology Metadata Sets.
CODT Patent FIG 14 Ontology Metadata Sets Logical Data Model diagram (color)
FIG 15 is a logical data model of the Entity-Relationship Metadata Sets.
CODT Patent FIG 15 Entity-Relationship Metadata Sets Logical Data Model diagram (color).
FIG 16 is a data flow diagram tracing the Transformation of Parent Relationship via various intermediate MDS to source ontology MDS.
CODT Patent FIG 16 Parent Relationship Metadata Set population Data Flow diagram (color).
The Data Flow diagram explains how data model Parent Relationships populate from ontology Object Properties various intermediate MDS. The user-friendly version of the CODT patent drawing is in color and without numbering.
CODT Patent FIG 17 PowerDesigner Metadata Sets Logical Data Model diagram (color).
FIG 18 is a BPMN diagram of the shows the Configuration task.
CODT FIG 18 Configuration Business Process Modeling Notation, BPMN, diagram (color).
FIG 19 is a CODT screenshot with the sheet for Configuration.
CODT Patent FIG 19 Configuration MS Excel screenshot (color)
FIG 20 is a BPMN diagram expanding the Extract Ontology Metadata subprocess.
CODT Patent FIG 20 Extract Ontology Metadata BPMN diagram (color).
CODT Patent FIG 21 Transformation Refresh Metadata Sets BPMN diagram (color).
FIG 22 shows the Load subprocess with its two swimlanes for CODT and the external Data Modeling Tool.
CODT Patent FIG 22 Load BPMN diagram (color).
FIG 23 is a BPMN diagram of the Reverse Transformation Process, which has two swimlanes, CODT, and external Tools and Platforms.
CODT Patent FIG 23 Reverse Transformation BPMN diagram (color).

Below is the section from the CODT patent.

BRIEF DESCRIPTION OF THE DRAWINGS

(1) FIG. 1 illustrates the mapping of an example Ontology Graph to the transformed Conceptual Data Model.

(2) FIG. 2 is a UML Component diagram of the CODT and external systems.

(3) FIG. 3 is a Data Flow Diagram of the Metadata Sets.

(4) FIG. 4 is a Business Process Modeling Notation (BPMN) diagram of the CODT method.

(5) FIG. 5 illustrates a raw ontology extract file in CSV format.

(6) FIG. 6 illustrates a sample embodiment of the Ontology Metadata Set in Microsoft (MS)-Excel

(7) FIG. 7 illustrates a sample embodiment of the Ontology Metadata Set Queries and Connections in MS-Excel

(8) FIG. 8 illustrates a sample embodiment of the Ontology Metadata Set in MS Power Query

(9) FIG. 9 illustrates a sample embodiment of the Entity-Relationship Metadata Set in MS-Excel

(10) FIG. 10 illustrates a sample embodiment of the Entity-Relationship Metadata Set name transformation in MS-Excel

(11) FIG. 11 illustrates a sample embodiment of the Tool-Specific Metadata Set in MS-Excel

(12) FIG. 12 illustrates the import of sample embodiment tool-specific metadata set into PowerDesigner.

(13) FIG. 13 is a Data Flow Diagram of the Class metadata set population.

(14) FIG. 14 is a Logical Data Model (LDM) diagram of the Ontology Metadata Sets.

(15) FIG. 15 is an LDM diagram of the Entity-Relationship Metadata Sets.

(16) FIG. 16 is a Data Flow Diagram of the Parent Relationship metadata set population.

(17) FIG. 17 is an LDM diagram of the PowerDesigner Metadata Sets.

(18) FIG. 18 is a BPMN diagram of the Configuration subprocess.

(19) FIG. 19 illustrates a sample embodiment of the Configuration settings.

(20) FIG. 20 is a BPMN diagram of the Extract Ontology Metadata subprocess.

(21) FIG. 21 is a BPMN diagram of the Refresh Metadata Set subprocess.

(22) FIG. 22 is a BPMN diagram of the Load subprocess.

(23) FIG. 23 is a BPMN diagram of the Reverse Transformation process.