Patents Represented by Attorney Kilpatrick Townsend LLP
  • Patent number: 8112445
    Abstract: Systems and methods for hosting variable schema data such as dynamic tables and columns in a fixed physical database schema. Standard objects, such as tables are provided for use by multiple tenants or organizations in a multi-tenant database system. Each organization may add or define custom fields for inclusion in a standard object. Custom fields for multiple tenants are stored in a single field within the object data structure, and this single field may contain different data types for each tenant. Indexing columns are also provided, wherein a tenant may designate a field for indexing. Data values for designated fields are copied to an index column, and each index column may include multiple data types. Each organization may also define custom objects including custom fields and indexing columns. Custom objects for multiple tenants are stored in a single custom object data structure.
    Type: Grant
    Filed: April 21, 2010
    Date of Patent: February 7, 2012
    Assignee: salesforce.com, inc.
    Inventors: Craig Weissman, Simon Wong