Patents by Inventor Jan Portisch

Jan Portisch has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Publication number: 20210318995
    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.
    Type: Application
    Filed: April 14, 2020
    Publication date: October 14, 2021
    Applicant: SAP SE
    Inventors: Jan Portisch, Ronald Boehle, Volker Saggau, Sandra Bracholdt
  • Patent number: 11144549
    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.
    Type: Grant
    Filed: December 14, 2018
    Date of Patent: October 12, 2021
    Assignee: SAP SE
    Inventors: Jan Portisch, Sandra Bracholdt, Volker Saggau
  • Patent number: 11106861
    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.
    Type: Grant
    Filed: February 1, 2019
    Date of Patent: August 31, 2021
    Assignee: SAP SE
    Inventors: Jan Portisch, Joachim Gross, Sandra Bracholdt
  • Publication number: 20210240675
    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.
    Type: Application
    Filed: February 3, 2020
    Publication date: August 5, 2021
    Applicant: SAP SE
    Inventors: Jan Portisch, Bjoern Pantel, Benjamin Merkle, Stephan Schub, Sandra Bracholdt, Roland Kolata, Michael Hladik, Christoph Meinel
  • Publication number: 20210232591
    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.
    Type: Application
    Filed: January 29, 2020
    Publication date: July 29, 2021
    Applicant: SAP SE
    Inventors: Jan Portisch, Ronald Boehle, Sandra Bracholdt, Volker Saggau
  • Publication number: 20210182055
    Abstract: Techniques and solutions are described for automatically refactoring code. In particular, disclosed technologies provide for automatically refactoring code that includes function calls, which can be to particular types of functions, such as external functions or functions that are not member functions of a class. For code to be refactored, an interface and a class are created. The class implements the interface. Method declarations corresponding to the function calls being refactored are added to the interface and the class. Code is added instantiating an object of the class. Implementations for the methods in the class can call the functions called by the source code being refactored, or can include code implementing the functionality of the called functions. Refactored code has function calls replaced with calls to corresponding methods of the interface.
    Type: Application
    Filed: December 11, 2019
    Publication date: June 17, 2021
    Applicant: SAP SE
    Inventors: Joachim Gross, Jan Portisch
  • Publication number: 20210073655
    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.
    Type: Application
    Filed: September 11, 2019
    Publication date: March 11, 2021
    Applicant: SAP SE
    Inventors: Jan Portisch, Ronald Boehle, Volker Saggau, Sandra Bracholdt
  • Publication number: 20210073196
    Abstract: Techniques and solutions are described for identifying data, such as records in a relational database. The data can have a first plurality of attributes, a second plurality of which are used to create the identifier. The identifier can be included as a column in a data structure in which the data is stored, such as a column in a table storing a record. The disclosed data identifiers can provide semantically meaningful information. The disclosed identifiers can also improve data store performance, such as by facilitating data retrieval, and helping to guard against inserting duplicate entries in the data store.
    Type: Application
    Filed: September 9, 2019
    Publication date: March 11, 2021
    Applicant: SAP SE
    Inventors: Stephan Schub, Jan Portisch, Michael Monych
  • Patent number: 10901987
    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.
    Type: Grant
    Filed: December 14, 2018
    Date of Patent: January 26, 2021
    Assignee: SAP SE
    Inventors: Jan Portisch, Sandra Bracholdt, Volker Saggau
  • Publication number: 20210012219
    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.
    Type: Application
    Filed: July 10, 2019
    Publication date: January 14, 2021
    Applicant: SAP SE
    Inventors: Jan Portisch, Sandra Bracholdt, Michael Monych, Volker Saggau
  • Publication number: 20200349129
    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.
    Type: Application
    Filed: April 30, 2019
    Publication date: November 5, 2020
    Applicant: SAP SE
    Inventors: Sandra Bracholdt, Volker Saggau, Jan Portisch
  • Publication number: 20200349128
    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.
    Type: Application
    Filed: April 30, 2019
    Publication date: November 5, 2020
    Applicant: SAP SE
    Inventors: Jan Portisch, Sandra Bracholdt, Björn Pantel, Volker Saggau
  • Publication number: 20200349130
    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.
    Type: Application
    Filed: April 30, 2019
    Publication date: November 5, 2020
    Applicant: SAP SE
    Inventors: Sandra Bracholdt, Joachim Gross, Volker Saggau, Jan Portisch
  • Publication number: 20200342007
    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.
    Type: Application
    Filed: July 10, 2020
    Publication date: October 29, 2020
    Applicant: SAP SE
    Inventors: Sandra Bracholdt, Volker Saggau, Jan Portisch
  • Publication number: 20200250260
    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.
    Type: Application
    Filed: February 1, 2019
    Publication date: August 6, 2020
    Applicant: SAP SE
    Inventors: Jan Portisch, Joachim Gross, Sandra Bracholdt
  • Patent number: 10726052
    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.
    Type: Grant
    Filed: July 3, 2018
    Date of Patent: July 28, 2020
    Assignee: SAP SE
    Inventors: Sandra Bracholdt, Volker Saggau, Jan Portisch
  • Publication number: 20200192892
    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.
    Type: Application
    Filed: December 14, 2018
    Publication date: June 18, 2020
    Applicant: SAP SE
    Inventors: Jan Portisch, Sandra Bracholdt, Volker Saggau
  • Publication number: 20200192901
    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.
    Type: Application
    Filed: December 14, 2018
    Publication date: June 18, 2020
    Applicant: SAP SE
    Inventors: Jan Portisch, Sandra Bracholdt, Volker Saggau
  • Publication number: 20200012741
    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.
    Type: Application
    Filed: July 3, 2018
    Publication date: January 9, 2020
    Applicant: SAP SE
    Inventors: Sandra Bracholdt, Volker Saggau, Jan Portisch