Systems and methods for pruning external data
US11397729B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Nov 19, 2021 |
| Grant date | Jul 26, 2022 |
| Priority date | — |
| Expiry date | Nov 19, 2041 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/256
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Disclosed herein are systems and methods for pruning external data. In an embodiment, a database platform receives a query directed at least in part to external data in an external table on an external data storage platform. The external table includes partitions that correspond to storage locations in a source directory of the external data storage platform. The storage locations contain files that contain the external data. The database platform identifies, from external-table metadata that is stored by the database platform and that maps the partitions of the external table to the storage locations in the source directory, a subset of the partitions as including data that potentially satisfies the query. The database platform identifies data that satisfies the query by scanning the identified subset of the partitions, and responds to the query at least in part with the identified data that satisfies the query.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.