Your DBA has ultimate control over the arrangement of ATG database schemas. However, ATG recommends as a best practice that your installation include the databases described in the following list. ATG 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. See the Production Schema section that follows.
Management Schema—Data required for ATG administrative applications to run, including versioned repositories and internal users. See the Management Schema section that follows.
Agent Schema—Data to be accessed by internal users of the customer service applications, such as ATG Knowledge solutions and profile data for internal users. See the Agent Schema section that follows.
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 ATG Data Warehouse Guide.
ATG 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 ATG Multiple Application Integration Guide for additional information on system architecture.