Virtual function as query operator

Patent metadata

Field	Value
Publication number	US-11487779-B2
Application number	US-201414533277-A
Country	US
Kind code	B2
Filing date	Nov 5, 2014
Priority date	Nov 5, 2014
Publication date	Nov 1, 2022
Grant date	Nov 1, 2022

Abstract

A system includes definition of a remote data source, definition of a virtual function specifying executable job code, a return data format and a data location in the remote data source, reception of a structured language query including the virtual function as a data source, and, in response to the received query, instruction of the remote data source to execute the job code based on data in the data location and return data in the return data format.

First claim

What is claimed is:

1. A system comprising:
a memory storing processor-executable program code; and
a processor to execute the processor-executable program code in order to cause the computing system to:
define a remote data source;
define a virtual function, the virtual function specifying a return structured data format and a location of an unstructured file stored in the remote data source;
receive a structured language query, where the virtual function is a parameter of a FROM clause of the query; and
in response to the received query, retrieve the unstructured file from the remote data source, data of the file retrieved from the remote data source being returned in the return structured data format specified by the virtual function.

2. A system according to claim 1 , wherein return of the data of the file in the specified return data format comprises a return of the data in columnar and compressed format.

3. A system according to claim 1 , wherein the virtual function specifies executable job code and a data location in the remote data source, and
wherein, in response to the received query, the remote data source is instructed to execute the executable job code based on data in the data location.

4. A system according to claim 1 , wherein the virtual function specifies executable code of a plurality of jobs and a sequence of the plurality of jobs, and
wherein, in response to the received query, the remote data source is instructed to execute the executable code of the plurality of jobs according to the sequence.

5. A system comprising:
a memory storing processor-executable program code; and
a processor to execute the processor-executable program code in order to cause the computing system to:
define a remote data source;
define a virtual function, the virtual function specifying executable job code, a return structured data format and an unstructured file data location in the remote data source;
receive a structured language query, where the virtual function is a parameter of a FROM clause of the query; and
in response to the received query, instruct the remote data source to execute the executable job code based on data in the specified unstructured file data location and return data including results of the execution in the return structured data format specified by the virtual function.

6. A system according to claim 5 , wherein the returned data is in columnar and compressed format.

7. A system according to claim 5 , wherein the virtual function specifies executable code of a plurality of jobs and a sequence of the plurality of jobs, and
wherein, in response to the received query, the remote data source is instructed to execute the executable code of the plurality of jobs according to the sequence.

8. A non-transitory computer-readable medium storing program code, the program code executable by a processor of a computing system to cause the computing system to:
define a remote data source;
define a virtual function, the virtual function specifying a return structured data format and a location of an unstructured file stored in the remote data source;
receive a structured language query, where the virtual function is a parameter of a FROM clause of the query; and
in response to the received query, retrieve the unstructured file from the remote data source, data of the file retrieved from the remote data source being returned in the return structured data format specified by the virtual function.

9. A medium according to claim 8 , wherein return of the data of the file in the specified return data format comprises a return of the data in columnar and compressed format.

10. A medium according to claim 9 , wherein the virtual function specifies executable job code and a data location in the remote data source, and
wherein, in response to the received query, the remote data source is instructed to execute the executable job code based on data in the data location.

11. A medium according to claim 9 , wherein the virtual function specifies executable code of a plurality of jobs and a sequence of the plurality of jobs, and
wherein, in response to the received query, the remote data source is instructed to execute the executable code of the plurality of jobs according to the sequence.

Assignees

• Knezevic Sinisa
• Nikolova Petya
• Luo Shasha
• Maheshwari Nitesh
• P Shahul Hameed
• Du Haiyan
• Quaye George
• Sap Se

Inventors

• Knezevic Sinisa
• Nikolova Petya
• Luo Shasha
• Maheshwari Nitesh
• P Shahul Hameed
• Du Haiyan
• Quaye George

Classifications

• G06F16/258 Primary

  Data format conversion from or to a database · CPC title

• G06F16/24568

  Data stream processing; Continuous queries · CPC title