公开(公告)号：US11941142B2

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

申请号：US17389548

申请日：2021-07-30

Applicant: SAP SE

Inventor： Arne Harren ,  Marco Haupt ,  Helmut Prestel ,  Rolf Hammer ,  Christiane Kettschau ,  Kai Baumgarten ,  Diego Sebastian Will ,  Minh-Khanh Do ,  Timm Falter ,  Frank-Martin Haas ,  Kilian Kilger

IPC: G06F16/25 ,  G06F21/62 ,  H04L9/40

CPC classification number: G06F21/6227 ,  G06F16/256 ,  G06F16/258 ,  H04L63/0815 ,  H04L63/0823

Abstract: Methods for using SQL statements to access an application-server-managed database are disclosed herein. In some embodiments, a user sends, either directly or indirectly (i.e., remotely) a SQL statement from an ODBC application or server, respectively, to an application server that preprocesses SQL statements for accessing data from a centralized database. The application server may have a SQL endpoint, and access to the SQL endpoint may be determined by a user's logon credentials, a user's presentation of a SAML token, or a user's presentation of a valid certificate. The application server may then parse the SQL statement and determine the user's authorization to access certain objects in the centralized database based on a SQL handler design-time configuration. A result from the statement may be sent back to the user either directly or indirectly and exposed.

公开(公告)号：US20210365405A1

公开(公告)日：2021-11-25

申请号：US17398167

申请日：2021-08-10

Applicant: SAP SE

Inventor： Jonathan Bregler ,  Alexander Bunte ,  Arne Harren ,  Andreas Kellner ,  Daniel Kuntze ,  Simon Lueders ,  Volker Sauermann ,  Michael Schnaubelt ,  Le-Huan Stefan Tran

IPC: G06F16/11 ,  G06F9/445 ,  G06F8/70 ,  G06F8/60 ,  G06F16/28 ,  G06F16/21

Abstract: A container group is created using a database deployment infrastructure (DI) administrator (HA). API privileges for the container group are granted, using the HA, to a container group administrator (GA). API privileges for a container created in the container group using the GA are granted, using the GA, to a container administrator (CA). API privileges for the container are granted, using the CA, to a container developer (CD). Schema privileges for the container are granted, using the CA, to a container consumer (CC). API privileges for the container group are revoked, using the HA, from the GA. The container group is dropped using the HA.

公开(公告)号：US11157854B2

公开(公告)日：2021-10-26

申请号：US15221710

申请日：2016-07-28

Applicant: SAP SE

Inventor： Le-Huan Stefan Tran ,  Arne Harren ,  Jonathan Bregler ,  Alexander Bunte ,  Andreas Kellner ,  Daniel Kuntze ,  Vladislav Leonkev ,  Simon Lueders ,  Volker Sauermann ,  Michael Schnaubelt

IPC: G06Q10/06 ,  G06F16/21 ,  G06F16/23 ,  G06F16/2458 ,  G06F16/2455 ,  G06F16/901

Abstract: Systems and methods are disclosed for automatically detecting a connection status in an asynchronous processing request. An example method includes obtaining, at a processing client and responsive to a first request from a requesting client to perform a plurality of database operations in a single transaction, a connection identifier for a connection to a database on a database server, the connection to be used to execute the plurality database operations and storing the connection identifier in a row of a status table. In some implementations the existence of the row indicates the status of the connection is active. In some implementations the row includes a flag indicating the status. The method also includes providing the connection identifier to the requesting client, receiving a second request from the requesting client, the second request being for a status of the connection, determining the status using the status table.

公开(公告)号：US20210157776A1

公开(公告)日：2021-05-27

申请号：US16695770

申请日：2019-11-26

Applicant: SAP SE

Inventor： Jonathan Bregler ,  Alexander Bunte ,  Andreas Kellner ,  Simon Lueders ,  Arne Harren

IPC: G06F16/21 ,  G06F16/23 ,  G06F16/25 ,  G06F8/71 ,  G06F16/22

Abstract: In an example embodiment, a new development infrastructure is provided that provides an external repository for database definitions. The development infrastructure also then includes a development mode. When using the development mode, the behavior of the development infrastructure is modified to better fit the development of database artifacts. The developer uses a development base version of a definition (usually the latest released version of the definition) but also creates migrations that indicate how the development base version should be modified to arrive at the developer's intended new definition. While still in development mode, the deployment may be run, which causes data in the development mode that uses the old definition to be dropped and replaced by the base version. The development mode then executes the specified migrations.

公开(公告)号：US10789220B2

公开(公告)日：2020-09-29

申请号：US15471801

申请日：2017-03-28

Applicant: SAP SE

Inventor： Martin Mayer ,  Arne Harren ,  Matthias Jensen ,  Volker Driesen

IPC: G06F15/16 ,  G06F16/21 ,  G06F9/451 ,  G06F16/25

