公开(公告)号：US20240303364A1

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

申请号：US18180221

申请日：2023-03-08

Applicant: SAP SE

Inventor： Xun Zhang ,  Taehyung Lee ,  Yinghua Ouyang ,  Dongmei XV ,  Yanchen Cao ,  Hong-Hai Do ,  Taeyoung Jeong ,  Zhen Tian

IPC: G06F21/62

CPC classification number: G06F21/6227 ,  G06F2221/2141

Abstract: 1. Implementations of the present disclosure include receiving, by a database system, a query from an entity, providing a parse tree based on the query, the parse tree including nodes representative of operations to be executed and data objects stored within the database system, generating a module tree based on the parse tree, the module tree including a set of modules provided in sequential order from a root module to a leaf module, and executing an authorization check using the module tree by, for each module, determining a set of data objects and, for each data object in the set of data objects, determining whether the entity is one or more of authorized access the data object and perform an operation on the data object.

公开(公告)号：US20200311296A1

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

申请号：US16365903

申请日：2019-03-27

Applicant: SAP SE

Inventor： Taehun Kim ,  Taehyung Lee ,  Stephan Kessler ,  Kaweh Amoi-Taleghani ,  Thomas Seufert ,  Jens Hoff ,  Kai Morich ,  Jin Uk Bae ,  Chuho Chang

IPC: G06F21/62 ,  G06F16/2453 ,  G06F16/248 ,  G06F16/242

Abstract: Implementations of the present disclosure include receiving a view command for creating a view to display anonymized data in response to one or more queries, the view command including a view name, a table, a set of columns of the table, an anonymization type, a set of static parameters, and, for a sub-set of columns of the table, one or more sets of column-specific parameters, each set of column-specific parameters being specific to anonymization of data of a respective column of the table included in the sub-set of columns, storing the view command within the database system, and receiving a query referencing the view, and in response, providing a data set including data from each column in the sub-set of columns, receiving an anonymized data set including anonymized data that is generated from the data set using the anonymization type, the static parameters, and the sets of column-specific parameters.

公开(公告)号：US20200151180A1

公开(公告)日：2020-05-14

申请号：US16743680

申请日：2020-01-15

Applicant: SAP SE

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

IPC: 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.

公开(公告)号：US20190311057A1

公开(公告)日：2019-10-10

申请号：US15950013

申请日：2018-04-10

Applicant: SAP SE

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

IPC: G06F17/30

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.

公开(公告)号：US10303686B2

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

申请号：US14946745

申请日：2015-11-19

Applicant: SAP SE

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

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

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.

公开(公告)号：US20170147646A1

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

申请号：US14949372

申请日：2015-11-23

Applicant: SAP SE

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

IPC: G06F17/30

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 perfonned, where the requested parameter conversion includes an attribute or key figure requested by a query.

公开(公告)号：US20240134849A1

公开(公告)日：2024-04-25

申请号：US17973077

申请日：2022-10-24

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.

公开(公告)号：US20240134842A1

公开(公告)日：2024-04-25

申请号：US17973440

申请日：2022-10-24

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.

公开(公告)号：US20240086404A1

公开(公告)日：2024-03-14

申请号：US18075781

申请日：2022-12-06

Applicant: SAP SE

Inventor： Taehyung Lee ,  Taeyoung Jeong ,  Taehun Kim ,  Sungwon Kim ,  Sanghee Lee

IPC: G06F16/2453

CPC classification number: G06F16/2454 ,  G06F16/24542

Abstract: A computer implemented method can receive a parameterized query written in a declarative language. The parameterized query comprises a parameter which can be assigned different values. The method can perform a first compilation session of the parameterized query in which the parameter has no assigned value. Performing the first compilation session can generate an intermediate representation of the parameterized query. The intermediate representation describes a relational algebra expression to implement the parameterized query. The method can perform a second compilation session of the parameterized query in which parameter has an assigned value. Performing the second compilation session reuses the intermediate representation of the parameterized query.

公开(公告)号：US11468062B2

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

申请号：US16801039

申请日：2020-02-25

Applicant: SAP SE

Inventor： Nosub Sung ,  Myunggon Park ,  Taehyung Lee ,  Chui 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.