Per-segment secondary indexing in database systems
US11822532B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 24, 2021 |
| Grant date | Nov 21, 2023 |
| Priority date | — |
| Expiry date | Mar 24, 2041 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2379
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A database system operates by: receiving a user-generated secondary indexing hint data for a dataset from a client device, wherein the client device generated the user-generated hint data based on user input in response to at least one prompt displayed by an interactive interface displayed via a display device of the client device; generating a plurality of segments that each include distinct subsets of a plurality of rows of a dataset; automatically selecting, for each of the plurality of segments, a secondary indexing scheme from a plurality of secondary indexing options based on the user-provided secondary indexing hint data; generating a plurality of secondary indexes for each of the plurality of segments in accordance with the corresponding secondary indexing scheme; and storing the plurality of segments and the plurality of secondary indexes in memory.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.