METHOD AND SYSTEM FOR ACCESSING A REMOTE DATABASE USING PASS-THROUGH QUERIES

A method for accessing a database server using pass-through queries includes parsing a database query to separate a pass-through string, and then sending a pass-through string to retrieve information regarding the structure of a remote table. The method further includes fetching data as needed from the remote table, and caching the remote data in a temporary table in memory of the local computer system. The system includes a query processor to compile the database query, a remote engine to retrieve table structure information and fetch data as needed, and a temporary table manager to manage caching of the fetched data.