Your DBA has ultimate control over the arrangement of Oracle Commerce Platform database schemas. However, it is recommended as a best practice that your installation include the databases described in the following list. Oracle Commerce Platform documentation for data sources and other components uses this division as the frame of reference.
Production Schema—Data to be accessed or affected by external users, such as product catalogs and customer profiles, and the loader tables for the data warehouse.
Management Schema—Data required for administrative applications to run, including versioned repositories and internal users.
Agent Schema—Data to be accessed by internal users of Oracle Commerce Service Center.
Warehouse Schema—All of the data warehouse data. This schema should be created in a database optimized for data warehousing, and on a high-performance machine. see the Business Intelligence Data Warehouse Guide.
Oracle Commerce Platform documentation may also refer to a “local” schema. This schema contains the platform tables created by the das_ddl.sql
script (see Creating the DAS Tables in this guide).
See the Multiple Application Integration Guide for additional information on system architecture.