Methods and systems for utilizing bytecode in an on-demand service environment including providing multi-tenant runtime environments and systems

• US 8,984,009 B2
• Filed: 04/21/2011
• Issued: 03/17/2015
• Est. Priority Date: 04/21/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Fee, Gregory D., Gallagher, William J.
• Primary Examiner(s): Kim, Taelor
• Assistant Examiner(s): Brooks, David T
• Application Number:
  US13/091,353
• Publication Number:
  US 20110264861A1
• Time in Patent Office: 1,426 Days
• Field of Search: None
• US Class Current: 707/783
• CPC Class Codes: G06F 12/0811 with multilevel cache hierarchies
• CPC Class Codes: G06F 12/0866 for peripheral storage systems, e.g. disk cache
• CPC Class Codes: G06F 12/0875 with dedicated cache, e.g. instruction or stack
• CPC Class Codes: G06F 16/172 Caching, prefetching or hoarding of files
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 2209/549 Remote execution
• CPC Class Codes: G06F 2212/45 Caching of specific data in cache memory
• CPC Class Codes: G06F 2212/465 Structured object, e.g. database record
• CPC Class Codes: G06F 8/41 Compilation
• CPC Class Codes: G06F 9/5027 the resource being a machine, e.g. CPUs, Servers, Terminals

Abstract

Execution of code in a multitenant runtime environment. A request to execute code corresponding to a tenant identifier (ID) is received in a multitenant environment. The multitenant database stores data for multiple client entities each identified by a tenant ID having one of one or more users associated with the tenant ID. Users of each of multiple client entities can only access data identified by a tenant ID associated with the respective client entity. The multitenant database is a hosted database provided by an entity separate from the client entities, and provides on-demand database service to the client entities. Source code corresponding to the code to be executed is retrieved from a multitenant database. The retrieved source code is compiled. The compiled code is executed in the multitenant runtime environment. The memory used by the compiled code is freed in response to completion of the execution of the compiled code.

Claims

1. A computer-implemented method for execution of code in a multitenant runtime environment, the method comprising:

receiving a request to execute code corresponding to a tenant identifier (ID) in a multitenant database;

wherein the multitenant database stores data for multiple client entities each identified by a tenant ID having one of one or more users associated with the tenant ID,

wherein users of each of multiple client entities can only access data identified by a tenant ID associated with the respective client entity, and

wherein the multitenant database is a hosted database provided by an entity separate from the client entities, and provides on-demand database service to the client entities;

retrieving source code corresponding to the code to be executed from a multitenant database, wherein the source code is stored as an abstract syntax tree (AST) in a general-purpose distributed memory caching system;

compiling the retrieved source code to generate executable code;

translating the executable code to bytecode;

parsing the bytecode to find a selected portion of the bytecode to service a request;

executing the selected bytecode in the multitenant runtime environment;

freeing memory used by the selected bytecode upon completion of the execution of the selected bytecode so that the selected bytecode is not preserved in the memory after execution of the bytecode.

2. The method of claim 1 wherein freeing the memory used by the selected bytecode in response to completion of the execution of the selected bytecode further comprises copying the selected bytecode to a first level cache memory.

3. The method of claim 2 further comprising copying the selected bytecode from the first level cache memory to a second level cache memory.

4. The method of claim 3 wherein the second level cache memory comprises memcached caching system.

5. The method of claim 2 further comprising:

receiving a subsequent request to execute code corresponding to the selected bytecode stored in the first level cache memory;

retrieving the selected bytecode from the first level cache memory;

executing the selected bytecode in the multitenant runtime environment;

freeing the memory used by the selected bytecode in response to completion of the execution of the selected bytecode.

6. The method of claim 1, wherein the multitenant runtime environment provides a round robin based load balancing strategy.

7. The method of claim 6 wherein the multitenant runtime environment comprises multiple server systems interconnected to receive requests from a load balancer providing the round robin based balancing strategy.

8. A system to provide a multitenant runtime environment for execution of code, the system comprising:

a plurality of interconnected hardware server computing platforms;

a load-balancing agent communicatively coupled with the plurality of server computing platforms, the load balancing agent to receive a request to execute code corresponding to a tenant identifier (ID) in a multitenant environment, the load balancing agent to allocate execution of the code to a selected one of the plurality of server computing platforms;

a multitenant database communicatively coupled to the plurality of server computing platforms and the load-balancing agent wherein the multitenant database stores data for multiple client entities each identified by a tenant ID having one of one or more users associated with the tenant ID, wherein users of each of multiple client entities can only access data identified by a tenant ID associated with the respective client entity, and wherein the multitenant database is a hosted database provided by an entity separate from the client entities, and provides on-demand database service to the client entities;

