Database memory management in a high availability database system using limits

    公开(公告)号:US10983965B2

    公开(公告)日:2021-04-20

    申请号:US16544739

    申请日:2019-08-19

    Applicant: SAP SE

    Abstract: Receiving a statement including requests for database operations in a secondary database system storing data replicated from a primary database system by replaying transaction output generated by the primary database system; responsive to receiving the statement, requesting an allocation of memory from the secondary database system to support the requested database operations; generating an aggregated statement memory consumption value based on the amount of memory consumed by all statements executing in the secondary database system that are not associated with replaying the transaction logs; determining that the requested allocation of memory in addition to the aggregated statement memory consumption value exceeds a total statement execution memory limit indicating a total amount of memory that may be allocated to all database operations associated with statement execution in a secondary database system, and denying the requested allocation of memory. Related apparatus, systems, techniques and articles are also described.

    DBMS storage management for non-volatile memory

    公开(公告)号:US10241907B2

    公开(公告)日:2019-03-26

    申请号:US15598609

    申请日:2017-05-18

    Applicant: SAP SE

    Abstract: A system includes reception of an instruction to create a data block associated with a portion of a database table in a non-volatile memory system, creation, in response to the instruction to create the data block, of a file associated with the data block in the non-volatile memory system, where a filename of the file comprises an indication that the data block is a temporary block, creation of an entry in a data block map table indicating that the data block is a temporary block, reception of an instruction to commit the data block, and, in response to the instruction to commit the data block, flush data associated with the data block to the file in the non-volatile memory system, rename the file to remove the indication that the data block is a temporary block, and update the entry in the data block map to indicate that the data block is a committed block.

    Method and apparatus for making changes to a quantity for a time interval within a time series

    公开(公告)号:US10068197B2

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

    申请号:US14859006

    申请日:2015-09-18

    Applicant: SAP SE

    Abstract: A method is described that involves providing a persisted quantity for a time series time interval to a first transaction, then, providing the same persisted quantity to a second transaction that operates in parallel with the first transaction. The second transaction is not permitted to change the persisted quantity. The method also involves replacing the persisted quantity with a second persisted quantity within the time series. The second persisted quantity is determined by the first transaction. The method also involves writing a persisted quantity change for the time series time interval. The persisted quantity change is determined by the second transaction.

    Hybrid Heap Memory Management
    6.
    发明申请
    Hybrid Heap Memory Management 审中-公开
    混合堆内存管理

    公开(公告)号:US20170068465A1

    公开(公告)日:2017-03-09

    申请号:US14849041

    申请日:2015-09-09

    Applicant: SAP SE

    Abstract: A database memory manager determines a size class for each of a plurality of memory allocation requests. The memory manager then, based on the determined size classes, assigns which of a plurality of sub-allocators forming part of a plurality of memory pools should handle each memory allocation request. The sub-allocators assignments are based on predefined size ranges for each size class. The corresponding assigned sub-allocators then identify locations within the memory for each memory allocation request. The corresponding assigned sub-allocators next handle the memory allocation requests to allocate memory at the identified locations such that one of the sub-allocators utilizes both thread local storage and core-striped memory management.

    Abstract translation: 数据库存储器管理器为多个存储器分配请求中的每一个确定大小类别。 然后,存储器管理器基于所确定的大小类别,分配构成多个存储器池的一部分的多个子分配器中的哪一个应该处理每个存储器分配请求。 子分配器分配基于每个大小类别的预定义大小范围。 相应的分配的子分配器然后识别存储器内的每个存储器分配请求的位置。 相应的分配的子分配器接下来处理在所识别的位置处分配存储器的存储器分配请求,使得一个子分配器利用线程本地存储和核心条带存储器管理两者。

    Fast shutdown of large scale-up processes

    公开(公告)号:US12093732B2

    公开(公告)日:2024-09-17

    申请号:US18333752

    申请日:2023-06-13

    Applicant: SAP SE

    Abstract: A system for shutting down a process of a database is provided. In some aspects, the system performs operations including tracking, during startup of a process, code locations of a process in the at least one memory. The operations may further include tracking, during runtime of the process and in response to the tracking the code locations, memory segments of the at least one memory allocated to the process. The operations may further include receiving an indication for a shutdown of a process. The operations may further include waking, in response to the indication, at least one processing thread of a plurality of processing threads allocated to a database system. The operations may further include allocating a list of memory mappings to the plurality of processing threads. The operations may further include freeing, by the first processing thread, the physical memory assigned to the processing thread by the memory mappings.

    Fast shutdown of large scale-up processes

    公开(公告)号:US11720402B2

    公开(公告)日:2023-08-08

    申请号:US17818957

    申请日:2022-08-10

    Applicant: SAP SE

    Abstract: A system for shutting down a process of a database is provided. In some aspects, the system performs operations including tracking, during startup of a process, code locations of a process in the at least one memory. The operations may further include tracking, during runtime of the process and in response to the tracking the code locations, memory segments of the at least one memory allocated to the process. The operations may further include receiving an indication for a shutdown of a process. The operations may further include waking, in response to the indication, at least one processing thread of a plurality of processing threads allocated to a database system. The operations may further include allocating a list of memory mappings to the plurality of processing threads. The operations may further include freeing, by the first processing thread, the physical memory assigned to the processing thread by the memory mappings.

    RECLAMATION OF CACHE RESOURCES
    10.
    发明申请

    公开(公告)号:US20190258580A1

    公开(公告)日:2019-08-22

    申请号:US15900120

    申请日:2018-02-20

    Applicant: SAP SE

    Abstract: A method may include dividing, into a first portion of memory resources and a second portion of memory resources, a plurality of memory resources included in a cache coupled with a database. The plurality of memory resources included in the cache may store data from the database. The first portion of memory resources may be occupied by data assigned to a first weight class. The second portion of memory resources may be occupied by data assigned to a second weight class. The first portion of memory resources may be selected based at least on the first weight class and an age of at least some of the data occupying the first portion of memory resources. In response to the selection of the first portion of memory resources, the first portion of memory resources may be reclaimed. Related systems and articles of manufacture, including computer program products, are also provided.

Patent Agency Ranking