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

    公开(公告)号:US20140280373A1

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

    申请号:US13842843

    申请日:2013-03-15

    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.

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

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

    公开(公告)号:US20110072217A1

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

    申请号:US12562928

    申请日:2009-09-18

    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.

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

    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

    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

    公开(公告)号:US09063962B2

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

    申请号:US13842843

    申请日:2013-03-15

    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.