-
公开(公告)号:US11487721B2
公开(公告)日:2022-11-01
申请号:US16399533
申请日:2019-04-30
Applicant: SAP SE
Inventor: Sandra Bracholdt , Joachim Gross , Volker Saggau , Jan Portisch
Abstract: A metastructure for representing and manipulating or analyzing a data model is provided herein. A source representation of the first data model may be received. The source representation may include a representation of one or more structural components of the first data model, respectively having identifiers and types. One or more instances of a metastructure schema object datatype may be generated based on the one or more structural components of the source representation. Generating a given instance of the metastructure schema object datatype for a given structural component may include assigning a first identifier of the given structural component to the first data member of the given instance, determining a first type associated with the given structural component, and assigning the first type to the second data member of the given instance. The one or more instances of the metastructure schema object datatype may be stored in association.
-
公开(公告)号:US11263187B2
公开(公告)日:2022-03-01
申请号:US16399477
申请日:2019-04-30
Applicant: SAP SE
Inventor: Sandra Bracholdt , Volker Saggau , Jan Portisch
IPC: G06F16/21 , G06F16/242 , G06N20/00 , G06F16/182 , G06F16/25 , G06F16/901 , G06F16/2457
Abstract: A method for aligning data model schemas is provided herein. A first schema and a second schema may be received. The schemas may include sets of nodes and links between the nodes. An anchor point between the first schema and the second schema may be received. A source node in the first schema may be identified to be mapped to the second schema. A source distance may be calculated between the source node and the anchor point in the first schema. Option distances may be calculated between the anchor point and the other nodes in the second schema. Penalty scores may be calculated for the option distances. A mapping node may be selected from the nodes in the second schema based on their penalty scores. A new anchor point identifying a correspondence between the source node and the mapping node may be stored.
-
公开(公告)号:US11907182B2
公开(公告)日:2024-02-20
申请号:US17470988
申请日:2021-09-09
Applicant: SAP SE
Inventor: Jan Portisch , Sandra Bracholdt , Volker Saggau
CPC classification number: G06F16/211 , G06F16/285
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.
-
公开(公告)号:US20230014739A1
公开(公告)日:2023-01-19
申请号:US17939869
申请日:2022-09-07
Applicant: SAP SE
Inventor: Sandra Bracholdt , Joachim Gross , Volker Saggau , Jan Portisch
Abstract: A metastructure for representing and manipulating or analyzing a data model is provided herein. A source representation of the first data model may be received. The source representation may include a representation of one or more structural components of the first data model, respectively having identifiers and types. One or more instances of a metastructure schema object datatype may be generated based on the one or more structural components of the source representation. Generating a given instance of the metastructure schema object datatype for a given structural component may include assigning a first identifier of the given structural component to the first data member of the given instance, determining a first type associated with the given structural component, and assigning the first type to the second data member of the given instance. The one or more instances of the metastructure schema object datatype may be stored in association.
-
公开(公告)号:US20210232591A1
公开(公告)日:2021-07-29
申请号:US16776407
申请日:2020-01-29
Applicant: SAP SE
Inventor: Jan Portisch , Ronald Boehle , Sandra Bracholdt , Volker Saggau
IPC: G06F16/25 , G06F16/28 , G06F16/9035 , G06N20/00 , G06F16/2455
Abstract: Transformation rule generation and validation functionality is provided herein. Transformation rules can be generated for one or more mappings in an alignment between a source database and a target database. The transformation rules can transform instance data from the source data model to a form matching the target data model. One or more transformation rules can be generated for a mapping between fields in a source database and a field in a target database. The transformation rules can be generated based on one or more source fields and a target field of a mapping, and one or more identified functions. Evaluating the transformation rules can include generating test data based on the transformation rules applied to instance data from the source database. The test data can be evaluated against instance data from the target database. The transformation rules and the evaluation results can be provided in a user interface.
-
公开(公告)号:US20200342007A1
公开(公告)日:2020-10-29
申请号:US16926097
申请日:2020-07-10
Applicant: SAP SE
Inventor: Sandra Bracholdt , Volker Saggau , Jan Portisch
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.
-
7.
公开(公告)号:US20240296080A1
公开(公告)日:2024-09-05
申请号:US18116751
申请日:2023-03-02
Applicant: SAP SE
Inventor: Jan Portisch , Sandra Bracholdt , Volker Saggau
Abstract: A computer-implemented method can include generating a first knowledge graph from a first version of an application programming interface (API), generating a second knowledge graph from a second version of the API, identifying changes from the second knowledge graph to the first knowledge graph, and generating a difference graph based on the identified changes from the second knowledge graph to the first knowledge graph. The difference graph connects the second knowledge graph to the first knowledge graph via one or more revision edges, which represent the identified changes from the second knowledge graph to the first knowledge graph.
-
公开(公告)号:US11726969B2
公开(公告)日:2023-08-15
申请号:US17939869
申请日:2022-09-07
Applicant: SAP SE
Inventor: Sandra Bracholdt , Joachim Gross , Volker Saggau , Jan Portisch
CPC classification number: G06F16/213 , G06F16/2282 , G06F16/254 , G06F16/284
Abstract: A metastructure for representing and manipulating or analyzing a data model is provided herein. A source representation of the first data model may be received. The source representation may include a representation of one or more structural components of the first data model, respectively having identifiers and types. One or more instances of a metastructure schema object datatype may be generated based on the one or more structural components of the source representation. Generating a given instance of the metastructure schema object datatype for a given structural component may include assigning a first identifier of the given structural component to the first data member of the given instance, determining a first type associated with the given structural component, and assigning the first type to the second data member of the given instance. The one or more instances of the metastructure schema object datatype may be stored in association.
-
公开(公告)号:US20220237185A1
公开(公告)日:2022-07-28
申请号:US17160153
申请日:2021-01-27
Applicant: SAP SE
Inventor: Jan Portisch , Sandra Bracholdt , Oliver Huth , Volker Saggau
IPC: 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.
-
公开(公告)号:US10901987B2
公开(公告)日:2021-01-26
申请号:US16220886
申请日:2018-12-14
Applicant: SAP SE
Inventor: Jan Portisch , Sandra Bracholdt , Volker Saggau
IPC: G06F16/00 , G06F16/242 , G06F16/955 , G06F16/22 , G06F16/26
Abstract: A process for mining existing views to generate new views is provided herein. A request to generate a proposed view combining a plurality of tables in a database may be received. One or more existing views in the database applicable to the request may be identified. The applicable existing views may include the plurality of tables in the request. One or more paths combining the plurality of tables may be identified in the respective one or more existing views. The identified one or more paths may be provided. One or more scores for the one or more paths may be generated and provided along with the one or more paths. A path may be automatically selected based on the scores or a path may be selected by a user. A view may be generated based on the selected path.
-
-
-
-
-
-
-
-
-