Database index and database query processing method, apparatus, and device
US11995059B2 · kind B2 · utility
0Cited by
9References
20Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | May 27, 2021 |
| Grant date | May 28, 2024 |
| Priority date | — |
| Expiry date | Aug 24, 2041 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY02D10/00
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method including determining a database table for which a database index is to be created, wherein the database table comprises a spatial field for storing spatial data; acquiring, for the database table, a spatial filter condition comprising a spatial field ID; and generating, according to the spatial filter condition, a tree-structured spatial index for the database table, wherein a leaf node of the tree-structured spatial index stores therein spatial data meeting the spatial filter condition and its primary key ID. The efficiency of queries related to spatial data is thus enhanced.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.