Extended cache for efficient object store access by a database

    公开(公告)号:US11567873B1

    公开(公告)日:2023-01-31

    申请号:US17486206

    申请日:2021-09-27

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for utilizing an extended cache to access an object store efficiently. An embodiment operates by executing a database transaction, thereby causing pages to be written from a buffer cache to an extended cache and to an object store. The embodiment determines a transaction type of the database transaction. The transaction type can a read-only transaction or an update transaction. The embodiment determines a phase of the database transaction based on the determined transaction type. The phase can be an execution phase or a commit phase. The embodiment then applies a caching policy to the extended cache for the evicted pages based on the determined transaction type of the database transaction and the determined phase of the database transaction.

    Adaptive data prefetch
    4.
    发明授权

    公开(公告)号:US11966393B2

    公开(公告)日:2024-04-23

    申请号:US17840961

    申请日:2022-06-15

    Applicant: SAP SE

    CPC classification number: G06F16/24539 G06F16/2255 G06F16/24542

    Abstract: A system includes reception of a request to fetch a first dataset, the request including a first identifier associated with the first dataset, determination, in response to the request, of a first signature associated with the first dataset based on the first identifier and on respective identifiers of one or more datasets fetched consecutively with the first dataset, and determination, based on the determined first signature, of whether to update a first link associating a second dataset with the first dataset, the link indicating to prefetch the first dataset in response to a request to fetch the second dataset.

Patent Agency Ranking