公开(公告)号：US11442907B2

公开(公告)日：2022-09-13

申请号：US16780481

申请日：2020-02-03

Applicant: SAP SE

Inventor： Jan Portisch ,  Bjoern Pantel ,  Benjamin Merkle ,  Stephan Schub ,  Sandra Bracholdt ,  Roland Kolata ,  Michael Hladik ,  Christoph Meinel

IPC: G06F16/21 ,  G06F16/28 ,  G06F16/22

Abstract: Techniques and solutions are described for converting data models between formats, such as between a conceptual data model and a physical data model for a database system, or between a conceptual data model and artefacts to be implemented in the database system. The conceptual data model is annotated with annotations that allow the physical data model or database artefacts to be automatically generated from the conceptual data model. The annotations can reflect relationships between entity types in the physical data model, such as inheritance relationships, header/item relationships, or one-to-one cardinality relationships. Annotations can also indicate attributes that should be added to entity types in the conceptual data model, such as attributes for versioning or data governance, that may not be used in the conceptual data model. Annotations can be used to determine how entity types in the conceptual data model will be denormalized in the physical data model.

公开(公告)号：US11422984B2

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

申请号：US16399363

申请日：2019-04-30

Applicant: SAP SE

Inventor： Jan Portisch ,  Sandra Bracholdt ,  Björn Pantel ,  Volker Saggau

IPC: G06F16/21 ,  G06F16/28 ,  G06F16/907

Abstract: A method for data model clustering is provided herein. A first representation of a data model may be received. Edge betweenness values may be determined for respective nodes in the first representation. At least one node in the first representation may be identified as a linking node based on the respective edge betweenness values. One or more linking nodes may be removed from the first representation, thereby forming at least a first cluster and a second cluster. Degrees for the respective remaining nodes may be calculated. Respective hub nodes may be identified for the respective clusters based on the respective degrees in the clusters. Respective descriptions may be generated for the respective clusters based on the respective hub nodes. A clustered representation of the first representation may be stored with the clusters and their respective descriptions.

公开(公告)号：US20210357577A1

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

申请号：US17387217

申请日：2021-07-28

Applicant: SAP SE

Inventor： Jan Portisch ,  Joachim Gross ,  Sandra Bracholdt

IPC: G06F40/151 ,  G06F16/2458 ,  G06F40/103

Abstract: Techniques and solutions are described for defining transformation specifications in a programming-language independent language and converting such specifications to one or more executable formats. The language can provide for defining rules and actions. Rules can refer to (e.g., be based at least in part on) data targets, such as attributes of a schema, whose identifiers are to be read or updated, or to other rules. Rules can be reused, and can recursively refer to one another, such that a large number of complex schema transformations can be accomplished using a series of first order logic statements. Actions can define what, and how, values will be changed when a predicate rule is satisfied. A transformation specification in the language can be parsed and selectively complied to one or more executable formats, including in programming languages such as the structured query language. Disclosed technologies can facilitate data transformations by non-technical users.

公开(公告)号：US20210318995A1

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

申请号：US16848463

申请日：2020-04-14

Applicant: SAP SE

Inventor： Jan Portisch ,  Ronald Boehle ,  Volker Saggau ,  Sandra Bracholdt

IPC: G06F16/21

Abstract: Techniques and solutions are described for determining a set of elements of a second set that may correspond to a given element of a first set of elements. The elements can be, in specific examples, components of a database system, such as tables (or entities), attributes, or records. Significance metric values are calculated for elements in the first and second sets. The significance metric values can be a number of records in an entity or a number of read or write access operations for an entity or for a record of an entity. A significance metric value for the given element can be used at least in part to select elements of the second set as potential match candidates, based at least in part on significance metric values for elements of the second set. Selecting elements can include selecting elements based on a window of elements of the second set or a range of significance metric values.

公开(公告)号：US11144549B2

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

申请号：US16221151

申请日：2018-12-14

Applicant: SAP SE

Inventor： Jan Portisch ,  Sandra Bracholdt ,  Volker Saggau

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/28 ,  G06F16/901

Abstract: A process for mining existing views to generate join statements is provided herein. A request to generate a join statement may be received, which may include a database object identifier to be part of the join statement. One or more views in the database may be identified, which may include the database object identifier. One or more edges in the one or more views may be identified, which may include the database object identifier. Scores for the one or more edges may be calculated. The edges may be filtered based on their scores according to one or more filtering rules. The filtered edges may be provided. A selected edge may be received, which may be selected from the provided filtered edges. The join statement may be generated in a query language. The join statement may be based on the selected edge. The generated join statement may be provided.

公开(公告)号：US20200012741A1

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

申请号：US16027010

申请日：2018-07-03

Applicant: SAP SE

Inventor： Sandra Bracholdt ,  Volker Saggau ,  Jan Portisch

IPC: G06F17/30

Abstract: Techniques and solutions are described for determining, evaluating, and selecting data retrieval pathways. A plurality of database objects, such as tables, can be retrieved, and relationships between them determined. The relationships are between various attributes of the database objects. A plurality of pathways are determined between at least two target database objects, where the path determination does not consider attribute-level relationship information. After a path is determined, the relationship-level information can be added. A summary of the path, and relationship information, can be displayed to a user. A user can select paths to remove from the display, and can indicate one or more database objects that are required for a valid path, one or more database objects that are prohibited from valid paths, or combinations thereof. A user can select a path, and a query language statement to implement the path can be generated and displayed to the user.