Sap Se

Jan Portisch

Sandra Bracholdt

Volker Saggau

Michael Hladik

Joachim Gross

Stephan Schub

Christoph Meinel

Roland Kolata

Oliver Huth

Bjoern Pantel

Benjamin Merkle

Ronald Boehle

Yannik Hahn

Katharina Minninger

Michael Monych

Robert Weller

Björn Pantel

Guilherme Ehrhardt Soares Ferreira Da Costa

Ulrich Block

Guilherme Ehrhardt S Ferreira Costa

Various examples are directed to systems and methods for utilizing relationship data. A computing system may receive a time-dependent query against a knowledge graph data structure. The computing system may access confirmation data from the knowledge graph data structure, the confirmation data describing a first plurality of confirmation points-in-time at which the first test relationship is true. The computing system may determine that at least one of a beginning or an end of a first time period associated with a test relationship of the time-dependent query is not defined by the knowledge graph data structure. The computing system may determine a response to the first time-dependent query indicating a veracity of the test relationship at a test point-in-time using the first plurality of confirmation points-and-time.

Systems and methods for manipulating time-dependent relationships in knowledge graph data structures

In an example embodiment, a system is provided that takes a knowledge graph as input and generates multiple question templates based on predefined query types. These query types may be, for example, SPARQL query types and may also be configurable. The system repeatedly presents a single randomly or pseudo-randomly picked question template to a user, and asks the user to type a corresponding natural language question. The system persists the answer provided by the user with the question in a specialized format. Then, for each typed question, the system creates additional linguistic variations and asks users to rate them.

Question-answer reference data set generation for artificial intelligence

A computer-implemented method includes representing a plurality of database tables as respective vectors in a multi-dimensional vector space, receiving an indication that a first database table represented by a first vector and a second database table represented by a second vector are related to each other, moving positions of the respective vectors representing the plurality of database tables in the multi-dimensional vector space in response to the indication, and grouping the plurality of database tables into one or more table clusters based on positions of the respective vectors representing the plurality of database tables in the multi-dimensional vector space.

Relationship analysis using vector representations of database tables

Techniques and solutions are provided for improved data modelling, including techniques that facilitate data model comparison, integration, or deployment. A core data model is created that has a plurality of elements, which can represent semantic concepts, including relationships between semantic concepts. A plurality of domain models are mapped to core data model elements. In particular, when a domain model element is to be created, the element is mapped to a core data model element. When a relation is to be established between two domain model elements, the relation is mapped to a relation type represented in the core data model. Mapping to a core data model can be enforced as part of domain model creation, allowing different domain models to be compared, since domain elements in different domain models that represent a common semantic will be mapped to the same core data model element.

Automatic enforcement of standardized data model mapping

Intelligent annotation of data models can be implemented. In one embodiment, the method can receive a data model including entities and relationships between the entities. An entity can include a set of attributes. The method can annotate the data model by defining a logical entity including one or more of the entities, validate the logical entity, and automatically generate a message structure corresponding to the logical entity. The message structure can include properties mapped to at least some of the attributes of entities contained in the logical entity. The properties can be defined in one or more database tables represented by the logical entity.

Intelligent annotation of entity-relationship data models

An intelligent labeling method is disclosed herein. The method can receive a plurality of input instances and access a knowledge graph comprising a plurality of nodes and a plurality of edges connecting the plurality of nodes. The plurality of nodes represent objects and the edges represent relationship between the objects. For at least some selected input instances, the method can identify respective matching objects represented by corresponding nodes of the knowledge graph. A selected input instance shares a common label with the corresponding matching object. For identified matching objects, the method can identify a common class object represented by a corresponding node of the knowledge graph. A percentage of identified matching objects are descendants of the common class object, and the percentage is greater than a predefined threshold. The method can associate a label of the common class object with the plurality of input instances.

Systems and methods for intelligent labeling of instance data clusters based on knowledge graph

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.

Schema-based data retrieval from knowledge graphs

Systems and methods provide identification of a first configuration specifying a first column of a first data source, acquisition, based on the first configuration, of a first sequence of values stored in consecutive rows of the first column, and storage of the first sequence of values in a storage device in association with an identifier of the first data source and the first column.

Searchable catalog of columnar numerical data

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.

Automatic conversion of data models using data model annotations

Various examples are directed to systems and methods for administering data model metadata for a plurality of data models. A metadata service may receive a first retrieval request from a requesting system. The first retrieval request may comprise an indication of a first local object identifier referencing a definition of a first local object from a first data model and an indication of a target data model. The metadata service may retrieve a first record from a metadata identifier registry, where the first record comprises an indication of the first local object identifier and an indication of a first global object identifier corresponding to the first local object identifier. The metadata service may determine a second local object identifier referencing a definition of a second local object identifier referencing a definition of a second local object in the target data model and return the second local object identifier.

Metadata object identifier registry

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.

Matching metastructure for data modeling

A computer-implemented method includes representing a plurality of database tables as respective vectors in a multi-dimensional vector space, receiving an indication that a first database table represented by a first vector and a second database table represented by a second vector are related to each other, moving the respective vectors representing the plurality of database tables in the multi-dimensional vector space in response to the indication, and grouping the plurality of database tables into one or more table clusters based on positions of the respective vectors representing the plurality of database tables in the multi-dimensional vector space.

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.

Generation of realistic mock data

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.

Growing community of inventors

Bruchsal, Germany

Jan Portisch