Invention Grant
- Patent Title: Dynamic creation and maintenance of multi-column custom indexes for efficient data management in an on-demand services environment
-
Application No.: US15344326Application Date: 2016-11-04
-
Publication No.: US10776336B2Publication Date: 2020-09-15
- Inventor: Rohitashva Mathur
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Jaffery Watson Mendonsa & Hamilton LLP
- Main IPC: G06F16/20
- IPC: G06F16/20 ; G06F16/22 ; G06F16/2455 ; G06F16/2457

Abstract:
A method, system, and apparatus provide for multiple custom fields associated with an application running at a computing device, where the multiple custom fields are received in a specified sort order. The method includes dynamically building multi-column indexes of the multiple custom fields corresponding to multiple intrinsic datatypes stored in multiple custom field columns of a shared table, where the multiple intrinsic datatypes are converted into a generic-indexable datatype to preserve the specified sort order. The method further includes building a sorted index in a specified order in a multi-column indexable table, where the multi-column indexable table includes a partial copy of data from multiple tenants that inhibit the shared table.
Public/Granted literature
Information query