Abstract: Implementations for data migration in a maintenance procedure executed on a software system include actions of providing a first access schema, through which a first version of an application accesses data in a database system, establishing an API-schema, through which at least one direct consumer accesses data in the database system, the API-schema including one or more proxy objects that are mapped to respective one or more objects of the first access schema based on metadata of the API-schema, the metadata providing a mapping and one or more object definitions, and in response to execution of a maintenance procedure: providing a second access schema, through which a second version of the application accesses data in the database system, switching to the second access schema, and revising the mapping of the API-schema, such that at least one proxy object of the API-schema maps to a respective object of the second access schema.

公开(公告)号：US10671630B2

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

申请号：US15222035

申请日：2016-07-28

Applicant: SAP SE

Inventor： Le-Huan Stefan Tran ,  Arne Harren ,  Jonathan Bregler ,  Alexander Bunte ,  Andreas Kellner ,  Daniel Kuntze ,  Vladislav Leonkev ,  Simon Lueders ,  Volker Sauermann ,  Michael Schnaubelt

IPC: G06F16/21 ,  G06F16/25 ,  G06F16/2455 ,  G06F21/62

Abstract: A database includes a run-time database container, which provides an isolated computing environment for a database object deployed therein. The database further includes a public synonym object outside the run-time database container in the database. The public synonym object is associated with the database object deployed inside the run-time database container and provides external access to the database object deployed inside the run-time database container independent of the location of the run-time database container.

公开(公告)号：US10657114B2

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

申请号：US15824041

申请日：2017-11-28

Applicant: SAP SE

Inventor： Jonathan Bregler ,  Alexander Bunte ,  Arne Harren ,  Andreas Kellner ,  Daniel Kuntze ,  Simon Lueders ,  Volker Sauermann ,  Michael Schnaubelt ,  Le-Huan Stefan Tran

IPC: G06F16/22 ,  G06F16/25

Abstract: An import configuration section of a file is identified, where the import configuration identifies a database table. Key specifications of the database table are reserved based on the import configuration. A first and a second Boolean flag parameter associated with the database table is identified. A determination is made that i) a value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) a value of the second Boolean flag indicates removal of entries of the database table is allowed. In response to the determining entries are removed from the database table corresponding to the key specifications, and entries are imported from the file into the database table corresponding to the key specifications.

公开(公告)号：US10521310B2

公开(公告)日：2019-12-31

申请号：US15221998

申请日：2016-07-28

Applicant: SAP SE

Inventor： Le-Huan Stefan Tran ,  Arne Harren ,  Jonathan Bregler ,  Alexander Bunte ,  Andreas Kellner ,  Daniel Kuntze ,  Vladislav Leonkev ,  Simon Lueders ,  Volker Sauermann ,  Michael Schnaubelt

IPC: G06F16/26 ,  G06F11/14 ,  G06F16/21 ,  G06F11/36

Abstract: Systems and techniques for ordering deployment of artifacts to a database include collecting predecessor node information for nodes in a dependency graph. The dependency graph includes available edges connecting the nodes of the dependency graph, where each node in the dependency graph represents at least one artifact. A data structure contained within each of the nodes is populated with the predecessor node information. Successor node information is determined using the predecessor node information and an updated dependency graph is created by adding additional edges to the dependency graph using the predecessor node information in the data structure within each of the nodes and the successor node information. The artifacts are ordered for deployment to the database using the updated dependency graph.

公开(公告)号：US20190266171A1

公开(公告)日：2019-08-29

申请号：US16406757

申请日：2019-05-08

Applicant: SAP SE

Inventor： Le-Huan Stefan Tran ,  Jonathan Bregler ,  Alexander Bunte ,  Arne Harren ,  Andreas Kellner ,  Daniel Kuntze ,  Vladislav Leonkev ,  Simon Lueders ,  Volker Sauermann ,  Michael Schnaubelt

IPC: G06F16/25 ,  G06F16/2455 ,  G06F16/21 ,  G06F21/62

Abstract: A computer-implemented method for exporting a database container from a database includes exporting database container metadata including artifact definitions in the metadata along with the actual metadata content to a database management system, exporting the database container including the database objects deployed therein to the database management system. The exporting of the database container includes exporting dependencies and structures of the database objects deployed therein, but not the actual content of the database objects. In some instances, however, exporting of the database container can include exporting the actual content of the database objects in response to user request. The method further includes packing the exported database container metadata and the exported database container in an archive. The data in the archive can be unpacked in substantially reverse order to import the database container into another database.

公开(公告)号：US20190005108A1

公开(公告)日：2019-01-03

申请号：US15637601

申请日：2017-06-29

Applicant: SAP SE

Inventor： Jonathan Bregler ,  Alexander Bunte ,  Arne Harren ,  Andreas Kellner ,  Daniel Kuntze ,  Simon Lueders ,  Volker Sauermann ,  Michael Schnaubelt ,  Le-Huan Stefan Tran

IPC: G06F17/30 ,  G06F9/38 ,  G06F9/445

Abstract: A dependency graph is generated for database files. An unvisited node of the dependency graph is selected and a breadth-first-search performed starting from the selected unvisited node. Results of the breadth-first-search is defined as a group. A group assignment for the database files is returned.