公开(公告)号：US20200311074A1

公开(公告)日：2020-10-01

申请号：US16369773

申请日：2019-03-29

Applicant: SAP SE

Inventor： Boyung Lee ,  Sang Il Song ,  Won Seok Kim ,  Dan Bi Park ,  Heesik Shin

IPC: G06F16/2453 ,  G06F16/25

Abstract: Provided is a system and method for reconstructing and visualizing transformation steps that are performed to an optimized database query. In one example, the method may include receiving a database query including an initial set of execution steps, generating a plurality of alternative sets of execution steps for the database query based on transformations to the initial set of execution steps, selecting an alternative set of execution steps from among the plurality of alternative sets of execution steps based on a performance of the alternative set of execution steps, identifying transformations that are used to transform the initial set of execution steps into the selected alternative set of execution steps, and displaying information about the identified transformations via a user interface.

公开(公告)号：US11481392B2

公开(公告)日：2022-10-25

申请号：US16369773

申请日：2019-03-29

Applicant: SAP SE

Inventor： Boyung Lee ,  Sang Il Song ,  Won Seok Kim ,  Dan Bi Park ,  Heesik Shin

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

Abstract: Provided is a system and method for reconstructing and visualizing transformation steps that are performed to an optimized database query. In one example, the method may include receiving a database query including an initial set of execution steps, generating a plurality of alternative sets of execution steps for the database query based on transformations to the initial set of execution steps, selecting an alternative set of execution steps from among the plurality of alternative sets of execution steps based on a performance of the alternative set of execution steps, identifying transformations that are used to transform the initial set of execution steps into the selected alternative set of execution steps, and displaying information about the identified transformations via a user interface.

公开(公告)号：US10108662B2

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

申请号：US14950887

申请日：2015-11-24

Applicant: SAP SE

Inventor： Boyung Lee ,  Joo Young Yoon

IPC: G06F17/30

Abstract: According to various embodiments, systems and methods for performing unit conversion operations in a database system are provided. According to embodiments, a database operation will require unit conversion. A number of unit conversions that might be required both before and after performance of the operation can then be estimated. At least some of the data entries implicated by the operation can then be converted from a first unit to a second unit depending on the result of the estimation.

公开(公告)号：US20170147665A1

公开(公告)日：2017-05-25

申请号：US14950887

申请日：2015-11-24

Applicant: SAP SE

Inventor： Boyung Lee ,  Joo Young Yoon

IPC: G06F17/30

CPC classification number: G06F17/30442

Abstract: According to various embodiments, systems and methods for performing unit conversion operations in a database system are provided. According to embodiments, a database operation will require unit conversion. A number of unit conversions that might be required both before and after performance of the operation can then be estimated. At least some of the data entries implicated by the operation can then be converted from a first unit to a second unit depending on the result of the estimation.