CN114297535A - Page display method, device and equipment for query conditions and storage medium - Google Patents

Page display method, device and equipment for query conditions and storage medium Download PDF

Info

Publication number
CN114297535A
CN114297535A CN202111555569.0A CN202111555569A CN114297535A CN 114297535 A CN114297535 A CN 114297535A CN 202111555569 A CN202111555569 A CN 202111555569A CN 114297535 A CN114297535 A CN 114297535A
Authority
CN
China
Prior art keywords
query
condition
target
field
page
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
Application number
CN202111555569.0A
Other languages
Chinese (zh)
Inventor
秦增福
杨周龙
徐童
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Dongpu Software Co Ltd
Original Assignee
Dongpu Software Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Dongpu Software Co Ltd filed Critical Dongpu Software Co Ltd
Priority to CN202111555569.0A priority Critical patent/CN114297535A/en
Publication of CN114297535A publication Critical patent/CN114297535A/en
Pending legal-status Critical Current

Links

Images

Abstract

The invention relates to the field of artificial intelligence, and discloses a page display method, a page display device, a page display equipment and a page display storage medium for query conditions, which are used for accurately displaying the query conditions and improving the efficiency of data query. The method comprises the following steps: analyzing the preset query page to obtain corresponding field identification and acquiring at least two field type information from a preset database through the field identification; performing condition generation according to at least two field type information to obtain at least two query conditions; receiving a query condition display request sent by a terminal, responding to the query condition display request, and determining a corresponding condition screening algorithm and a target field; screening at least two query conditions according to the target field and a condition screening algorithm to obtain corresponding screening results, and generating corresponding condition display components according to the screening results; rendering the condition display assembly to obtain a corresponding query condition display page and displaying the query condition display page.

Description

