利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

14 条记录 (耗时 0.04 秒)

    Distributed Consistent Grid of In-Memory Database Caches
    5.
    发明申请
    Distributed Consistent Grid of In-Memory Database Caches 有权
    内存数据库缓存的分布式一致网格

    公开(公告)号：US20110072217A1

    公开(公告)日：2011-03-24

    申请号：US12562928

    申请日：2009-09-18

    申请人： Chi Hoang ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang ,  John Miller ,  Dilys Thomas ,  Nagender Bandi ,  Susan Cheng

    发明人： Chi Hoang ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang ,  John Miller ,  Dilys Thomas ,  Nagender Bandi ,  Susan Cheng

    IPC分类号： G06F12/08 ,  G06F12/00

    CPC分类号： G06F17/30312 ,  G06F12/084

    摘要： A plurality of mid-tier databases form a single, consistent cache grid for data in a one or more backend data sources, such as a database system. The mid-tier databases may be standard relational databases. Cache agents at each mid-tier database swap in data from the backend database as needed. Consistency in the cache grid is maintained by ownership locks. Cache agents prevent database operations that will modify cached data in a mid-tier database unless and until ownership of the cached data can be acquired for the mid-tier database. Cache groups define what backend data may be cached, as well as a general structure in which the backend data is to be cached. Metadata for cache groups is shared to ensure that data is cached in the same form throughout the entire grid. Ownership of cached data can then be tracked through a mapping of cached instances of data to particular mid-tier databases.

    摘要翻译： 多个中间层数据库形成用于一个或多个后端数据源（例如数据库系统）中的数据的单一，一致的高速缓存网格。 中间层数据库可以是标准关系数据库。 每个中间层数据库的缓存代理根据需要从后端数据库交换数据。 高速缓存网格中的一致性由所有权锁定维护。 高速缓存代理阻止数据库操作，将修改中间层数据库中的缓存数据，除非可以为中间层数据库获取缓存数据的所有权。 缓存组定义可以缓存哪些后端数据，以及要缓存后端数据的一般结构。 共享缓存组的元数据，以确保数据在整个网格中以相同的格式进行缓存。 然后可以通过将缓存的数据实例映射到特定中间层数据库来跟踪缓存数据的所有权。

    AUTOMATICALLY DETERMINING AN OPTIMAL DATABASE SUBSECTION
    6.
    发明申请
    AUTOMATICALLY DETERMINING AN OPTIMAL DATABASE SUBSECTION 有权
    自动确定最佳数据库选择

    公开(公告)号：US20140280373A1

    公开(公告)日：2014-09-18

    申请号：US13842843

    申请日：2013-03-15

    申请人： John Raitto ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang

    发明人： John Raitto ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30292 ,  G06F17/30442 ,  G06F17/30463 ,  G06F17/30575

    摘要： A method, apparatus, and system for automatically determining an optimal database subsection is provided. A database subsection is selected to optimize certain benefits when the database subsection is translated, transferred, and cached on an alternative database system, which may utilize a different technology or database engine that provides certain performance benefits compared to the original database system. Algorithms such as multi-path greedy selection and/or dynamic programming may provide optimal or near-optimal results. A host for the alternative database server may be shared with or otherwise located in close physical proximity to improve latency for a database application or client layer. Once the database subsection analysis is completed, a report may be generated and presented to the user, and an implementation script may also be created to automatically configure a client host to function as a cache or replacement system according various cache size configurations described in the report.

    摘要翻译： 提供了一种用于自动确定最佳数据库子部分的方法，装置和系统。 当数据库部分被翻译，传输和缓存在替代数据库系统上时，选择数据库子部分来优化某些优点，替代数据库系统可以利用与原始数据库系统相比提供某些性能优势的不同技术或数据库引擎。 诸如多路径贪心选择和/或动态规划的算法可以提供最佳或接近最佳的结果。 替代数据库服务器的主机可以与物理接近处于共享状态或以其他方式设置，以改善数据库应用程序或客户端层的延迟。 一旦完成了数据库子部分分析，就可以生成报告并呈现给用户，还可以创建实现脚本，以便根据报告中描述的各种缓存大小配置自动配置客户端主机作为缓存或替换系统。 。

    Distributed consistent grid of in-memory database caches
    7.
    发明授权
    Distributed consistent grid of in-memory database caches 有权
    分布式一致的内存数据库缓存网格

    公开(公告)号：US08401994B2

    公开(公告)日：2013-03-19

    申请号：US12562928

    申请日：2009-09-18

    申请人： Chi Hoang ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang ,  John Miller ,  Dilys Thomas ,  Nagender Bandi ,  Susan Cheng

    发明人： Chi Hoang ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang ,  John Miller ,  Dilys Thomas ,  Nagender Bandi ,  Susan Cheng

    IPC分类号： G06F17/00

    CPC分类号： G06F17/30312 ,  G06F12/084

    摘要： A plurality of mid-tier databases form a single, consistent cache grid for data in a one or more backend data sources, such as a database system. The mid-tier databases may be standard relational databases. Cache agents at each mid-tier database swap in data from the backend database as needed. Consistency in the cache grid is maintained by ownership locks. Cache agents prevent database operations that will modify cached data in a mid-tier database unless and until ownership of the cached data can be acquired for the mid-tier database. Cache groups define what backend data may be cached, as well as a general structure in which the backend data is to be cached. Metadata for cache groups is shared to ensure that data is cached in the same form throughout the entire grid. Ownership of cached data can then be tracked through a mapping of cached instances of data to particular mid-tier databases.

    摘要翻译： 多个中间层数据库形成用于一个或多个后端数据源（例如数据库系统）中的数据的单一，一致的高速缓存网格。 中间层数据库可以是标准关系数据库。 每个中间层数据库的缓存代理根据需要从后端数据库交换数据。 高速缓存网格中的一致性由所有权锁定维护。 高速缓存代理阻止数据库操作，将修改中间层数据库中的缓存数据，除非可以为中间层数据库获取缓存数据的所有权。 缓存组定义可以缓存哪些后端数据，以及要缓存后端数据的一般结构。 共享缓存组的元数据，以确保数据在整个网格中以相同的格式缓存。 然后可以通过将缓存的数据实例映射到特定中间层数据库来跟踪缓存数据的所有权。

    Automatically determining an optimal database subsection
    8.
    发明授权
    Automatically determining an optimal database subsection 有权

    公开(公告)号：US09063962B2

    公开(公告)日：2015-06-23

    申请号：US13842843

    申请日：2013-03-15

    申请人： John Raitto ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang

    发明人： John Raitto ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang

    IPC分类号： G06F17/30

    摘要： A method, apparatus, and system for automatically determining an optimal database subsection is provided. A database subsection is selected to optimize certain benefits when the database subsection is translated, transferred, and cached on an alternative database system, which may utilize a different technology or database engine that provides certain performance benefits compared to the original database system. Algorithms such as multi-path greedy selection and/or dynamic programming may provide optimal or near-optimal results. A host for the alternative database server may be shared with or otherwise located in close physical proximity to improve latency for a database application or client layer. Once the database subsection analysis is completed, a report may be generated and presented to the user, and an implementation script may also be created to automatically configure a client host to function as a cache or replacement system according various cache size configurations described in the report.

    DATABASE SYSTEM WITH DYNAMIC DATABASE CACHING
    9.
    发明申请
    DATABASE SYSTEM WITH DYNAMIC DATABASE CACHING 审中-公开
    具有动态数据库缓存的数据库系统

    公开(公告)号：US20080222111A1

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

    申请号：US12030113

    申请日：2008-02-12

    申请人： Chi Kim Hoang ,  Chih-Ping Wang ,  John Ernest Miller ,  Marie-Anne Neimat ,  Susan Sokeng Cheung

    发明人： Chi Kim Hoang ,  Chih-Ping Wang ,  John Ernest Miller ,  Marie-Anne Neimat ,  Susan Sokeng Cheung

    IPC分类号： G06F7/06

    CPC分类号： G06F16/21

    摘要： A fully transactional mid-tier database system services database transactions. A cache manager dynamically loads database entries from a fully transactional backend-tier database system into the mid-tier database system according to the received database transactions. Time based aging or usage based aging can be assigned to selected tables in the mid-tier database system. Database entries contained in the selected tables are then automatically removed according to assigned aging constraints.

    摘要翻译： 完全事务中层数据库系统服务数据库事务。 高速缓存管理器根据接收的数据库事务，将数据库条目从完全事务后端数据库系统动态加载到中间层数据库系统中。 基于时间的老化或基于使用的老化可以分配给中间层数据库系统中的选定表。 然后根据分配的老化约束自动删除选定表中包含的数据库条目。

    Database system with active standby and nodes
    10.
    发明授权
    Database system with active standby and nodes 有权
    具有活动待机和节点的数据库系统

    公开(公告)号：US08868504B2

    公开(公告)日：2014-10-21

    申请号：US12030094

    申请日：2008-02-12

    申请人： Rohan Aranha ,  Paul Tuck ,  John Ernest Miller ,  Chih-Ping Wang ,  Marie-Anne Neimat ,  Susan Sokeng Cheung

    发明人： Rohan Aranha ,  Paul Tuck ,  John Ernest Miller ,  Chih-Ping Wang ,  Marie-Anne Neimat ,  Susan Sokeng Cheung

    IPC分类号： G06F17/30 ,  G06F17/00

    CPC分类号： G06F17/30289

    摘要： A system includes an active node and a standby node and zero or more replica nodes. Each of the nodes includes a database system, such as an in-memory database system. Client updates applied to the active node are written through to the standby node, and the standby node writes the updates through to a primary database and updates the replica nodes. Commit ticket numbers tag entries in transaction logs and are used to facilitate recovery if either of the active node or the standby node fails. Updates applied to the primary database are autorefreshed to the active node and written through by the active node to the standby node which propagates the updates to the replica nodes. Bookmarks are used to track updated records of the primary database and are used to facilitate recovery if either of the active node or the standby node fails.

    摘要翻译： 系统包括主动节点和备用节点以及零个或多个副本节点。 每个节点包括数据库系统，诸如内存中数据库系统。 应用于主动节点的客户端更新被写入到备用节点，备用节点将更新写入主数据库，并更新副本节点。 提交票号在事务日志中标记条目，并且如果活动节点或备​​用节点中的任一个失败，则用于促进恢复。 应用于主数据库的更新将自动刷新到活动节点，并由主动节点写入到将更新传播到副本节点的备用节点。 书签用于跟踪主数据库的更新记录，并且如果主动节点或备​​用节点中的任一个失败，则用于促进恢复。