公开(公告)号：US11675761B2

公开(公告)日：2023-06-13

申请号：US16135748

申请日：2018-09-19

Applicant: Oracle International Corporation

Inventor： Roger Dermot Macnicol ,  Xia Hua ,  Allison Holloway ,  Shasank Kisan Chavan ,  Jesse Kamp ,  Maria Colgan ,  Tirthankar Lahiri

IPC: G06F16/22 ,  G06F16/2458 ,  G06F16/2455 ,  G06F16/25 ,  G06F16/21 ,  G06F16/248

CPC classification number: G06F16/221 ,  G06F16/219 ,  G06F16/2237 ,  G06F16/248 ,  G06F16/2455 ,  G06F16/2456 ,  G06F16/2471 ,  G06F16/256

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.