Sap Se

Shasha Luo

Shahul Hameed P

Sinisa Knezevic

Petya Nikolova

Nitesh Maheshwari

Haiyan Du

George Quaye

Engin Dogusoy

Paul Hermens

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.

Virtual function as query operator

Disclosed herein are system, method, and computer program product embodiments for a massively parallel processing (MPP) database system. The embodiments disclosed herein more quickly retrieve results from computer nodes configured to process and store distributed datasets. An embodiment operates by utilizing a middleware adapter residing in a server to send queries to a middleware controller residing in a database cluster. The queries are parsed and delivered as sub-queries to computer nodes within the database cluster. In an embodiment, sub-queries represent a query plan for faster execution. In an embodiment, the queries are also functionally translated to provide more operators than available solely based on the database cluster context. After a computer node completes the execution of a sub-query, the result is delivered directly to the middleware adapter without the need to wait for other sub-queries to complete execution.

Massively parallel processing database middleware connector

A system includes reception of a client query identifying data stored by a remote data source, generation of a remote query of the remote data source based on the client query, determination of a cache name based on the remote query, determination of whether the remote data source comprises a cache associated with the cache name and, if it is determined that the remote data source comprises a valid cache associated with the cache name, instruction of the remote data source to read the data of the cache, and reception of the data of the cache from the remote data source.

Remote materialization of low velocity data

Growing community of inventors

Sunnyvale, CA, United States of America

Shasha Luo