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.

Abstract: 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.

Abstract: Disclosed herein are system, method, and computer program product embodiments for a data processing redistribution system. An embodiment operates by an in-memory database, that includes a portion of data from a remote database, receiving a request to perform a procedure on a portion of data of the remote. A remote processor having access to the portion of data is identified to execute the procedure. The result data is then received from the remote processor and provided to an application responsive to the request.

Abstract: Disclosed herein are system, method, and computer program product embodiments for a massively parallel processing (MPP) database system. The embodiments disclosed herein may be used to 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.

Abstract: Disclosed herein are system, method, and computer program product embodiments for a data processing redistribution system. An embodiment operates by an in-memory database, that includes a portion of data from a remote database, receiving a request to perform a procedure on a portion of data of the remote. A remote processor having access to the portion of data is identified to execute the procedure. The result data is then received from the remote processor and provided to an application responsive to the request.

Abstract: A system includes reception of a client query including a JOIN between a local database table of a first computing system and a remote table of a second computing system, transmission of an instruction to the second computing system to define a new table in the second computing system, the new table associated with a storage handler for retrieving data of the local database table, generation of a remote query of the second computing system, the remote query including a second JOIN between the new table and the remote table, transmission of the remote query to the second computing system, and reception of results of the remote query from the second computing system.

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.

Abstract: A system includes reception of a client query including a JOIN between a local database table of a first computing system and a remote table of a second computing system, transmission of an instruction to the second computing system to define a new table in the second computing system, the new table associated with a storage handler for retrieving data of the local database table, generation of a remote query of the second computing system, the remote query including a second JOIN between the new table and the remote table, transmission of the remote query to the second computing system, and reception of results of the remote query from the second computing system.

Abstract: 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.

Abstract: 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.