CN110928896A - Data query method and device - Google Patents
Data query method and device Download PDFInfo
- Publication number
- CN110928896A CN110928896A CN201811096119.8A CN201811096119A CN110928896A CN 110928896 A CN110928896 A CN 110928896A CN 201811096119 A CN201811096119 A CN 201811096119A CN 110928896 A CN110928896 A CN 110928896A
- Authority
- CN
- China
- Prior art keywords
- syntax
- data query
- query statement
- format
- data
- 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 57
- 230000014509 gene expression Effects 0.000 claims description 35
- 238000004458 analytical method Methods 0.000 claims description 18
- 238000013507 mapping Methods 0.000 claims description 14
- 238000006243 chemical reaction Methods 0.000 claims description 6
- 230000006870 function Effects 0.000 abstract description 19
- 238000010586 diagram Methods 0.000 description 13
- 238000004590 computer program Methods 0.000 description 11
- 230000008569 process Effects 0.000 description 10
- 238000005516 engineering process Methods 0.000 description 4
- 230000011218 segmentation Effects 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 3
- 238000002408 directed self-assembly Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a data query method and a data query device, wherein the method comprises the following steps: after a first data query statement with a first format is obtained, the first data query statement may be converted into a second data query statement, where the second data query statement is in a second format, and the second format is different from the first format, and the second format is a query statement format supported by a query server with a data query function, and then, the second data query statement may be used to request the query server to perform data query. Therefore, the embodiment of the application enables the user to perform data query on the query server by inputting the query sentence with a simple format in a mode of converting the format of the query sentence, so that the learning cost of the user for performing ES query is reduced, and the accuracy of the query sentence is improved.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a data query method and apparatus.
Background
ElastiSearch (ES for short) is a Lucene-based search server that provides a distributed multi-user full-text retrieval and analysis engine, and Restful-based web interface. In actual use, a user may Query and screen data through a structured Query statement (Query DSL) provided by the ES, where the Query statement is in a JavaScript Object Notation (JSON) format.
However, the existing ES query technology has the following three disadvantages:
1. query DSLs provided by ES are not easy to understand, and users often need to spend a lot of time looking up documents to know how to Query data using Query DSLs, resulting in higher learning cost of ES Query;
2. the Query DSL provided by the ES adopts a JSON format, when the Query of multi-condition combination is met, the nesting structure of JSON grammar is very long, the input of a user is inconvenient, and the Query result cannot be obtained due to the fact that the Query is easy to be mistaken frequently under the condition that no grammar prompt exists;
3. the ES version is upgraded very quickly, grammars supported by some old versions can no longer be supported in the new versions, and users need to relearn JSON grammars supported by the new versions, so that learning cost of ES query is further improved.
Disclosure of Invention
The embodiment of the present application mainly aims to provide a data query method and device, which can reduce the learning cost of ES query and improve the input accuracy of query statements.
The embodiment of the application provides a data query method, which comprises the following steps:
acquiring a first data query statement with a first format;
converting the first data query statement into a second data query statement, wherein the format of the second data query statement is a second format, the second format is different from the first format, and the second format is a query statement format supported by a query server with a data query function;
and requesting the query server to perform data query by using the second data query statement.
Optionally, the obtaining a first data query statement having a first format includes:
acquiring each first syntax unit used by the first data query statement input by a user;
and assembling the first syntax units into the first data query statement.
Optionally, the obtaining each first syntax unit used by the first data query statement input by the user includes:
sending an updating request to the query server, wherein the updating request is used for requesting the query server to update grammar unit options provided by a user query interface according to a latest query database;
and acquiring each first syntax unit used by the first data query statement input by a user, wherein the first syntax unit is input by the user through selecting a corresponding syntax unit option on the user query interface.
Optionally, the converting the first data query statement into a second data query statement includes:
parsing the first data query statement to identify a plurality of first syntax units in the first data query statement and a syntactic relationship between the plurality of first syntax units;
and searching a second syntax unit corresponding to each first syntax unit in the first data query statement according to a preset syntax mapping relation table, and generating a second data query statement according to the searched syntax relation between the second syntax unit and the corresponding first syntax unit.
Optionally, the identifying a plurality of first syntax units in the first data query statement and a syntactic relationship between the plurality of first syntax units includes:
performing syntax analysis on the first data query statement to generate an abstract syntax tree, wherein the abstract syntax tree expresses the syntactic relation among all first syntax units in the first data query statement;
and, upon generation of the second data query statement,
sequentially traversing each first syntax unit in the abstract syntax tree according to a preset traversal sequence;
and converting the currently traversed first syntax unit into a second syntax unit in the second format to obtain each second syntax unit used by the second data query statement.
Optionally, after parsing the first data query statement, the method further includes:
judging whether the syntactic format of the first data query statement conforms to a query specification;
if yes, continuing to execute the step of identifying a plurality of first syntax units in the first data query statement and the syntactic relations among the plurality of first syntax units;
and if not, providing a first prompt for the user, wherein the first prompt is used for representing that the first data query statement does not accord with the query specification.
Optionally, the query server is elastissearch, and the second format is JSON format.
Optionally, the first format is a boolean expression.
An embodiment of the present application further provides a data query device, including:
a query statement acquisition unit configured to acquire a first data query statement having a first format;
a query statement conversion unit, configured to convert the first data query statement into a second data query statement, where a format of the second data query statement is a second format, the second format is different from the first format, and the second format is a query statement format supported by a query server having a data query function;
and the data query request unit is used for requesting the query server to perform data query by using the second data query statement.
Optionally, the query statement obtaining unit includes:
a syntax unit obtaining subunit, configured to obtain each first syntax unit used by the first data query statement input by the user;
and the query statement assembling subunit is used for assembling the first grammar units into the first data query statement.
Optionally, the syntax element obtaining sub-unit includes:
the updating request sending subunit is used for sending an updating request to the query server, wherein the updating request is used for requesting the query server to update grammar unit options provided by a user query interface according to a latest query database;
and the first syntax unit acquiring subunit is used for acquiring each first syntax unit used by the first data query statement input by the user, wherein the first syntax unit is input by the user through selecting a corresponding syntax unit option on the user query interface.
Optionally, the query statement conversion unit includes:
a syntax relationship identifying subunit, configured to perform syntax analysis on the first data query statement, and identify a plurality of first syntax units in the first data query statement and syntax relationships among the plurality of first syntax units;
and the query sentence generating subunit is used for searching a second syntax unit corresponding to each first syntax unit in the first data query sentence according to a preset syntax mapping relation table, and generating a second data query sentence according to the searched syntax relation between the second syntax unit and the corresponding first syntax unit.
Optionally, the syntactic relationship identifying subunit includes:
a syntax tree generating subunit, configured to perform syntax analysis on the first data query statement to generate an abstract syntax tree, where the abstract syntax tree expresses a syntax relationship between the first syntax units in the first data query statement;
the syntax tree traversal subunit is used for sequentially traversing each first syntax unit in the abstract syntax tree according to a preset traversal sequence when generating a second data query statement;
and the second syntax unit obtaining subunit is configured to convert the currently traversed first syntax unit into a second syntax unit in the second format, so as to obtain each second syntax unit used by the second data query statement.
Optionally, the apparatus further comprises:
a syntax format judging unit, configured to judge whether a syntax format of the first data query statement conforms to a query specification after the syntax relationship identifying subunit performs syntax analysis on the first data query statement;
a syntax identification continuing unit, configured to trigger the syntax relationship identification subunit to implement the function of identifying multiple first syntax units in the first data query statement and the syntax relationship among the multiple first syntax units if a syntax format of the first data query statement conforms to a query specification;
the first prompt sending unit is used for providing a first prompt for the user if the syntax format of the first data query statement does not conform to the query specification, wherein the first prompt is used for representing that the first data query statement does not conform to the query specification.
Optionally, the query server is elastissearch, and the second format is JSON format.
Optionally, the first format is a boolean expression.
An embodiment of the present application further provides a storage medium, where a program is stored on the storage medium, and when the program is executed by a processor, the program performs any one of the methods described above.
The embodiment of the present application further provides a processor, where the processor is configured to execute a program, where when the program runs, the processor executes the method described in any one of the above.
An apparatus is also provided in an embodiment of the present application, where the apparatus includes a processor, a memory, and a program stored in the memory and executable on the processor, and when the processor executes the program, the processor is caused to perform any one of the methods described above.
Embodiments of the present application further provide a computer program product, which, when executed on a data processing device, causes the data processing device to execute any of the methods described above.
According to the data query method and device provided by the embodiment of the application, after a first data query statement with a first format is obtained, the first data query statement can be converted into a second data query statement, wherein the second data query statement is in a second format, the second format is different from the first format, the second format is a query statement format supported by a query server with a data query function, and then the query server can be requested to perform data query by using the second data query statement. Therefore, the embodiment of the application enables the user to perform data query on the query server by inputting the query sentence with a simple format in a mode of converting the format of the query sentence, so that the learning cost of the user for performing ES query is reduced, and the accuracy of the query sentence is improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
Fig. 1 is a schematic diagram of a framework of an exemplary application scenario provided in an embodiment of the present application;
fig. 2 is a schematic flowchart of a data query method according to an embodiment of the present application;
fig. 3 is a schematic flowchart of acquiring a first data query statement according to an embodiment of the present application;
fig. 4 is an interaction flowchart of an embodiment of a data query method according to an embodiment of the present application;
fig. 5 is a second interaction flowchart of an embodiment of a data query method according to the present application;
FIG. 6 is a flowchart illustrating a process of converting a first data query statement into a second data query statement according to an embodiment of the present application;
FIG. 7 is a diagram illustrating a structure of an abstract syntax tree according to an embodiment of the present application;
fig. 8 is a mapping table diagram of a pool expression lexical unit and an ES query sentence syntax unit provided in the embodiment of the present application;
fig. 9 is a schematic structural diagram of a data query device according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
In order to facilitate understanding of the technical solutions provided by the present application, an application scenario of the present application in practice is described below.
Referring to fig. 1, which is an exemplary view of a scenario of the present application in practical application, as shown in fig. 1, the data query method provided by the present application may be applied to an application scenario including a terminal 101, a server 102, and a query server 103; the terminal 101 is a device capable of installing and operating a browser and a client, such as a smart phone, a tablet computer, a laptop personal computer, a desktop personal computer, a small computer, a medium computer, a large computer, and the like; the server 102 is a service device which can communicate with the terminal 101 and the query server 103, provide data support for the terminal 101, and send a query request to the query server 103, and the server 102 may provide service for one terminal 101 or multiple terminals 101 at the same time; query server 103 may be an example of an existing, developing, or future developed device capable of providing ES data query functionality to server 102.
As shown in fig. 1, a user may input a first data query statement in a first format in a browser of the terminal 101, and then the terminal 101 may transmit the first data query statement to the server 102, the server 102 converts the first data query statement into a second data query statement having a format of a query statement supported by the query server 103, and the server 102 may request the query server 103 to perform a data query using the second data query statement. Those skilled in the art will appreciate that the frame diagram shown in fig. 1 is only one example in which embodiments of the present application may be implemented, and the scope of applicability of embodiments of the present application is not limited in any way by this frame.
Therefore, the method provided by the application converts the query statement in the simple format input by the user into the query statement in the specific format capable of performing data query on the query server 103 in a format conversion mode, so that the user can perform data query on the query server 103 by inputting the query statement in the simple format, the learning cost of performing ES query by the user is reduced, and the accuracy of the query statement is improved.
Based on the above application scenarios, the embodiments of the present application provide a data query method, which will be described in detail below with reference to the accompanying drawings.
Referring to fig. 2, which shows a flowchart of a data query method provided by an embodiment of the present application, an execution subject of each step of the method may be the server 102, as shown in fig. 2, and the method includes:
s201: a first data query statement is obtained having a first format.
In this embodiment, in order to reduce the learning cost of the ES query performed by the user and improve the input accuracy of the query statement, first, a first data query statement having a first format is required to be obtained, where the first data query statement refers to a query statement input by the user to query ES data, and the first format of the query statement refers to a simple statement format convenient for the user to input, and an optional implementation manner is that the first format in this embodiment may be a boolean variable (boolean) expression.
In some possible implementation manners of the present application, step S201 may specifically include step 2011-2012, as shown in fig. 3:
step 2011: and acquiring each first syntax unit used by the first data query statement input by the user.
Specifically, in the process of acquiring the first data query statement with the first format, as shown in fig. 4, a user may send an update request to the server 102 through a data query page of a browser installed on the terminal 101, the server 102 forwards the update request to the query server 103, and the server 102 sends the update request to the query server 103 to request the query server 103 to update the syntax element options provided by the user query interface according to the latest query database, that is, the query server 103 sends the syntax element options required by the user query interface to the server 102 according to the update request sent by the server 102 and the latest query database, so that the syntax element options on the user query interface at the browser end are updated.
The query database may be an ES database, a large number of data indexes for data query may be stored in the ES database, and the query server 103 may be an ElastiSearch connected to the ES database; the syntax element options refer to syntax data that can be selected by a user, and an arrangement format of the syntax element options conforms to a first format, that is, a simple sentence format that is convenient for a user to input, taking a bool expression as an example, the bool expression is composed of a left value, a right value and a bool operator, the syntax element options include respective data that can be selected by the user and constitute the left value, the right value and the bool operator of the bool expression, for example, in the bool expression "a ═ 1and b ═ 2", the bool operator is and, the left value is a ═ 1, and the right value is b ═ 2, and each data can be data selected by the user from the corresponding syntax element options.
Further, as shown in fig. 4, in step 2011, the server 102 may update, according to the syntax unit option provided by the query server 103, drop-down box data of the user query interface at the browser end for the user to input and select, and further may obtain, by the browser, each first syntax unit used by the first data query statement input by the user, where the first syntax unit is input by the user by selecting a corresponding syntax unit option on the user query interface at the browser end, for example, the first syntax unit may be data selected by the user in the drop-down box on the user query interface.
Step 2012: and assembling the first grammar units into a first data query statement.
In this embodiment, after obtaining each first syntax unit used by the first data query statement input by the user through step 2011, each first syntax unit may be assembled into the first data query statement, as shown in fig. 4, in step 2011, after obtaining each first syntax unit used by the first data query statement input by the user through the browser, that is, after obtaining data selected by the user in the drop-down box on the user query interface, the server 102 may assemble the data into the first data query statement according to the first format, for example, the data may be assembled into a corresponding bool expression as a query statement (i.e., the first data query statement) according to the composition format of the bool expression, so as to implement data query through subsequent steps.
It should be noted that, the implementation process of step 2011-2012 can also be completed by the terminal 101, as shown in fig. 5, in step 2011, the user can send an update request to the server 102 through a data query page of the browser installed on the terminal 101, the server 102 forwards the update request to the query server 103, and then the query server 103 sends syntax unit options required by the user query interface to the server 102 according to the update request sent by the server 102 and the latest query database, so that the server 102 forwards the syntax unit options to the browser. Further, the browser end may update the drop-down box data of the user query interface according to the syntax unit options sent by the server 102, so that the user may make an input selection, and further may obtain each first syntax unit used by the first data query statement input by the user, that is, data selected by the user in the drop-down box of the user query interface of the browser.
Correspondingly, in step 2012, after acquiring each first syntax unit used by the first data query statement input by the user, for example, after acquiring data selected by the user in the drop-down box of the user query interface, the browser end may assemble the data into the first data query statement according to the first format, for example, as shown in fig. 5, the data may be assembled into a corresponding bool expression according to the composition format of the bool expression, and the corresponding bool expression is sent to the server 102 as the query statement (i.e., the first data query statement) to implement data query through subsequent steps.
It can be seen that, in this embodiment, the first data query statement having the first format may be assembled by the server 102 or the terminal 101, and specifically, which manner is adopted may be set according to an actual situation, which is not limited in this embodiment of the present application.
S202: and converting the first data query statement into a second data query statement, wherein the format of the second data query statement is a second format, and the second format is different from the first format, and the second format is a query statement format supported by a query server with a data query function.
In this embodiment, after the first data query statement having the first format is obtained in step S201, the first data query statement may be converted into a second data query statement, where the second data query statement refers to a query statement used by the query server 103 to query data in the query database (such as an ES database), and the query statement has the second format, which refers to a query statement format supported by the query server 103 and is a statement format different from the first format. An optional implementation manner is that, in this embodiment, when the query server is an ElastiSearch and the query database is an ES database, the second format may be a JS Object Notation (JSON) format.
In some possible implementations of the present application, the step S202 may specifically include the steps 2021-2022, as shown in fig. 6:
step 2021: and parsing the first data query statement, and identifying a plurality of first syntax units in the first data query statement and a plurality of syntactic relations between the first syntax units.
In this implementation, in order to convert the first data query statement into the second data query statement, the server 102 may first perform syntax analysis on the first data query statement, specifically, may perform segmentation processing on the first data query statement by using a lexical segmentation algorithm to obtain corresponding first syntax units, that is, unit data constituting the first data query statement, and then identify a syntactic relationship between the first syntax units. For example, if the first data query statement is a pool expression composed of pool operators and the Like, then the syntax analysis thereof can identify the pool operators (such as and, or, not and the Like) with lower operation priority contained therein, and the left value, the right value and the corresponding operation symbols (such as ═ and ≈ and < >, Like and in and the Like) with higher operation priority in each expression.
Step 2022: and searching a second syntax unit corresponding to each first syntax unit in the first data query statement according to a preset syntax mapping relation table, and generating a second data query statement according to the searched syntax relation between the second syntax unit and the corresponding first syntax unit.
In this implementation, in order to convert the first data query statement into the second data query statement, in this embodiment, a syntax mapping relationship table is preset, where the table includes a corresponding relationship between the first syntax unit and the second syntax unit, in step 2021, each first syntax unit in the first data query statement is obtained, after the syntax relationship between each first syntax unit is identified, each second syntax unit corresponding to each first syntax unit in the first data query statement can be found by querying the syntax mapping relationship table according to the corresponding relationship between the first syntax unit and the second syntax unit included in the syntax mapping relationship table, then, according to the syntax relationship between the first syntax units, the syntax relationship between the second syntax units corresponding to the first syntax units found is determined, and further, the syntax relationship between the second syntax units and the syntax relationship between the second syntax units can be utilized, a second data query statement is generated.
In some possible implementation manners of the present application, a specific implementation process of step S2021 is: and carrying out syntactic analysis on the first data query statement to generate an abstract syntax tree, wherein the abstract syntax tree expresses the syntactic relation among the first syntax units in the first data query statement.
In this implementation, in order to convert the first data query statement into the second data query statement, the server 102 may first perform syntax analysis on the first data query statement, specifically, may perform segmentation processing on the first data query statement by using a lexical segmentation algorithm, so as to obtain corresponding first syntax units, that is, lexical data forming the first data query statement.
Taking the first data query statement as a bool expression "a ═ 1and b > 2" as an example, the bool expression can be segmented by using a regular expression, and seven syntax units obtained are "a", "═ 1", "and", "b", ">" 2 ".
Further, an abstract syntax tree may be generated according to the obtained first syntax units and the syntactic relations therebetween, that is, the abstract syntax tree expresses the syntactic relations between the first syntax units in the first data query statement. If the abstract syntax tree cannot be generated, it may be that the syntactic relationship between the first syntax units in the first data query statement is not in accordance with the conventional situation, at this time, a prompt that the abstract syntax tree cannot be generated may be provided to the user, and a specific prompt manner may be set according to an actual situation, which is not limited in the embodiment of the present application.
It should be noted that, in the process of generating the abstract syntax tree, the first syntax unit with the lowest operation priority may be used as a root node, and then corresponding nodes of the next hierarchy are sequentially generated from low to high according to the operation priority until the first syntax unit with the highest operation priority is used as a leaf node of the abstract syntax tree. For example, based on the above example, an abstract syntax tree corresponding to the pool expression "a ═ 1and b > 2" may be generated, as shown in fig. 7, which expresses a syntax relationship among seven syntax elements "a", "═ 1", "and", "b", ">," 2 ", in which the pool operator" and "with the lowest operation priority is taken as a root node (i.e., the node on the top level), and then" ═ and ">" with the lower operation priority are taken as nodes on the next level, and "a", "1", "b", and "2" with the highest operation priority are taken as leaf nodes (i.e., the nodes on the bottom level) of the abstract syntax tree.
It should be further noted that, after the abstract syntax tree is generated according to the operation priority level through the above steps, the abstract syntax tree can embody the syntax relationship between the first syntax units in the first data query statement, since the syntax structures between the first syntax units in the first data query statement (e.g. the bool expression) and the second syntax units in the second data query statement (e.g. the ES query statement) are consistent, the first syntax units on the nodes can be correspondingly converted into a specific second syntax unit according to the hierarchical structure of the abstract syntax tree, and the syntax relationship between each second syntax unit is also consistent with the hierarchical relationship embodied by the abstract syntax tree, so that not only can the user input the query statement in a simple format (e.g. the bool expression), but also, the system can also input the query statement in a simple format according to the abstract syntax tree, the input sentences with the simple formats corresponding to each node are more conveniently, simply and accurately converted into corresponding data query sentences (such as ES query sentences), so that the learning cost of ES query by a user is reduced, and the accuracy of the query sentences is improved.
Correspondingly, step S2022 may specifically include steps a-B:
step A: and when the second data query statement is generated, sequentially traversing each first syntax unit in the abstract syntax tree according to a preset traversal order.
In this embodiment, after the abstract syntax tree corresponding to the first data query statement is generated, when the second data query statement is generated, each first syntax unit in the abstract syntax tree may be sequentially traversed according to a preset traversal order. The traversal order may be set according to an actual situation, for example, a depth-first traversal method may be used to sequentially traverse from the root node to each leaf node at the bottom layer. For example, for the abstract syntax tree shown in fig. 7, traversal may be started from the root node "and", then to two expressions of a left value and a right value in the next level, then downward traversal may be performed from the expression corresponding to the left value to the syntax element "═", then downward traversal may be performed to two syntax elements "a" and "1" corresponding to two leaf nodes, and similarly, downward traversal may be performed from the expression corresponding to the right value to the syntax element ">, then downward traversal may be performed to two syntax elements" b "and" 1 "corresponding to two leaf nodes.
And B: and converting the currently traversed first syntax unit into a second syntax unit in a second format to obtain each second syntax unit used by the second data query statement.
In this implementation manner, in the process of sequentially traversing the abstract syntax trees according to the preset traversal order, the currently traversed first syntax unit may be converted into second syntax units in the second format to obtain second syntax units used by the second data query statement, where the second syntax unit option refers to each lexical unit of the second data query statement that may constitute the query ES data, and the formats of the syntax units conform to the second format, for example, the first syntax unit "═ may be converted into" Term "in the ES query statement, that is, the syntax unit in the bool expression may be converted into a JSON format, where a complete mapping table of the boom expression lexical unit and the ES query statement syntax unit may be shown in fig. 8.
In some possible implementations of the present application, after parsing the first data query statement through step S2021, the present embodiment further includes:
judging whether the syntax format of the first data query statement conforms to the query specification, if so, continuing to execute the step of identifying the syntactic relations among the plurality of first syntax units and the plurality of first syntax units in the first data query statement in the step 2021; and if not, providing a first prompt for the user, wherein the first prompt is used for representing that the first data query statement does not accord with the query specification.
In this implementation manner, as shown in fig. 4, after the syntax analysis is performed on the first data query statement in step 2021, it can be determined whether the syntax format of the first data query statement conforms to the query specification, that is, whether each first syntax unit corresponding to the first data query statement conforms to the query specification. For example, based on the above example, it can be determined whether seven syntax units corresponding to the bool expression "a ═ 1and b > 2" are "a", "═ 1", "and", "b", ">," 2 "and meet the query specification, that is, it can be determined whether these syntax units can be translated into syntax units in JSON format in the ES query statement, and it can be determined whether the bool expression composed of these syntax units is a complete expression capable of implementing the query.
If the respective first syntax units corresponding to the first data query statement are determined to meet the query specification, the step of "identifying the syntactic relations between the plurality of first syntax units and the plurality of first syntax units in the first data query statement" in step 2021 may be continuously performed. Correspondingly, if each first syntax unit corresponding to the first data query statement is judged to be not in accordance with the query specification, a first prompt can be provided for the user, wherein the first prompt is used for representing that the first data query statement is not in accordance with the query specification. As shown in fig. 4, when the server 102 determines that the syntax format does not conform to the query specification, the browser may prompt the user that the selected data does not conform to the query specification, and it should be noted that a specific prompting manner may be set according to an actual situation, which is not limited in this embodiment of the present application.
S203: and requesting the query server to perform data query by using the second data query statement.
In this embodiment, after the first data query statement is converted into the second data query statement through step S202, as shown in fig. 4, a data query request may be sent to the query server 103 by using the second data query statement, and after the query server 103 returns the query result to the server 102, the server 102 sends the query result to the browser, so that the query result is displayed to the user at the browser end, and a specific display manner may be selected according to actual situations, which is not limited in this embodiment of the present invention.
As can be seen from the foregoing embodiments, in the data query method provided in this embodiment, after a first data query statement having a first format is obtained, the first data query statement may be converted into a second data query statement, where the second data query statement has a second format, the second format is different from the first format, and the second format is a query statement format supported by a query server having a data query function, and then, the query server may be requested to perform data query by using the second data query statement. Therefore, the embodiment of the application enables the user to perform data query on the query server by inputting the query sentence with a simple format in a mode of converting the format of the query sentence, so that the learning cost of the user for performing ES query is reduced, and the accuracy of the query sentence is improved.
Based on the above data query method, the present application also provides a data query device, as shown in fig. 9, the device includes:
a query statement acquisition unit 901 configured to acquire a first data query statement having a first format;
a query statement converting unit 902, configured to convert the first data query statement into a second data query statement, where a format of the second data query statement is a second format, the second format is different from the first format, and the second format is a query statement format supported by a query server having a data query function;
a data query requesting unit 903, configured to request the query server to perform data query by using the second data query statement.
In some possible implementations of the present application, the query statement obtaining unit 901 includes:
a syntax unit obtaining subunit, configured to obtain each first syntax unit used by the first data query statement input by the user;
and the query statement assembling subunit is used for assembling the first grammar units into the first data query statement.
In some possible implementations of the present application, the syntax element obtaining sub-unit includes:
the updating request sending subunit is used for sending an updating request to the query server, wherein the updating request is used for requesting the query server to update grammar unit options provided by a user query interface according to a latest query database;
and the first syntax unit acquiring subunit is used for acquiring each first syntax unit used by the first data query statement input by the user, wherein the first syntax unit is input by the user through selecting a corresponding syntax unit option on the user query interface.
In some possible implementations of the present application, the query statement conversion unit 902 includes:
a syntax relationship identifying subunit, configured to perform syntax analysis on the first data query statement, and identify a plurality of first syntax units in the first data query statement and syntax relationships among the plurality of first syntax units;
and the query sentence generating subunit is used for searching a second syntax unit corresponding to each first syntax unit in the first data query sentence according to a preset syntax mapping relation table, and generating a second data query sentence according to the searched syntax relation between the second syntax unit and the corresponding first syntax unit.
In some possible implementations of the present application, the syntactic relationship identifying subunit includes:
a syntax tree generating subunit, configured to perform syntax analysis on the first data query statement to generate an abstract syntax tree, where the abstract syntax tree expresses a syntax relationship between the first syntax units in the first data query statement;
the syntax tree traversal subunit is used for sequentially traversing each first syntax unit in the abstract syntax tree according to a preset traversal sequence when generating a second data query statement;
and the second syntax unit obtaining subunit is configured to convert the currently traversed first syntax unit into a second syntax unit in the second format, so as to obtain each second syntax unit used by the second data query statement.
In some possible implementations of the present application, the apparatus further includes:
a syntax format judging unit, configured to judge whether a syntax format of the first data query statement conforms to a query specification after the syntax relationship identifying subunit performs syntax analysis on the first data query statement;
a syntax identification continuing unit, configured to trigger the syntax relationship identification subunit to implement the function of identifying multiple first syntax units in the first data query statement and the syntax relationship among the multiple first syntax units if a syntax format of the first data query statement conforms to a query specification;
the first prompt sending unit is used for providing a first prompt for the user if the syntax format of the first data query statement does not conform to the query specification, wherein the first prompt is used for representing that the first data query statement does not conform to the query specification.
In some possible implementations of the present application, the query server is an ElastiSearch, and the second format is a JSON format.
In some possible implementations of the present application, the first format is a boolean expression.
As can be seen from the foregoing embodiments, in the data query device provided in this embodiment, after a first data query statement having a first format is obtained, the first data query statement may be converted into a second data query statement, where the second data query statement has a second format, the second format is different from the first format, and the second format is a query statement format supported by a query server having a data query function, and then, the query server may be requested to perform data query by using the second data query statement. Therefore, the embodiment of the application enables the user to perform data query on the query server by inputting the query sentence with a simple format in a mode of converting the format of the query sentence, so that the learning cost of the user for performing ES query is reduced, and the accuracy of the query sentence is improved.
The data query device comprises a processor and a memory, wherein the query statement acquisition unit, the query statement conversion unit, the data query request unit and the like are stored in the memory as program units, and the processor executes the program units stored in the memory to realize corresponding functions.
The processor comprises a kernel, and the kernel calls the corresponding program unit from the memory. The kernel can be set to be one or more, data query is carried out by adjusting kernel parameters, the learning cost of ES query can be reduced, and the input accuracy of query sentences is improved.
The memory may include volatile memory in a computer readable medium, Random Access Memory (RAM) and/or nonvolatile memory such as Read Only Memory (ROM) or flash memory (flash RAM), and the memory includes at least one memory chip.
An embodiment of the present invention further provides a storage medium, on which a program is stored, where the program, when executed by a processor, implements the following steps:
acquiring a first data query statement with a first format;
converting the first data query statement into a second data query statement, wherein the format of the second data query statement is a second format, the second format is different from the first format, and the second format is a query statement format supported by a query server with a data query function;
and requesting the query server to perform data query by using the second data query statement.
In one implementation manner of this embodiment, the program further implements the following steps when executed by the processor:
acquiring each first syntax unit used by the first data query statement input by a user;
and assembling the first syntax units into the first data query statement.
In one implementation manner of this embodiment, the program further implements the following steps when executed by the processor:
sending an updating request to the query server, wherein the updating request is used for requesting the query server to update grammar unit options provided by a user query interface according to a latest query database;
and acquiring each first syntax unit used by the first data query statement input by a user, wherein the first syntax unit is input by the user through selecting a corresponding syntax unit option on the user query interface.
In one implementation manner of this embodiment, the program further implements the following steps when executed by the processor:
parsing the first data query statement to identify a plurality of first syntax units in the first data query statement and a syntactic relationship between the plurality of first syntax units;
and searching a second syntax unit corresponding to each first syntax unit in the first data query statement according to a preset syntax mapping relation table, and generating a second data query statement according to the searched syntax relation between the second syntax unit and the corresponding first syntax unit.
In one implementation manner of this embodiment, the program further implements the following steps when executed by the processor:
performing syntax analysis on the first data query statement to generate an abstract syntax tree, wherein the abstract syntax tree expresses the syntactic relation among all first syntax units in the first data query statement;
and, upon generation of the second data query statement,
sequentially traversing each first syntax unit in the abstract syntax tree according to a preset traversal sequence;
and converting the currently traversed first syntax unit into a second syntax unit in the second format to obtain each second syntax unit used by the second data query statement.
In one implementation manner of this embodiment, the program further implements the following steps when executed by the processor:
judging whether the syntactic format of the first data query statement conforms to a query specification;
if yes, continuing to execute the step of identifying a plurality of first syntax units in the first data query statement and the syntactic relations among the plurality of first syntax units;
and if not, providing a first prompt for the user, wherein the first prompt is used for representing that the first data query statement does not accord with the query specification.
In an implementation manner of this embodiment, the query server is an ElastiSearch, and the second format is a JSON format.
In an implementation manner of this embodiment, the first format is a boolean expression.
The embodiment of the invention also provides a processor, which is used for running the program, wherein the program executes the following steps when running:
acquiring a first data query statement with a first format;
converting the first data query statement into a second data query statement, wherein the format of the second data query statement is a second format, the second format is different from the first format, and the second format is a query statement format supported by a query server with a data query function;
and requesting the query server to perform data query by using the second data query statement.
In one implementation manner of this embodiment, the program further implements the following steps when executed by the processor:
acquiring each first syntax unit used by the first data query statement input by a user;
and assembling the first syntax units into the first data query statement.
In one implementation manner of this embodiment, the program further implements the following steps when executed by the processor:
sending an updating request to the query server, wherein the updating request is used for requesting the query server to update grammar unit options provided by a user query interface according to a latest query database;
and acquiring each first syntax unit used by the first data query statement input by a user, wherein the first syntax unit is input by the user through selecting a corresponding syntax unit option on the user query interface.
In one implementation manner of this embodiment, the program further implements the following steps when executed by the processor:
parsing the first data query statement to identify a plurality of first syntax units in the first data query statement and a syntactic relationship between the plurality of first syntax units;
and searching a second syntax unit corresponding to each first syntax unit in the first data query statement according to a preset syntax mapping relation table, and generating a second data query statement according to the searched syntax relation between the second syntax unit and the corresponding first syntax unit.
In one implementation manner of this embodiment, the program further implements the following steps when executed by the processor:
performing syntax analysis on the first data query statement to generate an abstract syntax tree, wherein the abstract syntax tree expresses the syntactic relation among all first syntax units in the first data query statement;
and, upon generation of the second data query statement,
sequentially traversing each first syntax unit in the abstract syntax tree according to a preset traversal sequence;
and converting the currently traversed first syntax unit into a second syntax unit in the second format to obtain each second syntax unit used by the second data query statement.
In one implementation manner of this embodiment, the program further implements the following steps when executed by the processor:
judging whether the syntactic format of the first data query statement conforms to a query specification;
if yes, continuing to execute the step of identifying a plurality of first syntax units in the first data query statement and the syntactic relations among the plurality of first syntax units;
and if not, providing a first prompt for the user, wherein the first prompt is used for representing that the first data query statement does not accord with the query specification.
In an implementation manner of this embodiment, the query server is an ElastiSearch, and the second format is a JSON format.
In an implementation manner of this embodiment, the first format is a boolean expression.
The embodiment of the invention also provides equipment, which comprises a processor, a memory and a program which is stored on the memory and can be operated on the processor, wherein the processor executes the program and realizes the following steps:
acquiring a first data query statement with a first format;
converting the first data query statement into a second data query statement, wherein the format of the second data query statement is a second format, the second format is different from the first format, and the second format is a query statement format supported by a query server with a data query function;
and requesting the query server to perform data query by using the second data query statement.
In an implementation manner of this embodiment, the processor executes the program to further implement the following steps:
acquiring each first syntax unit used by the first data query statement input by a user;
and assembling the first syntax units into the first data query statement.
In an implementation manner of this embodiment, the processor executes the program to further implement the following steps:
sending an updating request to the query server, wherein the updating request is used for requesting the query server to update grammar unit options provided by a user query interface according to a latest query database;
and acquiring each first syntax unit used by the first data query statement input by a user, wherein the first syntax unit is input by the user through selecting a corresponding syntax unit option on the user query interface.
In an implementation manner of this embodiment, the processor executes the program to further implement the following steps:
parsing the first data query statement to identify a plurality of first syntax units in the first data query statement and a syntactic relationship between the plurality of first syntax units;
and searching a second syntax unit corresponding to each first syntax unit in the first data query statement according to a preset syntax mapping relation table, and generating a second data query statement according to the searched syntax relation between the second syntax unit and the corresponding first syntax unit.
In an implementation manner of this embodiment, the processor executes the program to further implement the following steps:
performing syntax analysis on the first data query statement to generate an abstract syntax tree, wherein the abstract syntax tree expresses the syntactic relation among all first syntax units in the first data query statement;
and, upon generation of the second data query statement,
sequentially traversing each first syntax unit in the abstract syntax tree according to a preset traversal sequence;
and converting the currently traversed first syntax unit into a second syntax unit in the second format to obtain each second syntax unit used by the second data query statement.
In an implementation manner of this embodiment, the processor executes the program to further implement the following steps:
judging whether the syntactic format of the first data query statement conforms to a query specification;
if yes, continuing to execute the step of identifying a plurality of first syntax units in the first data query statement and the syntactic relations among the plurality of first syntax units;
and if not, providing a first prompt for the user, wherein the first prompt is used for representing that the first data query statement does not accord with the query specification.
In an implementation manner of this embodiment, the query server is an ElastiSearch, and the second format is a JSON format.
In an implementation manner of this embodiment, the first format is a boolean expression.
The device in the application can be a server, a PC, a PAD, a mobile phone and the like.
The present application also provides a computer program product which, when executed on a data processing apparatus, causes the data processing apparatus to execute a program of method steps:
acquiring a first data query statement with a first format;
converting the first data query statement into a second data query statement, wherein the format of the second data query statement is a second format, the second format is different from the first format, and the second format is a query statement format supported by a query server with a data query function;
and requesting the query server to perform data query by using the second data query statement.
In one implementation of this embodiment, the program is further caused to cause a data processing apparatus to perform the method steps of:
acquiring each first syntax unit used by the first data query statement input by a user;
and assembling the first syntax units into the first data query statement.
In one implementation of this embodiment, the program is further caused to cause a data processing apparatus to perform the method steps of:
sending an updating request to the query server, wherein the updating request is used for requesting the query server to update grammar unit options provided by a user query interface according to a latest query database;
and acquiring each first syntax unit used by the first data query statement input by a user, wherein the first syntax unit is input by the user through selecting a corresponding syntax unit option on the user query interface.
In one implementation of this embodiment, the program is further caused to cause a data processing apparatus to perform the method steps of:
parsing the first data query statement to identify a plurality of first syntax units in the first data query statement and a syntactic relationship between the plurality of first syntax units;
and searching a second syntax unit corresponding to each first syntax unit in the first data query statement according to a preset syntax mapping relation table, and generating a second data query statement according to the searched syntax relation between the second syntax unit and the corresponding first syntax unit.
In one implementation of this embodiment, the program is further caused to cause a data processing apparatus to perform the method steps of:
performing syntax analysis on the first data query statement to generate an abstract syntax tree, wherein the abstract syntax tree expresses the syntactic relation among all first syntax units in the first data query statement;
and, upon generation of the second data query statement,
sequentially traversing each first syntax unit in the abstract syntax tree according to a preset traversal sequence;
and converting the currently traversed first syntax unit into a second syntax unit in the second format to obtain each second syntax unit used by the second data query statement.
In one implementation of this embodiment, the program is further caused to cause a data processing apparatus to perform the method steps of:
judging whether the syntactic format of the first data query statement conforms to a query specification;
if yes, continuing to execute the step of identifying a plurality of first syntax units in the first data query statement and the syntactic relations among the plurality of first syntax units;
and if not, providing a first prompt for the user, wherein the first prompt is used for representing that the first data query statement does not accord with the query specification.
In an implementation manner of this embodiment, the query server is an ElastiSearch, and the second format is a JSON format.
In an implementation manner of this embodiment, the first format is a boolean expression.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, 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 specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). The memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in the process, method, article, or apparatus that comprises the element.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The above are merely examples of the present application and are not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A method for querying data, comprising:
acquiring a first data query statement with a first format;
converting the first data query statement into a second data query statement, wherein the format of the second data query statement is a second format, the second format is different from the first format, and the second format is a query statement format supported by a query server with a data query function;
and requesting the query server to perform data query by using the second data query statement.
2. The method of claim 1, wherein obtaining the first data query statement having the first format comprises:
acquiring each first syntax unit used by the first data query statement input by a user;
and assembling the first syntax units into the first data query statement.
3. The method of claim 2, wherein the obtaining each first syntax element used by the first data query statement input by the user comprises:
sending an updating request to the query server, wherein the updating request is used for requesting the query server to update grammar unit options provided by a user query interface according to a latest query database;
and acquiring each first syntax unit used by the first data query statement input by a user, wherein the first syntax unit is input by the user through selecting a corresponding syntax unit option on the user query interface.
4. The method of claim 1, wherein converting the first data query statement into a second data query statement comprises:
parsing the first data query statement to identify a plurality of first syntax units in the first data query statement and a syntactic relationship between the plurality of first syntax units;
and searching a second syntax unit corresponding to each first syntax unit in the first data query statement according to a preset syntax mapping relation table, and generating a second data query statement according to the searched syntax relation between the second syntax unit and the corresponding first syntax unit.
5. The method of claim 4, wherein identifying the plurality of first syntax elements in the first data query statement and the syntactic relationship between the plurality of first syntax elements comprises:
performing syntax analysis on the first data query statement to generate an abstract syntax tree, wherein the abstract syntax tree expresses the syntactic relation among all first syntax units in the first data query statement;
when the second data query statement is generated, sequentially traversing each first syntax unit in the abstract syntax tree according to a preset traversal order;
and converting the currently traversed first syntax unit into a second syntax unit in the second format to obtain each second syntax unit used by the second data query statement.
6. The method of claim 4, wherein after parsing the first data query statement, further comprising:
judging whether the syntactic format of the first data query statement conforms to a query specification;
if yes, continuing to execute the step of identifying a plurality of first syntax units in the first data query statement and the syntactic relations among the plurality of first syntax units;
and if not, providing a first prompt for the user, wherein the first prompt is used for representing that the first data query statement does not accord with the query specification.
7. The method according to any one of claims 1 to 6, wherein the query server is ElastiSearch, and the second format is JSON format;
the first format is a boolean expression.
8. A data query apparatus, comprising:
a query statement acquisition unit configured to acquire a first data query statement having a first format;
a query statement conversion unit, configured to convert the first data query statement into a second data query statement, where a format of the second data query statement is a second format, the second format is different from the first format, and the second format is a query statement format supported by a query server having a data query function;
and the data query request unit is used for requesting the query server to perform data query by using the second data query statement.
9. A storage medium, characterized in that the storage medium has stored thereon a program which, when executed by a processor, performs the method of any one of claims 1-7.
10. A processor, configured to execute a program, wherein the program when executed performs the method of any one of claims 1 to 7.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811096119.8A CN110928896A (en) | 2018-09-19 | 2018-09-19 | Data query method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811096119.8A CN110928896A (en) | 2018-09-19 | 2018-09-19 | Data query method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110928896A true CN110928896A (en) | 2020-03-27 |
Family
ID=69855213
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811096119.8A Pending CN110928896A (en) | 2018-09-19 | 2018-09-19 | Data query method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110928896A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112965999A (en) * | 2021-03-12 | 2021-06-15 | 上海益世界信息技术集团有限公司广州分公司 | Data query method and related device |
CN113626470A (en) * | 2021-08-09 | 2021-11-09 | 杭州安恒信息技术股份有限公司 | ElasticSearch query method, device, equipment and readable storage medium |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107423342A (en) * | 2017-05-10 | 2017-12-01 | 北京数码大方科技股份有限公司 | Page data querying method and device |
CN107798038A (en) * | 2017-05-05 | 2018-03-13 | 平安科技(深圳)有限公司 | Data response method and data response apparatus |
CN108491470A (en) * | 2018-03-07 | 2018-09-04 | 北京奇安信科技有限公司 | For the management method, server-side and management method of search server |
-
2018
- 2018-09-19 CN CN201811096119.8A patent/CN110928896A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107798038A (en) * | 2017-05-05 | 2018-03-13 | 平安科技(深圳)有限公司 | Data response method and data response apparatus |
CN107423342A (en) * | 2017-05-10 | 2017-12-01 | 北京数码大方科技股份有限公司 | Page data querying method and device |
CN108491470A (en) * | 2018-03-07 | 2018-09-04 | 北京奇安信科技有限公司 | For the management method, server-side and management method of search server |
Non-Patent Citations (1)
Title |
---|
铭毅天下: "DSL的诞生|复杂sql转成Elasticsearch DSL深入详解", 《HTTPS://BLOG.CSDN.NET/LAOYANG360/ARTICLE/DETAILS/78556221》 * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112965999A (en) * | 2021-03-12 | 2021-06-15 | 上海益世界信息技术集团有限公司广州分公司 | Data query method and related device |
CN113626470A (en) * | 2021-08-09 | 2021-11-09 | 杭州安恒信息技术股份有限公司 | ElasticSearch query method, device, equipment and readable storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107038207B (en) | Data query method, data processing method and device | |
US10839011B2 (en) | Application programing interface document generator | |
US10169471B2 (en) | Generating and executing query language statements from natural language | |
US11023500B2 (en) | Systems and methods for code parsing and lineage detection | |
CN108304201B (en) | Object updating method, device and equipment | |
US10303689B2 (en) | Answering natural language table queries through semantic table representation | |
US20210279115A1 (en) | Automated api code generation | |
US10901804B2 (en) | Apparatus and method to select services for executing a user program based on a code pattern included therein | |
US10521201B2 (en) | Information processing apparatus and method | |
CN106951231B (en) | Computer software development method and device | |
CN110554875B (en) | Code conversion method and device, electronic equipment and storage medium | |
US11537448B1 (en) | Adapting application programming interfaces with schema mappings | |
US11971916B2 (en) | Conversion of tabular format data to machine readable text for QA operations | |
US11113034B2 (en) | Smart programming assistant | |
CN111818175A (en) | Enterprise service bus configuration file generation method, device, equipment and storage medium | |
US20230185639A1 (en) | Mapping application programming interface schemas with semantic representations | |
CN110928896A (en) | Data query method and device | |
CN108932225B (en) | Method and system for converting natural language requirements into semantic modeling language statements | |
US10223086B2 (en) | Systems and methods for code parsing and lineage detection | |
US10922106B2 (en) | Systems and methods for providing globalization features in a service management application interface | |
CN117111902B (en) | AI intelligent software development method and device | |
JP2014211729A (en) | Computer, program, and data generation method | |
CN108108429B (en) | Data storage method and device of terminal equipment, storage medium and computer equipment | |
CN116303574A (en) | Database operation statement optimization and database operation method, equipment and medium | |
Androcec et al. | Interoperability of Machine Learning Services: A Use Case |
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 | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200327 |