公开(公告)号：US12204529B2

公开(公告)日：2025-01-21

申请号：US17973077

申请日：2022-10-25

Applicant: SAP SE

Inventor： Juhyeon Jeong ,  Hyeong Seog Kim ,  Taehyung Lee

IPC: G06F16/24 ,  G06F16/242 ,  G06F16/2453 ,  G06F16/25

Abstract: Techniques and solutions are provided for providing federated data access to parameterized data objects. At a local system, a virtual parameterized data object is created. A remote computing system is contacted to obtain parameters used by a parameterized data object of the remote computing system to which the virtual parameterized data object corresponds. Parameter information received from the remote system is stored in a definition of the virtual parameterized data object at the local system. When a request for a database operation involving the virtual parameterized data object is received, the parameter information can be used to determine whether the request is correctly formed, or can be used in preparing a request to be sent to the remote system to be performed using the parameterized data object to obtain information specified in the request for a database operation.

公开(公告)号：US10997174B2

公开(公告)日：2021-05-04

申请号：US14947927

申请日：2015-11-20

Applicant: SAP SE

Inventor： Sang Il Song ,  Junhee Woo ,  Taehyung Lee ,  Sung Heun Wi ,  Ki Hong Kim ,  Yongsik Yoon

IPC: G06F16/24 ,  G06F16/2453

Abstract: Methods and apparatus, including computer program products, are provided for a case join. In one aspect, there is provided method, which may include receiving a query for a predefined view that is configured to inhibit modification; detecting whether the predefined view includes a database table extended to include an additional column; and generating, in response to the query, a view based on a case join, when the predefined view includes the database table extended to include the additional column. Related apparatus, systems, methods, and articles are also described.

公开(公告)号：US20170147639A1

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

申请号：US14946745

申请日：2015-11-19

Applicant: SAP SE

Inventor： Jane Jung Lee ,  Taehyung Lee ,  Jiyoung Yoo ,  Sung Heun Wi ,  Ki Hong Kim

IPC: G06F17/30

CPC classification number: G06F17/30463

Abstract: In one aspect there is a method. The method may include associating a query received from an application with a hint, wherein the hint modifies an execution of the query. The method may further include an optimizer to compile the query according to the hint to produce a second query plan. When no hint is associated with the query, the optimizer may produce a first query plan. The method may further include storing the hint in a persistent table to enable state preservation during a database restart or binary upgrade, and/or executing the query using the second query plan.

公开(公告)号：US11681702B2

公开(公告)日：2023-06-20

申请号：US16743680

申请日：2020-01-15

Applicant: SAP SE

Inventor： Taehyung Lee ,  Wolfgang Stephan ,  Felix Knittel ,  Chuho Chang

IPC: G06F16/24 ,  G06F16/2453

CPC classification number: G06F16/24544

Abstract: Disclosed herein are system, method, and computer tangible medium embodiments for generating a relational database model from a model view that provides an estimate for generating query plan for a query on the model view, according to an embodiment. A join model of a model view set on one or more database tables is received. At least one index conversion of the join model is performed, where the index conversion converts at least one index in the join model into at least one leaf node in a relational model tree. At least one join conversion of the join model is performed where the at least one join conversion generates a node in the relational model tree that joins a first and second leaf nodes in the relational model tree. A requested parameter conversion is performed, where the requested parameter conversion includes an attribute or key figure requested by a query.

公开(公告)号：US10698892B2

公开(公告)日：2020-06-30

申请号：US15950013

申请日：2018-04-10

Applicant: SAP SE

Inventor： Nosub Sung ,  Myunggon Park ,  Taehyung Lee ,  Chul Won Lee ,  Juchang Lee ,  Sung Heun Wi

IPC: G06F15/16 ,  G06F16/2453 ,  G06F16/14 ,  G06F16/2455

Abstract: A process is provided for independently hashing and filtering a data set, such as during preprocessing. For the data set, one or more records, separately having one or more fields, may be identified. A record hash value set, containing one or more record hash values for the respective one or more records, may be generated. Generating a given record hash value may be accomplished as follows. For a given record, a hash value set may be generated, having one or more field hash values for the respective one or more fields of the given record. The record hash value for the given record may be generated based on the hash value set. A total hash value for the data set may be generated based on the record hash value set. The records of the data set may be filtered based on classification of the query that generated the records.

公开(公告)号：US10133778B2

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

申请号：US14947252

申请日：2015-11-20

Applicant: SAP SE

