SMART ROLLOVER
    5.
    发明申请
    SMART ROLLOVER 审中-公开

    公开(公告)号:US20190026387A1

    公开(公告)日:2019-01-24

    申请号:US15692267

    申请日:2017-08-31

    Applicant: SAP SE

    Abstract: A system and method, including determining, by a processor, a data type for each column of a database table; determining, by the processor and based on the determined data type for each column of the database table, an indication of a size of the database table; calculating, by the processor and based on the determined indication of the size of the database table, a start nbit size for a nbit compression process to be used on the database table; specifying, by the processor, the calculated start nbit size for the nbit compression process; and compressing the database table by executing the nbit data compression process using the specified start nbit size.

    Distributed storage orphan scan
    6.
    发明授权

    公开(公告)号: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.

    Data access and recommendation system

    公开(公告)号:US11308047B2

    公开(公告)日:2022-04-19

    申请号:US16816511

    申请日:2020-03-12

    Applicant: SAP SE

    Abstract: System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter, corresponding to the first column and stored in a distributed hash table, is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.

    DATA ACCESS AND RECOMMENDATION SYSTEM

    公开(公告)号:US20210286777A1

    公开(公告)日:2021-09-16

    申请号:US16816511

    申请日:2020-03-12

    Applicant: SAP SE

    Abstract: System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter, corresponding to the first column and stored in a distributed hash table, is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.

Patent Agency Ranking