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

公开(公告)号：US20230073312A1

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

申请号：US17470988

申请日：2021-09-09

Applicant: SAP SE

Inventor： Jan Portisch ,  Sandra Bracholdt ,  Volker Saggau

IPC: G06F16/21 ,  G06F16/28

Abstract: A computer-implemented method includes receiving a request of data records for a data schema, obtaining a schema alignment which maps the data schema to a subset of an ontology of a knowledge graph, generating at least one query based on the subset of the ontology of the knowledge graph, obtaining a list of data records by executing the at least one query on the knowledge graph to obtain a list of data records, and persisting the list of data records to the data schema.

公开(公告)号：US11599517B2

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

申请号：US16920260

申请日：2020-07-02

Applicant: SAP SE

Inventor： Jan Portisch ,  Volker Saggau ,  Sandra Bracholdt

IPC: G06F16/00 ,  G06F16/22

Abstract: A variety of scenarios for generating mock data based on original data are described. Characteristics of the original data can be reflected in the mock data without having access to the actual original data. Instead, statistical artifacts representing the original data can be used to instantiate reconstructed database tables. In relational database scenarios, foreign key relationships can be preserved even if the actual values are not known. The reconstructed database tables can be used as mock data in a variety of circumstances, including testing, and is especially useful to recreate characteristics of the original data when the original data cannot be made available for size, confidentiality, or privacy reasons.

公开(公告)号：US11455283B2

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

申请号：US16848463

申请日：2020-04-14

Applicant: SAP SE

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

IPC: G06F16/00 ,  G06F16/21 ,  G06Q10/10

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.

公开(公告)号：US11449529B2

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

申请号：US16926097

申请日：2020-07-10

Applicant: SAP SE

Inventor： Sandra Bracholdt ,  Volker Saggau ,  Jan Portisch

IPC: G06F16/00 ,  G06F16/28 ,  G06F16/26 ,  G06F16/21 ,  G06F3/04842

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.

公开(公告)号：US11436244B2

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

申请号：US17160153

申请日：2021-01-27

Applicant: SAP SE

Inventor： Jan Portisch ,  Sandra Bracholdt ,  Oliver Huth ,  Volker Saggau

IPC: G06F16/24 ,  G06F16/2458

Abstract: A computer-implemented method can receive a source table containing data tuples and a source schema defining attributes of the data tuples, and match the source schema to an ontology of a knowledge graph. The knowledge graph can include a plurality of instances and the ontology defines properties of the plurality of instances. The computer-implemented method can link the data tuples to respective instances in the knowledge graph, and identifying non-matching properties of the respective instances, wherein the non-matching properties are defined in the ontology and not matched to the source schema. The computer-implemented method can obtain property values associated with the non-matching properties from the knowledge graph, and add one or more of the non-matching properties and the associated property values to respective data tuples of the source table.

公开(公告)号：US20220004532A1

公开(公告)日：2022-01-06

申请号：US16920260

申请日：2020-07-02

Applicant: SAP SE

Inventor： Jan Portisch ,  Volker Saggau ,  Sandra Bracholdt

IPC: G06F16/22

Abstract: A variety of scenarios for generating mock data based on original data are described. Characteristics of the original data can be reflected in the mock data without having access to the actual original data. Instead, statistical artifacts representing the original data can be used to instantiate reconstructed database tables. In relational database scenarios, foreign key relationships can be preserved even if the actual values are not known. The reconstructed database tables can be used as mock data in a variety of circumstances, including testing, and is especially useful to recreate characteristics of the original data when the original data cannot be made available for size, confidentiality, or privacy reasons.

公开(公告)号：US20210073655A1

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

申请号：US16567470

申请日：2019-09-11

Applicant: SAP SE

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

IPC: G06N5/02 ,  G06F16/901

Abstract: Smart rule development and rule mining functionality is provided herein. Rule mining for use in rule development can include generating logic statement proposals, rule deduplication, and rule template generation. Rule mining can include accessing a rule set to analyze the rule set against an input logic statement to identify existing rules which match at least in part the input logic statement. Rule deduplication can include returning exact rule matches to replace the input logic statement. Proposing logic statements can include returning logically related rules from rules found that include the input logic statement. Generating rule templates can include returning a template based on the entire rule(s) which includes the input logic statement. Ranking scores can be calculated for returned rules, whether for deduplication, proposals, or template generation. The scores can be based on statistical information for the rules, such as usage of the rule or coverage of the rule.

公开(公告)号：US20210012219A1

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

申请号：US16507465

申请日：2019-07-10

Applicant: SAP SE

Inventor： Jan Portisch ,  Sandra Bracholdt ,  Michael Monych ,  Volker Saggau

IPC: G06N5/02 ,  G06N7/00

Abstract: Automatic rule generation is provided herein for generating data mapping, data transformation, or process flow rules or logic statements. The rules may be generated based on a field or attribute, and may be further based on a partial rule or one or more existing rules, or a combination thereof. Proposed rules may be generated based on analysis of a data set, including identifying possible values for the attribute and to calculate scores for the possible values. A score may be the probability of the value based on the data set. The data set may be cleaned or scrubbed based on the partial rule or existing rules. The proposed rules may be provided to a user, or may be automatically selected. Rule generation may include constraint checking. Constraint checking may include detecting empty data sets or detecting when two rules are not mutually exclusive.

公开(公告)号：US10726052B2

公开(公告)日：2020-07-28

申请号：US16027010

申请日：2018-07-03

Applicant: SAP SE

Inventor： Sandra Bracholdt ,  Volker Saggau ,  Jan Portisch

IPC: G06F16/00 ,  G06F16/28 ,  G06F16/26 ,  G06F16/21 ,  G06F3/0484

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.