Page display method, device and equipment for query conditions and storage medium
Technical Field
The invention relates to the field of artificial intelligence, in particular to a method, a device, equipment and a storage medium for displaying a page of a query condition.
Background
With the continuous development of the internet, in the daily work, internet staff need real-time service statistical information in order to know the service development situation, and often need to obtain the data needed by the internet staff from a large amount of data for service processing or analysis and the like.
However, if the rough situation of the mass data to be queried is not known, it is likely that the appropriate query condition cannot be configured, so that multiple attempts are needed to obtain the required data, thereby wasting time and energy of the user and consuming a large amount of query resources. At present, a fuzzy query mode is usually adopted, the mode usually needs to carry out multiple queries to find a needed target, query conditions cannot be set according to query requirements for query, the space occupied after the query conditions are expanded is too large, and the conditions cannot be subjected to range processing. The query work is very complicated and the workload is huge, resulting in low query efficiency.
Disclosure of Invention
The embodiment of the invention provides a page display method, a page display device, a page display equipment and a storage medium for query conditions, which are used for accurately displaying the query conditions and improving the efficiency of data query.
The invention provides a page display method of query conditions in a first aspect, which comprises the following steps: analyzing a preset query page to obtain corresponding field identification and acquiring at least two field type information from a preset database through the field identification; performing condition generation according to the at least two field type information to obtain at least two query conditions, wherein the query conditions comprise a plurality of query terms, and each query term corresponds to each preset field expression one by one; receiving a query condition display request sent by a terminal, responding to the query condition display request, and determining a corresponding condition screening algorithm and a target field; screening the at least two query conditions according to the target field and the condition screening algorithm to obtain corresponding screening results, and generating corresponding condition display components according to the screening results; rendering the condition display assembly to obtain a corresponding query condition display page and displaying the query condition display page.
Optionally, in a first implementation manner of the first aspect of the present invention, the performing condition generation according to the at least two field type information to obtain at least two query conditions, where the query conditions include a plurality of query terms, and a one-to-one correspondence between each query term and each preset field expression includes: acquiring attribute information corresponding to each field type information, and performing query item matching on the attribute information corresponding to each field type information through a preset reflection mechanism to obtain a plurality of corresponding query items; and generating query conditions through the corresponding query terms to obtain at least two query conditions.
Optionally, in a second implementation manner of the first aspect of the present invention, the screening the at least two query conditions according to the target field and the condition screening algorithm to obtain corresponding screening results, and generating the corresponding condition display component according to the screening results includes: based on the target field, performing field similarity calculation on the at least two query conditions through the condition screening algorithm to obtain the similarity corresponding to each query condition; sorting according to the similarity corresponding to each query condition to obtain a corresponding sorting list, determining M query conditions ranked in the front row according to the sorting list and using the M query conditions as the screening result, wherein M is a positive integer greater than or equal to 5; and generating components according to the screening result to obtain corresponding condition display components.
Optionally, in a third implementation manner of the first aspect of the present invention, the rendering the condition displaying component to obtain a corresponding query condition displaying page and displaying the query condition displaying page includes: determining a target component template corresponding to the condition display component from a plurality of pre-packaged preset component templates; acquiring attribute information of the condition display component, inputting the attribute information into the target component template for rendering, and acquiring a rendering result of the condition display component; and displaying the rendering result in the page to obtain a corresponding query condition display page and displaying the query condition display page.
Optionally, in a fourth implementation manner of the first aspect of the present invention, after the rendering the condition showing component to obtain a corresponding query condition showing page and show the query condition showing page, the method further includes: receiving a query request sent by a terminal and analyzing the query request to obtain corresponding target field type information; performing query condition matching on the target field type information to obtain a corresponding target query condition; determining a data query type corresponding to the target query condition according to the target query condition; analyzing the target query condition through an analysis rule corresponding to the data query type to obtain a query statement corresponding to the target query condition; and executing the query statement to obtain a data query result corresponding to the target query condition.
Optionally, in a fifth implementation manner of the first aspect of the present invention, the analyzing the target query condition according to an analysis rule corresponding to the data query type, and obtaining the query statement corresponding to the target query condition includes: if the data query type is conjunction query, scanning the target query condition, determining a plurality of corresponding candidate query terms, and acquiring a query statement corresponding to the target query condition according to a target field expression corresponding to each candidate query term; and if the data query type is complex query, analyzing the target query condition through a preset template engine to generate a query statement corresponding to the target query condition.
Optionally, in a sixth implementation manner of the first aspect of the present invention, the scanning the target query condition, determining a plurality of corresponding candidate query terms, and obtaining a query statement corresponding to the target query condition according to a target field expression corresponding to each candidate query term includes: analyzing a target field expression corresponding to each candidate query item to obtain a field and an operator contained in each candidate query item; determining a field value corresponding to each candidate query item based on a corresponding relation between an operator and preset query syntax, and generating a query statement according to the field, the operator and the field value corresponding to each candidate query item to obtain the query statement corresponding to each candidate query item; and combining the query sentences corresponding to the candidate query terms to obtain the query sentences corresponding to the target query conditions.
The second aspect of the present invention provides a page display apparatus for query conditions, including: the analysis module is used for analyzing the preset query page to obtain a corresponding field identifier and acquiring at least two pieces of field type information from a preset database through the field identifier; the generating module is used for performing condition generation according to the at least two field type information to obtain at least two query conditions, wherein the query conditions comprise a plurality of query terms, and each query term corresponds to each preset field expression one by one; the response module is used for receiving a query condition display request sent by the terminal, responding to the query condition display request and determining a corresponding condition screening algorithm and a target field; the screening module is used for screening the at least two query conditions according to the target field and the condition screening algorithm to obtain corresponding screening results, and generating corresponding condition display components according to the screening results; and the rendering module is used for rendering the condition display assembly to obtain a corresponding query condition display page and displaying the query condition display page.
Optionally, in a first implementation manner of the second aspect of the present invention, the generating module is specifically configured to: acquiring attribute information corresponding to each field type information, and performing query item matching on the attribute information corresponding to each field type information through a preset reflection mechanism to obtain a plurality of corresponding query items; and generating query conditions through the corresponding query terms to obtain at least two query conditions.
Optionally, in a second implementation manner of the second aspect of the present invention, the screening module is specifically configured to: based on the target field, performing field similarity calculation on the at least two query conditions through the condition screening algorithm to obtain the similarity corresponding to each query condition; sorting according to the similarity corresponding to each query condition to obtain a corresponding sorting list, determining M query conditions ranked in the front row according to the sorting list and using the M query conditions as the screening result, wherein M is a positive integer greater than or equal to 5; and generating components according to the screening result to obtain corresponding condition display components.
Optionally, in a third implementation manner of the second aspect of the present invention, the rendering module is specifically configured to: determining a target component template corresponding to the condition display component from a plurality of pre-packaged preset component templates; acquiring attribute information of the condition display component, inputting the attribute information into the target component template for rendering, and acquiring a rendering result of the condition display component; and displaying the rendering result in the page to obtain a corresponding query condition display page and displaying the query condition display page.
Optionally, in a fourth implementation manner of the second aspect of the present invention, the page displaying apparatus for query conditions further includes: the receiving module is used for receiving the query request sent by the terminal and analyzing the query request to obtain corresponding target field type information; the matching module is used for matching the query conditions of the target field type information to obtain corresponding target query conditions; the determining module is used for determining a data query type corresponding to the target query condition according to the target query condition; the acquisition module is used for analyzing the target query condition through an analysis rule corresponding to the data query type to acquire a query statement corresponding to the target query condition; and the execution module is used for executing the query statement to obtain a data query result corresponding to the target query condition.
Optionally, in a fifth implementation manner of the second aspect of the present invention, the obtaining module specifically includes: the scanning unit is used for scanning the target query condition if the data query type is conjunction query, determining a plurality of corresponding candidate query items, and acquiring a query statement corresponding to the target query condition according to a target field expression corresponding to each candidate query item; and the analysis unit is used for analyzing the target query condition through a preset template engine if the data query type is complex query, and generating a query statement corresponding to the target query condition.
Optionally, in a sixth implementation manner of the second aspect of the present invention, the scan unit is specifically configured to: analyzing a target field expression corresponding to each candidate query item to obtain a field and an operator contained in each candidate query item; determining a field value corresponding to each candidate query item based on a corresponding relation between an operator and preset query syntax, and generating a query statement according to the field, the operator and the field value corresponding to each candidate query item to obtain the query statement corresponding to each candidate query item; and combining the query sentences corresponding to the candidate query terms to obtain the query sentences corresponding to the target query conditions.
A third aspect of the present invention provides a computer apparatus comprising: a memory and at least one processor, the memory having instructions stored therein; the at least one processor invokes the instructions in the memory to cause the computer device to execute the page display method of the query condition described above.
A fourth aspect of the present invention provides a computer-readable storage medium having stored therein instructions, which, when run on a computer, cause the computer to execute the above-mentioned page presentation method of the query condition.
In the technical scheme provided by the invention, a preset query page is analyzed to obtain corresponding field identification, and at least two pieces of field type information are obtained from a preset database through the field identification; performing condition generation according to the at least two field type information to obtain at least two query conditions, wherein the query conditions comprise a plurality of query terms, and each query term corresponds to each preset field expression one by one; receiving a query condition display request sent by a terminal, responding to the query condition display request, and determining a corresponding condition screening algorithm and a target field; screening the at least two query conditions according to the target field and the condition screening algorithm to obtain corresponding screening results, and generating corresponding condition display components according to the screening results; rendering the condition display assembly to obtain a corresponding query condition display page and displaying the query condition display page.
In the embodiment of the invention, the screening mode can be a mode of selecting the query conditions, namely screening the query conditions of the demand to screen the unselected query conditions, or a mode of excluding and selecting the query conditions by a condition screening algorithm, the selected query conditions are taken as exclusion items to screen the unselected query conditions, and the server adopts a mode of screening the query conditions by the condition screening algorithm, so that the user can conveniently configure the query conditions, and the query times are effectively reduced. And the condition display component is generated according to the screening result so as to be convenient for rendering the condition display component in a page subsequently and displaying the condition display component in a search interface for a user to inquire, when a subsequent user inquires, the corresponding inquiry work can be automatically completed only by selecting required inquiry conditions in the condition display component, the inquiry conditions in a search area can be self-defined according to the self requirements, the interference of unnecessary inquiry conditions in the search area is reduced, and the search efficiency is greatly improved.
Drawings
FIG. 1 is a diagram of an embodiment of a page display method of a query condition according to an embodiment of the present invention;
FIG. 2 is a diagram of another embodiment of a page display method of a query condition according to an embodiment of the present invention;
FIG. 3 is a diagram of an embodiment of a page displaying apparatus for query conditions according to an embodiment of the present invention;
FIG. 4 is a diagram of another embodiment of a page displaying apparatus for query conditions according to an embodiment of the present invention;
FIG. 5 is a diagram of an embodiment of a computer device in an embodiment of the invention.
Detailed Description
The embodiment of the invention provides a page display method, device and equipment of query conditions and a storage medium, which are used for improving the efficiency of account transfer information identification.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims, as well as in the drawings, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that the embodiments described herein may be practiced otherwise than as specifically illustrated or described herein. Furthermore, the terms "comprises," "comprising," or "having," and any variations thereof, are intended to cover non-exclusive inclusions, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
The embodiment of the application can acquire and process related data based on an artificial intelligence technology. Among them, Artificial Intelligence (AI) is a theory, method, technique and application system that simulates, extends and expands human Intelligence using a digital computer or a machine controlled by a digital computer, senses the environment, acquires knowledge and uses the knowledge to obtain the best result. The artificial intelligence infrastructure generally includes technologies such as sensors, dedicated artificial intelligence chips, cloud computing, distributed storage, big data processing technologies, operation/interaction systems, mechatronics, and the like. The artificial intelligence software technology mainly comprises a computer vision technology, a robot technology, a biological recognition technology, a voice processing technology, a natural language processing technology, machine learning/deep learning and the like.
For convenience of understanding, a detailed flow of the embodiment of the present invention is described below, and referring to fig. 1, an embodiment of a page display method of a query condition in the embodiment of the present invention includes:
101. analyzing the preset query page to obtain corresponding field identification and acquiring at least two field type information from a preset database through the field identification;
it is understood that the execution subject of the present invention may be a page display apparatus of a query condition, or may be a server, and is not limited herein. The embodiment of the present invention is described by taking a server as an execution subject.
It should be noted that the field type information may be preset in the database, or may be obtained by loading the field type information into the database from a local storage or a cloud server. The field type information may be stored in the database in a manner of being according to each field type information and various types of field data contained therein, each field type information includes attribute information corresponding thereto, for example, the field type information may include information such as a logistics manner, a state, a logistics dynamic creation date, and logistics initial information. The field data included in the creation date is a specific creation date in days. For example, 2018-5-24, 2009-4-13, and the like, specifically, the server parses the preset query page, determines a field identifier corresponding to the preset query page, and obtains at least two pieces of field type information from a preset database according to the field identifier. It is emphasized that, in order to further ensure the privacy and security of the cluster identifier information, the field type information may also be stored in a node of a block chain.
102. Performing condition generation according to at least two field type information to obtain at least two query conditions, wherein the query conditions comprise a plurality of query terms, and each query term corresponds to each preset field expression one to one;
specifically, the server performs keyword matching according to the attribute information corresponding to the at least two pieces of field type information, determines a plurality of pieces of keyword information corresponding to each piece of field type information, uses the plurality of pieces of keyword information as corresponding query items, and further performs query condition generation according to the plurality of query items to determine at least two corresponding query conditions.
103. Receiving a query condition display request sent by a terminal, responding to the query condition display request, and determining a corresponding condition screening algorithm and a target field;
it should be noted that the query condition display request carries corresponding keyword information, where the keyword information is mainly used to indicate corresponding screening reference information, the server determines a corresponding condition screening algorithm and a target field corresponding to the keyword information through the screening reference information, and the specific server receives the query condition display request sent by the terminal and responds to the query condition display request to determine the corresponding condition screening algorithm and the target field.
104. Screening at least two query conditions according to the target field and a condition screening algorithm to obtain corresponding screening results, and generating corresponding condition display components according to the screening results;
it should be noted that the screening method may be a method of selecting the query conditions, that is, checking the query conditions of the demand, and screening the unselected query conditions, or may be a method of selecting the query conditions by a condition screening algorithm, and screening the unselected query conditions by using the selected query conditions as the excluded items. And generating a condition display component according to the screening result so as to render the condition display component in a page in the follow-up process, and displaying the condition display component in a search interface for a user to inquire and use.
105. Rendering the condition display assembly to obtain a corresponding query condition display page and displaying the query condition display page.
It should be noted that the page is generated by building a preset component, and the preset component is preset for building a display page, and the preset component is used for implementing each function of the display page, such as a request parameter component for implementing a parameter request, a button component for implementing a button function, an input frame component for implementing an input frame function, a data component for implementing a data display function, and the like. Meanwhile, a plurality of different attributes are set for different preset components, for example, the attributes of the button components at least comprise the shapes, sizes and the like of the buttons, the attributes of the input box components at least comprise the range of input data, a text box, a drop-down box and the like, and the attributes of the data components at least comprise display shapes such as a line graph, a column graph and the like, a display time range and the like. The required components are selected from the preset components, and the attributes of the selected components are configured to form a page for rendering, so that a final page is obtained for displaying. Specifically, the server selects a corresponding target component template from preset component templates and configures the attribute of the target component template to complete page rendering, so that a final page is obtained and displayed, when a subsequent user inquires, the corresponding inquiry work can be automatically completed only by selecting required inquiry conditions from the condition display component, the inquiry conditions of a search area can be customized according to the self-demand, the interference of unnecessary inquiry conditions in the search area is reduced, and the search efficiency is greatly improved.
In the embodiment of the invention, the server adopts a mode of screening the query conditions by a condition screening algorithm, so that the user can conveniently configure the query conditions, the query times are effectively reduced, the condition display component is generated according to the screening result, the condition display component is conveniently rendered in a page subsequently and displayed in a search interface for the user to query, when the subsequent user queries, the corresponding query work can be automatically completed only by selecting the required query conditions in the condition display component, the query conditions of a search area can be customized according to the self-demand, the interference of unnecessary query conditions in the search area is reduced, and the search efficiency is improved.
Referring to fig. 2, another embodiment of the page display method of the query condition in the embodiment of the present invention includes:
201. analyzing the preset query page to obtain corresponding field identification and acquiring at least two field type information from a preset database through the field identification;
specifically, in this embodiment, the specific implementation of step 201 is similar to that of step 101, and is not described herein again.
202. Performing condition generation according to at least two field type information to obtain at least two query conditions, wherein the query conditions comprise a plurality of query terms, and each query term corresponds to each preset field expression one to one;
specifically, the server acquires attribute information corresponding to each field type information, and performs query item matching on the attribute information corresponding to each field type information through a preset reflection mechanism to obtain a plurality of corresponding query items; and the server generates query conditions through the corresponding query terms to obtain at least two query conditions.
The server obtains the attribute information of each field type information in the database, performs query item matching through the attribute information corresponding to each field type information of a preset reflection mechanism, and loads and calls the obtained query item information to generate query conditions.
203. Receiving a query condition display request sent by a terminal, responding to the query condition display request, and determining a corresponding condition screening algorithm and a target field;
specifically, in this embodiment, the specific implementation of step 203 is similar to that of step 103, and is not described herein again.
204. Screening at least two query conditions according to the target field and a condition screening algorithm to obtain corresponding screening results, and generating corresponding condition display components according to the screening results;
specifically, the server calculates the field similarity of at least two query conditions through a condition screening algorithm based on a target field to obtain the similarity corresponding to each query condition; the server sorts according to the similarity corresponding to each query condition to obtain a corresponding sorted list, and determines M query conditions arranged in the front row according to the sorted list and uses the M query conditions as a screening result, wherein M is a positive integer greater than or equal to 5; and the server generates the components according to the screening result to obtain the corresponding condition display components.
The method comprises the steps that a server calculates similarity between target fields in at least two query conditions by adopting a cosine similarity formula based on a condition screening algorithm, the server obtains the at least two query conditions, removes non-character data in the at least two query conditions to obtain a training corpus, removes stop words and word vectors corresponding to words with word frequency smaller than a preset threshold value from the at least two query conditions after word vectors of each word in the training corpus are obtained, word vector combinations corresponding to the remaining words form a word vector set S, the preset threshold value is located between 5 and 10, the similarity of each query condition is further obtained, a subsequent server conducts sorting according to the numerical value of the similarity to obtain a corresponding sorting list, determines M query conditions arranged in the front row according to the sorting list and uses the M query conditions as screening results, wherein M is a positive integer larger than or equal to 5, the lowest value of M is set to be 5 based on layout conditions of display pages and attention of a user when the query conditions are selected The numerical value obtained by comprehensively analyzing the two factors of the area can avoid the condition that the selection efficiency of the user on the query condition is low due to too few conditions and low relevance when the user queries the condition, and then the server determines the corresponding component type according to the style identification of the screening result and generates the component according to the screening result to obtain the corresponding condition display component.
205. Determining a target component template corresponding to the condition display component from a plurality of pre-packaged preset component templates;
specifically, the server presets packaged preset component templates for the types of components, and the server renders the types of components in the formed page through the corresponding preset component templates to obtain the final page display.
206. Acquiring attribute information of the condition display component, inputting the attribute information into a target component template for rendering, and acquiring a rendering result of the condition display component;
specifically, the server stores the attribute information configured for the condition display component in the attribute data in the data structure of the condition display component through the attribute configuration instruction, so that the attribute information of the condition display component is obtained from the attribute data of the condition display component, the item attribute information is input into a target component template corresponding to the condition display component, and the target component template performs rendering according to the corresponding rendering logic to obtain a rendering result of the condition display component.
207. And displaying the rendering result in a page to obtain a corresponding query condition display page and displaying the query condition display page.
Specifically, after the attribute information of the condition display component is rendered and the rendering result of the condition display component is obtained, the server displays the rendering result in the page according to the display position of the condition display component in the page, so that the rendering of the page is completed.
Optionally, after step 207, the method may include:
the server receives a query request sent by the terminal and analyzes the query request to obtain corresponding target field type information; the server carries out query condition matching on the target field type information to obtain a corresponding target query condition; the server determines a data query type corresponding to the target query condition according to the target query condition; the server analyzes the target query condition through an analysis rule corresponding to the data query type to obtain a query statement corresponding to the target query condition; and the server executes the query statement to obtain a data query result corresponding to the target query condition.
After receiving the query request, the server may obtain target field type information corresponding to a query condition corresponding to the query request, where the query condition includes a plurality of query terms, and the query terms are connected by query term connection terms. According to the query request, besides the query condition, an identification method corresponding to the query request can be obtained, wherein the identification method can be used for identifying a data query type corresponding to the query condition, the data query type can comprise conjunctive query and complex query, in an actual scene, most queries are conjunctive queries, only a few queries are complex queries, a specific server analyzes the target query condition through an analysis rule corresponding to the data query type to obtain a query statement corresponding to the target query condition, and the server executes the query statement to obtain a data query result corresponding to the target query condition.
Optionally, the analyzing the target query condition according to the analysis rule corresponding to the data query type, and obtaining the query statement corresponding to the target query condition may include: if the data query type is conjunction query, the server scans the target query condition, determines a plurality of corresponding candidate query items, and acquires a query statement corresponding to the target query condition according to a target field expression corresponding to each candidate query item; if the data query type is complex query, the server analyzes the target query condition through a preset template engine to generate a query statement corresponding to the target query condition.
If the data query type is conjunction query, the server acquires a target field expression corresponding to each candidate query item, and then uses annotation in a field of the candidate query item corresponding to the target field expression to acquire a query statement corresponding to a target query condition.
Optionally, scanning the target query condition, determining a plurality of corresponding candidate query terms, and obtaining the query statement corresponding to the target query condition according to the target field expression corresponding to each candidate query term may include: the server analyzes the target field expression corresponding to each candidate query item to obtain the field and operator contained in each candidate query item; the server determines a field value corresponding to each candidate query item based on the corresponding relation between the operator and the preset query grammar, and generates query sentences according to the field, the operator and the field value corresponding to each candidate query item to obtain the query sentences corresponding to each candidate query item; and the server combines the query sentences corresponding to the candidate query terms to obtain the query sentences corresponding to the target query conditions.
The server analyzes the field expression corresponding to each candidate query item in the plurality of query items to obtain the field and the operator contained in each candidate query item, so that the field expression corresponding to each candidate query item can be analyzed to obtain the field and the operator contained in each candidate query item, then the field and the operator contained in each candidate query item can be obtained, and the query statement corresponding to each candidate query item is generated according to the field, the operator and the field value contained in each candidate query item. After the fields, operators and field values contained in each candidate query item are obtained, query statements corresponding to each candidate query item can be generated according to the corresponding relation between the operators and the query syntax.
In the embodiment of the invention, a server calculates the similarity between the at least two query conditions and a target field by adopting a cosine similarity formula based on a condition screening algorithm, so as to obtain the similarity of each query condition, a subsequent server sorts according to the numerical value of the similarity to obtain a corresponding sorted list, determines at least 5 query conditions arranged in the front row according to the sorted list and uses the query conditions as a screening result, selects at least 5 query conditions as 5 which are numerical values obtained by comprehensively analyzing two factors, namely the layout condition based on a display page and the area of an area concerned by a user when selecting the query conditions, can avoid the condition that the selection efficiency of the user under the query conditions is low due to too few conditions and low relevance when the user is in the query conditions, and can dynamically construct the query sentences by using a template engine in the generation process of the query sentences, therefore, the complexity of generating the query statement can be reduced, and the efficiency of data query is further improved.
Referring to fig. 3, an embodiment of a page displaying apparatus for query conditions according to an embodiment of the present invention includes:
the analysis module 3001 is configured to analyze a preset query page to obtain a corresponding field identifier, and obtain at least two pieces of field type information from a preset database through the field identifier;
a generating module 3002, configured to perform condition generation according to the at least two field type information to obtain at least two query conditions, where the query conditions include a plurality of query terms, and each query term corresponds to each preset field expression one to one;
a response module 3003, configured to receive a query condition display request sent by a terminal, and respond to the query condition display request to determine a corresponding condition screening algorithm and a target field;
a screening module 3004, configured to screen the at least two query conditions according to the target field and the condition screening algorithm to obtain corresponding screening results, and generate corresponding condition display components according to the screening results;
the rendering module 3005 is configured to render the condition display component, obtain a corresponding query condition display page, and display the query condition display page.
Referring to fig. 4, another embodiment of the page displaying apparatus for query conditions according to the embodiment of the present invention includes:
the analysis module 3001 is configured to analyze a preset query page to obtain a corresponding field identifier, and obtain at least two pieces of field type information from a preset database through the field identifier;
a generating module 3002, configured to perform condition generation according to the at least two field type information to obtain at least two query conditions, where the query conditions include a plurality of query terms, and each query term corresponds to each preset field expression one to one;
a response module 3003, configured to receive a query condition display request sent by a terminal, and respond to the query condition display request to determine a corresponding condition screening algorithm and a target field;
a screening module 3004, configured to screen the at least two query conditions according to the target field and the condition screening algorithm to obtain corresponding screening results, and generate corresponding condition display components according to the screening results;
the rendering module 3005 is configured to render the condition display component, obtain a corresponding query condition display page, and display the query condition display page.
Optionally, the generating module 3002 is specifically configured to: acquiring attribute information corresponding to each field type information, and performing query item matching on the attribute information corresponding to each field type information through a preset reflection mechanism to obtain a plurality of corresponding query items; and generating query conditions through the corresponding query terms to obtain at least two query conditions.
Optionally, the screening module 3004 is specifically configured to: based on the target field, performing field similarity calculation on the at least two query conditions through the condition screening algorithm to obtain the similarity corresponding to each query condition; sorting according to the similarity corresponding to each query condition to obtain a corresponding sorting list, determining M query conditions ranked in the front row according to the sorting list and using the M query conditions as the screening result, wherein M is a positive integer greater than or equal to 5; and generating components according to the screening result to obtain corresponding condition display components.
Optionally, the rendering module 3005 is specifically configured to: determining a target component template corresponding to the condition display component from a plurality of pre-packaged preset component templates; acquiring attribute information of the condition display component, inputting the attribute information into the target component template for rendering, and acquiring a rendering result of the condition display component; and displaying the rendering result in the page to obtain a corresponding query condition display page and displaying the query condition display page.
Optionally, the page display device of the query condition further includes:
a receiving module 3006, configured to receive an inquiry request sent by a terminal and analyze the inquiry request to obtain corresponding target field type information;
a matching module 3007, configured to perform query condition matching on the target field type information to obtain a corresponding target query condition;
a determining module 3008, configured to determine, according to the target query condition, a data query type corresponding to the target query condition;
an obtaining module 3009, configured to analyze the target query condition according to an analysis rule corresponding to the data query type, and obtain a query statement corresponding to the target query condition;
the execution module 3010 is configured to execute the query statement to obtain a data query result corresponding to the target query condition.
Optionally, the obtaining module 3009 specifically includes:
a scanning unit 30091, configured to scan the target query condition if the data query type is a conjunction query, determine a plurality of corresponding candidate query terms, and obtain a query statement corresponding to the target query condition according to a target field expression corresponding to each candidate query term;
the analyzing unit 30092 is configured to, if the data query type is a complex query, analyze the target query condition through a preset template engine to generate a query statement corresponding to the target query condition.
Optionally, the scanning unit 30091 is specifically configured to: analyzing a target field expression corresponding to each candidate query item to obtain a field and an operator contained in each candidate query item; determining a field value corresponding to each candidate query item based on a corresponding relation between an operator and preset query syntax, and generating a query statement according to the field, the operator and the field value corresponding to each candidate query item to obtain the query statement corresponding to each candidate query item; and combining the query sentences corresponding to the candidate query terms to obtain the query sentences corresponding to the target query conditions.
Fig. 5 is a schematic structural diagram of a computer device 500 according to an embodiment of the present invention, where the computer device 500 may have a relatively large difference due to different configurations or performances, and may include one or more processors (CPUs) 510 (e.g., one or more processors) and a memory 520, and one or more storage media 530 (e.g., one or more mass storage devices) for storing applications 533 or data 532. Memory 520 and storage media 530 may be, among other things, transient or persistent storage. The program stored on the storage medium 530 may include one or more modules (not shown), each of which may include a sequence of instructions operating on the computer device 500. Further, the processor 510 may be configured to communicate with the storage medium 530 to execute a series of instruction operations in the storage medium 530 on the computer device 500.
The computer device 500 may also include one or more power supplies 540, one or more wired or wireless network interfaces 550, one or more input-output interfaces 560, and/or one or more operating systems 531, such as Windows Server, Mac OS, Uni, Linu, FreeBSD, etc. Those skilled in the art will appreciate that the computer device configuration illustrated in FIG. 5 does not constitute a limitation of computer devices, and may include more or fewer components than those illustrated, or some components may be combined, or a different arrangement of components.
The present invention further provides a computer device, which includes a memory and a processor, where the memory stores computer readable instructions, and when the computer readable instructions are executed by the processor, the processor executes the steps of the page display method of the query condition in the above embodiments.
The present invention also provides a computer-readable storage medium, which may be a non-volatile computer-readable storage medium, and may also be a volatile computer-readable storage medium, having stored therein instructions, which, when run on a computer, cause the computer to perform the steps of the page presentation method for the query condition.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, etc. that can store program codes.
The block chain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. The Blockchain (Blockchain), which is essentially a decentralized database, is a string of data blocks associated by using a cryptographic method, each data block contains information of a batch of network transactions for verifying the validity (anti-counterfeiting) of the information and generating a next block, and the Blockchain may include a Blockchain underlying platform, a platform product service layer, an application service layer, and the like.

