System and method for adaptive database caching
    1.
    发明授权
    System and method for adaptive database caching 有权
    自适应数据库缓存的系统和方法

    公开(公告)号:US07395258B2

    公开(公告)日:2008-07-01

    申请号:US10902583

    申请日:2004-07-30

    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查询计划的远程查询部分。

    System and method for adaptive database caching
    2.
    发明授权
    System and method for adaptive database caching 有权
    自适应数据库缓存的系统和方法

    公开(公告)号:US07945577B2

    公开(公告)日:2011-05-17

    申请号:US12123101

    申请日:2008-05-19

    IPC分类号: G06F17/00

    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查询计划的远程查询部分。

    System and method for adaptive database caching
    3.
    发明申请
    System and method for adaptive database caching 有权
    自适应数据库缓存的系统和方法

    公开(公告)号:US20060026154A1

    公开(公告)日:2006-02-02

    申请号:US10902583

    申请日:2004-07-30

    IPC分类号: G06F17/00

    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查询计划的远程查询部分。

    Integrating Data Resources by Generic Feed Augmentation
    4.
    发明申请
    Integrating Data Resources by Generic Feed Augmentation 审中-公开
    通过通用Feed增强集成数据资源

    公开(公告)号:US20090327323A1

    公开(公告)日:2009-12-31

    申请号:US12163302

    申请日:2008-06-27

    IPC分类号: G06F17/30

    CPC分类号: G06F16/972

    摘要: Data integration in a data processing system is provided. A data mashup specification is received and an interleaved sequence of operations as defined by the data mashup specification is executed. The interleaved sequence of operations comprises at least one of an import operation, an augment operation, or a publish operation. In executing the interleaved sequence of operations a determination is made as to the next operation to execute. An outer context is formed and added to a binding context of the next operation. If the next operation is an import operation, a data resource is imported from a data source and an input generic feed is generated. If the next operation is an augment operation, a set of augmented generic feeds is produced from a set of input generic feeds. If the next operation is a publish operation, a new data resource is produced from a specified augmented generic feed.

    摘要翻译: 提供数据处理系统中的数据集成。 接收数据混搭规范,并执行由数据混搭规范定义的交错操作序列。 交织的操作序列包括导入操作,扩充操作或发布操作中的至少一个。 在执行交织的操作序列时,确定要执行的下一个操作。 形成外部上下文并将其添加到下一个操作的绑定上下文中。 如果下一个操作是导入操作,则从数据源导入数据资源,并生成输入的通用供稿。 如果下一个操作是扩充操作,则从一组输入的通用供稿中产生一组增强的通用供稿。 如果下一个操作是发布操作,则会从指定的增强的通用供稿中生成新的数据资源。

    SYSTEM AND METHOD FOR ADAPTIVE DATABASE CACHING
    5.
    发明申请
    SYSTEM AND METHOD FOR ADAPTIVE DATABASE CACHING 有权
    用于自适应数据库缓存的系统和方法

    公开(公告)号:US20080215580A1

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

    申请号:US12123101

    申请日:2008-05-19

    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查询计划的远程查询部分。