Back to results
US 9,286,343 B2Granted
Statistics mechanisms in multitenant database environments
Assigneesalesforce.com, inc.
InventorsHoon Kim, Jesse Collins, Chirag Rajan
Life of this patent
Estimating the term…
Abstract
Statistics mechanisms in multitenant database environments. A master statistics file is maintained in a multitenant database system. The master statistics file has statistics corresponding to multiple tenants within the multitenant database system. Statistics for a selected table within the multitenant database system are generated. The selected table corresponding to a selected tenant of the multitenant database system. The master statistics file is updated based on the generated statistics for the selected table.
Claims18
A method comprising:
- maintaining a master statistics file in a multitenant environment, the master statistics file having statistics corresponding to multiple tenants within the multitenant environment;
- parsing the master statistics file into an object having an ordered grouping of statistical information corresponding to one or more selected tables stored in a single database within the multitenant environment;
- generating statistics for a table, the table corresponding to a selected tenant of the multitenant environment, the table from the one or more selected tables;
- and
- updating the master statistics file based on the generated statistics for the table.
2 more elements
An apparatus comprising:
- means for maintaining a master statistics file in a multitenant environment, the master statistics file having statistics corresponding to multiple tenants within the multitenant environment;
- means for parsing the master statistics file into an object having an ordered grouping of statistical information corresponding to one or more selected tables stored in a single database within the multitenant environment;
- means for generating statistics for a table, the table corresponding to a selected tenant of the multitenant environment, the table from the one or more selected tables;
- and
- means for updating the master statistics file based on the generated statistics for the table.
2 more elements
A system comprising:
- one or more user computing systems;
- a server computing system communicatively coupled with the one or more user computing systems via a network, the server computing system to provide a multitenant environment, wherein the multitenant environment includes data for multiple client entities, each identified by a tenant identifier (ID) having one of one or more users associated with the tenant ID, users of each of multiple client identities can only access data identified by a tenant ID associated with the respective client entity, and the multitenant environment is at least a hosted database provided by an entity separate from the client entities, and provides on-demand database service to the client entities, the server system further to
- maintain a master statistics file in a multitenant environment, the master statistics file having statistics corresponding to multiple tenants within the multitenant environment;
- parse the master statistics file into an object having an ordered grouping of statistical information corresponding to one or more selected tables stored in a single database within the multitenant environment;
- generate statistics for a table, the table corresponding to a selected tenant of the multitenant environment, the table from the one or more selected tables;
- and
- update the master statistics file based on the generated statistics for the table.
4 more elements
Dependencies are inferred from the claim text.