SG10201607662VA - Query rewriting in a relational data harmonization framework - Google Patents

Query rewriting in a relational data harmonization framework

Info

Publication number
SG10201607662VA
SG10201607662VA SG10201607662VA SG10201607662VA SG10201607662VA SG 10201607662V A SG10201607662V A SG 10201607662VA SG 10201607662V A SG10201607662V A SG 10201607662VA SG 10201607662V A SG10201607662V A SG 10201607662VA SG 10201607662V A SG10201607662V A SG 10201607662VA
Authority
SG
Singapore
Prior art keywords
framework
relational data
query rewriting
data harmonization
harmonization
Prior art date
Application number
SG10201607662VA
Inventor
Neda Abolhassani
Teresa Sheausan Tung
Karthik Gomadam
Original Assignee
Accenture Global Solutions Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Accenture Global Solutions Ltd filed Critical Accenture Global Solutions Ltd
Publication of SG10201607662VA publication Critical patent/SG10201607662VA/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24549—Run-time optimisation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G06F16/243—Natural language query formulation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2452—Query translation
    • G06F16/24526—Internal representations for queries

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Artificial Intelligence (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
SG10201607662VA 2016-07-07 2016-09-14 Query rewriting in a relational data harmonization framework SG10201607662VA (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US201662359547P 2016-07-07 2016-07-07
US15/227,605 US10346401B2 (en) 2016-07-07 2016-08-03 Query rewriting in a relational data harmonization framework

Publications (1)

Publication Number Publication Date
SG10201607662VA true SG10201607662VA (en) 2018-02-27

Family

ID=56855368

Family Applications (1)

Application Number Title Priority Date Filing Date
SG10201607662VA SG10201607662VA (en) 2016-07-07 2016-09-14 Query rewriting in a relational data harmonization framework

Country Status (4)

Country Link
US (1) US10346401B2 (en)
EP (1) EP3267330A1 (en)
AU (1) AU2016222437B1 (en)
SG (1) SG10201607662VA (en)

Families Citing this family (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10606952B2 (en) * 2016-06-24 2020-03-31 Elemental Cognition Llc Architecture and processes for computer learning and understanding
DE102016223193A1 (en) * 2016-11-23 2018-05-24 Fujitsu Limited Method and apparatus for completing a knowledge graph
US10664472B2 (en) * 2018-06-27 2020-05-26 Bitdefender IPR Management Ltd. Systems and methods for translating natural language sentences into database queries
US11151117B2 (en) 2018-07-30 2021-10-19 International Business Machines Corporation Increasing the accuracy of a statement by analyzing the relationships between entities in a knowledge graph
US11269867B2 (en) 2019-08-30 2022-03-08 Microsoft Technology Licensing, Llc Generating data retrieval queries using a knowledge graph
US11693855B2 (en) * 2019-12-20 2023-07-04 International Business Machines Corporation Automatic creation of schema annotation files for converting natural language queries to structured query language
US11995561B2 (en) 2020-03-17 2024-05-28 MeetKai, Inc. Universal client API for AI services
US11308104B2 (en) * 2020-06-25 2022-04-19 Microsoft Technology Licensing, Llc Knowledge graph-based lineage tracking
US11921712B2 (en) 2020-10-05 2024-03-05 MeetKai, Inc. System and method for automatically generating question and query pairs
CN113467785B (en) * 2021-07-19 2023-02-28 上海红阵信息科技有限公司 SQL translation method and system for mimicry database
US20230031659A1 (en) * 2021-07-26 2023-02-02 Conexus ai, Inc. Data migration by query co-evaluation
EP4198763A1 (en) * 2021-12-17 2023-06-21 Dassault Systèmes Optimizing sparql queries in a distributed graph database

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6665664B2 (en) * 2001-01-11 2003-12-16 Sybase, Inc. Prime implicates and query optimization in relational databases
CN101093493B (en) 2006-06-23 2011-08-31 国际商业机器公司 Speech conversion method for database inquiry and converter
US7818352B2 (en) 2007-11-26 2010-10-19 Microsoft Corporation Converting SPARQL queries to SQL queries
US8285748B2 (en) 2008-05-28 2012-10-09 Oracle International Corporation Proactive information security management
US8010521B2 (en) * 2009-03-23 2011-08-30 Sap Ag Systems and methods for managing foreign key constraints
US9396283B2 (en) 2010-10-22 2016-07-19 Daniel Paul Miranker System for accessing a relational database using semantic queries
US8666969B2 (en) * 2011-11-14 2014-03-04 International Business Machines Corporation Query rewrite for pre-joined tables
US9703830B2 (en) 2014-10-09 2017-07-11 International Business Machines Corporation Translation of a SPARQL query to a SQL query

Also Published As

Publication number Publication date
US10346401B2 (en) 2019-07-09
US20180011903A1 (en) 2018-01-11
EP3267330A1 (en) 2018-01-10
AU2016222437B1 (en) 2017-03-30

Similar Documents

Publication Publication Date Title
SG10201607662VA (en) Query rewriting in a relational data harmonization framework
IL260165A (en) Identifying entities using a deep-learning model
IL258761A (en) Identifying content items using a deep-learning model
GB201708976D0 (en) Searching in a database
SG11201703247WA (en) Learning with transformed data
PT3114561T (en) Architectural mode configuration in a computing system
GB201616819D0 (en) Processing data sets in a big data repository
EP2946333A4 (en) Efficient query processing using histograms in a columnar database
EP3067815C0 (en) Access relationships in a computer system
EP3114672A4 (en) Methods and devices for displaying trend and variability in a physiological dataset
GB201517416D0 (en) Task-execution in a DBMS using stored procedures
EP3563296A4 (en) Zero-shot learning using multi-scale manifold alignment
EP3420449A4 (en) Managing updates in a computing system using multiple access methods
SG11201700236WA (en) Data storage upon database failure
HK1216928A1 (en) A database access method based on attribute labels
SG11201604859RA (en) Database key identification
GB201715585D0 (en) A well in a geological structure
GB2555242B (en) A portfolio case for use with tablet computer
GB2551420B (en) A secure searchable media object
PT3174746T (en) Glass panel comprising a pin and method for manufacturing the glass panel
ZA201700045B (en) Swing-and-slide door module with a central function connection
GB201402292D0 (en) Adaptive access control in relational database system
GB201615381D0 (en) Planning drilling operations using models and rig market databases
SI2907616T1 (en) Method for producing a ball lock pin and corresponding assembling device
EP3230878A4 (en) Synchronization in a computing device