Claims (10)

1. A page display method for query conditions is characterized by comprising the following steps:
analyzing a preset query page to obtain corresponding field identification and acquiring at least two field type information from a preset database through the field identification;
performing condition generation according to the at least two field type information to obtain at least two query conditions, wherein the query conditions comprise a plurality of query terms, and each query term corresponds to each preset field expression one by one;
receiving a query condition display request sent by a terminal, responding to the query condition display request, and determining a corresponding condition screening algorithm and a target field;
screening the at least two query conditions according to the target field and the condition screening algorithm to obtain corresponding screening results, and generating corresponding condition display components according to the screening results;
rendering the condition display assembly to obtain a corresponding query condition display page and displaying the query condition display page.
2. The method for displaying pages of query conditions according to claim 1, wherein the performing condition generation according to the at least two field type information obtains at least two query conditions, wherein the query conditions include a plurality of query terms, and each query term corresponds to each preset field expression one-to-one, and the method includes:
acquiring attribute information corresponding to each field type information, and performing query item matching on the attribute information corresponding to each field type information through a preset reflection mechanism to obtain a plurality of corresponding query items;
and generating query conditions through the corresponding query terms to obtain at least two query conditions.
3. The method for displaying pages of query conditions according to claim 1, wherein the step of screening the at least two query conditions according to the target field and the condition screening algorithm to obtain corresponding screening results, and generating corresponding condition display components according to the screening results comprises:
based on the target field, performing field similarity calculation on the at least two query conditions through the condition screening algorithm to obtain the similarity corresponding to each query condition;
sorting according to the similarity corresponding to each query condition to obtain a corresponding sorting list, determining M query conditions ranked in the front row according to the sorting list and using the M query conditions as the screening result, wherein M is a positive integer greater than or equal to 5;
and generating components according to the screening result to obtain corresponding condition display components.
4. The method for displaying the query terms on the page according to claim 1, wherein the rendering the condition display component to obtain the corresponding query term display page and display the query term display page includes:
determining a target component template corresponding to the condition display component from a plurality of pre-packaged preset component templates;
acquiring attribute information of the condition display component, inputting the attribute information into the target component template for rendering, and acquiring a rendering result of the condition display component;
and displaying the rendering result in the page to obtain a corresponding query condition display page and displaying the query condition display page.
5. The method for displaying the query terms on the page according to claim 1, wherein after the rendering of the condition displaying component to obtain the corresponding query term displaying page and displaying the query term displaying page, the method further comprises:
receiving a query request sent by a terminal and analyzing the query request to obtain corresponding target field type information;
performing query condition matching on the target field type information to obtain a corresponding target query condition;
determining a data query type corresponding to the target query condition according to the target query condition;
analyzing the target query condition through an analysis rule corresponding to the data query type to obtain a query statement corresponding to the target query condition;
and executing the query statement to obtain a data query result corresponding to the target query condition.
6. The method for displaying pages of query conditions according to claim 5, wherein the analyzing the target query conditions according to the analysis rules corresponding to the data query types, and the obtaining query statements corresponding to the target query conditions comprises:
if the data query type is conjunction query, scanning the target query condition, determining a plurality of corresponding candidate query terms, and acquiring a query statement corresponding to the target query condition according to a target field expression corresponding to each candidate query term;
and if the data query type is complex query, analyzing the target query condition through a preset template engine to generate a query statement corresponding to the target query condition.
7. The method for displaying pages of query conditions according to any one of claims 1 to 6, wherein the scanning the target query condition to determine a plurality of corresponding candidate query terms, and obtaining the query statement corresponding to the target query condition according to the target field expression corresponding to each candidate query term comprises:
analyzing a target field expression corresponding to each candidate query item to obtain a field and an operator contained in each candidate query item;
determining a field value corresponding to each candidate query item based on a corresponding relation between an operator and preset query syntax, and generating a query statement according to the field, the operator and the field value corresponding to each candidate query item to obtain the query statement corresponding to each candidate query item;
and combining the query sentences corresponding to the candidate query terms to obtain the query sentences corresponding to the target query conditions.
8. A device for displaying pages of query conditions, the device comprising:
the analysis module is used for analyzing the preset query page to obtain a corresponding field identifier and acquiring at least two pieces of field type information from a preset database through the field identifier;
the generating module is used for performing condition generation according to the at least two field type information to obtain at least two query conditions, wherein the query conditions comprise a plurality of query terms, and each query term corresponds to each preset field expression one by one;
the response module is used for receiving a query condition display request sent by the terminal, responding to the query condition display request and determining a corresponding condition screening algorithm and a target field;
the screening module is used for screening the at least two query conditions according to the target field and the condition screening algorithm to obtain corresponding screening results, and generating corresponding condition display components according to the screening results;
and the rendering module is used for rendering the condition display assembly to obtain a corresponding query condition display page and displaying the query condition display page.
9. A computer device, characterized in that the computer device comprises: a memory and at least one processor, the memory having instructions stored therein;
the at least one processor invoking the instructions in the memory to cause the computer device to perform a page presentation method of the query term of any one of claims 1-7.
10. A computer-readable storage medium having instructions stored thereon, wherein the instructions, when executed by a processor, implement a page presentation method according to the query term of any one of claims 1-7.
CN202111555569.0A 2021-12-17 2021-12-17 Page display method, device and equipment for query conditions and storage medium Pending CN114297535A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111555569.0A CN114297535A (en) 2021-12-17 2021-12-17 Page display method, device and equipment for query conditions and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111555569.0A CN114297535A (en) 2021-12-17 2021-12-17 Page display method, device and equipment for query conditions and storage medium

