CN113868375A - Data query method, device, device and storage medium based on structured query language - Google Patents

Abstract

The invention relates to a data query method, device, device and storage medium based on structured query language. The method includes: receiving a data query statement input by a user in a text document, and generating a query key carrying a query key according to the data query statement. The tree structure data of the word, for each database to be queried, according to the query type of the database and the tree structure data, generate a retrieval formula corresponding to the database, and retrieve the database according to the retrieval formula to obtain the query data corresponding to the data query statement, and return the query data corresponding to the data query statement to the user. Through the above method, the search method constructed by the structured query language can enable users to flexibly design complex data query sentences in the text document according to their own search requirements, which greatly improves the flexibility of the search method.

Description

Data query method, device, device and storage medium based on structured query language

technical field

The invention relates to the field of computer technology, in particular to a data query method based on structured query language, a data query device based on structured query language, a data query device based on structured query language, and a computer storage medium .

Background technique

With the rapid development of modern Internet technology, the amount of data stored in the database is also increasing.

Currently, in order to improve the efficiency of obtaining data from a database, a search tool is usually used to search the database for desired data.

Existing search tools usually display an interactive interface to the user. The interactive interface is provided with multiple search fields with different search conditions. According to the requirements of the search focus, input the corresponding search words in different search fields to query the user's information. required data.

In the prior art, the interactive interface displayed to the user by the existing search tool is all fixed, and the user can only search the required data according to the fixed search conditions on the interactive interface, and the search method is extremely inflexible.

SUMMARY OF THE INVENTION

The invention provides a data query based on a structured query language, which can solve the technical problem that the search method of the existing search tool is extremely inflexible.

The technical scheme that the present invention solves the above-mentioned technical problems is as follows:

According to a first aspect of the present invention, a data query method based on a structured query language is provided, comprising:

Receive the data query statement entered by the user in the text document;

generating tree-structured data carrying query keywords according to the data query statement;

For each database to be queried, a retrieval formula corresponding to the database is generated according to the query type of the database and the tree structure data, and the database is retrieved according to the retrieval formula to obtain query data corresponding to the data query statement ;

The query data corresponding to the data query statement is returned to the user.

Optionally, the data query statement includes: querying at least one of the name of the data source, the displayed field name, filter conditions, sorting rules, or skipping the initial number of data items.

Optionally, wherein, according to the data query statement, generate tree-structured data carrying query keywords, including:

Semantic analysis is performed on the data query statement to determine the query keywords of the data query statement;

The query keywords of the data query statement are added to the tree structure to generate tree structure data carrying the query keywords.

Optionally, performing semantic analysis on the data query statement to determine query keywords of the data query statement, including:

According to the preset word list, determine and extract the keywords in the data query statement to obtain a keyword list corresponding to the data query statement, wherein the keyword list includes the name of the keyword and the position of the keyword information and the original text corresponding to the keyword;

According to the keyword list corresponding to the data query statement, the query keyword of the data query statement is determined.

Optionally, performing semantic analysis on the data query statement to determine query keywords of the data query statement, including:

Perform word segmentation processing on the data query statement to obtain a word sequence;

Obtain the words of the specified part of speech in the word sequence;

Using the acquired words as keywords, a keyword list corresponding to the data query statement is obtained, wherein the keyword list includes the name of the keyword, the location information of the keyword, and the original text corresponding to the keyword;

According to the keyword list corresponding to the data query statement, the query keyword of the data query statement is determined.

Optionally, wherein, according to the keyword list corresponding to the data query statement, the query keywords of the data query statement are determined, including:

Syntactic analysis is performed on each keyword in the keyword list corresponding to the data query statement to determine whether each keyword conforms to the grammatical structure;

A keyword that conforms to the grammatical structure is determined as the query keyword of the data query statement.

Optionally, the part of speech of the query keyword is a predicate part of speech.

According to a second aspect of the present invention, a data query device based on structured query language is provided, comprising:

The receiving module is used to receive the data query statement input by the user in the text document;

a generating module, configured to generate tree-structured data carrying query keywords according to the data query statement;

A query module, for each database to be queried, according to the query type of the database and the tree structure data, generate a retrieval formula corresponding to the database, and retrieve the database according to the retrieval formula to obtain the data query query data corresponding to the statement;

The returning module is configured to return the query data corresponding to the data query statement to the user.

According to a third aspect of the present invention, a structured query language-based data query device is provided, including a structured query language-based data query device; or,

