Definitions

Siebel Repository- The metadata where the Siebel configuration is stored (including schema object definitions).

Logical Schema- The description of the schema objects as defined in the Siebel Repository.

Physical Schema- The actual schema as defined in the underlying database.

Table Types- Siebel CRM tables can be divided into a few categories.

Type	Description	"Type" as defined in the Siebel Repository
EIM	Staging tables for getting data into or out of the Siebel base tables. There is typically at least one EIM table for every frequently-used base table.	Interface
Base	Tables in which "end-user" data would appear. Examples include customer accounts, opportunities, or service requests.	Data (Public) and Data (Intersection)
System	Tables that support the infrastructure of the behavior of the product, such as the Server Request tables, Siebel Remote Transaction Logs, etc.	Data (Private)
Repository	The tables in which the Repository metadata is stored.	Repository

Data Definition Language (DDL)- This refers to SQL statements that can change the physical schema of the data, such as creating new tables or indexes, adding columns to tables, etc. DDL statements are issued at specific times, such as immediately after making a change in the logical schema, or during an Upgrade, Update, or Migration.

Data Manipulation Language (DML)- This refers to SQL statements that change the data within the database, such as creating, modifying, or deleting a new account, service request, or opportunity record. DML is constantly being executed as users use the system and are updating their data.

CRUD- This is an acronym for the four types of DML statements: Create, Read, Update, and Delete.