- Patent Title: Identification, and query, of semantically-related database tables
-
Application No.: US16122566Application Date: 2018-09-05
-
Publication No.: US10942926B2Publication Date: 2021-03-09
- Inventor: Marco Valentin
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Klarquist Sparkman, LLP
- Main IPC: G06F16/2455
- IPC: G06F16/2455 ; G06F16/248 ; G06F16/22 ; G06F16/242

Abstract:
Techniques and solutions are described for determining elements of different database tables have a semantic relationship, and optionally executing a value query using such tables. Tables, including those lacking a technical relationship (such as having a foreign key relationship or association) can be semantically related if an element of the table has the same semantic identifier, such as a domain, as an element of another table. The semantic relationship can exist even if other information, such as field names associated with a respective semantic identifier, are different between the two tables. A source table can be semantically related to one or more other tables, including indirectly based on semantic relationships between two or more of such other tables. Semantic table information can be recursively analyzed, including in a hierarchical manner, to identify a set of semantically related tables. The analysis can be constrained, such as to avoid loops or limit result size or running time.
Public/Granted literature
- US20200073989A1 IDENTIFICATION, AND QUERY, OF SEMANTICALLY-RELATED DATABASE TABLES Public/Granted day:2020-03-05
Information query