3.3 Differences from Traditional Warehouse Architecture

This table summarizes the differences of the OFSDF from a traditional Data Warehouse architecture.

Table 3-1 Differences between the traditional Data Warehouse architecture and OFSDF

Component FSDF Traditional BI Architecture

Staging Layer

Common staging Area (CSA) where data from source systems are staged and is implemented as database schema.

Usually a file system-based area where file-based extracts (operational images) from source systems are staged prior to loading into a target schema.

3rd Normal Form Operational Data Store/Enterprise Data Warehouse

Does not provide a physicalized model for a 3NF store.

Operational/fine-grained reporting will be fulfilled from the reporting area.

Notification sent to all users captured as owners and user who submitted the definition.

Data Marts/Reporting Model

Set of star schemas with conformed dimensions (Ralph Kimball approach)

Set of star schemas

With the preceding understanding in mind, the following sections describe the data models in the OFSDF in greater detail.

  • Readily Deployable: The Physical Data Model is a readily deployable physical schema. It is provided as an erwin Data Model file (for details on erwin, seehttps://erwin.com/products/erwin-data-modeler/) and consists of tables grouped into distinct subject areas depending on function. The tables are either used to gather source data (Staging Area), or as containers of outputs/results from analytical processing and engines for reporting purposes (Reporting Area).
  • Use-case Driven: The OFSDF Physical Data model is driven by a set of clearly identified analytical use cases spanning Risk, Performance, Customer Insight, and Compliance.
  • Extensible: While the OFSDF Physical Data Model satisfies a very large number of analytical use cases across Risk, Finance, Marketing, and Compliance subject areas, customers may find the need to customize the model for a specific installation.

These customizations may be done in accordance with guidelines published in Using OFSDF section of this manual.

The OFSDF Physical Data Model is divided into two primary areas:

  • Staging Data Model
  • Reporting Data Model