Invention Grant
- Patent Title: Query rewriting in a relational data harmonization framework
-
Application No.: US15227605Application Date: 2016-08-03
-
Publication No.: US10346401B2Publication Date: 2019-07-09
- Inventor: Neda Abolhassani , Teresa Sheausan Tung , Karthik Gomadam
- Applicant: Accenture Global Solutions Limited
- Applicant Address: IE Dublin
- Assignee: ACCENTURE GLOBAL SOLUTIONS LIMITED
- Current Assignee: ACCENTURE GLOBAL SOLUTIONS LIMITED
- Current Assignee Address: IE Dublin
- Agency: Brinks Gilson & Lione
- Main IPC: G06F16/2452
- IPC: G06F16/2452 ; G06F16/2453 ; G06F16/242

Abstract:
A query rewriting processor (processor) analyzes database semantic models (e.g., RDF knowledge graphs) that capture the interconnections (e.g., foreign and primary key links to other tables) present in a relational database. The processor generates an enriched model query given an initial model query (e.g., a SPARQL query) against the semantic model. The processor generates the enriched model query and translates the enriched model query into a relational database query (e.g., an SQL query). The processor may then pass the relational database query to another system or process (e.g., a data virtualization layer) for execution against the individual relational databases. In this manner, the processor automatically translates queries for information about the relational database structure to a corresponding or matching query for data from the relational database structure.
Public/Granted literature
- US20180011903A1 QUERY REWRITING IN A RELATIONAL DATA HARMONIZATION FRAMEWORK Public/Granted day:2018-01-11
Information query