Internal tables for accessing data stored in a database

    公开(公告)号:US11204909B2

    公开(公告)日:2021-12-21

    申请号:US16174824

    申请日:2018-10-30

    Applicant: SAP SE

    Abstract: A method for transferring data from a database may include receiving, at a database management system, a request to transfer, to a client, at least a portion of data stored at a database coupled with the database management system. The database management system may respond to the request by at least generating an internal table containing at least the portion of the data being transferred to the client. The database management system may further transfer at least the portion of the data to the client by at least sending, to the client, one or more data chunks. Each of the one or more data chunks may include at least a portion of a column of data from the internal table. Related systems and articles of manufacture, including computer program products, are also provided.

    Distributed storage orphan scan
    3.
    发明授权

    公开(公告)号:US11422743B2

    公开(公告)日:2022-08-23

    申请号:US16896033

    申请日:2020-06-08

    Applicant: SAP SE

    Abstract: A distributed storage system includes a primary storage system and a secondary storage system. The secondary storage system stores the actual data and the primary storage system stores metadata for the actual data. The metadata references at the primary storage system may be deleted without deleting the corresponding data at the secondary storage system. Snapshots of the metadata at the primary storage system are sent to the secondary storage system. The secondary storage system can compare two metadata snapshots received from the primary storage in order to determine whether data stored at the secondary storage system has been deleted at the primary storage system for longer than a retention period. Such data may be deleted to free up storage space at the secondary storage server.

    Column loadable and page loadable load unit recommendation system

    公开(公告)号:US11249962B2

    公开(公告)日:2022-02-15

    申请号:US16411869

    申请日:2019-05-14

    Applicant: SAP SE

    Abstract: Disclosed herein are systems, methods, and devices for providing load unit recommendations. An example method includes monitoring queries executed by a database management system including a database object, determining an access frequency of the database object based upon the monitoring, and determining relative access counter information for the database object based on the access frequency. Subsequently, the method includes generating a sorted element based on the relative access counter information, determining threshold values based on threshold information and the sorted element, and determining a load unit for the database object based on the sorted element and the threshold values. The load unit indicates whether to load the whole database object, or only a portion thereof, into a main memory of the DBMS while accessing the database object.

    Distributed Storage Orphan Scan
    5.
    发明申请

    公开(公告)号:US20210318834A1

    公开(公告)日:2021-10-14

    申请号:US16896033

    申请日:2020-06-08

    Applicant: SAP SE

    Abstract: A distributed storage system includes a primary storage system and a secondary storage system. The secondary storage system stores the actual data and the primary storage system stores metadata for the actual data. The metadata references at the primary storage system may be deleted without deleting the corresponding data at the secondary storage system. Snapshots of the metadata at the primary storage system are sent to the secondary storage system. The secondary storage system can compare two metadata snapshots received from the primary storage in order to determine whether data stored at the secondary storage system has been deleted at the primary storage system for longer than a retention period. Such data may be deleted to free up storage space at the secondary storage server.

    INTERNAL TABLES FOR ACCESSING DATA STORED IN A DATABASE

    公开(公告)号:US20200034463A1

    公开(公告)日:2020-01-30

    申请号:US16174824

    申请日:2018-10-30

    Applicant: SAP SE

    Abstract: A method for transferring data from a database may include receiving, at a database management system, a request to transfer, to a client, at least a portion of data stored at a database coupled with the database management system. The database management system may respond to the request by at least generating an internal table containing at least the portion of the data being transferred to the client. The database management system may further transfer at least the portion of the data to the client by at least sending, to the client, one or more data chunks. Each of the one or more data chunks may include at least a portion of a column of data from the internal table. Related systems and articles of manufacture, including computer program products, are also provided.

Patent Agency Ranking