Table object definitions are logical representations in the Siebel repository of the physical tables in the underlying database management system.
2. Explain in brief about the prefixes and suffixes used for tables in Siebel.
EIM_ Interface tables for Enterprise Integration Manager.
S_ Siebel base table. (Exception: Tables with names of the form
W_ Siebel eBusiness Data Warehouse table.
Base Table Suffixes
_ATT File attachment table.
_REL A table that supports a many-to-many relationship from an entity back to itself.
_SS A table that stores Siebel-to-Siebel integration information.
_X One-to-one extension table, available for customers to add attributes to the Siebel database.
_XA A table that stores extended attributes associated with an object class.
_XM One-to-many extension table, available for customers to add attributes to the Siebel database.
3. What are Columns in Siebel?
Column object definitions are representations of the physical columns in the underlying database management system. The name, data type, length, primary key and foreign key status, alias, and other properties of the database column are recorded as properties in the corresponding column object definition.
4. Explain about indexes in Database Management System?
An index object definition is a logical representation of physical index in the underlying database management system. Indexes are used for faster searching of records thereby increasing the performance. Siebel applications include a set of standard indexes and are named with a prefix of S_.