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

公开(公告)号：US20180293276A1

公开(公告)日：2018-10-11

申请号：US15483690

申请日：2017-04-10

Applicant: SAP SE

Inventor： Jin Uk Bae ,  Stefan Baeuerle ,  Christian Bensberg ,  Steffen Geissinger ,  Ki Hong Kim ,  Taehyung Lee ,  Jaeyun Noh ,  Di Wu ,  Long Zhang

IPC: G06F17/30

Abstract: A method can include: generating a query execution plan for a query including a plurality of operations that operate on data from a relational database and data from a non-structured query language (NoSQL) database, the generating comprising optimizing the query by: identifying a first operation that operate on data from the relational database and an intermediate result output by a second operation, the second operation outputting the intermediate result by operating on the data from the NoSQL database; and determining a fixed datatype for the intermediate result, an indication of the fixed datatype being included in the query execution plan; and executing, based on the query execution plan, the query, the executing of the query comprising converting the intermediate result to the fixed datatype, the converting enabling the first operation to operate on the intermediate result output by the second operation along with the data from the relational database.

公开(公告)号：US20180018368A1

公开(公告)日：2018-01-18

申请号：US15208736

申请日：2016-07-13

Applicant: SAP SE

Inventor： Stefan Baeuerle ,  Bjoern Mielenhausen ,  Daniel Hutzel ,  Ki Hong Kim ,  Di Wu ,  Long Zhang

IPC: G06F17/30

CPC classification number: G06F16/24544 ,  G06F16/22 ,  G06F16/24535

Abstract: A system, medium, and method to define a database table and view based on a database model using a database language statement, the database language statement including a statement to create the table and a forward-declared JOIN statement that names the table and view, respectively and includes information regarding a relationship between at least two entities of the database.

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

公开(公告)号：US10599650B2

公开(公告)日：2020-03-24

申请号：US15208736

申请日：2016-07-13

Applicant: SAP SE

Inventor： Stefan Baeuerle ,  Bjoern Mielenhausen ,  Daniel Hutzel ,  Ki Hong Kim ,  Di Wu ,  Long Zhang

IPC: G06F7/00 ,  G06F17/30 ,  G06F16/2453 ,  G06F16/22

Abstract: A system, medium, and method to define a database table and view based on a database model using a database language statement, the database language statement including a statement to create the table and a forward-declared JOIN statement that names the table and view, respectively and includes information regarding a relationship between at least two entities of the database.