Invention Grant
- Patent Title: Static query optimization
- Patent Title (中): 静态查询优化
-
Application No.: US13167498Application Date: 2011-06-23
-
Publication No.: US09251204B2Publication Date: 2016-02-02
- Inventor: Jesse Collins , Jaikumar Bathija , John F. O'Brien
- Applicant: Jesse Collins , Jaikumar Bathija , John F. O'Brien
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Blakely, Sokoloff, Taylor & Zafman
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
In some embodiments, a computer-implemented method for tuning queries for a multi-tenant database system is provided. A processor retrieves actual statistics associated with data stored on one or more servers in the multi-tenant database system. The data may be associated with one or more tenants of the multi-tenant database system. A subset of the actual statistics is selected, wherein the subset of the actual statistics is related to tenants having a data trait targeted for optimization. The processor determines synthetic statistics based on the subset of the actual statistics. An original query is received at the multi-tenant database system, wherein the original query operates upon data associated with a tenant that has the data trait targeted for optimization. The processor determines an optimal query plan based on the original query and synthetic statistics. Finally, the processor executes the original query based on the optimal query plan.
Public/Granted literature
- US20110320435A1 STATIC QUERY OPTIMIZATION Public/Granted day:2011-12-29
Information query