公开(公告)号：US20240134838A1

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

申请号：US17971506

申请日：2022-10-20

Applicant: SAP SE

Inventor： Won Wook Hong ,  Joo Yeon Lee ,  Hyeong Seog Kim ,  Jane Jung Lee ,  Younkyoung Lee

IPC: G06F16/23

CPC classification number: G06F16/23

Abstract: The present disclosure provides techniques and solutions for executing requests for database operations involving a remote data source in a system that includes an anchor node and one or more non-anchor nodes. A first request for one or more database operations is received, where at least a first database operation includes a data request for a remote data object. It is determined that the first database operation is not an insert, delete, or update operation, and therefore is assignable to the anchor node or one of the non-anchor nodes. The first database operation is assigned to a non-anchor node for execution. In a particular implementation, for a particular set of requests for a database operation, once an insert, delete, or update operation is received for the remote data object, subsequent operations for the remote data object in the set of requests are assigned to the anchor node for execution.

公开(公告)号：US11379483B1

公开(公告)日：2022-07-05

申请号：US17217412

申请日：2021-03-30

Applicant: SAP SE

Inventor： Jaeyoung Choi ,  Deok Hoe Kim ,  Kyu Hwan Kim ,  Chae Kwang Lee ,  Jane Jung Lee ,  Juchang Lee

IPC: G06F16/2455 ,  G06F16/22 ,  G06F16/248 ,  G06F16/2453

Abstract: Technologies are described for routing structured query language (SQL) statements to elastic compute nodes (ECNs) using workload classes within a distributed database environment. The elastic compute nodes do not store persistent database tables. For example, a SQL statement can be received for execution within the distributed database environment. A workload class can be identified that matches properties of the SQL statement. Based on the workload class, a routing location hint can be obtained that identifies a set of elastic compute nodes. The SQL statement can then be routed to one of the identified elastic compute nodes for execution. Execution of the SQL statement at the elastic compute node can involve retrieving database data from other nodes which store persistent database tables.

公开(公告)号：US20220318249A1

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

申请号：US17826060

申请日：2022-05-26

Applicant: SAP SE

Inventor： Jaeyoung Choi ,  Deok Hoe Kim ,  Kyu Hwan Kim ,  Chae Kwang Lee ,  Jane Jung Lee ,  Juchang Lee

IPC: G06F16/2455 ,  G06F16/2453 ,  G06F16/22 ,  G06F16/248

Abstract: Technologies are described for routing structured query language (SQL) statements to elastic compute nodes (ECNs) using workload classes within a distributed database environment. The elastic compute nodes do not store persistent database tables. For example, a SQL statement can be received for execution within the distributed database environment. A workload class can be identified that matches properties of the SQL statement. Based on the workload class, a routing location hint can be obtained that identifies a set of elastic compute nodes. The SQL statement can then be routed to one of the identified elastic compute nodes for execution. Execution of the SQL statement at the elastic compute node can involve retrieving database data from other nodes which store persistent database tables.

公开(公告)号：US10275401B2

公开(公告)日：2019-04-30

申请号：US15364649

申请日：2016-11-30

Applicant: SAP SE

Inventor： Chul Won Lee ,  Kyu Hwan Kim ,  Marcel Birn ,  Jane Jung Lee ,  Di Wu ,  Juchang Lee ,  Zhi Qiao

IPC: G06F16/27 ,  G06F16/23 ,  G06F16/2455 ,  G06F16/903

Abstract: A computer implemented method for initializing a first image of a first database from a recovery image; modifying the first image of the first database by replaying transaction logs of a second database; establishing a connection with a client; receiving a query via the connection, the query including a transaction to be executed on the first database; and rejecting the query when the transaction would cause any one of: updating of the first image of the first database; generating a new transaction log; and modifying the recovery image. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20200320076A1

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

申请号：US16373867

申请日：2019-04-03

Applicant: SAP SE

Inventor： JunGyoung Seong ,  Jane Jung Lee ,  Jung Kook Lee

IPC: G06F16/2453 ,  G06F16/22