The device includes: a processor and a memory;

The memory is used to store executable instructions for controlling the processor to perform the method according to any one of the first aspects.

According to a third aspect of the present invention, there is provided a computer storage medium, where computer instructions are stored in the storage medium, and when the computer instructions in the storage medium are executed by a processor, any one of the first aspect can be implemented. method described.

The beneficial effects of the present invention are: the search mode constructed by the structured query language can enable users to flexibly design complex data query sentences in the text document according to their own search requirements, thereby greatly improving the flexibility of the search mode.

Description of drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention.

1 is a flowchart of a data query method based on a structured query language provided by an embodiment of the present invention;

2 is a schematic structural diagram of a data query device based on a structured query language provided by an embodiment of the present invention;

FIG. 3 is a schematic structural diagram of a data query device based on a structured query language provided by an embodiment of the present invention.

Detailed ways

The principles and features of the present invention will be described below with reference to the accompanying drawings. The examples are only used to explain the present invention, but not to limit the scope of the present invention.

Techniques, methods, and apparatus known to those of ordinary skill in the relevant art may not be discussed in detail, but where appropriate, such techniques, methods, and apparatus should be considered part of the specification.

In all examples shown and discussed herein, any specific values should be construed as illustrative only and not limiting. Accordingly, other instances of the exemplary embodiment may have different values.

It should be noted that like numerals and letters refer to like items in the following figures, so once an item is defined in one figure, it does not require further discussion in subsequent figures.

<Method Example>

An embodiment of the present invention provides a data query method based on a structured query language, as shown in FIG. 1 , and the specific steps are as follows:

S101: Receive a data query statement input by a user in a text document.

In the embodiment of the present invention, in the process of querying the required data in the database, the user no longer uses the interactive interface provided with multiple search bars with different search conditions, but directly opens a blank text document and opens the text document in the text document. Enter the data query statement.

It should be noted here that the data fields included in the data query statement are pre-designed, which can be at least the name of the query data source, the displayed field name, filter conditions, sorting rules, or skipping the initial number of data items. One, in addition, you can also add other data fields in the data query statement according to the actual situation.

It should also be noted here that the field name of the name of the query data source is FROM; the field name of the displayed field name is SELECT; the field name of the filter condition is WHERE; the field name of the collation rule is ORDERBY; skip the initial data The field name of the number of bars is SKIP.

S102: Generate tree-structured data carrying query keywords according to the data query statement.

Further, since query keywords need to be used when querying the required data in the database, in this embodiment of the present invention, after receiving the data query statement input by the user, it is necessary to generate a query statement carrying a query according to the data query statement. Tree-structured data for keywords.

Further, since the query keyword is based on the data query statement, in the embodiment of the present invention, according to the data query statement, the implementation manner of generating tree-structured data carrying the query keyword can specifically be The data query statement is semantically analyzed to determine the query keyword of the data query statement; the query keyword of the data query statement is added to the tree structure to generate tree structure data carrying the query keyword.

It should be noted here that, in order to perform semantic analysis on the data query statement and determine the query keywords of the data query statement, the embodiment of the present invention provides two specific implementation manners, as follows:

The first embodiment: determine and extract keywords in the data query statement according to a preset word list, and obtain a keyword list corresponding to the data query statement, wherein the keyword list includes keywords The name, the location information of the keyword, and the original text corresponding to the keyword, and the query keyword of the data query statement is determined according to the keyword list corresponding to the data query statement.

It should be noted here that the word list is preset, for example, the word list includes: FROM, SELECT, WHERE, ORDERBY and SKIP; according to the preset word list, determine and extract the keywords in the data query statement Specifically, for each word recorded in the word list, match one by one in the data query statement. If the word in the word list is matched in the data query statement, the word is used as a keyword, and the location information of the keyword is recorded. (that is, the position of the keyword in the data query statement) and the original text corresponding to the keyword. For example, if the data query statement is FROM:A-SELECT:B, the word list includes: FROM and SELECT. For the FROM in the word list If it matches FROM in the data query statement, record the name of the keyword FROM, the 0th byte of the position information of the keyword, and the original text A corresponding to the keyword; match the SELECT in the word list to the SELECT in the data query statement , then record the name of the keyword SELECT, the 7th byte of the position information of the keyword, the original text B corresponding to the keyword, according to the determined name of the keyword FROM, the 0th byte of the position information of the keyword, the keyword The corresponding original text A, the name of the keyword SELECT, the 7th byte of the position information of the keyword, and the original text B corresponding to the keyword, generate a keyword list.

