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:
Mar. 02, 2021
Filed:
Jun. 08, 2015
Oracle International Corporation, Redwood Shores, CA (US);
Dmitry Mikhailovich Potapov, Emerald Hills, CA (US);
Krishnan Meiyyappan, Fremont, CA (US);
Alexander Tsukerman, Foster City, CA (US);
Kothanda Umamageswaran, Sunnyvale, CA (US);
Semen Ustimenko, Sunnyvale, CA (US);
Wei Zhang, Foster City, CA (US);
Adrian Tsz Him Ng, Redwood City, CA (US);
Daniel McClary, San Francisco, CA (US);
Allen Brumm, Foster City, CA (US);
James Stenoish, San Francisco, CA (US);
Robert K. Abbott, Andover, MA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A storage system communicatively coupled to a database management system (DBMS performs storage-side scanning of data sources that are not stored in native database storage format of the DBMS. Data sources for external tables are accessible in a storage system referred to as a distributed data access system (DDAS), e.g. a Hadoop Distributed File System. To execute a query that references an external table, a DBMS first generates an execution plan. The DDAS supplies the DBMS with information that specifies each portion of the data source, and specifies which data node to use to access the portion. The DBMS sends a request for each portion to the respective data node, requesting that the data node generate rows from data in the portion. The request may specify scanning criteria, specifying one or more columns to project and/or filter on, and code modules for the data node to execute to generate records.