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

公开(公告)号：US20180336245A1

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

申请号：US15596905

申请日：2017-05-16

Applicant: SAP SE

Inventor： Di Wu ,  Ki Hong Kim ,  Stefan Baeuerle ,  Steffen Weinstock ,  Daniel Hutzel ,  Zhi Qiao

IPC: G06F17/30

CPC classification number: G06F16/24535 ,  G06F16/212 ,  G06F16/245 ,  G06F16/24537

Abstract: A method for propagating a structure query language (SQL) association can include determining, based at least on a syntax of a SQL create view statement, that a SQL association requires propagation to a SQL view associated with the SQL create view statement. The SQL association can combine data from at least a first data model and a second data model at a database. The SQL view can comprise at least a portion of the combined data. An association information data structure can be generated for storing information corresponding to a definition of the SQL association. The SQL create view statement can be executed based on the association information data structure. Related systems and articles of manufacture, including computer program products, are also disclose.

公开(公告)号：US11416485B2

公开(公告)日：2022-08-16

申请号：US16368448

申请日：2019-03-28

Applicant: SAP SE

Inventor： Zhi Qiao ,  Stefan Baeuerle ,  Ki Hong Kim ,  Florian Scheid ,  Timm Falter ,  Andreas Balzar ,  Di Wu

IPC: G06F16/2453 ,  G06F9/54 ,  G06F16/22

Abstract: Implementations of the present disclosure include receiving a query, the query including an expression macro (EM), processing the query to provide a raw parse tree, the raw parse tree including an initial node representative of the EM, retrieving metadata corresponding to the EM, the metadata including a definition string, replacing the initial node with a node based on the definition string to provide a consumable parse tree, and executing the query within the database system using the consumable parse tree to provide a query result.

公开(公告)号：US10558658B2

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

申请号：US15596905

申请日：2017-05-16

Applicant: SAP SE

Inventor： Di Wu ,  Ki Hong Kim ,  Stefan Baeuerle ,  Steffen Weinstock ,  Daniel Hutzel ,  Zhi Qiao

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/21 ,  G06F16/245

Abstract: A method for propagating a structure query language (SQL) association can include determining, based at least on a syntax of a SQL create view statement, that a SQL association requires propagation to a SQL view associated with the SQL create view statement. The SQL association can combine data from at least a first data model and a second data model at a database. The SQL view can comprise at least a portion of the combined data. An association information data structure can be generated for storing information corresponding to a definition of the SQL association. The SQL create view statement can be executed based on the association information data structure. Related systems and articles of manufacture, including computer program products, are also disclose.

公开(公告)号：US20200311078A1

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

申请号：US16368448

申请日：2019-03-28

Applicant: SAP SE

Inventor： Zhi Qiao ,  Stefan Baeuerle ,  Ki Hong Kim ,  Florian Scheid ,  Timm Falter ,  Andreas Balzar ,  Di Wu

IPC: G06F16/2453 ,  G06F16/22 ,  G06F9/54

Abstract: Implementations of the present disclosure include receiving a query, the query including an expression macro (EM), processing the query to provide a raw parse tree, the raw parse tree including an initial node representative of the EM, retrieving metadata corresponding to the EM, the metadata including a definition string, replacing the initial node with a node based on the definition string to provide a consumable parse tree, and executing the query within the database system using the consumable parse tree to provide a query result.

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