Patent ID: 9710516
Date: 2017-07-18
CPC Classifications: G06F

Claim:
1. A system comprising: a first computing system comprising: a first data storage device storing a local database table comprising a plurality of columns and defined by a first schema; a first memory storing first processor-executable program code; and a first processor to execute the first processor-executable program code in order to cause the first computing system to: receive a client query including a JOIN between the local database table and a remote table of a second computing system; transmit an instruction comprising (i) a create table statement and (ii) a select statement to the second computing system to define a new table in the second computing system based on the create table statement, the new table comprising the plurality of columns and defined by the first schema, wherein the new table is associated with a storage handler for retrieving data of the local database table and wherein the select statement is for retrieving data from the local database table; generate a remote query of the second computing system, the remote query including a second JOIN between the new table and the remote table; transmit the remote query to the second computing system; and receive results of the remote query from the second computing system.