Patent ID: 8185546

Claim:
A computer implemented method of processing queries in database systems, said method comprising: providing a plurality of tables in a database system to store data, wherein said plurality of tables are provided based on a storage contained in said database system; responding, from said database system, to SQL (structured query language) queries received from external client systems and directed to said plurality of tables, wherein said responding is based on data in said plurality of tables as corresponding responses to the SQL queries; receiving in said database system, from a first client system, an explicit indication indicating that an information in said plurality of tables of said database system is to be loaded into a cache contained in said database system; examining said plurality of tables provided based on said storage to determine said information; storing said information in said cache as a response to said receiving said explicit indication; receiving, after receipt of said explicit indication, a first request from said first client system, said first request specifying a first query to be performed in said database system; determining in said database system, that said information is required for performing said first query; forming in said database system, a result of said first query based on said information in said cache; and sending to said first client system, said result as a response to said first request, wherein said first client system and said database system are implemented as separate systems, and wherein said first client system sends said explicit indication in response to determining that said information is required for processing said first query in said database system.