Method, system, and computer program product for optimizing a database query
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 optimizing database queries 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 database query;
- and
- optimizing the database query based on the tenant-level statistics.
A system of optimizing database queries in a multi-tenant database system comprising:
- a memory coupled to a processor;
- 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 database query;
- and
- logic for optimizing the database query based on the tenant-level statistics.
A computer program product embodied on a non-transitory storage medium of optimizing database queries in a multi-tenant database system, 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 computer program product comprising:
- computer code 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;
- computer code for receiving a database query;
- and
- computer code for optimizing the database query based on the tenant-level statistics.
Dependencies are inferred from the claim text.