Financial Industry Business Data Model

Semantics for Managers

An introduction to the ontology-derived Enterprise Data Model for Finance and Business stakeholders.

Click to open Semantics for Manager
FIB-DM Semantics for Managers CtO

You can also download the tutorial in  PDF or watch the webinar video.

Text of the presentation

Semantics for Managers
Financial Industry Business Data Model (FIB-DM)
An introduction to the ontology-derived Enterprise Data Model for Finance and Business stakeholders. Jurgen Ziemer, Ontologist & Data Architect at Jayzed Data Models Inc.
https://fib-dm.com © 2025Jayzed Data Models Inc.
You work at a Financial Institution and already embrace model-driven development, industry standards, and reference models.
Finance business stakeholder and expert with a working knowledge of Entity-Relationship and Ontology diagrams.
Data or Application Architect experienced in Enterprise Reference models. You may have used FIBO design patterns and definitions.
As an Ontologist with an in-depth understanding of FIBO, you already use it as the reference ontology for your design and want to spread adaptation across your enterprise.
Finance key point 2
Introduction to the author and publisher
Jurgen Ziemer has 20 years of industry experience as a data architect and ontologist at leading Financial Institutions and service providers.
Jayzed Data Models
Accenture

  • Seven years as an IBM Software Group Consultant for the Banking and Financial Markets Data Warehouse (BFMDW) model at 45 banks in North America, Europe, and Asia.
  • Four years of implementing BFMDW at Citi and Deutsche Bank. • Speaker at FIBO conferences
    IBM Credit Suisse
    Deutsche Bank
    Jayzed Data Models Inc. is a US consulting company incorporated in 1999.
    Jayzed holds the FIB-DM copyrights and is the designated assignee to the CODT Patent.
    Citi
    Reuters
    German Stock Exchange
    Finance key point 3
    There is a chasm between semantic conventional data management.
    The EDMC specified FIBO in Ontology Web Language (OWL).
    FIBO is comprehensive with detailed coverage of business entities, loans, securities, derivatives, and indicators.
    Large financial institutions started implementations on RDF (“triple”) stores
    and
    OWL needs highly specialized ontologists.
    Many banks and investment managers don’t have the expertise in-house.
    IT departments must still support and design conventional databases.
    Finance key point 4
    FIB-DM is the bridge across the chasm.
    Finance key point 5
    The ontology transformed into a data model leverages the design for relational databases.
    FIBO RDF OWL
    FIB-DM
    Data Model
    Configurable Ontology to Data-model Transformation
    Semantic Triple Store Relational Database
    Finance key point 6
    Predictions
  • RDF stores dominate data systems for knowledge management. • RDBMS remains the standard for traditional transactional and
    business intelligence systems.
  • Hence, Financial Institutions still need relational models and data modelers.
  • However, Ontology Web Language replaces the Entity-Relationship Model (ERM) as the notation of choice for Industry Domain and Enterprise Models.
    Finance key point https://fib-dmh.ctotpms://f©ib-Jdamyz.ecdomData©M2o0d2e5lsJaIynzce.d20D1a9ta Models Inc. 7
    Semantic Enterprise Information Architecture
    Use Type
    FIB-DM
    FIBO
    RDF OWL
    Level
    Business Conceptual FIB-UM Enterprise
    Design Logical
    Data Model
    Department
    Physical
    Development RDBMS
    Implementation
    RDF Project
    Data Message Process Object
    Finance key point 8
    Semantic Model-Driven Development
    Conceptual
    Logical
    Physical
  • FIBO is the domain ontology; FIB-DM is the conceptual data model.
  • A conceptual business model for the Financial Industry and applied at the enterprise level.
  • Logical models for data, message, process, and object derive from the ontology
  • The ontology at the architecture apex ensures common names, definitions, and design across the enterprise.
  • Midsize Financial Institutions without Semantic Technologies yet adopt FIB-DM, a strategic enterprise model.
  • Large institutions use CODT to transform their in-house ontologies into data models for downstream implementation.
    Finance key point 9
    Financial Industry Business Data Model
    = in
    (and other data modeling tools)
  • Financial Industry Business Data Model of 3,212 Entities, complete definitions, annotations, and axioms (business rules).
  • Data Architects leverage the full content of the Industry Standard.
  • Common Language and design patterns for Semantic & Relational data.
    Finance key point 10
    Transformation principles & considerations for the derived data model
    1. The model must be practical.
    Overly normalized designs become too abstract for business users and developers.
    2 . The model must be complete.
    We don’t want to miss information from the ontology
  1. The model has complete documentation. The diagrams depict all subject areas and design patterns.
    4. The model maps back to its source, the ontology
    Data Architect 11
    Domain ontology generates a perfect CDM
    Ontology graph Conceptual Data Model
    This entity-relationship diagram is the best representation of the Bank Account, its provider, and ID.