Inventor： Taehyung Lee ,  Joo Young Yoon ,  Sang Il Song ,  Yongsik Yoon ,  Sung Heun Wi ,  Junhee Woo

IPC: G06F17/30

Abstract: Disclosed herein are system, method, and computer program product embodiments for utilizing join cardinality to improve the performance of query processing. An embodiment operates by a database engine receiving a query including a join operation on a first and a second table using a join predicate, and a tag for the join operation indicating a cardinality relationship between the first and the second table when satisfying the join predicate. Then, the database engine generates a query processing plan for performing the query. For the join operation, the database engine selects one of the first or the second tables to remove from the join operation based on a type of the join operation and the tag. Based on the selecting, the database engine may remove may the join operation and the selected table from the query processing plan.

公开(公告)号：US20240232186A9

公开(公告)日：2024-07-11

申请号：US17973077

申请日：2022-10-25

Applicant: SAP SE

Inventor： Juhyeon Jeong ,  Hyeong Seog Kim ,  Taehyung Lee

IPC: G06F16/242 ,  G06F16/2453 ,  G06F16/25

CPC classification number: G06F16/2448 ,  G06F16/24547 ,  G06F16/256

Abstract: Techniques and solutions are provided for providing federated data access to parameterized data objects. At a local system, a virtual parameterized data object is created. A remote computing system is contacted to obtain parameters used by a parameterized data object of the remote computing system to which the virtual parameterized data object corresponds. Parameter information received from the remote system is stored in a definition of the virtual parameterized data object at the local system. When a request for a database operation involving the virtual parameterized data object is received, the parameter information can be used to determine whether the request is correctly formed, or can be used in preparing a request to be sent to the remote system to be performed using the parameterized data object to obtain information specified in the request for a database operation.

公开(公告)号：US20240232165A9

公开(公告)日：2024-07-11

申请号：US17973440

申请日：2022-10-25

Applicant: SAP SE

Inventor： Jaehwa Kim ,  Kyungyul Park ,  Eunsang Kim ,  Joo Yeon Lee ,  Taehyung Lee

IPC: G06F16/23 ,  G06F11/34 ,  G06F16/21

CPC classification number: G06F16/2365 ,  G06F11/3409 ,  G06F16/213

Abstract: Various systems and methods for selective revalidation of data objects are provided. In one example, a computer-implemented method includes updating a target data object of a database system according to a definition statement, and determining whether the definition statement changes one or more object properties of the target data object. In response to determining that the definition statement changes the one or more object properties of the target data object, the method includes revalidating data objects depending on the target data object. In response to determining that the definition statement does not change the one or more object properties of the target data object, the method includes not revalidating the data objects depending on the target data object. In this way, database management performance and speed may be improved while maintaining validity of data objects in a database.

公开(公告)号：US20200311081A1

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

申请号：US16371276

申请日：2019-04-01

Applicant: SAP SE

Inventor： Johannes Merx ,  Taehyung Lee ,  Sung Heun Wi ,  Jin Uk Bae ,  Ki Hong Kim ,  Stefan Baeuerle ,  Florian Scheid

IPC: G06F16/2453

Abstract: Implementations of the present disclosure include receiving, by a query processing server, a first query, the first query including a syntax indicating that precision loss is allowed, processing, by the query processing server, the first query to provide a first QEP, optimization of which would result in precision loss in a generated query result, determining that the syntax is provided, and in response, optimizing the first QEP to provide an optimized QEP, executing the optimized QEP to generate a query result that includes data stored within a database system, the query result having reduced accuracy relative to a query result that would be generated based on the first QEP, and providing the query result as output from the database system.

公开(公告)号：US10565200B2

公开(公告)日：2020-02-18

申请号：US14949372

申请日：2015-11-23

Applicant: SAP SE

Inventor： Taehyung Lee ,  Wolfgang Stephan ,  Felix Knittel ,  Chuho Chang

IPC: G06F16/24 ,  G06F16/2453

Abstract: Disclosed herein are system, method, and computer tangible medium embodiments for generating a relational database model from a model view that provides an estimate for generating query plan for a query on the model view, according to an embodiment. A join model of a model view set on one or more database tables is received. At least one index conversion of the join model is performed, where the index conversion converts at least one index in the join model into at least one leaf node in a relational model tree. At least one join conversion of the join model is performed where the at least one join conversion generates a node in the relational model tree that joins a first and second leaf nodes in the relational model tree. A requested parameter conversion is performed, where the requested parameter conversion includes an attribute or key figure requested by a query.