METHOD, SYSTEM, AND COMPUTER PROGRAM PRODUCT FOR MANAGING A MULTI-TENANT DATABASE SYSTEM
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
43 Claims
-
1-25. -25. (canceled)
-
26. A multi-tenant database system, comprising:
-
a customer relationship management database having one or more data tables, wherein one or more of the data tables describe a customer and a purchase order; 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 user requests to the application server. - View Dependent Claims (27, 28, 29, 30, 31)
-
-
32. A computer program product, 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 purchase order; 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 user requests to the application server using a load balancer associated with the application server. - View Dependent Claims (33, 34, 35, 36, 37)
-
-
38. A method, 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 purchase order; 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 user requests to the application server using a load balancer associated with the application server. - View Dependent Claims (39, 40, 41, 42, 43)
-
Specification