The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jun. 13, 2023
Filed:
Sep. 19, 2018
Oracle International Corporation, Redwood Shores, CA (US);
Roger Dermot Macnicol, Stevens, PA (US);
Xia Hua, Mountain View, CA (US);
Allison Holloway, San Carlos, CA (US);
Shasank Kisan Chavan, Menlo Park, CA (US);
Jesse Kamp, Castro Valley, CA (US);
Maria Colgan, Menlo Park, CA (US);
Tirthankar Lahiri, Palo Alto, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
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.