Method, system, and computer program product for querying in a multi-tenant database
Assigneesalesforce.com, inc.
InventorsCraig Weissman, Dave Moellenhoff, Simon Wong, Paul Nakada
Life of this patent
Estimating the term…
Abstract
More efficient querying of a multi-tenant database using dynamic tuning of database indices. A layer of meta-data associates data items with tenants, e.g., via tags, and the meta-data is used to optimize searches by channeling processing resources during a query to only those pieces of data bearing the relevant tenant's unique tag.
Claims21
A method of querying in a multi-tenant database, the database having one or more data tables, each table having one or more logical columns defining data categories and one or more logical rows associated with a plurality of tenants, the method comprising:
- generating tenant-level statistics from data stored in each of the data tables, the data stored in the data tables comprising tenant-specific data, and the data tables being stored in one database;
- receiving a SQL query;
- and
- optimizing the SQL query based on the tenant-level statistics.
A multi-tenant database system comprising:
- a database having one or more data tables, each table having one or more logical columns defining data categories and one or more logical rows associated with a plurality of tenants;
- logic for generating tenant-level statistics from data stored in each of the data tables, the data stored in the data tables comprising tenant-specific data, and the data tables being stored in one database;
- logic for receiving a SQL query;
- and
- logic for optimizing the SQL query based on the tenant-level statistics.
A computer program product, comprising a non-transitory computer-readable medium having a computer readable program code embodied therein, the computer readable program code adapted to be executed by a processor to implement a method for querying in a multi-tenant database, the database having one or more data tables, each table having one or more logical columns defining data categories and one or more logical rows associated with a plurality of tenants, the method comprising:
- generating tenant-level statistics from data stored in each of the data tables, the data stored in the data tables comprising tenant-specific data, and the data tables being stored in one database;
- receiving a SQL query;
- and
- optimizing the SQL query based on the tenant-level statistics.
Dependencies are inferred from the claim text.