Forcedotcom数据定义和存储.docxVIP

FData Definition and StorageF数据定义和存储陈宪刚Chief Architect Mail：chenwpp@原文：F_Multitenancy_WP_101508F没有尝试去管理应用和租户的大规模、经常变化的数据结构，而是采用了一套元数据、数据和透视表的方式管理“虚拟的”数据结构。如下图所示：Rather than attempting to manage a vast,everchanging set of actual database structures on behalf of each applicationand tenant, the F storage model manages “virtual”database structures using a set of metadata,data, and pivot tables, as illustrated in Figure 4.在企业自定义应用对象（也就是自定义表）时，UDD跟踪对象的元数据、字段、关系以及其他属性。同时，用大数据表来存储所有虚拟表的结构化和非结构化的数据，用一套相互关联的、特定用途的透视表来维护去序列化的数据，从而使合并后的数据集更加实用。When organizations create custom application objects(i.e., custom tables), the UDD keeps track of metadata concerning the objects,their fields, relationships, and other object definition characteristics.Meanwhile, a few large database tables store the structured and unstructured datafor all virtual tables, and a set of related,specialized pivot tables maintain denormalized data that makes the combined data set extremely functional.图5是一张简化的ER图，描述了支撑F平台的三个核心实体的元数据和数据结构：即对象（Objects）、字段（Fields）和数据表（Data tables）。说明:为了简单起见，本文没有使用F系统中实际的表名和列名。Figure 5 is a simplified entity-relationship (ER) diagram of three core F metadata and data structures that enable this approach:the Objects, Fields, and Data tables.Note: For brevity andclarity, the actual names of F system tables and columns are not necessarilycited in this paper.The Objects Metadata Table对象元数据表对象元数据表存的是企业应用自定义对象（表或者实体）的信息，包括对象的唯一标识符，对象所属的企业编号，还有对象名称。The Objectsmetadata table stores information about the custom objects (a.k.a. tables or entities)that an organization defines for an application, including a unique identifierfor an object (ObjID), the organization (OrgID) that owns the object, and thename given to the object (ObjName).The Fields Metadata Table字段元数据表字段元数据表存储了对象的字段（或者叫列或属性）信息，包括字段的唯一标识，对象所属的企业编号、字段名称、字段数据类型、一个布尔型值来标识字段是索引字段，以及字段的相对位置。The Fields metadata table stores information about thecustom fields (a.k.a. columns or attributes) that an organization defines for customobject