Features in Operational Data Store
This section describes the ODS features and technology specific information for GA release 1.0.0.0.
ODS Dataset and Records
ODS runs a replicated dataset from an instance of OIPA with no direct interface with the OIPA Database. The instances can be created from any OIPA database (production or development).
ODS Utility
The ODS Utility allows the administration of the ODS data schema. The user can create scripts to generate a database schema from the existing OIPA data records and rules. The scripts used to build and update the schema will be logged and saved. The system will name most of the tables for their business rules or entities (e.g. Client, Segment) and name few tables by their function of hierarchy.
Dashboard
A Dashboard will display Run Statistics of the ODS schema creation and update the job count details (Passed / Failed jobs) of Data Sync process.
Aggregation
Aggregation controls the level at which entities will be grouped into common tables such as; Clients by Type, Policies by Product or Transactions by Name.
Run
The user can add a run to generate and apply the database scripts to the Target database (Reporting Schema). A 'Run' is a predefined action to administer the ODS Schema such as; initializing the database, adding a new schema, or updating an existing one creating a delta script of the current ODS and new production configuration. The Run screen will display all runs that have been created for the ODS.
Job Scheduler
The Job Scheduler allows the user to setting the frequency with which the ODS schema should be refreshed with data from the source database instance (scheduling). The more frequent the updates, the closer the ODS will be to 'real time' instance data but will also be tempered by the size of the data in each update.
Alias Mapping
Alias Mapping defines the replacement text for table names that might otherwise be too cumbersome for the ODS to administer. The Alias table allows the user to create alternative, user friendly names for the ODS generated tables.
Data Synchronization
Data synchronization among the source (OIPA through ODS Staging) and the Target database is carried in 3 steps:
- Move the Data from OIPA Transactional Database to ODS Staging Schema through data pump or data dump via IMPORT/EXPORT or IMPDMP/EXPDMP.
- Replicate OIPA data (instance data) to a Staging database via a data transformation tool (e.g. Golden Gate).
- Replicate the instance data from the staging database into the Target Database based on the Job Scheduler frequency set by the user in the ODS utility.
Pivot Tables
Executing the Create/Alter scripts from the ODS Utility will generate and insert a replicated database schema of the OIPA source in the target database (but not the table data). The schema of the ODS will be based on the configured screen and transaction rules where the dynamic field data will be pivoted into columns to create a flat data structure.
Technology-Specific Support
Please refer to the 1.0.0.0 version (part number E88461-01) information published in the Technology Stack section of the Oracle Technology Network (OTN).