Statistics mechanisms in multitenant database environments
First Claim
Patent Images
1. 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.
1 Assignment
0 Petitions
Accused Products
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.
138 Citations
18 Claims
-
1. 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. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. 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. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. 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. - View Dependent Claims (14, 15, 16, 17, 18)
-
Specification