DYNAMIC RANGE PARTITIONING OF DATABASE TABLE

    公开(公告)号:US20230129468A1

    公开(公告)日:2023-04-27

    申请号:US17512379

    申请日:2021-10-27

    Applicant: SAP SE

    Abstract: A method may include generating a database table to include a first partition having a first range and a dynamic partition associated with an undefined range of a specified length. A record may be inserted into the database table. In response to one or more values of the record being outside of the first range of the first partition, a second partition having a second range of the specified length that includes the one or more values of the record may be generated. The record may be stored in the second partition. Moreover, a query on the database table may be executed by the first partition and/or the second partition of the database table. Related systems and articles of manufacture are also provided.

Patent Agency Ranking