Multi-tenant database system
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.
Claims18
A system for optimizing database queries in a multi-tenant database system, comprising:
- a processor coupled to a memory;
- a customer relationship management database having one or more data tables, wherein one or more of the data tables describe a customer and a sale associated with the customer;
- a statistics generating module configured to generate tenant-level statistics for one or more tenants for the one or more data tables;
- a query optimization module, configured to optimize a database query based on the tenant level statistics;
- an application server configured to execute customer relationship management software applications, wherein the application server stores to, and retrieves from customer data from the customer relationship management database;
- and
- a load balancer associated with the application server to route requests to the application server.
A computer program code embodied on a non-transitory computer readable medium for optimizing database queries in a multi-tenant database system, comprising:
- computer code for generating tenant-level statistics for one or more tenants for one or more data tables of a customer relationship management database of a multi-tenant database system, wherein at least one of the data tables describe a customer and a sale associated with the customer;
- computer code for optimizing a database query based on the tenant-level statistics;
- computer code for executing customer relationship management software applications, wherein an application server stores to, and retrieves from customer data from the customer relationship management database;
- and
- computer code for routing requests to the application server using a load balancer associated with the application server.
A method for optimizing database queries in a multi-tenant database system, comprising:
- generating tenant-level statistics for one or more tenants for one or more data tables of a customer relationship management database of a multi-tenant database system, wherein at least one of the data tables describe a customer and a sale associated with the customer;
- optimizing a database query based on the tenant-level statistics;
- executing customer relationship management software applications, wherein an application server stores to, and retrieves from customer data from the customer relationship management database;
- and
- routing requests to the application server using a load balancer associated with the application server.
Dependencies are inferred from the claim text.