SYSTEMS AND METHODS FOR ANALYZING OPERATIONS IN A MULTI-TENANT DATABASE SYSTEM ENVIRONMENT

• US 20110302212A1
• Filed: 01/10/2011
• Published: 12/08/2011
• Est. Priority Date: 06/07/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Agrawal, Sonali, Macklem, Walter, Mathew, Reena, Wong, Simon Y.
• Granted Patent: US 9,053,231 B2
• Time in Patent Office: Days
• US Class Current: 707/793
• CPC Class Codes: G06F 11/3636 by tracing the execution of the program
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/24565 Triggers; Constraints

Abstract

A system and method for analyzing operations in a multi-tenant database system environment is provided. The system may include a database storing tenant application data and common application data, the tenant application data and common application data controlling a creation, read, update, deletion or undeletion of an object in the multi-tenant database system environment. The system may further include a processor to analyze the tenant application data and common application data to identify therein where the object is being modified, and generate a report identifying potential errors or side effects which may affect the object based upon the analyzed tenant application data and common application data

Claims

1. A system for analyzing operations in a multi-tenant database system environment, comprising:

a database storing tenant application data specific to one of a plurality of tenants of the multi-tenant database system and storing common application data common to the plurality of tenants of the multi-tenant database system, the tenant application data and common application data controlling a modification of an object in the multi-tenant database system environment; and

a processor to;

analyze the tenant application data and common application data to identify therein where the object is being modified, and

generate a report identifying potential errors which may affect the object based upon how the object is being modified by the tenant application data and common application data.

2. The system of claim 1, wherein the generated report identifies a pre-trigger rule associated with the object.

3. The system of claim 2, wherein the pre-trigger rule is one of a customer written validation rule and a system validation rule which validates a data field associated with the object before the object is saved.

4. The system of claim 1, wherein the generated report identifies a post-trigger rule associated with the object.

5. The system of claim 4, wherein the post-trigger rule is one of an assignment rule, a workflow rule and an escalation rule which causes an action after the object is saved.

6. The system of claim 5, wherein the action is an update to the object.

7. The system of claim 5, wherein the action is creation, read, update, deletion or undeletion of a second object.

8. The system of claim 1, wherein the generated report identifies a recursive save of the object.

9. The system of claim 1, wherein the modification is one of a creation, read, update, deletion or undeletion operation on the object.

10. A method for analyzing operations in a multi-tenant database system environment by a processor, comprising:

identifying an object in the multi-tenant database system environment;

analyzing common application data common to a plurality of tenants of the multi-tenant database system to identify system rules which affect the object before and after the object is saved;

analyzing tenant application data specific to a tenant of the multi-tenant database system to identify tenant rules which affect the object before and after the object is saved; and

generating a report identifying areas in the common application data and tenant application data where the object is affected.

11. The method of claim 10, further comprising identifying a pre-trigger rule which validates a data field associated with the object before the object is saved.

12. The method of claim 11, further comprising identifying a post-trigger rule which causes an action after the object is saved.

13. The method of claim 12, wherein the action is an update to the object.

14. The method of claim 11, wherein the action is creation, read, update, deletion or undeletion of a second object.

15. The method of claim 10, further comprising identifying a recursive save of the object.

16. The method of claim 10, further comprising parsing the respective application data to identify to identify system and tenant rules which affect the object before and after the object is saved.

17. The method of claim 12, further comprising determining a processing time associated with each pre-trigger rule and post trigger rule,

wherein the generating a report further comprises reporting the determined processing time associated with each pre-trigger rule and post trigger rule.

18. A user interface for visualizing create, read, update, delete and undelete (“

CRUD”

) operations affecting an object in a multi-tenant database system environment, comprising;

an interface for selecting an object;

an interface for selecting at least one of the CRUD operations to analyze; and

an interface for causing the generation of a report identifying where in the multi-tenant database system the selected object is affected by the selected CRUD operation.

19. The user interface of claim 18, wherein the report provides a link to tenant specific code or tenant common code where the selected object is affected by the selected CRUD operation.

20. The user interface of claim 18, wherein the user interface is presented to an administrator of the multi-tenant database system.