Tuesday, February 5, 2008

DATA MODEL and PARTY(1 to 4)

1. Explain briefly about Table.
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.
Table Prefixes
EIM_ Interface tables for Enterprise Integration Manager.
S_ Siebel base table. (Exception: Tables with names of the form
S__IF are Obsolete interface tables.)
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_.

2 comments:

crackingsiebel.com said...

Hi All

For an enhanced introduction to Siebel Party Data Model, including its importance and Database characteristics, please refer the post at - http://crackingsiebel.com/2012/06/15/siebel-party-model-introduction/

If you want to know about Siebel Party Model - History and its impact on database architecture, please read out article at - http://crackingsiebel.com/2012/06/22/siebel-party-model-history/

To understand the concept of Parties, Party Types and their relationships in siebel, please refer to my post at CrackingSiebel: http://crackingsiebel.com/2012/06/29/siebel-party-model-party-and-party-types/

Regards
SS

crackingsiebel.com said...

Interested to know about Party Data Model in depth, including Practice Labs and details diagrams???

Click on to - http://crackingsiebel.com/2013/02/19/siebel-ebook-party-data-model/

Thanks
SS

Siebel Basics and FAQs