PRIORITIZING REPOPULATION OF IN-MEMORY COMPRESSION UNITS
    13.
    发明申请
    PRIORITIZING REPOPULATION OF IN-MEMORY COMPRESSION UNITS 有权
    内存压缩单元的重新排列

    公开(公告)号:US20160085834A1

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

    申请号:US14823393

    申请日:2015-08-11

    CPC classification number: G06F17/30339 G06F17/30377 G06F17/30578

    Abstract: To prioritize repopulation of in-memory compression units (IMCU), a database server compresses, into an IMCU, a plurality of data units from a database table. In response to changes to any of the plurality of data units within the database table, the database server performs the steps of: (a) invalidating corresponding data units in the IMCU; (b) incrementing an invalidity counter of the IMCU that reflects how many data units within the IMCU have been invalidated; (c) receiving a data request that targets one or more of the plurality of data units of the database table; (d) in response to receiving the data request, incrementing an access counter of the IMCU; and (e) determining a priority for repopulating the IMCU based, at least in part, on the invalidity counter and the access counter.

    Abstract translation: 为了优先重新填充内存中的压缩单元(IMCU),数据库服务器从数据库表将多个数据单元压缩到IMCU中。 响应于对数据库表内的多个数据单元中的任一个的改变,数据库服务器执行以下步骤:(a)使IMCU中的相应数据单元无效; (b)增加反映IMCU内有多少数据单位无效的IMCU的无效计数器; (c)接收针对所述数据库表的所述多个数据单元中的一个或多个的数据请求; (d)响应于接收到数据请求,递增IMCU的访问计数器; 以及(e)至少部分地基于无效计数器和访问计数器确定重新填充IMCU的优先级。

    Versioning and non-disruptive servicing of in-memory units in a database

    公开(公告)号:US10572469B2

    公开(公告)日:2020-02-25

    申请号:US15169013

    申请日:2016-05-31

    Abstract: Techniques for non-disruptive versioning of in-memory units in a database are provided. A database server generates and maintains a first IMU that reflects changes made to a mirrored-data-set up to a first snapshot time, and a second IMU that reflects changes made to the mirrored-data-set up to a second snapshot time. During a first period, the database server responds to updates to first data items in the mirrored data by storing first staleness metadata that indicates that the copies of the first data items in the first IMU are stale. During a second period, the database server responds to updates to second data items in the mirrored data by storing second staleness metadata that indicates that the copies of the second data items in the second IMU are stale. The database server responds to a request by accessing the first IMU or the second IMU.

    Multi-version concurrency control on in-memory snapshot store of oracle in-memory database
    19.
    发明授权
    Multi-version concurrency control on in-memory snapshot store of oracle in-memory database 有权
    oracle内存数据库的内存中快照存储的多版本并发控制

    公开(公告)号:US09128972B2

    公开(公告)日:2015-09-08

    申请号:US14337183

    申请日:2014-07-21

    Abstract: Techniques are provided for maintaining data persistently in one format, but making that data available to a database server in more than one format. For example, one of the formats in which the data is made available for query processing is based on the on-disk format, while another of the formats in which the data is made available for query processing is independent of the on-disk format. Data that is in the format that is independent of the disk format may be maintained exclusively in volatile memory to reduce the overhead associated with keeping the data in sync with the on-disk format copies of the data.

    Abstract translation: 提供的技术用于以一种格式持续保持数据,但使数据库可以以多种格式提供给数据库服务器。 例如,数据可用于查询处理的格式之一是基于磁盘格式,而数据可用于查询处理的其他格式与磁盘格式无关。 独立于磁盘格式的格式的数据可以专门保存在易失性存储器中,以减少与保持数据与数据的磁盘格式副本同步的开销。

Patent Agency Ranking