公开(公告)号：US20190102412A1

公开(公告)日：2019-04-04

申请号：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: G06F17/30

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.