Invention Grant
US09589036B2 Query-level access to external petabyte-scale distributed file systems
有权
查询级访问外部PB级分布式文件系统
- Patent Title: Query-level access to external petabyte-scale distributed file systems
- Patent Title (中): 查询级访问外部PB级分布式文件系统
-
Application No.: US13564204Application Date: 2012-08-01
-
Publication No.: US09589036B2Publication Date: 2017-03-07
- Inventor: Robert Hanckel , Garret Swart
- Applicant: Robert Hanckel , Garret Swart
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Vista IP Law Group, LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A system to implement query-level access by a database engine to an external distributed file system by identifying a results file location of one or more results files on the external distributed file system, and storing the results file locations in external table files on the database engine for subsequent use during retrieval of data from the results files. The database engine serves to process queries where the query specifies the external table (which in turn references locations of the results files). Execution of the query streams data from the external distributed file system into the database engine. The data from the external distributed file system is not stored in the external table files on the database engine; rather, the external table files specify a location of code or operational directives which, when executed, streams results from the external distributed file system to at least one parallel query engine.
Public/Granted literature
- US20140040310A1 QUERY-LEVEL ACCESS TO EXTERNAL PETABYTE-SCALE DISTRIBUTED FILE SYSTEMS Public/Granted day:2014-02-06
Information query