公开(公告)号：WO2019067964A1

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

申请号：PCT/US2018/053523

申请日：2018-09-28

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： MACNICOL, Roger ,  HUA, Xia ,  HOLLOWAY, Allison ,  CHAVAN, Shasank ,  KAMP, Jesse ,  COLGAN, Maria ,  LAHIRI, Tirthankar

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.

公开(公告)号：EP3688611A1

公开(公告)日：2020-08-05

申请号：EP18792664.7

申请日：2018-09-28

Applicant: Oracle International Corporation

Inventor： MACNICOL, Roger ,  HUA, Xia ,  HOLLOWAY, Allison ,  CHAVAN, Shasank ,  KAMP, Jesse ,  COLGAN, Maria ,  LAHIRI, Tirthankar

IPC: G06F16/00