QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM

• US 20130246472A1
• Filed: 05/02/2013
• Published: 09/19/2013
• Est. Priority Date: 09/23/2003
• Status: Abandoned Application

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Weissman, Craig, Moellenhoff, Dave, Wong, Simon, Nakada, Paul
• Application Number:
  US13/886,223
• Publication Number:
  US 20130246472A1
• Time in Patent Office: Days
• US Class Current: 707/783
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 16/2462 Approximate or statistical queries
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99939 Privileged access

Abstract

The present invention provides techniques for managing process space on a multi-tenant database system that features a method that provides to multiple users of two or more organizations, over a network, access to information stored in a database repository shared by the two or more organizations. The database repository implements security protocols to restrict a set of first users to a first sub-portion of the information. The set of first users belongs to one of the two or more organizations. The first sub-portion of the information is different from a second sub-portion accessible by users from another organization. Access of the information by the multiple users is monitored. A first processing space for the set of first users is generated in response to the access of the database repository. The first processing space is distinct from a second processing space for the users from the other organization.

Claims

1. A method, comprising:

over a network, providing, to multiple users from two or more organizations, access to information stored in a database repository shared by the two or more organizations, wherein the database repository implements security protocols to restrict a set of first users to a first sub-portion of the information, the set of first users belonging to one of the two or more organizations and the first sub-portion of the information is different from a second sub-portion accessible by users from another organization;

monitoring the access of the information by the multiple users; and

generating a first processing space for the set of first users in response to the access of the database repository, the first processing space being distinct from a second processing space for the users from the other organization.

2. The method as recited in claim 1 wherein the generating further includes augmenting a pool of servers available to the multiple users.

3. The method as recited in claim 1 wherein the generating further includes diminishing a pool of servers available to the multiple users.

4. A machine-readable medium carrying one or more sequences of instructions which when executed by one or more processors cause the one or more processors to carry out steps of:

over a network, providing, to multiple users from two or more organizations, access to information stored in a database repository shared by the two or more organizations, wherein the database repository implements security protocols to restrict a set of first users to a first sub-portion of the information, the set of first users belonging to one of the two or more organizations and the first sub-portion of the information being different from a second sub-portion accessible by users from another organization;

monitoring the access of the information by the multiple users; and

generating a first processing space for the set of first users in response to the access of the database repository, the first processing space being distinct from a second processing space for the users from the other organization.

5. The machine-readable medium of claim 10 wherein the instructions to carry out the step of generating further includes instructions to carry out a step of augmenting a pool of servers available to the multiple users.

6. The machine-readable medium of claim 10 wherein the instructions to carry out the step of generating further includes instructions to carry out a step of diminishing a pool of servers available to the multiple users.

7. A data center, comprising:

a processor; and

a memory space having a sequence of instructions which, when executed by the processor, causes the processor to carry out the steps of;

over a network, providing, to multiple users from two or more organizations, access to information stored in a database repository shared by the two or more organizations, wherein the database repository implements security protocols to restrict a set of first users to a first sub-portion of the information, the set of first users belonging to one of the two or more organizations and the first sub-portion of the information being different from a second sub-portion accessible by users from an other organization;

monitoring the access of the information by the multiple users; and

generating a first processing space for the set of first users in response to the access of the database repository, the first processing space being distinct from a second processing space for the users from the other organization.