Dynamic creation and maintenance of multi-column custom indexes for efficient data management in an on-demand services environment
US10776336B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Nov 4, 2016 |
| Grant date | Sep 15, 2020 |
| Priority date | — |
| Expiry date | Jan 18, 2038 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24578
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.