Оцените презентацию от 1 до 5 баллов!
Тип файла:
ppt / pptx (powerpoint)
Всего слайдов:
25 слайдов
Для класса:
1,2,3,4,5,6,7,8,9,10,11
Размер файла:
554.50 kB
Просмотров:
96
Скачиваний:
0
Автор:
неизвестен
Слайды и текст к этой презентации:
№1 слайд
Содержание слайда: Module 18: Siebel Party Business Components
№2 слайд
Содержание слайда: Module Objectives
After completing this module you should be able to:
Define a party business component
Describe the role of S_PARTY and its extension tables in storing party business component data
Describe how data is stored differently for non-party business components and party business components
Describe how implicit and explicit joins are used with party business components
Why you need to know:
Party business components are a fundamental element of the application architecture
№3 слайд
Содержание слайда: Business Challenge: Modeling Party Data
Party data is the ubiquitous information found in most RDBMS
Some prominent party types include Contacts, Employees, Positions, Accounts, User Lists, Organizations, and Access Groups
Party types are often related to each other
Employees are related to positions
Positions are related to accounts
Access groups are related to organizations
and so forth
Relationships may be dynamic or ad hoc
A contractor becomes an intern, then an employee
An access group is required for participants of the January 2007 Big Release Roll-Out Event
№4 слайд
Содержание слайда: Business Challenge: Modeling Party Data Continued
Representing these relationships could result in data models that do not have optimal normalization
Multiple records may be created for each relationship
A separate record is created for a contractor, another for an intern, and a third for an employee
A special entity may have to be created for each new ad hoc relationship
№5 слайд
Содержание слайда: Business Solution: Party Business Component
Provides a way to create a network of relationships between party types to reflect changes and complexities in the business environment
Infuses flexibility into the data model
Can establish and change relationships between various party types, as needed
№6 слайд
Содержание слайда: Party Business Components
Are similar to standard business components; they:
Group data according to business logic
Are referenced by applets
Specify access to tables
Have fields that map to columns
№7 слайд
Содержание слайда: Differences Between Party and Non-Party BCs
In standard BCs, most data is stored in the base table
In party BCs, data is stored in extension tables
S_PARTY acts solely as a linking mechanism between types
№8 слайд
Содержание слайда: S_PARTY and Its Extension Tables
Eight prominent S_PARTY extension tables store the data
№9 слайд
Содержание слайда: Commonly Used Party Business Components
Represent a variety of entities that can be arranged into groups related to persons, organizations, or access control
№10 слайд
Содержание слайда: Person-Related Party Business Components
Store their main data in S_CONTACT
May store additional data in S_USER and S_EMP_PER
Serve as logical extension tables
№11 слайд
Содержание слайда: Person-Related Party Business Components Continued
Primarily reference person-related S_PARTY extension tables
№12 слайд
Содержание слайда: Person-Related Party Business Components Continued
A number of person-related business components use these tables
№13 слайд
Содержание слайда: Organization-Related Party Business Components
Store their main data in S_ORG_EXT
May store additional data in S_BU
May include account, division, organization, or household data
№14 слайд
Содержание слайда: Organization-Related Party Business Components Continued
Multiple organization-related business components use these tables
№15 слайд
Содержание слайда: Groupings for Access Control
Represent groupings of party instances
User List
Access Group
Position
№16 слайд
Содержание слайда: Groupings for Access Control Continued
Access Group, User List, and Position are party business components
№17 слайд
Содержание слайда: Example, Relating Party Data
A user list can be associated with persons via the S_PARTY intersection table S_PARTY_PER
There are relationships in S_PARTY
They are represented in S_PARTY_PER
ROW_ID in S_PARTY is used to relate party types
№18 слайд
Содержание слайда: Example, Relating Party Data Continued
An access group can then be networked with those users, or other user lists, or most any other S_PARTY type
Person, User List, Organization and Account party types can be related to an Access List party type
№19 слайд
Содержание слайда: Party Implicit Joins
Used to populate the prominent S_PARTY extension tables
Created automatically for these extension tables
Are similar to implicit joins for standard business components
Do not appear in join object definitions
ROW_ID in base table is always the PK
PAR_ROW_ID in extension is always the FK
№20 слайд
Содержание слайда: Explicit Join: Non-Party Business Component
Data in a party table can be joined into a non-party business component
Example: Bringing account data into the Opportunity business component for display in an Opportunity applet
№21 слайд
Содержание слайда: Explicit Join Definition
References the extension table that contains data of interest
№22 слайд
Содержание слайда: Explicit Join: Another Party Business Component
Uses an explicit join to the party table, and not the implicit one
Example: Bringing parent account data into the Account business component for display in an Account applet
№23 слайд
Содержание слайда: Explicit Join Definition
Select or create an explicit join to the desired S_PARTY extension table
Use a join specification to specify the relationship
№24 слайд
Содержание слайда: Module Highlights
Party types have dynamic or ad hoc relationships
Party BCs create relationships between party types
Party BCs are similar to standard BCs but data is stored in extension tables
Eight prominent S_PARTY extension tables store data
Person-related party BCs store data in S_CONTACT
Organization-related party BCs store data in S_ORG_EXT
Access Group, User List, and Position are party BCs
Party implicit joins populate S_PARTY extension tables
Explicit joins reference extension tables that contain data
№25 слайд
Содержание слайда: Lab
In the lab you will:
Examine how fields in a (non-party) business component map to columns in base and joined tables
Examine how fields in a party business component map to columns in S_PARTY, its extension tables, and joined tables