The second embodiment: acquire words with a specified part of speech in the word sequence; use the acquired words as keywords to obtain a keyword list corresponding to the data query statement, wherein the keyword list includes keywords. The name, the location information of the keyword, and the original text corresponding to the keyword; the query keyword of the data query statement is determined according to the keyword list corresponding to the data query statement.

It should be noted here that the specified part of speech may be a predicate part of speech, a noun part of speech, or an adjective part of speech.

For example, assuming that the specified part of speech is the predicate part of speech, the data query statement is FROM: A-SELECT: B, and the predicated words in the word sequence are FROM and SELECT, then both FROM will be used as the keyword, and the name of the keyword will be recorded. FROM, the 0th byte of the position information of the keyword, the original text A corresponding to the keyword; using SELECT as the keyword, record the name of the keyword SELECT, the 7th byte of the position information of the keyword, the original text corresponding to the keyword B, according to the determined keyword name FROM, the 0th byte of the keyword position information, the original text A corresponding to the keyword, the name SELECT of the keyword, the 7th byte of the keyword position information, the corresponding keyword Original text B, generate a keyword list.

It should also be noted here that, regardless of the first embodiment or the second embodiment, as long as it is an unrecognized keyword, an error message can be returned and the operation can be terminated.

In addition, since the keywords are to be input into the database for query, that is to say, the keywords in the keyword list must conform to the grammatical structure of the database. Determining the query keywords of the data query statement according to the keyword list corresponding to the data query statement may specifically be: performing grammatical analysis on each keyword in the keyword list corresponding to the data query statement, and determining each keyword Whether the keyword conforms to the grammatical structure; the keyword that conforms to the grammatical structure is determined as the query keyword of the data query statement.

It should be noted here that, for keywords that do not conform to the grammatical structure in the keyword list, an error message can be returned and the operation can be terminated.

S103: For each database to be queried, generate a retrieval formula corresponding to the database according to the query type of the database and the tree structure data, and retrieve the database according to the retrieval formula, and obtain the corresponding data query statement. Query data.

Further, although the query keywords in the tree-structured data all conform to the grammatical structure, the retrieval methods of different types of databases are different, that is, the retrieval formulas used by different types of databases are different. Therefore, in the implementation of the present invention, In an example, it is necessary to generate a retrieval formula corresponding to the database according to the query type of the database and the tree structure data for each database to be queried, and retrieve the database according to the retrieval formula to obtain the data query statement. Corresponding query data, so that each type of database will generate a retrieval formula that conforms to its own database query rules according to the query type and tree structure data of the database, so as to query the data required by the user.

It should be noted here that the generated retrieval formula only contains the data that can be determined at this stage. For some data that can be determined only when the query is executed, the acquisition method of these data can be reserved and wait for the query to be filled in the running stage.

S104: Return the query data corresponding to the data query statement to the user.

Further, the query data corresponding to the data query statement queried in each database is returned to the user.

Through the above method, the search method constructed by the structured query language can enable users to flexibly design complex data query sentences in the text document according to their own search requirements, which greatly improves the flexibility of the search method.

<Apparatus Example>

As shown in FIG. 2 , an embodiment of the present invention also provides a data query device based on a structured query language, including:

A receiving module 201, configured to receive a data query statement input by a user in a text document;

A generating module 202, configured to generate tree-structured data carrying query keywords according to the data query statement;

The query module 203 is configured to, for each database to be queried, generate a retrieval formula corresponding to the database according to the query type of the database and the tree structure data, and retrieve the database according to the retrieval formula to obtain the data The query data corresponding to the query statement;

Returning module 204, configured to return the query data corresponding to the data query statement to the user.

The data query statement includes: at least one of the name of the query data source, the displayed field name, filter conditions, sorting rules or skipping the initial number of data items.

The generating module 202 is specifically configured to perform semantic analysis on the data query statement, and determine the query keyword of the data query statement; add the query keyword of the data query statement to the tree structure, and generate a query keyword carrying the data query statement. Tree-structured data for query keywords.

The generating module 202 is further configured to, according to a preset word list, determine and extract keywords in the data query statement, and obtain a keyword list corresponding to the data query statement, wherein the keyword list includes: The name of the keyword, the position information of the keyword, and the original text corresponding to the keyword; the query keyword of the data query statement is determined according to the keyword list corresponding to the data query statement.

