公开(公告)号：EP3401804A1

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

申请号：EP18170530.2

申请日：2018-05-03

Applicant: SAP SE

Inventor： LEE, Juchang ,  KIM, Kyu Hwan ,  LEE, Joo Yeon ,  PARK, Kyungyul ,  KIM, Deok Hoe

IPC: G06F17/30 ,  G06F11/14 ,  H04L29/08

CPC classification number: G06F17/30356 ,  G06F11/14 ,  G06F17/30353 ,  G06F17/30377 ,  G06F17/30545 ,  G06F17/30554 ,  G06F17/30575 ,  H04L67/1034

Abstract: Technologies are described providing adaptive query routing in a replicated database environment. The technologies can be used with a variety of replication protocols. Prepared statements, such as for queries, from a database client can be routed to a source node, or a source node and available replica nodes, when a replica node becomes unavailable. When a replica node becomes available again, a prepared statement can be updated to indicate that the updated prepared statement can be executed at nodes including the replica node that is available again. Prepared statement routing can also be used when a portion of replicated data becomes unavailable at a replica node, but a portion of replicated data remains available.

公开(公告)号：EP4361834A1

公开(公告)日：2024-05-01

申请号：EP23204059.2

申请日：2023-10-17

Applicant: SAP SE

Inventor： KIM, Jaehwa ,  PARK, Kyungyul ,  KIM, Eunsang ,  LEE, Joo Yeon ,  LEE, Taehyung

IPC: G06F16/21

CPC classification number: 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.