-
公开(公告)号：US10528440B2
公开(公告)日：2020-01-07
申请号：US15362701
申请日：2016-11-28
Applicant: SAP SE
Inventor： Joo Yeon Lee , Eunsang Kim , Sunghoon Lee , Hanggjun Cho , Kyungyul Park
IPC: G06F11/20
Abstract: Systems and methods for generating a platform-independent metadata catalog framework of a database system are disclosed. These include receiving, at the database system, a metadata object, and determining a version of the received metadata object. Responsive to determining that a metadata catalog, which has catalog entries associated with unique versions of metadata objects, does not include a catalog entry associated with the version of the received metadata object, a catalog entry in the metadata catalog is created. The created catalog entry is then associated with the version of the received metadata object. Furthermore, a version number based on the version of the received metadata is generated, which is associated with the created catalog entry. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号：US12242459B2
公开(公告)日：2025-03-04
申请号：US17973440
申请日：2022-10-25
Applicant: SAP SE
Inventor： Jaehwa Kim , Kyungyul Park , Eunsang Kim , Joo Yeon Lee , Taehyung Lee
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.
-
公开(公告)号：US20240134842A1
公开(公告)日：2024-04-25
申请号：US17973440
申请日：2022-10-24
Applicant: SAP SE
Inventor： Jaehwa Kim , Kyungyul Park , Eunsang Kim , Joo Yeon Lee , Taehyung Lee
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.
-
公开(公告)号：US11914572B2
公开(公告)日：2024-02-27
申请号：US18087712
申请日：2022-12-22
Applicant: SAP SE
Inventor： Juchang Lee , Kyu Hwan Kim , Joo Yeon Lee , Kyungyul Park , Deok Hoe Kim
IPC: G06F16/23 , G06F16/248 , G06F16/27 , G06F16/2458 , G06F11/20 , H04L67/1095 , G06F11/16
CPC classification number: G06F16/2329 , G06F11/2035 , G06F11/2094 , G06F11/2097 , G06F16/2322 , G06F16/2379 , G06F16/248 , G06F16/2471 , G06F16/27 , H04L67/1095 , G06F11/1658 , G06F11/2048 , G06F2201/80
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.
-
Patent Agency Ranking
公开(公告)号：US20180322157A1
公开(公告)日：2018-11-08
申请号：US15589160
申请日：2017-05-08
Applicant: SAP SE
Inventor： Juchang Lee , Kyu Hwan Kim , Joo Yeon Lee , Kyungyul Park , Deok Hoe Kim
IPC: G06F17/30
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.
-
公开(公告)号：US20240232165A9
公开(公告)日：2024-07-11
申请号：US17973440
申请日：2022-10-25
Applicant: SAP SE
Inventor： Jaehwa Kim , Kyungyul Park , Eunsang Kim , Joo Yeon Lee , Taehyung Lee
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.
-
公开(公告)号：US20230129099A1
公开(公告)日：2023-04-27
申请号：US18087712
申请日：2022-12-22
Applicant: SAP SE
Inventor： Juchang Lee , Kyu Hwan Kim , Joo Yeon Lee , Kyungyul Park , Deok Hoe Kim
IPC: G06F16/23 , G06F16/248 , G06F16/27 , G06F16/2458 , G06F11/20 , H04L67/1095
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.
-
公开(公告)号：US11573947B2
公开(公告)日：2023-02-07
申请号：US15589160
申请日：2017-05-08
Applicant: SAP SE
Inventor： Juchang Lee , Kyu Hwan Kim , Joo Yeon Lee , Kyungyul Park , Deok Hoe Kim
IPC: G06F16/23 , G06F16/248 , G06F16/27 , G06F16/2458 , G06F11/20 , H04L67/1095 , G06F11/16
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.
-
公开(公告)号：US10185632B2
公开(公告)日：2019-01-22
申请号：US14657865
申请日：2015-03-13
Applicant: SAP SE
Inventor： Juchang Lee , Joo-Yeon Lee , Kyu-Hwan Kim , Deok-Hoe Kim , Kyungyul Park
Abstract: Disclosed herein are system, method, and computer program product embodiments for minimizing table lock duration during lost change resynchronization between a source table and a replica table. An embodiment operates by detecting a restart at a source node or a replica node. A source table at the source node is then locked based on the detection. A database transaction is then created for a lost change resynchronization operation and the source table is unlocked. The database transaction is then compared to another database transaction based on its timestamp. Based on the comparison, either the database transaction for the lost change resynchronization operation or the other database transaction is executed.
-
-
-
-
-
-
-
-
Search Results
9
records
(took 0.014 seconds)
