Database Tier

Oracle DMW uses the Oracle LSH database tier that includes:

Oracle Enterprise Edition RDBMS: All of Oracle LSH's database tier components use the Oracle Enterprise Edition database server and database.

Oracle Applications Schema: The Oracle Applications Schema is the schema installed as part of the Oracle Applications installation. It contains the Oracle LSH schema.

Oracle LSH Database Server and Schema: These include Oracle LSH's business logic in PL/SQL packages, internal Oracle LSH tables and views, security, adapters, and APIs; as well as Oracle LSH user-developed metadata tables and packages.

Oracle Warehouse Builder (OWB): Oracle LSH uses the OWB Java Server and schema for running and tracking internal and external jobs. Oracle LSH uses the following custom OWB operators:

• The OWB PL/SQL operator communicates with SQL*Plus, which runs many of the internal processes in Oracle LSH as well as user-developed PL/SQL Programs.
• The OWB Workflow operator communicates with Oracle Workflow.
• The OWB Distributed Processing (DP) Server operator communicates with external processing engines to run jobs in external technologies.

Oracle Thesaurus Management System (TMS) : Oracle LSH classification system is based on TMS.