Custom multi-tenant non-relational platform objects

• US 10,380,094 B2
• Filed: 09/30/2016
• Issued: 08/13/2019
• Est. Priority Date: 09/30/2016
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Warshavsky, Alex, Torman, Adam, Levine, Eli, Fernando, Jan Asita, Jain, Samarpan
• Primary Examiner(s): Woo, Isaac M
• Application Number:
  US15/283,130
• Publication Number:
  US 20180096013A1
• Time in Patent Office: 1,047 Days
• Field of Search: 707755
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/2291 User-Defined Types; Storage management thereof

Abstract

Disclosed are examples of systems, apparatus, methods and computer program products for creating custom platform objects for a multi-tenant non-relational database environment. A database system maintains a multi-tenant non-relational database associated with multiple enterprises and a number of records for each of the enterprises. The system also maintains a dynamic virtual table associated with a number of records. A request is received from one of the enterprises to define a custom data object within the database system, uniquely associated with an enterprise. The request is processed, and a custom object is generated based on the request. The custom object defines database columns corresponding to the data object and the enterprise. The virtual table is updated to include virtual columns corresponding to the database column definitions, and existing columns of a shared table in the non-relational database are updated to match the virtual columns. Access to the existing columns is then restricted for enterprises not uniquely associated with the custom data object.

Claims

1. A database system comprising:

a processor; and

a memory storing instructions configurable to cause the database system to;

maintain a multi-tenant non-relational database for a plurality of tenant enterprises, the multi-tenant non-relational database storing a plurality of records for the enterprises;

maintain a dynamic virtual table associated with the records for the enterprises;

process a request from one of the enterprises to define a custom data object within the database system, the request indicating at least an enterprise ID uniquely identifying the requesting enterprise and identifying one or more attributes of the custom data object;

generate a custom object script based on the request, the custom object script defining one or more database columns in the database system that correspond to the custom data object, the unique enterprise ID, and the one or more attributes;

update the dynamic virtual table to include one or more virtual columns corresponding to the one or more database columns defined by the custom object script;

update one or more existing columns of a table shared by the enterprises in the multi-tenant non-relational database to match the one or more virtual columns; and

restrict access to the one or more existing columns of the shared table for enterprises not associated with the unique enterprise ID.

2. The system of claim 1, wherein the custom object script is associated with the unique enterprise ID.

3. The system of claim 1, wherein the custom data object is an extension of a standard shared object.

4. The system of claim 1, wherein the request from the requesting enterprise identifies one or more primary key columns associated with the custom data object.

5. The system of claim 4, wherein the one or more primary key columns corresponds to the unique enterprise ID.

6. The system of claim 1, the instructions further configurable to cause the database system to:

provision access to the one or more existing columns of the shared table for the requesting enterprise.

7. The system of claim 1, the instructions further configurable to cause the database system to:

add one or more records to the shared table, the one or more records associated with the unique enterprise ID and the one or more existing columns of the shared table.

8. The system of claim 1, the instructions further configurable to cause the database system to:

associate the one or more existing columns of the shared table with one or more privacy settings, the one or more privacy settings determining a visibility of the one or more existing columns.

9. The system of claim 1, wherein the one or more attributes are custom attributes defined by the enterprise.

10. The system of claim 1, wherein the request identifies a correlation ID attribute defined by the enterprise, the correlation ID attribute configurable to aggregate data associated with one or more columns of the shared table.

11. A method comprising:

maintaining a multi-tenant non-relational database for a plurality of tenant enterprises, the multi-tenant non-relational database storing a plurality of records for the enterprises;

maintaining a dynamic virtual table associated with the records for the enterprises;

processing a request from one of the enterprises to define a custom data object within a database system, the request indicating at least an enterprise ID uniquely identifying the requesting enterprise and identifying one or more attributes of the custom data object;

generating a custom object script based on the request, the custom object script defining one or more database columns in the database system that correspond to the custom data object, the unique enterprise ID, and the one or more attributes;

updating the dynamic virtual table to include one or more virtual columns corresponding to the one or more database columns defined by the custom object script;

updating one or more existing columns of a table shared by the enterprises in the multi-tenant non-relational database to match the one or more virtual columns; and

restricting access to the one or more existing columns of the shared table for enterprises not associated with the unique enterprise ID.

12. The method of claim 11, wherein the custom object script is associated with the unique enterprise ID.

13. The method of claim 11, wherein the custom data object is an extension of a standard shared object.

14. The method of claim 11, further comprising:

adding one or more records to the shared table, the one or more records associated with the unique enterprise ID and the one or more existing columns of the shared table.

15. The method of claim 11, further comprising:

associating the one or more existing columns of the shared table with one or more privacy settings, the one or more privacy settings determining a visibility of the one or more existing columns.

16. The method of claim 11, wherein the one or more attributes are custom attributes defined by the enterprise.

17. The method of claim 11, wherein the request identifies a correlation ID attribute defined by the enterprise, the correlation ID attribute configurable to aggregate data associated with one or more columns of the shared table.

18. A computer program product comprising computer-readable program code capable of being executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code comprising instructions configurable to cause:

maintaining a multi-tenant non-relational database for a plurality of tenant enterprises, the multi-tenant non-relational database storing a plurality of records for the enterprises;

maintaining a dynamic virtual table associated with the records for the enterprises;

processing a request from one of the enterprises to define a custom data object within a database system, the request indicating at least an enterprise ID uniquely identifying the requesting enterprise and identifying one or more attributes of the custom data object;

generating a custom object script based on the request, the custom object script defining one or more database columns in the database system that correspond to the custom data object, the unique enterprise ID, and the one or more attributes;

updating the dynamic virtual table to include one or more virtual columns corresponding to the one or more database columns defined by the custom object script;

updating one or more existing columns of a table shared by the enterprises in the multi-tenant non-relational database to match the one or more virtual columns; and

restricting access to the one or more existing columns of the shared table for enterprises not associated with the unique enterprise ID.

19. The computer program product of claim 18, wherein the one or more attributes are custom attributes defined by the enterprise.

20. The computer program product of claim 18, wherein the request identifies a correlation ID attribute defined by the enterprise, the correlation ID attribute configurable to aggregate data associated with one or more columns of the shared table.