×

Statistics management for database querying

  • US 8,577,870 B2
  • Filed: 06/15/2012
  • Issued: 11/05/2013
  • Est. Priority Date: 06/21/2011
  • Status: Active Grant
First Claim
Patent Images

1. A method of obtaining data from a multi-tenant database, the method comprising:

  • modifying a development database representative of the multi-tenant database based on expected utilization information for a tenant supported by the multi-tenant database;

    generating model database statistics based on the development database after modifying the development database, wherein generating the model database statistics comprises;

    obtaining a subset of database statistics determined by a database management system of the development database after modifying the development database;

    creating the model database statistics having values representative of an anticipated state of the multi-tenant database based at least in part on the obtained subset of the database statistics determined by the database management system of the development database; and

    providing the model database statistics to the multi-tenant database by modifying on-demand database statistics maintained by the multi-tenant database to reflect the model database statistics, a query optimizer of the multi-tenant database generating a query plan based on the on-demand database statistics, wherein the query plan generated by the multi-tenant database to obtain the data is influenced by the model database statistics.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×