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

公开(公告)号：US20170322989A1

公开(公告)日：2017-11-09

申请号：US15221946

申请日：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: G06F17/30

CPC classification number: G06F11/3495 ,  G06F11/302 ,  G06F11/3466 ,  G06F11/3476 ,  G06F11/3636 ,  G06F16/211 ,  G06F16/217 ,  G06F16/258 ,  G06F16/289 ,  G06F2201/865

Abstract: Parameter-based deployment control for database objects is provided, in which processes for deploying database artifacts into a database as database objects are implemented. Many different techniques may be used in executing such deployment processes, including whether and how to combine various deployment-related jobs, identify/record/assess/correct potential errors, govern or instruct artifact conversion operations, or generally manage available resources with respect to executing the deployment(s) efficiently. By providing for selectable parameter values that are executed in an efficient, e.g., hierarchical, manner, deployment procedures may be implemented in a highly efficient and customizable manner.

公开(公告)号：US09600269B1

公开(公告)日：2017-03-21

申请号：US14948990

申请日：2015-11-23

Applicant: SAP SE

Inventor： Jonathan Bregler ,  Alexander Bunte ,  Arne Harren ,  Andreas Kellner ,  Daniel Kuntze ,  Vladislav Leonkev ,  Simon Lueders ,  Volker Sauermann ,  Michael Schnaubelt ,  Le-Huan Stefan Tran ,  Michael Wintergerst ,  Cornelia Kinder ,  Christopher Schildt ,  Andreas Thumfart ,  Ralph Debusmann ,  Andre Hildebrandt

IPC: G06F9/44 ,  G06F9/445

CPC classification number: G06F17/30 ,  G06F8/60

Abstract: A system, a method, and a computer program product for deploying of objects are disclosed. At least one file containing a plurality of artifacts for deploying during runtime of an application is defined. Each artifact in the plurality of artifacts includes at least one object in the plurality of objects required to be deployed during runtime of the application. At least one dependency for at least one artifact in the plurality of artifacts is determined. An execution order for deployment of the plurality of artifacts is generated. The plurality of artifacts is deployed in accordance with the generated execution order.

公开(公告)号：US20230401182A1

公开(公告)日：2023-12-14

申请号：US17838955

申请日：2022-06-13

Applicant: SAP SE

Inventor： Jian Luo ,  Qian Li ,  Ivan Veselinov Andreev ,  Joo Yeon Lee ,  Jonathan Bregler ,  Simon Lueders ,  Alexander Bunte ,  Eunsang Kim ,  Juchang Lee

IPC: G06F16/21 ,  G06F16/23

CPC classification number: G06F16/214 ,  G06F16/2379 ,  G06F16/212

Abstract: Technologies are described for migrating deployment infrastructure containers. Deployment infrastructure containers are used for isolating and deploying related database objects together. Deployment infrastructure containers can store design-time artifacts and run-time artifacts. Deployment infrastructure containers can be migrated using a first migration technique in which catalog objects are migrated from a source database system to a target database system and updated to work in the target database system (e.g., by updating metadata). Deployment infrastructure containers can also be migrated using a second migration technique that migrates design-time artifacts and builds the design-time artifacts at the target database system to re-create the run-time artifacts. Migrated deployment infrastructure containers can be integrated into the target environment, which can include creating new service instances and associating them with the migrated deployment infrastructure containers.

公开(公告)号：US20230087066A1

公开(公告)日：2023-03-23

申请号：US17480838

申请日：2021-09-21

Applicant: SAP SE

Inventor： Simon Lueders ,  Alexander Bunte

IPC: G06F16/23 ,  G06F16/22

Abstract: In some implementations, the current subject matter relates to deployment of database objects. In some implementations, there is provided a method that includes receiving a container including a plurality of database objects; detecting whether the plurality of database objects in the container includes a linking object pointing to an object at another container; in response to detecting the linking object, generating an external object table to store metadata about the obj ect at the other container; obtain metadata about the external object to store in the external object table; and store the obtained metadata in the external object table. Related systems, methods, and articles of manufacture are also disclosed.

公开(公告)号：US11093443B2

公开(公告)日：2021-08-17

申请号：US15637531

申请日：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: 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.

公开(公告)号：US10789208B2

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

申请号：US15666967

申请日：2017-08-02

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/00 ,  G06F16/14 ,  G06F16/13 ,  G06F16/901 ,  G06F16/23

Abstract: Embodiments map from a database environment, dependencies between files created at designtime and corresponding runtime data objects defined by deployment of those files. A dependency table is populated with dependency information (e.g., origin, target, dependency type) extracted during deployment. That dependency information may be searched according to user-specified parameters (e.g., a file provides an object; an object requires a file), to allow rapid correlation between designtime file(s) and related runtime data object(s). Embodiments are particularly useful in visualizing complex (e.g., one-to-many; many-to-one) file-object dependencies characteristic of modern database environments. Queries posed to the dependency table may further seek intra-designtime dependency information (e.g., one file depends upon another file; one file impacts another file), and/or intra-runtime dependency information (e.g., table objects referenced by view objects; view objects referenced by procedure objects). Dependency information may be recursively searched in an iterative manner in order to construct dependency pathways reflecting complex file-object relationships.