Abstract: A system includes determination of a first partition-wise operation on a first database table partition of a first table located at a first server node and a first database table partition of a second table located at a second server node, determination of a first cost to execute the first partition-wise operation on the first server node, and a second cost to execute the first partition-wise operation on the second server node, determination of a second partition-wise operation on a result of the first partition-wise operation, determination of a third cost to execute the second partition-wise operation on the first server node based on the first cost and the second cost, and a fourth cost to execute the second partition-wise operation on the second server node based on the first cost and the second cost, determination of one of the first server node and the second server node to execute the second partition-wise operation based on the third cost and the fourth cost, and determination of one of the first server node and the second server node to execute the first partition-wise operation based on the third cost and the fourth cost.

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

公开(公告)号：US12189603B2

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

申请号：US17971506

申请日：2022-10-21

Applicant: SAP SE

Inventor： Won Wook Hong ,  Joo Yeon Lee ,  Hyeong Seog Kim ,  Jane Jung Lee ,  Younkyoung Lee

IPC: G06F16/23

Abstract: The present disclosure provides techniques and solutions for executing requests for database operations involving a remote data source in a system that includes an anchor node and one or more non-anchor nodes. A first request for one or more database operations is received, where at least a first database operation includes a data request for a remote data object. It is determined that the first database operation is not an insert, delete, or update operation, and therefore is assignable to the anchor node or one of the non-anchor nodes. The first database operation is assigned to a non-anchor node for execution. In a particular implementation, for a particular set of requests for a database operation, once an insert, delete, or update operation is received for the remote data object, subsequent operations for the remote data object in the set of requests are assigned to the anchor node for execution.

公开(公告)号：US20240232159A9

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

申请号：US17971506

申请日：2022-10-21

Applicant: SAP SE

Inventor： Won Wook Hong ,  Joo Yeon Lee ,  Hyeong Seog Kim ,  Jane Jung Lee ,  Younkyoung Lee

IPC: G06F16/23

CPC classification number: G06F16/23

Abstract: The present disclosure provides techniques and solutions for executing requests for database operations involving a remote data source in a system that includes an anchor node and one or more non-anchor nodes. A first request for one or more database operations is received, where at least a first database operation includes a data request for a remote data object. It is determined that the first database operation is not an insert, delete, or update operation, and therefore is assignable to the anchor node or one of the non-anchor nodes. The first database operation is assigned to a non-anchor node for execution. In a particular implementation, for a particular set of requests for a database operation, once an insert, delete, or update operation is received for the remote data object, subsequent operations for the remote data object in the set of requests are assigned to the anchor node for execution.

公开(公告)号：US11514042B1

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

申请号：US17338452

申请日：2021-06-03

Applicant: SAP SE

Inventor： Dan Bi Park ,  Jin Uk Bae ,  Jane Jung Lee ,  Yoseob Kim

IPC: G06F16/2453 ,  G06F16/248

Abstract: Technologies are described for managing multiple cache specifications for a single view in a database environment. For example, a plurality of caches can be crated for the single view. Each of the plurality of caches can have a different cache specification. A query can then be received that operates on the single view. One of the plurality of caches can be selected for processing the query based at least in part on the cache specifications. The query can be processed using the selected cache. Results of processing the query can be output.

公开(公告)号：US20180150504A1

公开(公告)日：2018-05-31

申请号：US15364649

申请日：2016-11-30

Applicant: SAP SE

Inventor： Chul Won Lee ,  Kyu Hwan Kim ,  Marcel Birn ,  Jane Jung Lee ,  Di Wu ,  Juchang Lee ,  Zhi Qiao

IPC: G06F17/30

CPC classification number: G06F17/30377 ,  G06F17/30283 ,  G06F17/30353 ,  G06F17/30365 ,  G06F17/30368 ,  G06F17/30477 ,  G06F17/30964

Abstract: A computer implemented method for initializing a first image of a first database from a recovery image; modifying the first image of the first database by replaying transaction logs of a second database; establishing a connection with a client; receiving a query via the connection, the query including a transaction to be executed on the first database; and rejecting the query when the transaction would cause any one of: updating of the first image of the first database; generating a new transaction log; and modifying the recovery image. Related apparatus, systems, techniques and articles are also described.