Performing in-memory columnar analytic queries on externally resident data
US11675761B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 19, 2018 |
| Grant date | Jun 13, 2023 |
| Priority date | — |
| Expiry date | Mar 2, 2042 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/256
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques herein use in-memory column vectors to process data that is external to a database management system (DBMS) and logically join the external data with data that is native to the DBMS. In an embodiment, a computer maintains a data dictionary for native data that is durably stored in an DBMS and external data that is not durably stored in the DBMS. From a client through a connection to the DBMS, the computer receives a query. The computer loads the external data into an in-memory column vector that resides in random access memory of the DBMS. Based on the query and the data dictionary, the DBMS executes a data join of the in-memory column vector with the native data. To the client through said connection, the computer returns results of the query based on the data join.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.