Invention Grant
- Patent Title: Query optimization in a multi-tenant database system
- Patent Title (中): 多租户数据库系统中的查询优化
-
Application No.: US12760975Application Date: 2010-04-15
-
Publication No.: US08423535B2Publication Date: 2013-04-16
- Inventor: Craig Weissman , Dave Moellenhoff , Simon Wong , Paul Nakada
- Applicant: Craig Weissman , Dave Moellenhoff , Simon Wong , Paul Nakada
- 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:
The present invention provides techniques for storing information on a multi-tenant database system to control query latency that includes a method that stores the information on the database among a plurality of tables arranged in columns and rows. For each of a subset of the plurality of tables, sets of the rows are distributed amongst different storage nodes on the database, with the set of rows stored at a common node having a common index value. Data storage and retrieval capabilities to the database are provided to allow access to the information, in response to requests from one of a plurality of remotely disposed computer systems. The retrieval capability includes a query condition that includes a query index value, with the query condition and the query index value being established to control retrieval latency. Also disclosed is a machine-readable medium carrying one or more sequences of instructions for storing information on a multi-tenant database system to control query latency when executed by one or more processors and cause the one or more processors to carry out steps of the method. A data center for storing information on a multi-tenant database system to control query latency is also disclosed that carries-out the functions of the method.
Public/Granted literature
- US20100274779A1 QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM Public/Granted day:2010-10-28
Information query