CN113868375A - Data query method, device, equipment and storage medium based on structured query language - Google Patents
Data query method, device, equipment and storage medium based on structured query language Download PDFInfo
- Publication number
- CN113868375A CN113868375A CN202111091779.9A CN202111091779A CN113868375A CN 113868375 A CN113868375 A CN 113868375A CN 202111091779 A CN202111091779 A CN 202111091779A CN 113868375 A CN113868375 A CN 113868375A
- Authority
- CN
- China
- Prior art keywords
- query
- data
- data query
- keywords
- keyword
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 33
- 238000000547 structure data Methods 0.000 claims abstract description 21
- 238000004458 analytical method Methods 0.000 claims description 11
- 238000012545 processing Methods 0.000 claims description 10
- 230000011218 segmentation Effects 0.000 claims description 3
- 238000013461 design Methods 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 12
- 230000006870 function Effects 0.000 description 7
- 238000004590 computer program Methods 0.000 description 5
- 230000002452 interceptive effect Effects 0.000 description 5
- 230000005540 biological transmission Effects 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 2
- 239000000835 fiber Substances 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000001902 propagating effect Effects 0.000 description 2
- RYGMFSIKBFXOCR-UHFFFAOYSA-N Copper Chemical compound [Cu] RYGMFSIKBFXOCR-UHFFFAOYSA-N 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 229910052802 copper Inorganic materials 0.000 description 1
- 239000010949 copper Substances 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000018109 developmental process Effects 0.000 description 1
- 230000000670 limiting effect Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000717 retained effect Effects 0.000 description 1
- 230000002441 reversible effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
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/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
- G06F16/3332—Query translation
- G06F16/3334—Selection or weighting of terms from queries, including natural language queries
-
- 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/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
- G06F16/334—Query execution
- G06F16/3344—Query execution using natural language analysis
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)
- Artificial Intelligence (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a data query method, a device, equipment and a storage medium based on a structured query language, wherein the method comprises the following steps: receiving a data query statement input by a user in a text document, generating tree-structure data carrying query keywords according to the data query statement, generating a retrieval formula corresponding to each database to be queried according to the query type of the database and the tree-structure data, retrieving the database according to the retrieval formula, obtaining query data corresponding to the data query statement, and returning the query data corresponding to the data query statement to the user. By the method, the searching mode constructed by the structured query language can enable a user to flexibly design complex data query sentences in the text document according to the searching requirement of the user, and the flexibility of the searching mode is greatly improved.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a data query method based on a structured query language, a data query device based on the structured query language, data query equipment based on the structured query language and a computer storage medium.
Background
With the rapid development of modern internet technology, the amount of data stored in databases is increasing.
Currently, in order to improve the efficiency of a user to obtain data from a database, a search tool is generally used to search the database for desired data.
The existing search tools usually show an interactive interface to a user, the interactive interface is provided with a plurality of search bars with different search conditions, and corresponding search terms are input in the different search bars according to the requirement of search emphasis to inquire data required by the user.
In the prior art, the interactive interfaces displayed to the user by the existing search tools are all fixed, the user can only search the required data according to the fixed search conditions on the interactive interfaces, and the search mode is extremely inflexible.
Disclosure of Invention
The invention provides a data query based on a structured query language, which can solve the technical problem that the existing search tool has an extremely inflexible search mode.
The technical scheme for solving the technical problems is as follows:
according to a first aspect of the present invention, there is provided a data query method based on a structured query language, including:
receiving a data query statement input by a user in a text document;
generating tree structure data carrying query keywords according to the data query statement;
aiming at each database to be queried, generating a retrieval formula corresponding to the database according to the query type of the database and the tree structure data, and retrieving the database according to the retrieval formula to obtain query data corresponding to the data query statement;
and returning the query data corresponding to the data query statement to the user.
Optionally, wherein the data query statement includes: querying at least one of a name of the data source, a field name displayed, a filter condition, a sort rule, or skipping the initial number of data pieces.
Optionally, generating tree structure data carrying query keywords according to the data query statement includes:
performing semantic analysis on the data query statement to determine a query keyword of the data query statement;
and adding the query key words of the data query sentences into a tree structure to generate tree structure data carrying the query key words.
Optionally, performing semantic analysis on the data query statement to determine a query keyword of the data query statement includes:
determining and extracting keywords in the data query sentence according to a preset word list to obtain a keyword list corresponding to the data query sentence, wherein the keyword list comprises names of the keywords, position information of the keywords and original texts corresponding to the keywords;
and determining the query keywords of the data query sentence according to the keyword list corresponding to the data query sentence.
Optionally, performing semantic analysis on the data query statement to determine a query keyword of the data query statement includes:
performing word segmentation processing on the data query sentence to obtain a word sequence;
acquiring words of a specified part of speech in the word sequence;
taking the obtained words as keywords to obtain a keyword list corresponding to the data query sentence, wherein the keyword list comprises names of the keywords, position information of the keywords and original texts corresponding to the keywords;
and determining the query keywords of the data query sentence according to the keyword list corresponding to the data query sentence.
Optionally, determining the query keyword of the data query statement according to the keyword list corresponding to the data query statement includes:
performing syntactic analysis on each keyword in the keyword list corresponding to the data query statement to determine whether each keyword conforms to a syntactic structure;
and determining the keywords conforming to the grammatical structure as the query keywords 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, there is provided a data query apparatus based on a structured query language, comprising:
the receiving module is used for receiving a data query sentence input by a user in a text document;
the generating module is used for generating tree structure data carrying query keywords according to the data query statement;
the query module is used for generating a retrieval formula corresponding to each database to be queried according to the query type of the database and the tree structure data, retrieving the database according to the retrieval formula and obtaining query data corresponding to the data query statement;
and the return module is used for returning the query data corresponding to the data query statement to the user.
According to a third aspect of the present invention, there is provided a data query device based on a structured query language, comprising a data query device based on a structured query language; or,
the apparatus comprises: a processor and a memory;
the memory is for storing 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 storing computer instructions which, when executed by a processor, implement the method of any one of the first aspects.
The invention has the beneficial effects that: through the search mode constructed by the structured query language, a user can flexibly design complex data query sentences in the text document according to the search requirement of the user, and the flexibility of the search mode is greatly improved.
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.
FIG. 1 is a flowchart of a data query method based on a structured query language according to an embodiment of the present invention;
FIG. 2 is a schematic structural diagram of a data query apparatus based on a structured query language according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of a data query device based on a structured query language according to an embodiment of the present invention.
Detailed Description
The principles and features of this invention are described below in conjunction with the following drawings, which are set forth by way of illustration only and are not intended to limit the scope of the invention.
Techniques, methods, and apparatus known to those of ordinary skill in the relevant art may not be discussed in detail but are intended to be part of the specification where appropriate.
In all examples shown and discussed herein, any particular value should be construed as merely illustrative, and not limiting. Thus, other examples of the exemplary embodiments may have different values.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, further discussion thereof is not required in subsequent figures.
< method examples >
The embodiment of the invention provides a data query method based on a structured query language, which comprises the following specific steps as shown in figure 1:
s101: a data query statement entered by a user within a text document is received.
In the embodiment of the invention, in the process of inquiring the required data in the database, a user does not use an interactive interface provided with a plurality of search columns with different search conditions, but directly opens a blank text document and inputs a data inquiry statement in the text document.
It should be noted that the data field included in the data query statement is designed in advance, and may be at least one of the name of the query data source, the name of the field displayed, the filtering condition, the sorting rule, or the number of skipped initial data pieces, and in addition, other data fields may be added to the data query statement according to the actual situation.
It should be noted here that the field name of the query data source is FROM; the field name of the displayed field name is SELECT; the field name of the filtering condition is WHERE; the field name of the sort rule is ORDERBY; the field name skipping the first number of data pieces is SKIP.
S102: and generating tree structure data carrying query keywords according to the data query statement.
Further, since the query keyword is required to be used when the database queries the required data, in the embodiment of the present invention, after receiving the data query statement input by the user, the tree structure data carrying the query keyword needs to be generated according to the data query statement.
Further, since the query keyword is derived based on the data query statement, in the embodiment of the present invention, an implementation manner of generating tree structure data carrying the query keyword according to the data query statement may specifically perform semantic analysis on the data query statement to determine the query keyword of the data query statement; and adding the query key words of the data query sentences into a tree structure to generate tree structure data carrying the query key words.
It should be noted that, for performing semantic analysis on the data query statement and determining a query keyword of the data query statement, the embodiment of the present invention provides two specific implementation manners, as follows:
the first embodiment: determining and extracting keywords in the data query sentence according to a preset word list to obtain a keyword list corresponding to the data query sentence, wherein the keyword list comprises names of the keywords, position information of the keywords and original texts corresponding to the keywords, and determining the query keywords of the data query sentence according to the keyword list corresponding to the data query sentence.
It should be noted that, the word list is preset, for example, the word list includes: FROM, SELECT, WHERE, ORDERBY, and SKIP; according to a preset word list, determining and extracting keywords in the data query sentence, specifically, for each word recorded in the word list, matching the words in the data query sentence one by one, if a word in the word list is matched in the data query sentence, using the word as a keyword, and recording position information of the keyword (i.e., a position of the keyword in the data query sentence) and an original text corresponding to the keyword, for example, assuming that the data query sentence is FROM: A-SELECT: b, the word list comprises: according to the FROM and the SELECT, matching the FROM in the word list with the FROM in the data query statement, recording the name FROM of the keyword, the 0 th byte of the position information of the keyword and the original text A corresponding to the keyword; and recording the name SELECT of the keyword, the 7 th byte of the position information of the keyword, the original text B corresponding to the keyword, the 0 th byte of the position information of the keyword, the original text A corresponding to the keyword, the name SELECT of the keyword, the 7 th byte of the position information of the keyword and the original text B corresponding to the keyword according to the determined name FROM of the keyword.
The second embodiment: acquiring words of a specified part of speech in the word sequence; taking the obtained words as keywords to obtain a keyword list corresponding to the data query sentence, wherein the keyword list comprises names of the keywords, position information of the keywords and original texts corresponding to the keywords; and determining the query keywords of the data query sentence according to the keyword list corresponding to the data query sentence.
It should be noted 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 the specified part of speech is a predicate part of speech, the data query statement is FROM: A-SELECT: b, acquiring words of predicate part of speech in the word sequence as FROM and SELECT, taking the FROM as key words, recording the name FROM of the key words, the 0 th byte of position information of the key words and original texts A corresponding to the key words; and taking the SELECT as a keyword, recording the name SELECT of the keyword, the 7 th byte of position information of the keyword, the original text B corresponding to the keyword, and generating a keyword list according to the determined name FROM of the keyword, the 0 th byte of position information of the keyword, the original text A corresponding to the keyword, the name SELECT of the keyword, the 7 th byte of position information of the keyword, and the original text B corresponding to the keyword.
It should be noted that, in both the first embodiment and the second embodiment, as long as the keyword cannot be recognized, an error message may be returned and the operation may be terminated.
In addition, since the keywords are to be input into the database for query, that is, the keywords in the keyword list must conform to the syntactic structure of the database, in the embodiment of the present invention, the determining of the query keywords of the data query sentence according to the keyword list corresponding to the data query sentence mentioned in the above two embodiments may specifically be performing syntactic analysis on each keyword in the keyword list corresponding to the data query sentence, and determining whether each keyword conforms to the syntactic structure; and determining the keywords conforming to the grammatical structure as the query keywords of the data query statement.
It should be noted that, for the keywords in the keyword list that do not conform to the syntax structure, an error message may be returned and the operation may be terminated.
S103: and aiming at each database to be queried, generating a retrieval formula corresponding to the database according to the query type of the database and the tree structure data, retrieving the database according to the retrieval formula, and obtaining query data corresponding to the data query statement.
Further, although the query keywords in the tree-structured data all conform to the syntax structure, the retrieval modes of the different types of databases are different, that is, the retrieval modes used by the different types of databases are different, in the embodiment of the present invention, for each database to be queried, the retrieval mode corresponding to the database is generated according to the query type of the database and the tree-structured data, and the database is retrieved according to the retrieval mode to obtain the query data corresponding to the data query statement, so that each type of database can generate the retrieval mode conforming to the query rule of its own database according to the query type of the database and the tree-structured data, thereby querying the data required by the user.
It should be noted that the generated search formula only contains data that can be determined at this stage, and for a part of data that can be determined only when the query is executed, the manner of obtaining these data may be retained, and the phase filling of query execution is waited.
S104: and returning the query data corresponding to the data query statement to the user.
Furthermore, the query data corresponding to the data query statements queried in each database are all returned to the user.
By the method, the searching mode constructed by the structured query language can enable a user to flexibly design complex data query sentences in the text document according to the searching requirement of the user, and the flexibility of the searching mode is greatly improved.
< apparatus embodiment >
As shown in fig. 2, an embodiment of the present invention further provides a data query apparatus 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 generate, for each database to be queried, a search formula corresponding to the database according to the query type of the database and the tree structure data, and search the database according to the search formula to obtain query data corresponding to the data query statement;
and a returning module 204, configured to return the query data corresponding to the data query statement to the user.
The data query statement includes: querying at least one of a name of the data source, a field name displayed, a filter condition, a sort rule, or skipping the initial number of data pieces.
The generating module 202 is specifically configured to perform semantic analysis on the data query statement, and determine a query keyword of the data query statement; and adding the query key words of the data query sentences into a tree structure to generate tree structure data carrying the query key words.
The generating module 202 is further configured to determine and extract a keyword in the data query sentence according to a preset word list, so as to obtain a keyword list corresponding to the data query sentence, where the keyword list includes a name of the keyword, location information of the keyword, and an original text corresponding to the keyword; and determining the query keywords of the data query sentence according to the keyword list corresponding to the data query sentence.
The generating module 202 is further configured to perform word segmentation processing on the data query statement to obtain a word sequence; acquiring words of a specified part of speech in the word sequence; taking the obtained words as keywords to obtain a keyword list corresponding to the data query sentence, wherein the keyword list comprises names of the keywords, position information of the keywords and original texts corresponding to the keywords; and determining the query keywords of the data query sentence according to the keyword list corresponding to the data query sentence.
The generating module 202 is further configured to perform syntax analysis on each keyword in the keyword list corresponding to the data query statement, and determine whether each keyword conforms to a syntax structure; and determining the keywords conforming to the grammatical structure as the query keywords of the data query statement.
And the part of speech of the query keyword is a predicate part of speech.
< apparatus embodiment >
An embodiment of the present invention further provides a data query device based on a structured query language, as shown in fig. 3, where the data query device based on the structured query language includes a data query apparatus based on the structured query language in the above apparatus embodiments.
Alternatively, the structured query language-based data query device includes a memory 301 and a processor 302. Wherein the memory is configured to store executable instructions for controlling the processor to perform the method according to any of the above method embodiments.
< computer storage Medium >
The invention also provides a computer storage medium storing computer instructions which, when executed by a processor, implement a method as in any one of the above method embodiments.
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 embodied therewith for causing a processor to implement various aspects of the present invention.
The computer readable storage medium may be a tangible device that can hold and store the instructions for use by the instruction execution device. The computer readable storage medium may be, for example, but not limited to, an electronic memory device, a magnetic memory device, an optical memory device, an electromagnetic memory device, a semiconductor memory device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a Static Random Access Memory (SRAM), a portable compact disc read-only memory (CD-ROM), a Digital Versatile Disc (DVD), a memory stick, a floppy disk, a mechanical coding device, such as punch cards or in-groove projection structures having instructions stored thereon, and any suitable combination of the foregoing. Computer-readable storage media as used herein is not to be construed as transitory signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through a waveguide or other transmission medium (e.g., optical pulses through a fiber optic cable), or electrical signals transmitted through electrical wires.
The computer-readable program instructions described herein may be downloaded from a computer-readable storage medium to a respective computing/processing device, or to an external computer or external storage device via 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. The network adapter card or network interface in each computing/processing device receives computer-readable program instructions from the network and forwards the computer-readable program instructions for storage in a computer-readable storage medium in the respective computing/processing device.
The computer program instructions for carrying out operations of the present invention may be assembler instructions, Instruction Set Architecture (ISA) instructions, machine-related instructions, microcode, firmware instructions, state setting data, or source or object code written in any combination of one or more programming languages, including an object oriented programming language such as Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming 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. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider). In some embodiments, aspects of the present invention are implemented by personalizing an electronic circuit, such as a programmable logic circuit, a Field Programmable Gate Array (FPGA), or a Programmable Logic Array (PLA), with state information of computer-readable program instructions, which can execute the computer-readable program instructions.
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, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks. These computer-readable program instructions may also be stored in a computer-readable storage medium that can direct a computer, programmable data processing apparatus, and/or other devices to function in a particular manner, such that the computer-readable medium storing the instructions comprises an article of manufacture including instructions which implement the function/act specified in the flowchart and/or block diagram block or blocks.
The computer readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other devices to cause a series of operational steps to be performed on the computer, other programmable apparatus or other devices to produce a computer implemented process such that the instructions which execute on the computer, other programmable apparatus or other devices implement the functions/acts specified in the flowchart and/or block diagram block or blocks.
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 executable instructions for implementing the specified logical function(s). In some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown 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 will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions. It is well known to those skilled in the art that implementation by hardware, by software, and by a combination of software and hardware are equivalent.
Having described embodiments of the present invention, the foregoing description is intended to be exemplary, not exhaustive, and not limited to the embodiments disclosed. Many 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 is chosen in order to best explain the principles of the embodiments, the practical application, or improvements made to the technology 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 a structured query language is characterized by comprising the following steps:
receiving a data query statement input by a user in a text document;
generating tree structure data carrying query keywords according to the data query statement;
aiming at each database to be queried, generating a retrieval formula corresponding to the database according to the query type of the database and the tree structure data, and retrieving the database according to the retrieval formula to obtain query data corresponding to the data query statement;
and returning the query data corresponding to the data query statement to the user.
2. The method of claim 1, wherein the data query statement comprises: querying at least one of a name of the data source, a field name displayed, a filter condition, a sort rule, or skipping the initial number of data pieces.
3. The method of claim 1, wherein generating tree structure data carrying query keywords according to the data query statement comprises:
performing semantic analysis on the data query statement to determine a query keyword of the data query statement;
and adding the query key words of the data query sentences into a tree structure to generate tree structure data carrying the query key words.
4. The method of claim 3, wherein semantically analyzing the data query statement to determine query keywords of the data query statement comprises:
determining and extracting keywords in the data query sentence according to a preset word list to obtain a keyword list corresponding to the data query sentence, wherein the keyword list comprises names of the keywords, position information of the keywords and original texts corresponding to the keywords;
and determining the query keywords of the data query sentence according to the keyword list corresponding to the data query sentence.
5. The method of claim 3, wherein semantically analyzing the data query statement to determine query keywords of the data query statement comprises:
performing word segmentation processing on the data query sentence to obtain a word sequence;
acquiring words of a specified part of speech in the word sequence;
taking the obtained words as keywords to obtain a keyword list corresponding to the data query sentence, wherein the keyword list comprises names of the keywords, position information of the keywords and original texts corresponding to the keywords;
and determining the query keywords of the data query sentence according to the keyword list corresponding to the data query sentence.
6. The method according to claim 4 or 5, wherein determining the query keyword of the data query statement according to the keyword list corresponding to the data query statement comprises:
performing syntactic analysis on each keyword in the keyword list corresponding to the data query statement to determine whether each keyword conforms to a syntactic structure;
and determining the keywords conforming to the grammatical structure as the query keywords of the data query statement.
7. The method of claim 6, wherein the part-of-speech of the query keyword is a predicate part-of-speech.
8. A data query device based on a structured query language, comprising:
the receiving module is used for receiving a data query sentence input by a user in a text document;
the generating module is used for generating tree structure data carrying query keywords according to the data query statement;
the query module is used for generating a retrieval formula corresponding to each database to be queried according to the query type of the database and the tree structure data, retrieving the database according to the retrieval formula and obtaining query data corresponding to the data query statement;
and the return module is used for returning the query data corresponding to the data query statement to the user.
9. A data query device based on a structured query language, comprising the data query device based on the structured query language of claim 8; or,
the apparatus comprises: a processor and a memory;
the memory is to store executable instructions to control the processor to perform the method of any one of claims 1-7.
10. A computer storage medium storing computer instructions which, when executed by a processor, implement the method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111091779.9A CN113868375A (en) | 2021-09-17 | 2021-09-17 | Data query method, device, equipment and storage medium based on structured query language |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111091779.9A CN113868375A (en) | 2021-09-17 | 2021-09-17 | Data query method, device, equipment and storage medium based on structured query language |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113868375A true CN113868375A (en) | 2021-12-31 |
Family
ID=78996426
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111091779.9A Pending CN113868375A (en) | 2021-09-17 | 2021-09-17 | Data query method, device, equipment and storage medium based on structured query language |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113868375A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114547085A (en) * | 2022-03-22 | 2022-05-27 | 中国铁塔股份有限公司 | Data processing method and device, electronic equipment and storage medium |
-
2021
- 2021-09-17 CN CN202111091779.9A patent/CN113868375A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114547085A (en) * | 2022-03-22 | 2022-05-27 | 中国铁塔股份有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN114547085B (en) * | 2022-03-22 | 2023-05-05 | 中国铁塔股份有限公司 | Data processing method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10339924B2 (en) | Processing speech to text queries by optimizing conversion of speech queries to text | |
| US10169471B2 (en) | Generating and executing query language statements from natural language | |
| US10558754B2 (en) | Method and system for automating training of named entity recognition in natural language processing | |
| US9495387B2 (en) | Images for a question answering system | |
| US9020811B2 (en) | Method and system for converting text files searchable text and for processing the searchable text | |
| CN109522341B (en) | Method, device and equipment for realizing SQL-based streaming data processing engine | |
| US10747795B2 (en) | Cognitive retrieve and rank search improvements using natural language for product attributes | |
| CN108388635B (en) | Data searching method, device, medium and computing equipment | |
| US9201761B1 (en) | Debugging data format conversion | |
| US20160364374A1 (en) | Visual indication for images in a question-answering system | |
| US20200012719A1 (en) | Automated entity disambiguation | |
| US10360280B2 (en) | Self-building smart encyclopedia | |
| CN113297251A (en) | Multi-source data retrieval method, device, equipment and storage medium | |
| JPS6175957A (en) | Mechanical translation processor | |
| CN113868375A (en) | Data query method, device, equipment and storage medium based on structured query language | |
| CN108008947B (en) | Intelligent prompting method and device for programming statement, server and storage medium | |
| CN107220249B (en) | Classification-based full-text search | |
| CN108614821B (en) | Geological data interconnection and mutual-checking system | |
| CN111898762B (en) | Deep learning model catalog creation | |
| US20170235719A1 (en) | Evaluating parse trees in linguistic analysis | |
| JP2001101184A (en) | Method and device for generating structurized document and storage medium with structurized document generation program stored therein | |
| CN112650839A (en) | Retrieval information optimization method and device | |
| JP2840258B2 (en) | Method of creating bilingual dictionary and co-occurrence dictionary for machine translation system | |
| KR100963669B1 (en) | Query Language Automatic Input System Using Topic Information And Method Thereof, And Media That Can Record Computer Program Sources For Method Therof | |
| Mukhamedshin et al. | Complex Search Queries in the Corpus Management System |
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 |