CN113811869A - 将自然语言查询翻译成标准数据查询 - Google Patents

将自然语言查询翻译成标准数据查询 Download PDF

Info

Publication number
CN113811869A
CN113811869A CN202080034971.1A CN202080034971A CN113811869A CN 113811869 A CN113811869 A CN 113811869A CN 202080034971 A CN202080034971 A CN 202080034971A CN 113811869 A CN113811869 A CN 113811869A
Authority
CN
China
Prior art keywords
natural language
computer
query
standard data
language query
Prior art date
Legal status (The legal status 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 status listed.)
Pending
Application number
CN202080034971.1A
Other languages
English (en)
Chinese (zh)
Inventor
P.W.J.斯塔
M.多尔菲
C.奥尔
L.乔戈普洛斯
A.索布奇克
T.J.巴卡尔特
K.贝卡斯
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
International Business Machines Corp
Original Assignee
International Business Machines Corp
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 International Business Machines Corp filed Critical International Business Machines Corp
Publication of CN113811869A publication Critical patent/CN113811869A/zh
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/24522—Translation of natural language queries to structured queries
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/30—Semantic analysis
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/30—Semantic analysis
    • G06F40/35—Discourse or dialogue representation
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/40—Processing or translation of natural language

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Machine Translation (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CN202080034971.1A 2019-06-20 2020-06-16 将自然语言查询翻译成标准数据查询 Pending CN113811869A (zh)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US16/446,809 2019-06-20
US16/446,809 US11086861B2 (en) 2019-06-20 2019-06-20 Translating a natural language query into a formal data query
PCT/IB2020/055618 WO2020254962A1 (en) 2019-06-20 2020-06-16 Translating a natural language query into a formal data query

Publications (1)

Publication Number Publication Date
CN113811869A true CN113811869A (zh) 2021-12-17

Family

ID=74038547

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202080034971.1A Pending CN113811869A (zh) 2019-06-20 2020-06-16 将自然语言查询翻译成标准数据查询

Country Status (6)

Country Link
US (1) US11086861B2 (https=)
JP (1) JP7584449B2 (https=)
CN (1) CN113811869A (https=)
DE (1) DE112020002961T5 (https=)
GB (1) GB2599328A (https=)
WO (1) WO2020254962A1 (https=)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117891458A (zh) * 2023-11-23 2024-04-16 星环信息科技(上海)股份有限公司 一种sql语句生成方法、装置、设备及存储介质

Families Citing this family (17)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20240086444A1 (en) * 2019-10-11 2024-03-14 The Board Of Trustees Of The Leland Stanford Junior University Systems and Methods for Generating Knowledge Graphs and Text Summaries from Document Databases
US11861308B2 (en) * 2020-04-15 2024-01-02 Intuit Inc. Mapping natural language utterances to operations over a knowledge graph
US11423094B2 (en) * 2020-06-09 2022-08-23 International Business Machines Corporation Document risk analysis
US11726994B1 (en) * 2021-03-31 2023-08-15 Amazon Technologies, Inc. Providing query restatements for explaining natural language query results
US11604794B1 (en) 2021-03-31 2023-03-14 Amazon Technologies, Inc. Interactive assistance for executing natural language queries to data sets
US11500865B1 (en) 2021-03-31 2022-11-15 Amazon Technologies, Inc. Multiple stage filtering for natural language query processing pipelines
US12189782B2 (en) 2021-06-23 2025-01-07 The Mitre Corporation Methods and systems for natural language processing of graph database queries
US12271698B1 (en) 2021-11-29 2025-04-08 Amazon Technologies, Inc. Schema and cell value aware named entity recognition model for executing natural language queries
US20230368103A1 (en) * 2022-05-11 2023-11-16 Sap Se Knowledge graph enabled augmentation of natural language processing applications
WO2024157438A1 (ja) 2023-01-27 2024-08-02 日本電気株式会社 情報処理装置、情報処理方法、及び、記録媒体
US12346316B2 (en) * 2023-02-10 2025-07-01 DataIris Platform, Inc. Knowledge graph generation for data warehouse
US12265528B1 (en) 2023-03-21 2025-04-01 Amazon Technologies, Inc. Natural language query processing
US12585645B1 (en) 2023-03-21 2026-03-24 Amazon Technologies, Inc. Natural language query processing
US12346315B1 (en) 2023-03-21 2025-07-01 Amazon Technologies, Inc. Natural language query processing
US12511282B1 (en) 2023-05-02 2025-12-30 Microstrategy Incorporated Generating structured query language using machine learning
CN116757162B (zh) * 2023-06-16 2025-04-08 北京优酷科技有限公司 平台数据的智能编辑方法、装置、电子设备及存储介质
US12475156B2 (en) * 2024-04-12 2025-11-18 DevRev, Inc. Communication platform for a connected environment

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5963940A (en) * 1995-08-16 1999-10-05 Syracuse University Natural language information retrieval system and method
KR100980579B1 (ko) * 2010-02-03 2010-09-06 경북대학교 산학협력단 온톨로지에 대한 자연어 질의 검색 방법 및 시스템
CN104636478A (zh) * 2015-02-13 2015-05-20 广州神马移动信息科技有限公司 信息查询方法和设备
CN109063056A (zh) * 2018-07-20 2018-12-21 阿里巴巴集团控股有限公司 一种数据查询方法、系统及终端设备

Family Cites Families (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5265014A (en) * 1990-04-10 1993-11-23 Hewlett-Packard Company Multi-modal user interface
US5911138A (en) * 1993-06-04 1999-06-08 International Business Machines Corporation Database search facility having improved user interface
US7730063B2 (en) 2002-12-10 2010-06-01 Asset Trust, Inc. Personalized medicine service
US7640162B2 (en) * 2004-12-14 2009-12-29 Microsoft Corporation Semantic canvas
US8548799B2 (en) * 2005-08-10 2013-10-01 Microsoft Corporation Methods and apparatus to help users of a natural language system formulate queries
US20080235199A1 (en) 2007-03-19 2008-09-25 Yunyao Li Natural language query interface, systems, and methods for a database
US10318586B1 (en) * 2014-08-19 2019-06-11 Google Llc Systems and methods for editing and replaying natural language queries
US10326768B2 (en) 2015-05-28 2019-06-18 Google Llc Access control for enterprise knowledge
US10033714B2 (en) 2015-06-16 2018-07-24 Business Objects Software, Ltd Contextual navigation facets panel
US20180052842A1 (en) 2016-08-16 2018-02-22 Ebay Inc. Intelligent online personal assistant with natural language understanding
US10503767B2 (en) 2016-09-13 2019-12-10 Microsoft Technology Licensing, Llc Computerized natural language query intent dispatching
US10747761B2 (en) 2017-05-18 2020-08-18 Salesforce.Com, Inc. Neural network based translation of natural language queries to database queries
US11157564B2 (en) * 2018-03-02 2021-10-26 Thoughtspot, Inc. Natural language question answering systems
CN109241259B (zh) 2018-08-24 2021-01-05 国网江苏省电力有限公司苏州供电分公司 基于er模型的自然语言查询方法、装置及系统
CN109241103A (zh) 2018-09-26 2019-01-18 深圳壹账通智能科技有限公司 数据扩展查询方法、电子装置及计算机可读存储介质

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5963940A (en) * 1995-08-16 1999-10-05 Syracuse University Natural language information retrieval system and method
KR100980579B1 (ko) * 2010-02-03 2010-09-06 경북대학교 산학협력단 온톨로지에 대한 자연어 질의 검색 방법 및 시스템
CN104636478A (zh) * 2015-02-13 2015-05-20 广州神马移动信息科技有限公司 信息查询方法和设备
CN109063056A (zh) * 2018-07-20 2018-12-21 阿里巴巴集团控股有限公司 一种数据查询方法、系统及终端设备

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117891458A (zh) * 2023-11-23 2024-04-16 星环信息科技(上海)股份有限公司 一种sql语句生成方法、装置、设备及存储介质
CN117891458B (zh) * 2023-11-23 2024-12-17 星环信息科技(上海)股份有限公司 一种sql语句生成方法、装置、设备及存储介质

Also Published As

Publication number Publication date
WO2020254962A1 (en) 2020-12-24
JP7584449B2 (ja) 2024-11-15
JP2022536889A (ja) 2022-08-22
GB2599328A (en) 2022-03-30
US20200401590A1 (en) 2020-12-24
DE112020002961T5 (de) 2022-04-07
US11086861B2 (en) 2021-08-10

Similar Documents

Publication Publication Date Title
US11086861B2 (en) Translating a natural language query into a formal data query
US10884904B2 (en) Automatic cognitive adaptation of development assets according to requirement changes
US9384450B1 (en) Training machine learning models for open-domain question answering system
US20250363421A1 (en) Systems and methods for generating customized ai models
US10417581B2 (en) Question answering system-based generation of distractors using machine learning
US20210241893A1 (en) Dashboard Usage Tracking and Generation of Dashboard Recommendations
US11062222B2 (en) Cross-user dashboard behavior analysis and dashboard recommendations
US20160078344A1 (en) Extraction of inference rules from heterogeneous graphs
Monti et al. Nl2processops: Towards llm-guided code generation for process execution
US12106045B2 (en) Self-learning annotations to generate rules to be utilized by rule-based system
Pillutla et al. Iterative generation of insight from text collections through mutually reinforcing visualizations and fuzzy cognitive maps
CN114375447A (zh) 计算系统中的语言语句处理
Burch et al. Dashboard design
Kortum et al. Dissection of AI job advertisements: A text mining-based analysis of employee skills in the disciplines computer vision and natural language processing
Pathak et al. Mapping the evolution of generative AI: insights from bibliometric research
Regino et al. Can llms be knowledge graph curators for validating triple insertions?
US20170169094A1 (en) Statistical Clustering Inferred From Natural Language to Drive Relevant Analysis and Conversation With Users
Norouzifar et al. Imposing rules in process discovery: An inductive mining approach
Samhan et al. A review of ai-assisted impact analysis for software requirements change: Challenges and future directions
Biswas et al. Beginning AI Bot Frameworks
Agarwal et al. Fast natural language based data exploration with samples
CN115687631B (zh) 在复杂数据空间中快速开发用户意图和分析性规范
Euzenat et al. User involvement
US11301638B2 (en) Holistic knowledge representation for semantic modeling of structured data
Grigorov What Are Large Language Models?

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination