公开(公告)号：US20080215580A1

公开(公告)日：2008-09-04

申请号：US12123101

申请日：2008-05-19

申请人： MEHMET ALTINEL ,  Christof Bomhoevd ,  Chandasekaran Mohan ,  Mir Hamid Pirahesh ,  Berthold Reinwald ,  Saileshwar Krishnamurthy

发明人： MEHMET ALTINEL ,  Christof Bomhoevd ,  Chandasekaran Mohan ,  Mir Hamid Pirahesh ,  Berthold Reinwald ,  Saileshwar Krishnamurthy

IPC分类号： G06F17/30

CPC分类号： G06F17/3048 ,  Y10S707/99933

摘要： A local database cache enabling persistent, adaptive caching of either full or partial content of a remote database is provided. Content of tables comprising a local cache database is defined on per-table basis. A table is either: defined declaratively and populated in advance of query execution, or is determined dynamically and asynchronously populated on-demand during query execution. Based on a user input query originally issued against a remote DBMS and referential cache constraints between tables in a local database cache, a Janus query plan, comprising local, remote, and probe query portions is determined. A probe query portion of a Janus query plan is executed to determine whether up-to-date results can be delivered by the execution of a local query portion against a local database cache, or whether it is necessary to retrieve results from a remote database by executing a remote query portion of Janus query plan.

摘要翻译： 提供本地数据库缓存，实现远程数据库的完整或部分内容的持久自适应缓存。 包含本地缓存数据库的表的内容基于每个表进行定义。 表是：在查询执行之前以声明方式和填充方式定义，或者在查询执行期间按需动态和异步地填充表。 基于最初针对远程DBMS发出的用户输入查询和本地数据库高速缓存中的表之间的参考高速缓存约束，确定包括本地，远程和探测查询部分的Janus查询计划。 执行Janus查询计划的探查查询部分以确定是否可以通过对本地数据库高速缓存执行本地查询部分来传递最新结果，或者是否需要通过以下方式从远程数据库检索结果： 执行Janus查询计划的远程查询部分。