the selected server computing platform, in response to the allocation from the load-balancing agent, to retrieve source code corresponding to the code to be executed from a multitenant database, wherein the source code is stored as an abstract syntax tree (AST) in a general-purpose distributed memory caching system, to compile the retrieved source code to generate executable code, to translate the executable code to bytecode, to parse the bytecode to find a selected portion of the bytecode to service a request, to execute the selected bytecode in the multitenant runtime environment, and to free memory used by the selected bytecode upon completion of the execution of the selected bytecode so that the selected bytecode is not preserved in the memory after execution of the bytecode.

9. The system of claim 8 wherein freeing the memory used by the selected bytecode in response to completion of the execution of the selected bytecode further comprises the selected server computing platform copying the selected bytecode to a first level cache memory.

10. The system of claim 9 further comprising the selected server computing platform copying the selected bytecode from the first level cache memory to a second level cache memory.

11. The system of claim 10 wherein the second level cache memory comprises memcached caching system.

12. The system of claim 9 further, wherein the selected server computing platform further receives a subsequent request to execute code corresponding to the selected bytecode stored in the first level cache memory, retrieves the selected bytecode from the first level cache memory, executes the selected bytecode in the multitenant runtime environment, and frees the memory used by the selected bytecode in response to completion of the execution of the selected bytecode.

13. The system of claim 8, wherein the load-balancing agent provides a round robin based load balancing strategy.

14. An article of manufacture comprising a non-transitory computer-readable medium having stored thereon instructions to cause one or more processors to provide execution of code in a multitenant runtime environment, the instructions, when executed, causing the one or more processors to:

receive a request to execute code corresponding to a tenant identifier (ID) in a multitenant database;

wherein the multitenant database stores data for multiple client entities each identified by a tenant ID having one of one or more users associated with the tenant ID,

wherein users of each of multiple client entities can only access data identified by a tenant ID associated with the respective client entity, and

wherein the multitenant database is a hosted database provided by an entity separate from the client entities, and provides on-demand database service to the client entities;

retrieve source code corresponding to the code to be executed from a multitenant database, wherein the source code is stored as an abstract syntax tree (AST) in a general-purpose distributed memory caching system;

compile the retrieved source code to generate executable code;

translate the executable code to bytecode;

parse the bytecode to find a selected portion of the bytecode to service a request;

execute the selected bytecode in the multitenant runtime environment;

free memory used by the selected bytecode upon completion of the selected bytecode so that the selected bytecode is not preserved in the memory after execution of the bytecode.

15. The article of claim 14 wherein the instructions that cause the one or more processors to free the memory used by the selected bytecode in response to completion of the execution of the selected bytecode further comprise instructions that, when executed, cause the one or more processors to copy the selected bytecode to a first level cache memory.

16. The article of claim 15 further comprising instructions that, when executed, cause the one or more processors to copy the selected bytecode from the first level cache memory to a second level cache memory.

17. The article of claim 16 wherein the second level cache memory comprises memcached caching system.

18. The article of claim 15 further comprising instructions that, when executed, cause the one or more processors to:

receive a subsequent request to execute code corresponding to the selected bytecode stored in the first level cache memory;

retrieve the selected bytecode from the first level cache memory;

execute the selected bytecode in the multitenant runtime environment;

free the memory used by the selected bytecode in response to completion of the execution of the selected bytecode.

19. The article of claim 14, wherein the multitenant runtime environment provides a round robin based load balancing strategy.

20. The article of claim 19 wherein the multitenant runtime environment comprises multiple server systems interconnected to receive requests from a load balancer providing the round robin based balancing strategy.

21. A system to execute code in a multitenant runtime environment, the system comprising:

means for receiving a request to execute code corresponding to a tenant identifier (ID) in a multitenant database;

wherein the multitenant database stores data for multiple client entities each identified by a tenant ID having one of one or more users associated with the tenant ID,

wherein users of each of multiple client entities can only access data identified by a tenant ID associated with the respective client entity, and

wherein the multitenant database is a hosted database provided by an entity separate from the client entities, and provides on-demand database service to the client entities;

means for retrieving source code corresponding to the code to be executed from a multitenant database, wherein the source code is stored as an abstract syntax tree (AST) in a general-purpose distributed memory caching system;

means for compiling the retrieved source code to generate executable code;

means for translating the executable code to bytecode;

means for parsing the bytecode to find a selected portion of the bytecode to service a request;

means for executing the selected bytecode in the multitenant runtime environment;

means for freeing memory used by the selected bytecode upon completion of the selected bytecode so that the selected bytecode is not preserved in the memory after execution of the bytecode.

22. The system of claim 21 wherein the means for freeing the memory used by the selected bytecode in response to completion of the execution of the selected bytecode further comprise means for copying the selected bytecode to a first level cache memory.

23. The system of claim 22 further comprising means for copying the selected bytecode from the first level cache memory to a second level cache memory.

24. The system of claim 22 further comprising:

means for receiving a subsequent request to execute code corresponding to the selected bytecode stored in the first level cache memory;

means for retrieving the selected bytecode from the first level cache memory;

means for executing the selected bytecode in the multitenant runtime environment;

means for freeing the memory used by the selected bytecode in response to completion of the execution of the selected bytecode.