Unlock instant, AI-driven research and patent intelligence for your innovation.

Database query method and device, electronic equipment and computer storage medium

A query method and database technology, applied in the direction of database index, relational database, database model, etc., can solve the problems of low conversion efficiency and heavy conversion processing workload, and achieve the effect of high speed and high efficiency

Pending Publication Date: 2021-10-01
TIANYUN RONGCHUANG DATA TECH BEIJING CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, the existing conversion process for converting natural language into SQL statements requires a large amount of work and the conversion efficiency is not high

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database query method and device, electronic equipment and computer storage medium
  • Database query method and device, electronic equipment and computer storage medium
  • Database query method and device, electronic equipment and computer storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0075] In order to more clearly understand the above objects, features and advantages of the present disclosure, the solutions of the present disclosure will be further described below. It should be noted that, in the case of no conflict, the embodiments of the present disclosure and the features in the embodiments can be combined with each other.

[0076] In the following description, many specific details are set forth in order to fully understand the present disclosure, but the present disclosure can also be implemented in other ways than described here; obviously, the embodiments in the description are only some of the embodiments of the present disclosure, and Not all examples.

[0077] In the process of database query, SQL statements are often used for query. SQL is a programming language. During the database query process, it can receive the natural language input by the user and convert the natural language into a computer-readable SQL statement, so as to perform quer...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a database query method and device, electronic equipment and a computer storage medium. According to the method, a to-be-converted text and a column name of a data table are input into a natural language conversion model, and an attribute identifier, a conditional column name and a selected column name corresponding to each character in the to-be-converted text are obtained, wherein the attribute identifier comprises a text starting identifier, a text middle identifier, a number starting identifier, a number middle identifier or a non-conditional value identifier; and enabling column names of the data table to comprise condition column names and selection column names, extracting condition values from the to-be-converted text according to attribute identifiers corresponding to each character in the to-be-converted text, determining condition expressions of the condition values and the condition column names according to the condition values and the condition column names, obtaining structured query language statements according to the condition expressions and the selection column names, and querying based on the structured query language statement to obtain a query result. The efficiency of converting the natural language into the SQL statement is high, the database query speed is high, and the efficiency is high.

Description

technical field [0001] The present disclosure relates to the technical field of databases, and in particular to a database query method, device, electronic equipment and computer storage medium. Background technique [0002] When querying data in a database, it is often necessary to use a Structured Query Language (SQL for short) statement. For users who do not know how to use SQL statements, they can input natural language and convert the natural language into SQL statements to complete query tasks based on SQL statements. [0003] However, the existing conversion processing for converting natural language into SQL statements requires a large workload and the conversion efficiency is not high. Contents of the invention [0004] In order to solve the above technical problems, the present disclosure provides a database query method, device, electronic equipment and computer storage medium. [0005] In a first aspect, the present disclosure provides a database query method...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22G06F16/242G06F16/245G06F16/28G06F40/151
CPCG06F16/221G06F16/2282G06F16/2433G06F16/245G06F16/284G06F40/151
Inventor 徐东雷涛谭可华
Owner TIANYUN RONGCHUANG DATA TECH BEIJING CO LTD