Method, system, and computer program product for optimizing a multi-tenant database system
View Patent ↗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.
1. A multi-tenant database system, comprising:
a customer relationship management database having one or more data tables; and
an optimization engine which reads data from at least one of the one or more data tables and stores metadata in the customer relationship management database, wherein the metadata is tracked in order to make choices about query access paths and for gathering statistics information regarding a number of rows to which a user has access.
2. The system of claim 1 , wherein the customer relationship management database structure is fixed.
3. The system of claim 1 , wherein the multi-tenant database system is configured to keep tenant's data separate unless the data is shared.
4. The system of claim 1 , wherein the customer relationship management database contains a plurality of customizable fields.
5. The system of claim 1 , wherein the multi-tenant database system implements at least one protocol that keeps applications and application use separate.
6. A computer program product embodied on a non-transitory computer readable medium, comprising:
computer code for reading data from one or more data tables of a customer relationship management database; and
computer code for storing metadata in the customer relationship management database;
wherein the metadata is tracked in order to make choices about query access paths and for gathering statistics information regarding a number of rows to which a user has access.
7. The computer program product of claim 6 , wherein the customer relationship management database structure is fixed.
8. The computer program product of claim 6 , wherein the multi-tenant database system is configured to keep tenant's data separate unless the data is shared.
9. The computer program product of claim 6 , wherein the customer relationship management database contains a plurality of customizable fields.
10. The computer program product of claim 6 , wherein the multi-tenant database system implements at least one protocol that keeps applications and application use separate.
11. A method, comprising:
reading data from one or more data tables of a customer relationship management database; and
storing metadata in the customer relationship management database;
wherein the metadata is tracked in order to make choices about query access paths and for gathering statistics information regarding a number of rows to which a user has access.
12. The method of claim 11 , wherein the customer relationship management database structure is fixed.
13. The method of claim 11 , wherein the multi-tenant database system is configured to keep tenant's data separate unless the data is shared.
14. The method of claim 11 , wherein the customer relationship management database contains a plurality of customizable fields.
15. The method of claim 11 , wherein the multi-tenant database system implements at least one protocol that keeps applications and application use separate.