Generating an index for a table in a database background
US10489367B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Oct 19, 2015 |
| Grant date | Nov 26, 2019 |
| Priority date | — |
| Expiry date | May 1, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2272
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Embodiments of the present invention disclose a method, computer program product, and system for generating and manipulating an index for a table in a database. A query statement is received, the table of lines are searched, a result list is generated, and an index for the query statement is generated, wherein the index comprises information associated with the result list and the query condition. The query condition and the identifier of the table is extracted from the query statement, where the index is generated based on the query condition, the identifier of the table, and the result list. A hash value of the identifier of the table and the query condition is obtained, an association between the hash value and the result list to build the index is generated, and in response to a line of the plurality of lines in the table being modified, the index identified as invalid.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.