CN110945495B - 基于神经网络的自然语言查询到数据库查询的转换 - Google Patents

基于神经网络的自然语言查询到数据库查询的转换 Download PDF

Info

Publication number
CN110945495B
CN110945495B CN201880033017.3A CN201880033017A CN110945495B CN 110945495 B CN110945495 B CN 110945495B CN 201880033017 A CN201880033017 A CN 201880033017A CN 110945495 B CN110945495 B CN 110945495B
Authority
CN
China
Prior art keywords
query
database
agg
input
database 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.)
Active
Application number
CN201880033017.3A
Other languages
English (en)
Chinese (zh)
Other versions
CN110945495A (zh
Inventor
V·钟
熊蔡明
R·佐赫尔
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.)
Shuo Power Co
Original Assignee
Salesforce com Inc
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 Salesforce com Inc filed Critical Salesforce com Inc
Publication of CN110945495A publication Critical patent/CN110945495A/zh
Application granted granted Critical
Publication of CN110945495B publication Critical patent/CN110945495B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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
    • G06N—COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
    • G06N3/00—Computing arrangements based on biological models
    • G06N3/004—Artificial life, i.e. computing arrangements simulating life
    • G06N3/006—Artificial life, i.e. computing arrangements simulating life based on simulated virtual individual or collective life forms, e.g. social simulations or particle swarm optimisation [PSO]
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06N—COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
    • G06N3/00—Computing arrangements based on biological models
    • G06N3/02—Neural networks
    • G06N3/04—Architecture, e.g. interconnection topology
    • G06N3/044—Recurrent networks, e.g. Hopfield networks
    • G06N3/0442—Recurrent networks, e.g. Hopfield networks characterised by memory or gating, e.g. long short-term memory [LSTM] or gated recurrent units [GRU]
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06N—COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
    • G06N3/00—Computing arrangements based on biological models
    • G06N3/02—Neural networks
    • G06N3/04—Architecture, e.g. interconnection topology
    • G06N3/045—Combinations of networks
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06N—COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
    • G06N3/00—Computing arrangements based on biological models
    • G06N3/02—Neural networks
    • G06N3/04—Architecture, e.g. interconnection topology
    • G06N3/045—Combinations of networks
    • G06N3/0455—Auto-encoder networks; Encoder-decoder networks
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06N—COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
    • G06N3/00—Computing arrangements based on biological models
    • G06N3/02—Neural networks
    • G06N3/08—Learning methods
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06N—COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
    • G06N3/00—Computing arrangements based on biological models
    • G06N3/02—Neural networks
    • G06N3/08—Learning methods
    • G06N3/09—Supervised learning
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06N—COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
    • G06N3/00—Computing arrangements based on biological models
    • G06N3/02—Neural networks
    • G06N3/08—Learning methods
    • G06N3/092—Reinforcement learning
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06N—COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
    • G06N7/00—Computing arrangements based on specific mathematical models
    • G06N7/01—Probabilistic graphical models, e.g. probabilistic networks
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10—File systems; File servers
    • G06F16/13—File access structures, e.g. distributed indices
    • 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/2457—Query processing with adaptation to user needs
    • G06F16/24578—Query processing with adaptation to user needs using ranking

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Artificial Intelligence (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Computing Systems (AREA)
  • Software Systems (AREA)
  • Mathematical Physics (AREA)
  • Evolutionary Computation (AREA)
  • Biophysics (AREA)
  • Molecular Biology (AREA)
  • General Health & Medical Sciences (AREA)
  • Biomedical Technology (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Databases & Information Systems (AREA)
  • Algebra (AREA)
  • Computational Mathematics (AREA)
  • Mathematical Analysis (AREA)
  • Mathematical Optimization (AREA)
  • Pure & Applied Mathematics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CN201880033017.3A 2017-05-18 2018-05-17 基于神经网络的自然语言查询到数据库查询的转换 Active CN110945495B (zh)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
US201762508367P 2017-05-18 2017-05-18
US62/508,367 2017-05-18
US15/885,613 2018-01-31
US15/885,613 US10747761B2 (en) 2017-05-18 2018-01-31 Neural network based translation of natural language queries to database queries
PCT/US2018/033099 WO2018213530A2 (en) 2017-05-18 2018-05-17 Neural network based translation of natural language queries to database queries

Publications (2)

Publication Number Publication Date
CN110945495A CN110945495A (zh) 2020-03-31
CN110945495B true CN110945495B (zh) 2022-04-29

Family

ID=64272433

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201880033017.3A Active CN110945495B (zh) 2017-05-18 2018-05-17 基于神经网络的自然语言查询到数据库查询的转换

Country Status (6)

Country Link
US (2) US10747761B2 (enExample)
EP (1) EP3625734A4 (enExample)
JP (1) JP6929971B2 (enExample)
CN (1) CN110945495B (enExample)
CA (1) CA3062071C (enExample)
WO (1) WO2018213530A2 (enExample)

Families Citing this family (168)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10565493B2 (en) * 2016-09-22 2020-02-18 Salesforce.Com, Inc. Pointer sentinel mixture architecture
US10558750B2 (en) 2016-11-18 2020-02-11 Salesforce.Com, Inc. Spatial attention model for image captioning
US10565318B2 (en) 2017-04-14 2020-02-18 Salesforce.Com, Inc. Neural machine translation with latent tree attention
US11386327B2 (en) 2017-05-18 2022-07-12 Salesforce.Com, Inc. Block-diagonal hessian-free optimization for recurrent and convolutional neural networks
US10817650B2 (en) 2017-05-19 2020-10-27 Salesforce.Com, Inc. Natural language processing using context specific word vectors
US10885586B2 (en) * 2017-07-24 2021-01-05 Jpmorgan Chase Bank, N.A. Methods for automatically generating structured pricing models from unstructured multi-channel communications and devices thereof
US11087211B2 (en) * 2017-10-05 2021-08-10 Salesforce.Com, Inc. Convolutional neural network (CNN)-based suggestions for anomaly input
US10542270B2 (en) 2017-11-15 2020-01-21 Salesforce.Com, Inc. Dense video captioning
US11276002B2 (en) 2017-12-20 2022-03-15 Salesforce.Com, Inc. Hybrid training of deep networks
US11501076B2 (en) 2018-02-09 2022-11-15 Salesforce.Com, Inc. Multitask learning as question answering
US10929607B2 (en) 2018-02-22 2021-02-23 Salesforce.Com, Inc. Dialogue state tracking using a global-local encoder
US11227218B2 (en) 2018-02-22 2022-01-18 Salesforce.Com, Inc. Question answering from minimal context over documents
EP3731108A4 (en) * 2018-03-16 2020-11-18 Rakuten, Inc. RESEARCH SYSTEM, RESEARCH PROCESS AND PROGRAM
US11106182B2 (en) 2018-03-16 2021-08-31 Salesforce.Com, Inc. Systems and methods for learning for domain adaptation
US10783875B2 (en) 2018-03-16 2020-09-22 Salesforce.Com, Inc. Unsupervised non-parallel speech domain adaptation using a multi-discriminator adversarial network
US11501202B1 (en) * 2018-04-17 2022-11-15 Amazon Technologies, Inc. Querying databases with machine learning model references
US11494454B1 (en) * 2018-05-09 2022-11-08 Palantir Technologies Inc. Systems and methods for searching a schema to identify and visualize corresponding data
US10909157B2 (en) 2018-05-22 2021-02-02 Salesforce.Com, Inc. Abstraction of text summarization
US10777196B2 (en) * 2018-06-27 2020-09-15 The Travelers Indemnity Company Systems and methods for cooperatively-overlapped and artificial intelligence managed interfaces
US11436481B2 (en) 2018-09-18 2022-09-06 Salesforce.Com, Inc. Systems and methods for named entity recognition
US10970486B2 (en) 2018-09-18 2021-04-06 Salesforce.Com, Inc. Using unstructured input to update heterogeneous data stores
US11029694B2 (en) 2018-09-27 2021-06-08 Salesforce.Com, Inc. Self-aware visual-textual co-grounded navigation agent
US11087177B2 (en) 2018-09-27 2021-08-10 Salesforce.Com, Inc. Prediction-correction approach to zero shot learning
US11514915B2 (en) 2018-09-27 2022-11-29 Salesforce.Com, Inc. Global-to-local memory pointer networks for task-oriented dialogue
US11645509B2 (en) 2018-09-27 2023-05-09 Salesforce.Com, Inc. Continual neural network learning via explicit structure learning
US12301658B2 (en) * 2018-10-19 2025-05-13 Sap Se Network virtualization for web application traffic flows
EP3660733B1 (en) * 2018-11-30 2023-06-28 Tata Consultancy Services Limited Method and system for information extraction from document images using conversational interface and database querying
US11822897B2 (en) 2018-12-11 2023-11-21 Salesforce.Com, Inc. Systems and methods for structured text translation with tag alignment
US10963652B2 (en) 2018-12-11 2021-03-30 Salesforce.Com, Inc. Structured text translation
US11922323B2 (en) 2019-01-17 2024-03-05 Salesforce, Inc. Meta-reinforcement learning gradient estimation with variance reduction
US11966389B2 (en) * 2019-02-13 2024-04-23 International Business Machines Corporation Natural language to structured query generation via paraphrasing
US11568306B2 (en) 2019-02-25 2023-01-31 Salesforce.Com, Inc. Data privacy protected machine learning systems
US11003867B2 (en) 2019-03-04 2021-05-11 Salesforce.Com, Inc. Cross-lingual regularization for multilingual generalization
US11366969B2 (en) 2019-03-04 2022-06-21 Salesforce.Com, Inc. Leveraging language models for generating commonsense explanations
US11087092B2 (en) 2019-03-05 2021-08-10 Salesforce.Com, Inc. Agent persona grounded chit-chat generation framework
US11580445B2 (en) 2019-03-05 2023-02-14 Salesforce.Com, Inc. Efficient off-policy credit assignment
CN110059100B (zh) * 2019-03-20 2022-02-22 广东工业大学 基于演员-评论家网络的sql语句构造方法
US10902289B2 (en) 2019-03-22 2021-01-26 Salesforce.Com, Inc. Two-stage online detection of action start in untrimmed videos
CN110019151B (zh) * 2019-04-11 2024-03-15 深圳市腾讯计算机系统有限公司 数据库性能调整方法、装置、设备、系统及存储介质
US11789945B2 (en) * 2019-04-18 2023-10-17 Sap Se Clause-wise text-to-SQL generation
US11281863B2 (en) 2019-04-18 2022-03-22 Salesforce.Com, Inc. Systems and methods for unifying question answering and text classification via span extraction
US11550783B2 (en) * 2019-04-18 2023-01-10 Sap Se One-shot learning for text-to-SQL
US11487939B2 (en) 2019-05-15 2022-11-01 Salesforce.Com, Inc. Systems and methods for unsupervised autoregressive text compression
US11620572B2 (en) 2019-05-16 2023-04-04 Salesforce.Com, Inc. Solving sparse reward tasks using self-balancing shaped rewards
US11562251B2 (en) 2019-05-16 2023-01-24 Salesforce.Com, Inc. Learning world graphs to accelerate hierarchical reinforcement learning
US11604965B2 (en) 2019-05-16 2023-03-14 Salesforce.Com, Inc. Private deep learning
US11687588B2 (en) 2019-05-21 2023-06-27 Salesforce.Com, Inc. Weakly supervised natural language localization networks for video proposal prediction based on a text query
US11669712B2 (en) 2019-05-21 2023-06-06 Salesforce.Com, Inc. Robustness evaluation via natural typos
US11775775B2 (en) 2019-05-21 2023-10-03 Salesforce.Com, Inc. Systems and methods for reading comprehension for a question answering task
US11657269B2 (en) 2019-05-23 2023-05-23 Salesforce.Com, Inc. Systems and methods for verification of discriminative models
US11086861B2 (en) * 2019-06-20 2021-08-10 International Business Machines Corporation Translating a natural language query into a formal data query
US11615240B2 (en) 2019-08-15 2023-03-28 Salesforce.Com, Inc Systems and methods for a transformer network with tree-based attention for natural language processing
US12222935B2 (en) 2019-08-30 2025-02-11 Servicenow Canada Inc. Decision support system for data retrieval
US11520785B2 (en) 2019-09-18 2022-12-06 Salesforce.Com, Inc. Query classification alteration based on user input
US11475048B2 (en) 2019-09-18 2022-10-18 Salesforce.Com, Inc. Classifying different query types
US11449796B2 (en) * 2019-09-20 2022-09-20 Amazon Technologies, Inc. Machine learning inference calls for database query processing
US11599792B2 (en) * 2019-09-24 2023-03-07 Salesforce.Com, Inc. System and method for learning with noisy labels as semi-supervised learning
US11568000B2 (en) 2019-09-24 2023-01-31 Salesforce.Com, Inc. System and method for automatic task-oriented dialog system
US11640527B2 (en) 2019-09-25 2023-05-02 Salesforce.Com, Inc. Near-zero-cost differentially private deep learning with teacher ensembles
CN112580357A (zh) 2019-09-29 2021-03-30 微软技术许可有限责任公司 自然语言查询的语义解析
US11341340B2 (en) * 2019-10-01 2022-05-24 Google Llc Neural machine translation adaptation
US11620515B2 (en) 2019-11-07 2023-04-04 Salesforce.Com, Inc. Multi-task knowledge distillation for language model
US11347708B2 (en) 2019-11-11 2022-05-31 Salesforce.Com, Inc. System and method for unsupervised density based table structure identification
US11288438B2 (en) 2019-11-15 2022-03-29 Salesforce.Com, Inc. Bi-directional spatial-temporal reasoning for video-grounded dialogues
US11334766B2 (en) 2019-11-15 2022-05-17 Salesforce.Com, Inc. Noise-resistant object detection with noisy annotations
US11537899B2 (en) 2019-11-18 2022-12-27 Salesforce.Com, Inc. Systems and methods for out-of-distribution classification
US11922303B2 (en) 2019-11-18 2024-03-05 Salesforce, Inc. Systems and methods for distilled BERT-based training model for text classification
US11188530B2 (en) 2019-11-25 2021-11-30 Servicenow, Inc. Metadata-based translation of natural language queries into database queries
US11640505B2 (en) 2019-12-09 2023-05-02 Salesforce.Com, Inc. Systems and methods for explicit memory tracker with coarse-to-fine reasoning in conversational machine reading
US12086539B2 (en) 2019-12-09 2024-09-10 Salesforce, Inc. System and method for natural language processing using neural network with cross-task training
US11487999B2 (en) 2019-12-09 2022-11-01 Salesforce.Com, Inc. Spatial-temporal reasoning through pretrained language models for video-grounded dialogues
US11256754B2 (en) 2019-12-09 2022-02-22 Salesforce.Com, Inc. Systems and methods for generating natural language processing training samples with inflectional perturbations
US11416688B2 (en) 2019-12-09 2022-08-16 Salesforce.Com, Inc. Learning dialogue state tracking with limited labeled data
CN111177180A (zh) * 2019-12-11 2020-05-19 北京百分点信息科技有限公司 一种数据查询方法、装置以及电子设备
KR102277787B1 (ko) * 2019-12-26 2021-07-14 포항공과대학교 산학협력단 신경망 기반 자연어로부터 sql 질의 번역 시 사용되는 컬럼 및 테이블을 예측하는 방법
KR102345568B1 (ko) * 2019-12-26 2021-12-31 포항공과대학교 산학협력단 자연어 단어를 데이터베이스의 컬럼 및 테이블과 연결하는 방법
CN111125154B (zh) 2019-12-31 2021-04-02 北京百度网讯科技有限公司 用于输出结构化查询语句的方法和装置
US11481418B2 (en) 2020-01-02 2022-10-25 International Business Machines Corporation Natural question generation via reinforcement learning based graph-to-sequence model
US11669745B2 (en) 2020-01-13 2023-06-06 Salesforce.Com, Inc. Proposal learning for semi-supervised object detection
WO2021146538A1 (en) * 2020-01-16 2021-07-22 Warner Gaming, LLC System and method for management system data aggregation and transformation using client-specific criteria
US11562147B2 (en) 2020-01-23 2023-01-24 Salesforce.Com, Inc. Unified vision and dialogue transformer with BERT
US11900070B2 (en) * 2020-02-03 2024-02-13 International Business Machines Corporation Producing explainable rules via deep learning
US11521065B2 (en) * 2020-02-06 2022-12-06 International Business Machines Corporation Generating explanations for context aware sequence-to-sequence models
US20210249104A1 (en) 2020-02-06 2021-08-12 Salesforce.Com, Inc. Systems and methods for language modeling of protein engineering
US11748770B1 (en) * 2020-03-30 2023-09-05 Amdocs Development Limited System, method, and computer program for using shared customer data and artificial intelligence to predict customer classifications
US11328731B2 (en) 2020-04-08 2022-05-10 Salesforce.Com, Inc. Phone-based sub-word units for end-to-end speech recognition
CN111639153B (zh) * 2020-04-24 2024-07-02 平安国际智慧城市科技股份有限公司 基于法律知识图谱的查询方法、装置、电子设备及介质
CN111522839B (zh) * 2020-04-25 2023-09-01 华中科技大学 一种基于深度学习的自然语言查询方法
US11544597B2 (en) 2020-04-30 2023-01-03 International Business Machines Corporation Problem manipulators for language-independent computerized reasoning
US12299982B2 (en) 2020-05-12 2025-05-13 Salesforce, Inc. Systems and methods for partially supervised online action detection in untrimmed videos
US11625543B2 (en) 2020-05-31 2023-04-11 Salesforce.Com, Inc. Systems and methods for composed variational natural language generation
US12265909B2 (en) 2020-06-01 2025-04-01 Salesforce, Inc. Systems and methods for a k-nearest neighbor based mechanism of natural language processing models
US11720559B2 (en) * 2020-06-02 2023-08-08 Salesforce.Com, Inc. Bridging textual and tabular data for cross domain text-to-query language semantic parsing with a pre-trained transformer language encoder and anchor text
US12530560B2 (en) 2020-06-03 2026-01-20 Salesforce, Inc. System and method for differential architecture search for neural networks
US11625436B2 (en) 2020-08-14 2023-04-11 Salesforce.Com, Inc. Systems and methods for query autocompletion
US11934952B2 (en) 2020-08-21 2024-03-19 Salesforce, Inc. Systems and methods for natural language processing using joint energy-based models
US11720565B2 (en) * 2020-08-27 2023-08-08 International Business Machines Corporation Automated query predicate selectivity prediction using machine learning models
US11934781B2 (en) 2020-08-28 2024-03-19 Salesforce, Inc. Systems and methods for controllable text summarization
CN111813802B (zh) * 2020-09-11 2021-06-29 杭州量之智能科技有限公司 一种基于自然语言生成结构化查询语句的方法
US12197503B1 (en) 2020-09-30 2025-01-14 Amazon Technologies, Inc. Interactive command generation for natural language input
WO2022072844A1 (en) * 2020-10-01 2022-04-07 Vishal Misra Systems, methods, and media for formulating database queries from natural language text
WO2022077244A1 (en) * 2020-10-14 2022-04-21 Microsoft Technology Licensing, Llc. A look-ahead strategy for trie-based beam search in generative retrieval
US11803541B2 (en) * 2020-10-16 2023-10-31 Salesforce, Inc. Primitive-based query generation from natural language queries
US11947440B2 (en) * 2020-11-10 2024-04-02 Salesforce, Inc. Management of search features via declarative metadata
CN112270190A (zh) * 2020-11-13 2021-01-26 浩鲸云计算科技股份有限公司 一种基于注意力机制的数据库字段翻译方法及系统
US20220156270A1 (en) * 2020-11-16 2022-05-19 Science First Partnerships, LLC Data-Driven Academia and Industry Matching Platform
CN112380238B (zh) * 2020-11-16 2024-06-28 平安科技（深圳）有限公司 数据库数据查询方法、装置、电子设备及存储介质
US11829442B2 (en) 2020-11-16 2023-11-28 Salesforce.Com, Inc. Methods and systems for efficient batch active learning of a deep neural network
CN112559552B (zh) 2020-12-03 2023-07-25 北京百度网讯科技有限公司 数据对生成方法、装置、电子设备及存储介质
CN112507098B (zh) * 2020-12-18 2022-01-28 北京百度网讯科技有限公司 问题处理方法、装置、电子设备、存储介质及程序产品
CN112559690A (zh) * 2020-12-21 2021-03-26 广东珠江智联信息科技股份有限公司 一种自然语言智能数据建模技术
US11989528B2 (en) 2020-12-30 2024-05-21 Direct Cursus Technology L.L.C Method and server for training a machine learning algorithm for executing translation
KR102498403B1 (ko) * 2021-01-29 2023-02-09 포항공과대학교 산학협력단 자연어를 sql로 변환하는 시스템을 위한 훈련 세트 수집 장치 및 그 방법
CN113779062B (zh) * 2021-02-23 2025-02-21 北京沃东天骏信息技术有限公司 Sql语句生成方法、装置、存储介质及电子设备
CN113220881B (zh) * 2021-02-24 2024-02-06 盐城幼儿师范高等专科学校 基于深度学习的教育问答实现方法、装置及服务器
CN113010651B (zh) * 2021-03-02 2025-02-18 中国工商银行股份有限公司 一种针对用户提问的答复方法、装置及设备
US11928111B2 (en) * 2021-03-03 2024-03-12 Samsung Electronics Co., Ltd. Electronic apparatus and method for controlling electronic apparatus
JP7696736B2 (ja) 2021-03-23 2025-06-23 キオクシア株式会社 情報処理装置、情報処理方法、及び学習モデルの生成方法
US11500865B1 (en) 2021-03-31 2022-11-15 Amazon Technologies, Inc. Multiple stage filtering for natural language query processing pipelines
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
CN113052257B (zh) * 2021-04-13 2024-04-16 中国电子科技集团公司信息科学研究院 一种基于视觉转换器的深度强化学习方法及装置
US11768831B2 (en) * 2021-05-10 2023-09-26 Servicenow, Inc. Systems and methods for translating natural language queries into a constrained domain-specific language
CN113282724B (zh) * 2021-05-21 2024-05-28 北京京东振世信息技术有限公司 一种智能客服的交互方法和装置
CN113408298B (zh) * 2021-06-30 2024-05-31 北京百度网讯科技有限公司 语义解析方法、装置、电子设备及存储介质
CN113553414B (zh) * 2021-06-30 2023-08-25 北京百度网讯科技有限公司 智能对话方法、装置、电子设备和存储介质
CN113486056B (zh) * 2021-07-09 2023-06-09 平安科技（深圳）有限公司 基于知识图谱的学习情况获取方法、装置及相关设备
US20230009946A1 (en) * 2021-07-12 2023-01-12 International Business Machines Corporation Generative relation linking for question answering
CN113641805B (zh) * 2021-07-19 2024-05-24 北京百度网讯科技有限公司 结构化问答模型的获取方法、问答方法及对应装置
KR102666591B1 (ko) * 2021-10-20 2024-05-16 케이데이터랩 주식회사 크라우드 소싱을 활용하여 인공지능 학습용 데이터를 생성하는 인공지능 학습데이터 생성방법
US11726750B1 (en) * 2021-11-17 2023-08-15 Outsystems—Software Em Rede, S.A. Constrained decoding and ranking of language models for code generation
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
KR102737842B1 (ko) * 2021-11-29 2024-12-04 주식회사 포티투마루 자연어 질의의 sql 변환 방법 및 장치
US12505098B2 (en) * 2021-11-30 2025-12-23 POSTECH Research and Business Development Foundation Apparatus and method for processing natural language query about relational database using transformer neural network
US12412034B2 (en) * 2021-12-14 2025-09-09 Oracle International Corporation Transforming natural language to structured query language based on scalable search and content-based schema linking
WO2023128021A1 (ko) 2021-12-30 2023-07-06 포항공과대학교 산학협력단 자연어 처리 시스템의 학습 데이터셋 증강 방법
US11907226B2 (en) * 2022-03-21 2024-02-20 International Business Machines Corporation Refining understanding of natural language database queries
US12346378B2 (en) * 2022-03-22 2025-07-01 Paypal, Inc. Automated database query generation and analysis
CN114896275B (zh) * 2022-04-15 2025-11-28 中国航空工业集团公司沈阳飞机设计研究所 一种将自然语言文本转为sql语句的方法及系统
CN114896266B (zh) * 2022-04-27 2025-05-02 清华大学 基于学习的sql自动生成方法
EP4544418A1 (en) * 2022-06-24 2025-04-30 Salesforce, Inc. Systems and methods for semantic parsing with primitive level enumeration
CN115168408B (zh) * 2022-08-16 2024-05-28 北京永洪商智科技有限公司 基于强化学习的查询优化方法、装置、设备及存储介质
US12430330B2 (en) * 2022-08-22 2025-09-30 Oracle International Corporation Calibrating confidence scores of a machine learning model trained as a natural language interface
CN115576984B (zh) * 2022-09-13 2025-11-07 粤港澳国际供应链(广州)有限公司 中文自然语言生成sql语句及跨数据库查询方法
US20240104092A1 (en) * 2022-09-22 2024-03-28 Hitachi Energy Ltd Voice-based performance query with non-semantic databases
CN115525675B (zh) * 2022-09-27 2026-04-21 东北大学 一种数据查询方法、装置、设备及可读存储介质
US12591602B2 (en) * 2022-09-30 2026-03-31 Florida Power & Light Company Training machine learning based natural language processing for specialty jargon
CN115576983B (zh) * 2022-11-01 2025-09-02 国家电网有限公司大数据中心 一种语句生成方法、装置、电子设备及介质
EP4425350A1 (en) * 2023-02-28 2024-09-04 Siemens Aktiengesellschaft Method and system for performing automated database updates
CN116431797B (zh) * 2023-03-10 2025-11-14 中国工商银行股份有限公司 业务查询方法、装置、存储介质及电子设备
US12346315B1 (en) 2023-03-21 2025-07-01 Amazon Technologies, Inc. Natural language query processing
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
CN116467347B (zh) * 2023-03-22 2024-04-30 天云融创数据科技（北京）有限公司 一种股票问答方法
CN116629277B (zh) * 2023-04-07 2025-09-05 金叶天成(北京)科技有限公司 一种基于强化学习的医学机器翻译方法
US12511282B1 (en) 2023-05-02 2025-12-30 Microstrategy Incorporated Generating structured query language using machine learning
US12436982B2 (en) * 2023-06-13 2025-10-07 Microsoft Technology Licensing, Llc Data intelligence model for operator data queries
EP4535197A1 (en) * 2023-10-03 2025-04-09 Sap Se System and method for generating an executable data query
US12567074B2 (en) * 2023-11-02 2026-03-03 Rockwell Automation Technologies, Inc. Generative AI for customer support acceleration
CN117827882B (zh) * 2024-01-04 2024-08-20 北京新数科技有限公司 一种基于深度学习的金融数据库sql质量评分方法、系统、设备和可存储介质
US20250245220A1 (en) * 2024-01-26 2025-07-31 Microsoft Technology Licensing, Llc Evaluation and optimization of natural language to database query translation
WO2025189082A1 (en) * 2024-03-08 2025-09-12 Oracle International Corporation Automated prompt augmentation and engineering using ml automation in sql query engine
US20250284688A1 (en) * 2024-03-08 2025-09-11 Oracle International Corporation Automated Prompt Augmentation And Engineering Using ML Automation In SQL Query Engine
WO2025234102A1 (ja) * 2024-05-10 2025-11-13 株式会社Ｎｔｔドコモ 情報出力装置および情報出力方法
CN119670877B (zh) * 2024-10-17 2025-10-31 上海沄熹科技有限公司 数据库集成机器学习在线推理服务的方法及系统
CN119003567B (zh) * 2024-10-22 2025-01-28 思创数码科技股份有限公司 一种项目数据查询方法及系统
US20260127163A1 (en) * 2024-11-03 2026-05-07 International Business Machines Corporation Structured query language statement validation based on machine learning
CN120371854B (zh) * 2025-06-26 2025-10-21 浪潮云洲工业互联网有限公司 一种结构化查询语言生成方法、装置、设备以及存储介质

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8156145B2 (en) * 2003-11-06 2012-04-10 Oracle International Corporation Analytic enhancements to model clause in structured query language (SQL)
CN102622342A (zh) * 2011-01-28 2012-08-01 上海肇通信息技术有限公司 中间语系统、中间语引擎、中间语翻译系统和相应方法
CN102693303A (zh) * 2012-05-18 2012-09-26 上海极值信息技术有限公司 一种公式化数据的搜索方法及装置
US8380645B2 (en) * 2010-05-27 2013-02-19 Bmc Software, Inc. Method and system to enable inferencing for natural language queries of configuration management databases
CN106598948A (zh) * 2016-12-19 2017-04-26 杭州语忆科技有限公司 基于长短期记忆神经网络结合自动编码器的情绪识别方法
CN106663092A (zh) * 2014-10-24 2017-05-10 谷歌公司 具有罕见词处理的神经机器翻译系统

Family Cites Families (17)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070027905A1 (en) * 2005-07-29 2007-02-01 Microsoft Corporation Intelligent SQL generation for persistent object retrieval
US20110314010A1 (en) 2010-06-17 2011-12-22 Microsoft Corporation Keyword to query predicate maps for query translation
US9305050B2 (en) * 2012-03-06 2016-04-05 Sergey F. Tolkachev Aggregator, filter and delivery system for online context dependent interaction, systems and methods
US10025819B2 (en) * 2014-11-13 2018-07-17 Adobe Systems Incorporated Generating a query statement based on unstructured input
US20160171050A1 (en) 2014-11-20 2016-06-16 Subrata Das Distributed Analytical Search Utilizing Semantic Analysis of Natural Language
JP6305630B2 (ja) * 2015-03-20 2018-04-04 株式会社東芝 文書検索装置、方法及びプログラム
US10545958B2 (en) * 2015-05-18 2020-01-28 Microsoft Technology Licensing, Llc Language scaling platform for natural language processing systems
JP6678930B2 (ja) * 2015-08-31 2020-04-15 インターナショナル・ビジネス・マシーンズ・コーポレーションＩｎｔｅｒｎａｔｉｏｎａｌ Ｂｕｓｉｎｅｓｓ Ｍａｃｈｉｎｅｓ Ｃｏｒｐｏｒａｔｉｏｎ 分類モデルを学習する方法、コンピュータ・システムおよびコンピュータ・プログラム
US10606846B2 (en) 2015-10-16 2020-03-31 Baidu Usa Llc Systems and methods for human inspired simple question answering (HISQA)
US10430407B2 (en) * 2015-12-02 2019-10-01 International Business Machines Corporation Generating structured queries from natural language text
US10013416B1 (en) * 2015-12-18 2018-07-03 Amazon Technologies, Inc. Language based solution agent
US20170249309A1 (en) * 2016-02-29 2017-08-31 Microsoft Technology Licensing, Llc Interpreting and Resolving Conditional Natural Language Queries
US9830315B1 (en) * 2016-07-13 2017-11-28 Xerox Corporation Sequence-based structured prediction for semantic parsing
US20180052824A1 (en) * 2016-08-19 2018-02-22 Microsoft Technology Licensing, Llc Task identification and completion based on natural language query
US10783451B2 (en) * 2016-10-12 2020-09-22 Accenture Global Solutions Limited Ensemble machine learning for structured and unstructured data
US10654380B2 (en) * 2016-11-18 2020-05-19 Microsoft Technology Licensing, Llc Query rewriting and interactive inquiry framework
US20180210883A1 (en) * 2017-01-25 2018-07-26 Dony Ang System for converting natural language questions into sql-semantic queries based on a dimensional model

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8156145B2 (en) * 2003-11-06 2012-04-10 Oracle International Corporation Analytic enhancements to model clause in structured query language (SQL)
US8380645B2 (en) * 2010-05-27 2013-02-19 Bmc Software, Inc. Method and system to enable inferencing for natural language queries of configuration management databases
CN102622342A (zh) * 2011-01-28 2012-08-01 上海肇通信息技术有限公司 中间语系统、中间语引擎、中间语翻译系统和相应方法
CN102693303A (zh) * 2012-05-18 2012-09-26 上海极值信息技术有限公司 一种公式化数据的搜索方法及装置
CN106663092A (zh) * 2014-10-24 2017-05-10 谷歌公司 具有罕见词处理的神经机器翻译系统
CN106598948A (zh) * 2016-12-19 2017-04-26 杭州语忆科技有限公司 基于长短期记忆神经网络结合自动编码器的情绪识别方法

Also Published As

Publication number Publication date
CA3062071A1 (en) 2018-11-22
US20180336198A1 (en) 2018-11-22
JP2020520516A (ja) 2020-07-09
JP6929971B2 (ja) 2021-09-01
CA3062071C (en) 2023-08-29
WO2018213530A2 (en) 2018-11-22
CN110945495A (zh) 2020-03-31
US20200301925A1 (en) 2020-09-24
US10747761B2 (en) 2020-08-18
US11526507B2 (en) 2022-12-13
EP3625734A2 (en) 2020-03-25
EP3625734A4 (en) 2020-12-09
WO2018213530A3 (en) 2019-01-24

Similar Documents

Publication Publication Date Title
CN110945495A (zh) 基于神经网络的自然语言查询到数据库查询的转换
Zhong et al. Seq2sql: Generating structured queries from natural language using reinforcement learning
Zhang et al. A survey of graph retrieval-augmented generation for customized large language models
Kumar et al. An abstractive text summarization technique using transformer model with self-attention mechanism
US11410031B2 (en) Dynamic updating of a word embedding model
US10831752B2 (en) Semantic relational database operations
Lei et al. Semi-supervised geological disasters named entity recognition using few labeled data
Li et al. Using context information to enhance simple question answering
Qi et al. Aspect-based sentiment analysis with enhanced aspect-sensitive word embeddings
Shi et al. Cocoast: representing source code via hierarchical splitting and reconstruction of abstract syntax trees
Zhen et al. Frequent words and syntactic context integrated biomedical discontinuous named entity recognition method: Y. Zhen et al.
CN113822018A (zh) 实体关系联合抽取方法
Liu et al. Sentiment analysis of Chinese ancient poetry based on multidimensional knowledge attention
Li et al. Improving Medical Q&A Matching by Augmenting Dual‐Channel Attention with Global Similarity
Yang et al. B-LBConA: a medical entity disambiguation model based on Bio-LinkBERT and context-aware mechanism
Xue et al. Biomedical information integration via adaptive large language model construction
Shu Automatic extraction and structuration of soil–environment relationship information from soil survey reports
US12536481B2 (en) Methods and systems for holistic medical student and medical residency matching
Jiarong et al. Knowledge enhanced bert based on corpus associate generation
CN113704481A (zh) 一种文本处理方法、装置、设备及存储介质
CN120832942A (zh) 用于构建医学知识图谱的实体关系抽取方法、装置及设备
Wang et al. Joint modeling method of question intent detection and slot filling for domain-oriented question answering system
Wang Multimedia-aided English online translation platform based on bayesian theorem
Hou et al. HiEE: Hierarchical feature fusion for Chinese event extraction
Wang et al. Medical entity recognition based on BiLSTM with knowledge graph and attention mechanism

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
GR01 Patent grant
GR01 Patent grant
CP01 Change in the name or title of a patent holder
CP01 Change in the name or title of a patent holder

Address after: California, USA

Patentee after: Shuo Power Co.

Address before: California, USA

Patentee before: SALESFORCE.COM, Inc.