Publications (1)

Publication Number Publication Date
CN114297535A true CN114297535A (en) 2022-04-08

Family

ID=80967982

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111555569.0A Pending CN114297535A (en) 2021-12-17 2021-12-17 Page display method, device and equipment for query conditions and storage medium

Country Status (1)

Country Link
CN (1) CN114297535A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115617878A (en) * 2022-11-17 2023-01-17 浪潮电子信息产业股份有限公司 Data query method, system, device, equipment and computer storage medium

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115617878A (en) * 2022-11-17 2023-01-17 浪潮电子信息产业股份有限公司 Data query method, system, device, equipment and computer storage medium
CN115617878B (en) * 2022-11-17 2023-03-10 浪潮电子信息产业股份有限公司 Data query method, system, device, equipment and computer storage medium

Similar Documents

Publication Publication Date Title
CN107832229B (en) NLP-based system test case automatic generation method
CN109800307B (en) Product evaluation analysis method and device, computer equipment and storage medium
JP5477297B2 (en) Active metric learning device, active metric learning method, and active metric learning program
KR20200007969A (en) Information processing methods, terminals, and computer storage media
WO2019169858A1 (en) Searching engine technology based data analysis method and system
JP2018067278A (en) Device, method, and program for recognizing data property
WO2018079225A1 (en) Automatic prediction system, automatic prediction method and automatic prediction program
CN112035614B (en) Test set generation method, device, computer equipment and storage medium
CN104484392A (en) Method and device for generating database query statement
CN112749266A (en) Industrial question and answer method, device, system, equipment and storage medium
CN114297535A (en) Page display method, device and equipment for query conditions and storage medium
CN108701153B (en) Method, system and computer readable storage medium for responding to natural language query
JP2016110256A (en) Information processing device and information processing program
JP5439235B2 (en) Document classification method, document classification device, and program
US20200050637A1 (en) System and method to analyse and predict impact of textual data
CN116629215A (en) Teaching document generation method and device, electronic equipment and storage medium
US11182561B2 (en) Data analyzer and data analysis method
CN115687717A (en) Method, device and equipment for acquiring hook expression and computer readable storage medium
CN113705198B (en) Scene graph generation method and device, electronic equipment and storage medium
JP2020052767A (en) Vulnerability estimation device and vulnerability estimation method
JP2019200582A (en) Search device, search method, and search program
Komendantskaya et al. Proof mining with dependent types
CN114253990A (en) Database query method and device, computer equipment and storage medium
US7240050B2 (en) Methods and apparatus for generating automated graphics using stored graphics examples
JP2011227742A (en) Contrast display data generation device or contrast display data generation method

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