Patent ID: 7779039
Filing Date: 2010-08-17
Classification: G06F,G06Q

Abstract:
1. A computer-implemented method of storing multiple tables for one or more tenants in a single data structure, comprising: defining a data structure having a primary key column, an organization id column and a plurality of data columns; defining a first table for a first tenant, said first table having a first data field, said first data field having a first data type, and said first tenant having a first tenant id; assigning a first table id to the first table; defining a second table for the first tenant, said second table having a second data field, said second data field having a second data type different from the first data type; and assigning a second table id to the second table; wherein when records are created for the first table, for each created record: wherein when records are created for the second table, for each created record: wherein the first and second tables of the first tenant are stored in the data structure, and said single data column includes data values having said first and second data types; defining a third table for a second tenant, said third table having a third data field, said third data field having a third data type, and said second tenant having a second tenant id; and assigning a third table id to the third table; wherein when records are created for the third table, for each created record: wherein the third table is stored in the data structure; wherein said single data column includes data values having said first and second data types and said third data type; wherein the first and second table ids are different; and wherein the third table id is the same as one of the first and second table ids.