We are pleased to announce the publication of a new best practices paper: Deploying the IBM Banking Data Warehouse to IBM InfoSphere BigInsights
This paper shows how you can deploy the IBM Banking Data Warehouse (BDW) solution to BigInsights. This paper introduces the logical data model concept and then focuses on what you must do to transform a non-vendor-specific logical data model into a production-ready BigInsights BigSQL schema. The key steps of the deployment process are as follows:
Create a physical data model that is a subset of the supplied logical data model.
Refine the physical data model to reflect your reporting and analytics needs.
Create the physical schema from the physical data model.
Populate the test environment, to further optimize the physical design to reflect the anticipated query, ingest, and maintenance workload.
The example used in this paper is the Involved Party coverage within the BDW.
Although BigInsights includes a SQL interface (BigSQL), there are unique considerations when deploying to BigInsights. This paper explains how to translate reporting needs into BigInsights design decisions as part of the transformation process.