System Architecture

The operational data store (ODS) system is designed to extract data definition language (DDL) structure from OIPA and create a pivoted view (flattened) model for data transformation as per current OIPA rules configuration. The operational data store (ODS) can interact with OIPA asynchronously via REST services. ODS leverages Golden Gate data replication strategy to synchronize data from OIPA source to a staging data store. The staging data store is primarily used to hold the data for transformation, this is where the data gets pivoted or transposed using database views. The staging database also has a meta data model that holds data structure (DDL) snapshots and other run-time statistics that are related to scheduled jobs for data synchronization. The physical data movement between staging database and target database is through stored procedures that are designed to move pivoted data from stage to target schema. The stored procedures are triggered via a scheduled database job that can be created via ODS user interface.

 

 

Oracle Insurance Logo Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us