Patent ID: 8402044

Claim:
A computer-implemented method comprising: receiving a first query in a local computer system to access a first plurality of data stored on a remote computer system and a second plurality of data stored on the local computer system, wherein one or more first data elements of the first plurality of data are associated with one or more second data elements of the second plurality of data, wherein the first plurality of data comprises non-sensitive data, wherein the second plurality of data comprises sensitive data; transforming the first query to produce a second query and a third query, the second query to apply against the first plurality of data stored on the remote computer system; sending the second query from the local computer system to the remote computer system, wherein a first data result from the first plurality of data is retrieved on the remote computer system in response to the second query; receiving the first data result from the remote computer system in the local computer system, the first data result including the one or more first data elements; storing the first data result on the local computer system; incorporating the one or more first data elements from the first data result into the third query, the third query comprising one or more first query elements of the first query and the one or more first data elements of the first data result, wherein the one or more first query elements of the first query reference the sensitive data, wherein the one or more first data elements of the first data result reference the non-sensitive data; executing the third query on the local computer system against the second plurality of data and the first data result, wherein a second data result is retrieved in response to the third query; and returning the second data result in response to the first query.