Financial Industry Business Data Model

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)
FIG 3 is a Data Flow Diagram (in Gane / Sarson notation) of the Metadata Sets and the external interfaces.
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.
CODT FIG 10 Entity Relationship MDS Name Transformation Excel screenshot (color)
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).
FIG 17 is a logical model diagram of the PowerDesigner MDS.
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).
FIG 21 is a BPMN diagram of the Transformation Refresh Metadata Sets subprocess, which is internal and has only one swim lane.
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).