introduction to Siebel for Oracle DBA's
Siebel is a customer relationship management (CRM) system.
Siebel supports the following databases: Microsoft SQL Server, IBM DB2 and Oracle.
Siebel has a logical data model consisting of many entities and relationships.
The physical database schema (in Siebel 7.8 SIA) consists of 3,920 tables and 20,042 indexes.
The data model may be extended to suit business requirements
- adding columns to existing tables
- creating additional tables
- defining (non-unique) indexes
Siebel base tables (and indexes) are prefixed 'S_'.
EIM tables (and indexes) are prefixed 'EIM_'.
Custom columns on base tables are always prefixed 'X_'.
Custom tables and indexes (created in Siebel Tools) are always prefixed 'CX_'