The generating module 202 is further configured to perform word segmentation processing on the data query statement to obtain a word sequence; obtain words with a specified part of speech in the word sequence; and use the obtained word as a keyword to obtain the data query statement A corresponding keyword list, wherein the keyword list includes the name of the keyword, the location information of the keyword, and the original text corresponding to the keyword; according to the keyword list corresponding to the data query statement, determine the data query The query keyword of the statement.

The generating module 202 is further configured to perform grammatical analysis on each keyword in the keyword list corresponding to the data query statement to determine whether each keyword conforms to the grammatical structure; The query keyword of the data query statement.

The part of speech of the query keyword is a predicate part of speech.

<Apparatus Example>

An embodiment of the present invention further provides a data query device based on structured query language. As shown in FIG. 3 , the data query device based on structured query language includes the data query based on structured query language in the above device embodiments device.

Alternatively, the structured query language-based data query device includes a memory 301 and a processor 302 . The memory is used to store executable instructions, and the instructions are used to control the processor to execute the method according to any one of the foregoing method embodiments.

<Computer storage medium>

The present invention further provides a computer storage medium, the storage medium stores computer instructions, and when the computer instructions in the storage medium are executed by a processor, the method according to any one of the above method embodiments is implemented.

The present invention may be a system, method and/or computer program product. The computer program product may include a computer-readable storage medium having computer-readable program instructions loaded thereon for causing a processor to implement various aspects of the present invention.

A computer-readable storage medium may be a tangible device that can hold and store instructions for use by the instruction execution device. The computer-readable storage medium may be, for example, but not limited to, an electrical storage device, a magnetic storage device, an optical storage device, an electromagnetic storage device, a semiconductor storage device, or any suitable combination of the foregoing. More specific examples (non-exhaustive list) of computer readable storage media include: portable computer disks, hard disks, random access memory (RAM), read only memory (ROM), erasable programmable read only memory (EPROM) or flash memory), static random access memory (SRAM), portable compact disk read only memory (CD-ROM), digital versatile disk (DVD), memory sticks, floppy disks, mechanically coded devices, such as printers with instructions stored thereon Hole cards or raised structures in grooves, and any suitable combination of the above. Computer-readable storage media, as used herein, are not to be construed as transient signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through waveguides or other transmission media (eg, light pulses through fiber optic cables), or through electrical wires transmitted electrical signals.

The computer readable program instructions described herein may be downloaded to various computing/processing devices from a computer readable storage medium, or to an external computer or external storage device over a network such as the Internet, a local area network, a wide area network, and/or a wireless network. The network may include copper transmission cables, fiber optic transmission, wireless transmission, routers, firewalls, switches, gateway computers, and/or edge servers. A network adapter card or network interface in each computing/processing device receives computer-readable program instructions from a network and forwards the computer-readable program instructions for storage in a computer-readable storage medium in each computing/processing device .

The computer program instructions for carrying out the operations of the present invention may be assembly instructions, instruction set architecture (ISA) instructions, machine instructions, machine dependent instructions, microcode, firmware instructions, state setting data, or instructions in one or more programming languages. Source or object code, written in any combination, including object-oriented programming languages, such as Smalltalk, C++, etc., and conventional procedural programming languages, such as the "C" language or similar programming languages. The computer readable program instructions may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer, or entirely on the remote computer or server implement. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (eg, using an Internet service provider through the Internet connect). In some embodiments, custom electronic circuits, such as programmable logic circuits, field programmable gate arrays (FPGAs), or programmable logic arrays (PLAs), can be personalized by utilizing state information of computer readable program instructions. Computer readable program instructions are executed to implement various aspects of the present invention.

Aspects of the present invention are described herein with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer readable program instructions.

These computer readable program instructions may be provided to a processor of a general purpose computer, special purpose computer or other programmable data processing apparatus to produce a machine that causes the instructions when executed by the processor of the computer or other programmable data processing apparatus , resulting in means for implementing the functions/acts specified in one or more blocks of the flowchart and/or block diagrams. These computer readable program instructions can also be stored in a computer readable storage medium, these instructions cause a computer, programmable data processing apparatus and/or other equipment to operate in a specific manner, so that the computer readable medium on which the instructions are stored includes An article of manufacture comprising instructions for implementing various aspects of the functions/acts specified in one or more blocks of the flowchart and/or block diagrams.

