Distributed consistent grid of in-memory database caches
    3.
    发明授权
    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.

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

    CONSISTENT CLIENT-SIDE CACHE
    6.
    发明申请
    CONSISTENT CLIENT-SIDE CACHE 有权
    一致的客户端缓存

    公开(公告)号:US20080098173A1

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

    申请号:US11875782

    申请日:2007-10-19

    IPC分类号: G06F12/00 G06F17/30

    CPC分类号: G06F17/3048

    摘要: A method, system, and computer program product is disclosed for caching results in a client-side cache. Embodiments of a method, a system, and a computer program product are disclosed that associate a first snapshot of a database with a client that indicates a state of the database after a last database request by the client, and indicate any number of invalid cached results in the client cache for the client based upon the first snapshot. In some embodiments, the method further includes receiving a second snapshot that indicates a state of the database upon receipt of a database server request by the client, and updating the first snapshot with the second snapshot.

    摘要翻译: 公开了用于在客户端缓存中缓存结果的方法,系统和计算机程序产品。 公开了一种方法,系统和计算机程序产品的实施例,其将数据库的第一快照与客户端相关联,客户端在客户端的最后一个数据库请求之后指示数据库的状态,并指示任何数量的无效缓存结果 在基于第一个快照的客户端缓存中。 在一些实施例中,该方法还包括接收第二快照,其指示在客户端收到数据库服务器请求时指示数据库的状态,以及使用第二快照更新第一快照。

    Methods and systems for identifying highly contended blocks in a database
    8.
    发明申请
    Methods and systems for identifying highly contended blocks in a database 审中-公开
    用于识别数据库中高度竞争的块的方法和系统

    公开(公告)号:US20060224594A1

    公开(公告)日:2006-10-05

    申请号:US11099272

    申请日:2005-04-04

    IPC分类号: G06F17/30

    CPC分类号: G06F16/2308

    摘要: A computer-implemented method of generating a list of K most frequently accessed ones of a plurality of data blocks in a database may include steps of selecting the number K; building the list of K blocks by storing an identification of and maintaining a running count for up to selected K ones of the data blocks by iteratively carrying out a single step for each of the plurality of data blocks, the single step being selected from an incrementing step to increment the count, a decrementing step to decrement the count, an adding step to add a data block to the list and to set a count of the added data block and a replacing step to replace an existing data block of the list with a new data block and to set a count of the new data block, and providing the list of K most frequently accessed blocks.

    摘要翻译: 在数据库中生成多个数据块中最频繁访问的K的列表的计算机实现的方法可以包括选择数字K的步骤; 通过对多个数据块中的每一个迭代地执行单个步骤,通过存储对于所选数据块中所选择的K个数据块的运行计数的识别和维持来建立K个块的列表,该单个步骤从增量 逐步增加计数,减少计数的递减步骤,添加步骤,将数据块添加到列表中,并设置添加的数据块的计数,以及替换步骤,用一个替换步骤来替换该列表的现有数据块 新数据块并设置新数据块的计数,并提供K个最常访问块的列表。

    Time model
    10.
    发明申请
    Time model 有权
    时间模型

    公开(公告)号:US20050055672A1

    公开(公告)日:2005-03-10

    申请号:US10775513

    申请日:2004-02-09

    IPC分类号: G06F9/44

    摘要: Quantifying the impact of wasteful operations on a database system is provided. One or more operations that are determined to be wasteful are received. The impact of the wasteful operations on performance in a database may then be quantified. The database is monitored to determine when a wasteful operation is being performed. When a wasteful operation is detected, a time value is recorded of the time spent on processing the wasteful operation. The time value is stored and used to quantify an impact of a performance problem in a database. The time value may be stored and associated with other time values that are recorded for the same wasteful operation. Thus, the impact of wasteful operations that are performed and processed in a database may be determined.

    摘要翻译: 提供了浪费操作对数据库系统的影响。 接收到被确定为浪费的一个或多个操作。 然后可以量化浪费操作对数据库中的性能的影响。 监视数据库以确定何时执行浪费的操作。 当检测到浪费的操作时,记录处理浪费操作花费的时间的时间值。 时间值被存储并用于量化数据库中性能问题的影响。 时间值可以被存储并且与为相同的浪费操作记录的其他时间值相关联。 因此,可以确定在数据库中执行和处理的浪费操作的影响。