公开(公告)号：US20160292227A1

公开(公告)日：2016-10-06

申请号：US15140794

申请日：2016-04-28

Applicant: SAP SE

Inventor： Chanho Jeong ,  Sangyong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

IPC: G06F17/30

CPC classification number: G06F17/30463 ,  G06F17/30 ,  G06F17/30286 ,  G06F17/30471 ,  G06F17/30492 ,  G06F17/30569

Abstract: Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.

Abstract translation: 公开了用于处理与正在查询的数据库存储模型不同的数据库查询的设备，方法和系统。 可以通过接收对存储在数据库中的一个或多个数据项的查询来确定是否使用至少一个使用具有不同于存储模型的格式的数据的查询运算符来执行独立于查询数据库的存储模型的数据库查询 格式化存储在数据库中的一个或多个数据项中的至少一个，并且将由至少一个查询运算符使用的数据的格式转换为与存储的一个或多个数据项中的至少一个的存储模型格式相匹配的格式 在数据库中。 还描述了相关系统，方法和制品。

公开(公告)号：US09361340B2

公开(公告)日：2016-06-07

申请号：US14508524

申请日：2014-10-07

Applicant: SAP SE

Inventor： Chanho Jeong ,  Sangyong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

IPC: G06F17/30 ,  G06F7/00

CPC classification number: G06F17/30463 ,  G06F17/30 ,  G06F17/30286 ,  G06F17/30471 ,  G06F17/30492 ,  G06F17/30569

Abstract: Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.

Abstract translation: 公开了用于处理与正在查询的数据库存储模型不同的数据库查询的设备，方法和系统。 可以通过接收对存储在数据库中的一个或多个数据项的查询来确定是否使用至少一个使用具有不同于存储模型的格式的数据的查询运算符来执行独立于查询数据库的存储模型的数据库查询 格式化存储在数据库中的一个或多个数据项中的至少一个，并且将由至少一个查询运算符使用的数据的格式转换为与存储的一个或多个数据项中的至少一个的存储模型格式相匹配的格式 在数据库中。 还描述了相关系统，方法和制品。

公开(公告)号：US12222944B2

公开(公告)日：2025-02-11

申请号：US18362399

申请日：2023-07-31

Applicant: SAP SE

Inventor： Chanho Jeong ,  Sangyong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

IPC: G06F16/2453 ,  G06F16/00 ,  G06F16/20 ,  G06F16/2455 ,  G06F16/25

Abstract: Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US11755575B2

公开(公告)日：2023-09-12

申请号：US17500194

申请日：2021-10-13

Applicant: SAP SE

Inventor： Chanho Jeong ,  Sangyong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

IPC: G06F16/2453 ,  G06F16/00 ,  G06F16/20 ,  G06F16/25 ,  G06F16/2455

CPC classification number: G06F16/24542 ,  G06F16/00 ,  G06F16/20 ,  G06F16/24547 ,  G06F16/24557 ,  G06F16/258

Abstract: Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US20220035815A1

公开(公告)日：2022-02-03

申请号：US17500194

申请日：2021-10-13

Applicant: SAP SE

Inventor： Chanho Jeong ,  Sangyong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

IPC: G06F16/2453 ,  G06F16/25

Abstract: Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US20180075097A1

公开(公告)日：2018-03-15

申请号：US15266160

申请日：2016-09-15

Applicant: SAP SE

Inventor： Sangyong Hwang

IPC: G06F17/30

CPC classification number: G06F16/24542

Abstract: A system includes reception of a database query, determination of a first logical query execution plan to execute the database query, determination of a second logical query execution plan to execute the database query, determination of a first plurality of resource usage estimates associated with the first logical query execution plan, determination of a second plurality of resource usage estimates associated with the second logical query execution plan, and determination, based on the first plurality of resource usage estimates and the second plurality of resource usage estimates, whether it is determinable to a suitable degree of certainty that one of the first logical query execution plan and the second logical query execution plan will be associated with a smaller amount of resource usage than the other one of the first logical query execution plan and the second logical query execution plan.

公开(公告)号：US20230376487A1

公开(公告)日：2023-11-23

申请号：US18362399

申请日：2023-07-31

Applicant: SAP SE

Inventor： Chanho Jeong ,  Sangyong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

IPC: G06F16/2453 ,  G06F16/00 ,  G06F16/20 ,  G06F16/25 ,  G06F16/2455

CPC classification number: G06F16/24542 ,  G06F16/00 ,  G06F16/20 ,  G06F16/258 ,  G06F16/24547 ,  G06F16/24557

Abstract: Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US11061898B2

公开(公告)日：2021-07-13

申请号：US15266160

申请日：2016-09-15

Applicant: SAP SE

Inventor： Sangyong Hwang

IPC: G06F16/2453

Abstract: A system includes reception of a database query, determination of a first logical query execution plan to execute the database query, determination of a second logical query execution plan to execute the database query, determination of a first plurality of resource usage estimates associated with the first logical query execution plan, determination of a second plurality of resource usage estimates associated with the second logical query execution plan, and determination, based on the first plurality of resource usage estimates and the second plurality of resource usage estimates, whether it is determinable to a suitable degree of certainty that one of the first logical query execution plan and the second logical query execution plan will be associated with a smaller amount of resource usage than the other one of the first logical query execution plan and the second logical query execution plan.

公开(公告)号：US20190138523A1

公开(公告)日：2019-05-09

申请号：US16159084

申请日：2018-10-12

Applicant: SAP SE

Inventor： Chanho Jeong ,  Sangyong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/00 ,  G06F16/20 ,  G06F16/25

Abstract: Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US10127278B2

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

申请号：US15140794

申请日：2016-04-28

Applicant: SAP SE

Inventor： Chanho Jeong ,  Sangyong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

IPC: G06F17/30

Abstract: Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.