May 2008
Intermediate to advanced
100 pages
55m
English
book
The Force.com Multitenant Architecture: Understanding the Design of Salesforce.com’s Internet Application Development Platform
by Salesforce.com
Content preview from The Force.com Multitenant Architecture: Understanding the Design of Salesforce.com’s Internet Application Development Platform
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
The Relationships Pivot Table
Force.com provides “relationship” datatypes that an organization can use to declare relationships (referential integrity) among application objects. When an organization declares an object’s field with a relationship type, the platform maps the field to a Value field in the Data table, and then uses this field to store the ObjID of a related object.
To optimize join operations, Force.com maintains a pivot table called Relationships, as depicted in Figure 8.
Figure 8. The Relationship table helps optimize object joins.
The Relationships index table has two underlying database unique composite indexes (OrgID+GUID, ...