Administration Guide for Oracle Billing Insight > Creating Applications and Jobs >

About Data Protection

Oracle Billing Insight works with Oracle Data Guard to provide solutions for data protection and recovery from a hardware failure or data corruption.

Oracle Billing Insight uses a database instance for data storage. The database instance stores historical data for analytics, using the OLAP schema, and it stores transactional data using the OLTP schema. Oracle Billing Insight creates certain transactional data from the OLTP schema and synchronizes it with the OLAP schema.

The synchronization allows real-time analysis of the changes made in OLTP, of which the hierarchy structure is one example. Users can create the hierarchy structure. The newly created hierarchy is stored in the OLTP schema and then pushed to the OLAP schema. The analytic reports then can use the newly updated hierarchy structure.

You can set up a primary database and a standby database for the Oracle Billing Insight instance.

Data created from the Oracle Data Integrator processes are first loaded to the OLAP schema. After the data is committed and validated in the OLAP schema, some key data is populated in the OLTP exchange tables. In cases where the OLAP or OLTP schema is unavailable, the counterpart of each schema keeps all the data.

The database works with Oracle Data Guard. The integrity of the data is guaranteed in Oracle Billing Insight through the design of the data load processes as well as by using distributed database transaction management. For data created by online users, the distributed database transactions are used to guarantee data integrity. If one of the database schemas is unavailable, then no new data is written to either schema.