A One Thousand entity Core Financial Services Business Data Model goes open source.
Jayzed Data Models Inc. will release the core of the Financial Industry Business Data Model (FIB-DM) under GNU General Public License (GPL-3.0), an Open Source Initiative® recommended license.
The PowerDesigner conceptual model will be available for download on this website in June 2019. Other modeling tools can import the native CDM or XMI file. Data Modellers, you can follow our LinkedIn page for updates.
FIB-DM Core is a comprehensive, self-contained, high-quality blueprint for midsize financial service providers and independent data architects. You can use FIB-DM as a complete Enterprise Data Model, scoped subsets for application and departmental databases, or both.
With 1874 entities, the Financial Industry Business Data Model is the largest Enterprise Data Model available for Banks and Investment Companies.
FIB-DM Core has 1029 entities for free – more than half of the parent model.
Jayzed Data Models retains specialized packages for Securities (SEC), Derivatives (DER), Indices & Indicators (IND). Commercial licenses of the extensions fund the work for the open source core.
FIB-DM is a transformation from the industry standard ontology. In set theory, the core model is a definable inner model of the universe of sets (Wiki). Likewise, an ontology module is self-contained, if (SPARQL) queries on the module return the same results as queries on the whole ontology. In other words, there must be no open ends.
The diagram shows FIB-DM main package (subject area) dependencies, which correspond to ontology imports in the reference ontology.
The Foundation (FND) package at the uses entities from the generic packages for Metadata (SM), Languages, Countries, and Currencies (LCC), and classification, taxonomies, and vocabularies (SKOS). These packages provide the framework of the data model. For the most part, Foundation is not Finance-specific. You can use the data model patterns for any domain model. Business Entities (BE) and Finance, Business & Commerce (FBC) extend the Foundation. Most BE, and FBC entities are subtypes of Foundation entities. You can leverage half of the content in these packages for other domains.
FIB-DM Core has no references into SEC, DER, and IND. That is to say; there are no missing super-types or Relationship entities.
High quality, concise and business-friendly design
FIB-DM is a complete model transformation of FIBO, the Financial Industry Business Ontology. Above all, the Enterprise Data Management Council (EDMC), an association of global financial institutions created the ontology. Hence, FIBO is the authoritative open source industry standard for concepts, their relationships, and definitions.
But Ontology Web Language (OWL) is fundamentally different from the Entity Relationship Model (ERM) – won’t the design be changed as well?
Surprisingly not, there is a one-to-one correspondence between named OWL classes and data model entities, because both classes and entities define the same business concepts.
The example diagram below shows the FIB-DM Foundation Agreements Contracts sub-package. For clarity, Associative entities are blue throughout all diagrams.
A contract has effective and execution dates, various terms and contract parties. Note that in FIBO and FIB-DM party is the role that a person or legal entity plays in context of the contract.
Data modelers will notice the multiple inheritances of the Promissory Note – it’s not a bug, it’s a feature.
- For the business user, the Promissory Note is indeed both a Written and Unilateral Contract.
- FIB-DM is a conceptual data model – it will not be physicalized as is.
- After scoping, and attribution, the modeler will determine the appropriate pattern to resolve the inheritance.
The Transformation White Paper explains configuration decisions and intricacies in detail.
FIB-DM Core is a comprehensive, self-contained, high-quality blueprint for financial service providers. More than half of the model (>500 entities) is not Finance specifically. You can use the largest Open Source data model at the Enterprise level or pattern library Application DB design.
Next month, download the model and see for yourself!
References and further reading
FIBO homepage on the EDM Council website: https://edmcouncil.org/page/aboutfiboreview
Open Source Initiative website: https://opensource.org/
Jayzed Data Models website: http://jayzed.com/
FIB-DM Technical Specification, Whitepaper, and Diagrams: https://fib-dm.com/
The OSI logo trademark is the trademark of Open Source Initiative.