US 12,216,698 B2
System and method for implementing ontologies in SQL
Amit Weitzner, Ra'anana (IL); and Jacob Cohen, Tel Aviv (IL)
Assigned to WP SEMANTIX LTD, Ra'anana (IL)
Appl. No. 18/016,383
Filed by WP SEMANTIX LTD, Ra'anana (IL)
PCT Filed Jul. 14, 2021, PCT No. PCT/IL2021/050864
§ 371(c)(1), (2) Date Jan. 16, 2023,
PCT Pub. No. WO2022/013873, PCT Pub. Date Jan. 20, 2022.
Claims priority of application No. 280372 (IL), filed on Jan. 24, 2021.
Prior Publication US 2023/0273947 A1, Aug. 31, 2023
Int. Cl. G06F 16/36 (2019.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01); G06F 40/279 (2020.01); G06F 40/30 (2020.01)
CPC G06F 16/367 (2019.01) [G06F 16/24542 (2019.01); G06F 16/2455 (2019.01); G06F 40/279 (2020.01); G06F 40/30 (2020.01)] 27 Claims
OG exemplary drawing
 
1. A method for implementing a virtual ontology over a relational database, comprising:
defining a virtual ontology from multiple candidate ontologies for a relational database by
a) declaring a hierarchy of multiple virtual entities;
b) for each one of said multiple virtual entities in said hierarchy, declaring a corresponding mapping associating said one virtual entity with at least a subset of at least one physical table defined by a relational schema of said relational database, thereby introducing data stored in said relational database to said virtual ontology; and
c) storing said virtual entity in association with said corresponding mapping in a virtual ontology metadata database implemented as a relational database; and
defining multiple ontology schemas, each implemented as a different relational view of said virtual ontology and capturing at least one ontology capability,
wherein querying said ontology metadata database with at least a parsed portion of an intercepted first relational query targeting one of said multiple ontology schemas enables rewriting said first relational query as a second relational query, wherein executing said second relational query at said relational database enables extracting ontological knowledge from said data that is opaque with respect to said relational schema and which expresses said at least one ontology capability captured by said targeted one of said multiple ontology schemas,
thereby enabling extracting said ontological knowledge within a relational framework.