公开(公告)号：US11741127B2

公开(公告)日：2023-08-29

申请号：US17512379

申请日：2021-10-27

Applicant: SAP SE

Inventor： Xiaoke Liu ,  Qingwei Ren ,  Zhe Qu ,  Zhilong Hao ,  Weimin Qi ,  Long Zhang ,  Jiaxin Liu ,  Xiaolong Yang

IPC: G06F16/27 ,  G06F16/2453 ,  G06F16/22

CPC classification number: G06F16/278 ,  G06F16/2282 ,  G06F16/24542

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.

公开(公告)号：US20230129468A1

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

申请号：US17512379

申请日：2021-10-27

Applicant: SAP SE

Inventor： Xiaoke Liu ,  Qingwei Ren ,  Zhe Qu ,  Zhilong Hao ,  Weimin Qi ,  Long Zhang ,  Jiaxin Liu ,  Xiaolong Yang

IPC: G06F16/27 ,  G06F16/22 ,  G06F16/2453

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.

公开(公告)号：US20230126103A1

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

申请号：US17512375

申请日：2021-10-27

Applicant: SAP SE

Inventor： Qingwei Ren ,  Zhe Qu ,  Zhilong Hao ,  Weimin Qi ,  Long Zhang ,  Jiaxin Liu ,  Xiaoke Liu ,  Xiaolong Yang

IPC: G06F16/903 ,  G06F16/901

Abstract: A method for processing a query may include evaluating a query on a database table to identify a time based function included in the query. One or more partitions of the database table may be pruned from the query based at least on the partitions being associated with a first time range that does not overlap with a second time range associated with the time based function. An execution plan for the query may be generated to include a sequence of operations that avoids accessing the one or more partitions pruned from the query. The query may be executed based at least on the execution plan by at least accessing a second partition of the database table but not the first partition of the database table pruned from the query. Related systems and articles of manufacture are also provided.