Computer readable program instructions can also be loaded onto a computer, other programmable data processing apparatus, or other equipment to cause a series of operational steps to be performed on the computer, other programmable data processing apparatus, or other equipment to produce a computer-implemented process , thereby causing instructions executing on a computer, other programmable data processing apparatus, or other device to implement the functions/acts specified in one or more blocks of the flowcharts and/or block diagrams.

The flowchart and block diagrams in the Figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of instructions, which comprises one or more functions for implementing the specified logical function(s) executable instructions. In some alternative implementations, the functions noted in the blocks may occur out of the order noted in the figures. For example, two blocks in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It is also noted that each block of the block diagrams and/or flowchart illustrations, and combinations of blocks in the block diagrams and/or flowchart illustrations, can be implemented in dedicated hardware-based systems that perform the specified functions or actions , or can be implemented in a combination of dedicated hardware and computer instructions. It is well known to those skilled in the art that implementation in hardware, implementation in software, and implementation in a combination of software and hardware are all equivalent.

Various embodiments of the present invention have been described above, and the foregoing descriptions are exemplary, not exhaustive, and not limiting of the disclosed embodiments. Numerous modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the described embodiments. The terminology used herein was chosen to best explain the principles of the embodiments, the practical application or technical improvement in the marketplace, or to enable others of ordinary skill in the art to understand the embodiments disclosed herein. The scope of the invention is defined by the appended claims.

Claims (10)

1. a data query method based on structured query language, is characterized in that, comprises: Receive the data query statement entered by the user in the text document; generating tree-structured data carrying query keywords according to the data query statement; For each database to be queried, a retrieval formula corresponding to the database is generated according to the query type of the database and the tree structure data, and the database is retrieved according to the retrieval formula to obtain query data corresponding to the data query statement ; The query data corresponding to the data query statement is returned to the user. 2. The method according to claim 1, wherein the data query statement comprises: at least one of the name of the query data source, the displayed field name, filter conditions, sorting rules or skipping the initial number of data pieces . 3. The method according to claim 1, wherein, according to the data query statement, generating tree-structured data carrying query keywords, comprising: Semantic analysis is performed on the data query statement to determine the query keywords of the data query statement; The query keywords of the data query statement are added to the tree structure to generate tree structure data carrying the query keywords. 4. The method according to claim 3, characterized in that, performing semantic analysis on the data query statement to determine query keywords of the data query statement, comprising: According to the preset word list, determine and extract the keywords in the data query statement to obtain a keyword list corresponding to the data query statement, wherein the keyword list includes the name of the keyword and the position of the keyword information and the original text corresponding to the keyword; According to the keyword list corresponding to the data query statement, the query keyword of the data query statement is determined. 5. The method according to claim 3, characterized in that, performing semantic analysis on the data query statement to determine query keywords of the data query statement, comprising: Perform word segmentation processing on the data query statement to obtain a word sequence; Obtain the words of the specified part of speech in the word sequence; Using the acquired words as keywords, a keyword list corresponding to the data query statement is obtained, wherein the keyword list includes the name of the keyword, the location information of the keyword, and the original text corresponding to the keyword; According to the keyword list corresponding to the data query statement, the query keyword of the data query statement is determined. 6. The method according to claim 4 or 5, wherein determining the query keywords of the data query statement according to a keyword list corresponding to the data query statement, comprising: Syntactic analysis is performed on each keyword in the keyword list corresponding to the data query statement to determine whether each keyword conforms to the grammatical structure; A keyword that conforms to the grammatical structure is determined as the query keyword of the data query statement. 7. The method according to claim 6, wherein the part of speech of the query keyword is a part of speech of a predicate. 8. A data query device based on structured query language, characterized in that, comprising: The receiving module is used to receive the data query statement input by the user in the text document; a generating module, configured to generate tree-structured data carrying query keywords according to the data query statement; A query module, for each database to be queried, according to the query type of the database and the tree structure data, generate a retrieval formula corresponding to the database, and retrieve the database according to the retrieval formula to obtain the data query query data corresponding to the statement; The returning module is configured to return the query data corresponding to the data query statement to the user. 9. A structured query language-based data query device, comprising the structured query language-based data query device of claim 8; or, The device includes: a processor and a memory; The memory is used to store executable instructions for controlling the processor to perform the method according to any one of claims 1-7. 10. A computer storage medium storing computer instructions, when the computer instructions in the storage medium are executed by a processor, the method according to any one of claims 1-7 is implemented.

Images