There are no missing or superfluous entities or relationships in the design.

~
Depository Institution
Depository Institution subtype
Bank
is Provided By Bank
<> provides
Bank Account is Provided By
Bank Account
1,n
BankAccount isIdentified By
identifies
Bank Account Identifier identifies
1,n
Bank Account Identifier
Finance key point 12
From FIBO to FIB-DM – how does it work?
The Configurable Ontology-to-Data-Model Transformation (CODT) is a basic ETL.
RDF OWL
Extract Transform Load
We extract metadata from the source ontology, transform it into conceptual data model metadata, and load it into the data modeling tool PowerDesigner.
The extract process runs SPARQL queries against the ontology to retrieve metadata. PowerDesigner imports MS-Excel workbooks. The Transformation in between is a 2-step process using the patent-pending Metadata Sets.
Data Architect Ontologist 13
The CODT Metadata Sets.
The Extract process populates the Ontology Metadata Sets for classes, objects, data properties, and annotations.
Step 1 Step 2
Ontology Metadata Set
Generic EntityRelationship Metadata Set
Tool-specific Metadata Set
Step one transforms the ontology metadata and populates the generic ER representation. The Tool-specific metadata set is in PowerDesigner format. Step two is a simple conversion from generic ER to PowerDesigner objects, properties, and extended attributes. We serialize to MS Excel and load it directly into the data modeling tool.
Data Architect Ontologist 14
CODT Utility Patent US12038939
The groundbreaking and broad patent awarded means that Jayzed Data Models Inc. has protected its intellectual property to:

  • Protect FIB-DM open-source core users and licensees of the whole model
  • Transform very large ontologies. • Make the transformation process
    available for licensing.
  • Transforms other domain ontologies, Gene, oil, and auto, in the future.
    https://codt.net/patent/
    Finance key point https://fib-dmh.ctotpms://f©ib-Jdamyz.ecdomData©M2o0d2e5lsJaIynzce.d20D1a9ta Models Inc. 15
    FIB-DM Core is Open Source
    Core is
    GNU General Public License (GPL-3.0), an Open Source Initiative® recommended license. Available for download on the FIB-DM website: https://fib-dm.com/data-model-download/
    Finance key point 16
    A one thousand entity open-source model
    Finance key point 17
    A self-contained, standalone data model. Generic OMG Commons OMG Languages, Countries & Currencies Simple Knowledge Organization System Specification Metadata
    FIBO Foundation
    Domain Core
    Free Open Source
    FIBO Finance Business & Commerce FIBO Business Entities
    FIBO Loans & Mortgages FIBO Business Processes
    Domain Core
    FIBO Corporate Actions & Events
    FIBO Securities
    FIBO Derivatives FIBO Indicators
    Commercial License
    FIBO Market Data FIBO Collective Investment Vehicles
    Finance key point 18
    FIB-DM Extended for Financial Institutions
    The complete 3212-entity data model, plus updates as new FIBO modules for Full banking and investment become available.
    Your purchase and software license agreement upon request.
    Access to data diagrams, PowerPoint, Excel, and Visio resources. Permission to lift off and rebrand for internal use.
    Optional 12-month Maintenance agreement with training, model, and resource updates.
    Tiered pricing based on asset size with discounts for regulators and governments.
    Finance key point 19
    Transparency for your FIB-DM evaluation
    Download the Open Source
    Examine the Full Model report
    Review the Education resources
    Schedule an online demo and Q&A
    Finance key point 20
    Core in
    (and other data modeling tools)
    https://fib-dm.cm jziemer@jayzed.com
    Finance key point 21