首页>
外国专利>
Method and apparatus for caching result sets from queries to a remote database in a heterogeneous database system
Method and apparatus for caching result sets from queries to a remote database in a heterogeneous database system
展开▼
机译:在异构数据库系统中用于将结果集从查询缓存到远程数据库的方法和装置
展开▼
页面导航
摘要
著录项
相似文献
摘要
A method enables a data manipulation action to occur between data from a data source and data in a table in a database, where the database is remote from the data source. The method includes the steps of: determining whether data from the data source comprises unique values, and if not, enabling a caching procedure. The caching procedure obtains values from the data source and transmits a query to a database management system which controls the table, including a value from the data source. A result set is received from the table, is cached, and additionally is stored for purposes of responding to the query. Thereafter, if a value from the data source is retrieved which is identical to a previously retrieved data source value, the cached corresponding result set is utilized, in lieu of transmitting a further query to the table.
展开▼