The previous sections have discussed the components of the OFSDF Physical Data Model (or the OFSDF Analytical Warehouse model) – this is the actual deployable physical database model that addresses a number of analytical needs out of the box, as illustrated earlier.
The Logical Data Model is a reference data model of the Financial Services Domain, which captures the data created by the key business processes in Financial Services. A reference data model is different from the Physical Data Model in these ways:
Difference between Reference Data Model and Physical Data Model:
|
Area |
FS LDM |
OFSDF Physical Model |
|
Purpose |
Generic blueprint of the data produced by the business processes of a Financial Services institution |
Designed for analytical processing (Risk, Profitability, Customer Insight) |
|
For- mat/Structure |
Entity Relationship Diagrams organized into key Top Level subject areas |
Physical Tables/Columns Definitions |
|
Usage |
Cannot be directly used – needs to be used within a physical database design step to arrive at a database schema |
Readily deployable |
|
Scope |
All the key business processes/activities and their supporting reference data requirements |
The business and reference data required for a set of analytical use cases. However, can be extended to serve other needs. |