Implementation Guide for Oracle Billing Insight > Overview of Oracle Billing Insight >

About the Oracle Billing Insight Database

OLTP is the Oracle Billing Insight transactional data schema. Oracle Billing Insight expects access to product tables to go through the Oracle Billing Insight APIs. Do not change the existing product schema. However, you can add your own customization tables.

OLAP is the Oracle Billing Insight data warehouse. These tables are accessed directly through report XML files. For information on how to use report XML files to retrieve data from the OLAP schema, check the report XML files used to generate various billing reports. These files are defined in the EDX_HOME/config/rpt directory (or the EDX_HOME\config\rpt directory on Windows). In these directories, EDX_HOME is the directory where you installed Oracle Billing Insight.

Auditing Database Administration Activity

Oracle Billing Insight does not audit database administrator activity. However, to remain compliant with the Payment Card Industry Data Security Standard (PCI DSS), you must implement auditing functionality that documents each time an administrator logs in, creates new tables or attributes, deletes information including tables, attributes, or transaction details, or runs an external script against the Oracle Billing Insight database.