CN111309991B - Query statement generation method and device and data query method and system - Google Patents
Query statement generation method and device and data query method and system Download PDFInfo
- Publication number
- CN111309991B CN111309991B CN202010046963.0A CN202010046963A CN111309991B CN 111309991 B CN111309991 B CN 111309991B CN 202010046963 A CN202010046963 A CN 202010046963A CN 111309991 B CN111309991 B CN 111309991B
- Authority
- CN
- China
- Prior art keywords
- target
- demand
- user
- requirement
- information
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/9032—Query formulation
Abstract
The application relates to a query statement generation method, a query statement generation device, computer equipment and a storage medium. The method comprises the following steps: acquiring user requirement editing information in a requirement analysis selection page, wherein the user requirement editing information comprises user requirement information and a user requirement purpose; determining a corresponding data analysis structure according to the user requirement purpose; and generating corresponding target demand description information according to the user demand information and the data analysis structure, wherein the target demand description information is used for generating a corresponding target query statement. The method can improve the query efficiency, and also provides a data query method, a data query system, computer equipment and a storage medium.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a query statement generation method, an apparatus, a computer device, and a storage medium, and a data query method, a system, a computer device, and a storage medium.
Background
With the development of computers, many scenarios need to use query statements for query analysis, but if the requirements change, the original query statements cannot be queried, so developers need to reprocess the logic corresponding to the original query statements to generate new query statements, thereby querying. In addition, once the demand changes, the demander needs to communicate with the developer immediately, and the developer can realize new query only after changing the original processing logic according to the new demand of the demander, so that the data query efficiency is low.
Disclosure of Invention
In view of the foregoing, it is necessary to provide a query statement generation method, an apparatus, a computer device, and a storage medium capable of improving query efficiency, and a data query method, a system, a computer device, and a storage medium.
A query statement generation method, the method comprising:
acquiring user requirement editing information in a requirement analysis selection page, wherein the user requirement editing information comprises user requirement information and a user requirement purpose;
determining a corresponding data analysis structure according to the user requirement purpose;
and generating corresponding target demand description information according to the user demand information and the data analysis structure, wherein the target demand description information is used for generating a corresponding target query statement.
In one embodiment, the query statement generation method further includes: and sending the target requirement description information to the server so that the server generates a corresponding target query statement according to the target requirement description information, querying to obtain target data corresponding to the target query statement, returning the target data, and receiving the target data.
In one embodiment, the query statement generation method further includes: the server generates a target demand identifier according to the target demand description information, establishes an association relation between the target demand identifier and target data, generates a corresponding sharing link according to the target demand identifier, and broadcasts the sharing link.
In one embodiment, the query statement generation method further includes: the method comprises the steps of obtaining current click operation on a current sharing link, generating a corresponding current sharing request according to the current click operation, and sending the current sharing request to a server, wherein the current sharing request carries a current demand identifier, so that the server obtains corresponding current demand description information according to the current demand identifier, obtains current data corresponding to the current demand identifier according to an incidence relation, returns the current demand description information and the current data, renders and displays a demand analysis page corresponding to the current demand description information, the demand analysis page displays a target demand analysis selection page, the target demand analysis selection page comprises user demand editing information, renders and displays a demand result analysis page corresponding to the current data, and the demand result analysis page displays a query result corresponding to a target query statement.
In one embodiment, determining a corresponding data analysis structure according to a user requirement objective includes: and acquiring a user demand purpose, determining a corresponding demand analysis type, and acquiring a corresponding data analysis structure according to the demand analysis type.
In one embodiment, generating corresponding target demand description information according to the user demand information and the data analysis structure includes: and taking the user requirement information as a parameter of a data analysis structure to generate corresponding target requirement description information.
A method of data query, the method comprising:
acquiring target requirement description information, wherein the target requirement description information is generated according to user requirement information and a user requirement purpose in user requirement editing information;
generating a corresponding target query statement according to the target requirement description information;
and querying to obtain target data corresponding to the target query statement.
In one embodiment, generating a corresponding target query statement according to the target requirement description information includes: acquiring a candidate query statement template set, wherein the candidate query statement template set comprises at least one candidate query statement template, determining a target query statement template from the candidate query statement template set, and generating a corresponding target query statement according to the target query statement template and the target requirement description information.
A data query system, the system comprising:
the user terminal is used for displaying the demand analysis selection page, carrying out editing operation on the demand analysis selection page to obtain user demand editing information, determining a corresponding data analysis structure according to the user demand purpose, generating corresponding target demand description information according to the user demand information and the data analysis structure, and sending the target demand description information to the application server;
the application server is used for receiving the target requirement description information, generating a corresponding target query statement according to the target requirement description information and sending the target query statement to the query server;
and the query server is used for querying and obtaining target data corresponding to the target query statement after receiving the target query statement.
A query statement generation apparatus, the apparatus comprising:
the user editing information acquisition module is used for acquiring user requirement editing information in the requirement analysis selection page, wherein the user requirement editing information comprises user requirement information and a user requirement purpose;
the data analysis structure determining module is used for determining a corresponding data analysis structure according to the user requirement;
and the requirement description information generation module is used for generating corresponding target requirement description information according to the user requirement information and the data analysis structure, and the target requirement description information is used for generating a corresponding target query statement.
A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
acquiring user requirement editing information in a requirement analysis selection page, wherein the user requirement editing information comprises user requirement information and a user requirement purpose;
determining a corresponding data analysis structure according to the user requirement purpose;
and generating corresponding target demand description information according to the user demand information and the data analysis structure, wherein the target demand description information is used for generating a corresponding target query statement.
A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:
acquiring user requirement editing information in a requirement analysis selection page, wherein the user requirement editing information comprises user requirement information and a user requirement purpose;
determining a corresponding data analysis structure according to the user requirement purpose;
and generating corresponding target demand description information according to the user demand information and the data analysis structure, wherein the target demand description information is used for generating a corresponding target query statement.
A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
acquiring target requirement description information, wherein the target requirement description information is generated according to user requirement information and a user requirement purpose in user requirement editing information;
generating a corresponding target query statement according to the target requirement description information;
and querying to obtain target data corresponding to the target query statement.
A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:
acquiring target requirement description information, wherein the target requirement description information is generated according to user requirement information and a user requirement purpose in user requirement editing information;
generating a corresponding target query statement according to the target requirement description information;
and querying to obtain target data corresponding to the target query statement.
The query statement generation method, the query statement generation device, the computer device and the storage medium, and the data query method, the system, the computer device and the storage medium acquire user requirement editing information in a requirement analysis selection page, wherein the user requirement editing information comprises user requirement information and a user requirement purpose, a corresponding data analysis structure is determined according to the user requirement purpose, and corresponding target requirement description information is generated according to the user requirement information and the data analysis structure and is used for generating a corresponding target query statement. Therefore, when the demand changes, only new demand information needs to be edited again in the demand analysis selection page to obtain new user demand editing information, new target demand description information is finally generated, a new query statement is generated according to the target demand description information, communication with developers is not needed, and the developers can perform query after processing, so that the data query efficiency is improved.
Drawings
FIG. 1 is a diagram of an application environment of a data query method in one embodiment;
FIG. 2 is a flowchart illustrating a query statement generation method according to an embodiment;
FIG. 2A is an interface diagram of a demand analysis selection page in one embodiment;
FIG. 2B is a diagram illustrating the structure of data analysis in one embodiment;
FIG. 2C is a diagram of target demand description information in one embodiment;
FIG. 3 is a flowchart illustrating a query statement generation method according to another embodiment;
FIG. 4 is a flowchart showing a query statement generation method in still another embodiment;
FIG. 5 is a flowchart illustrating a method for generating a query statement according to an embodiment;
FIG. 6 is a flowchart illustrating the data analysis structure determination step in one embodiment;
FIG. 7 is a flow diagram that illustrates a methodology for querying data in one embodiment;
FIG. 8 is a flowchart of the target query statement generation step in one embodiment;
FIG. 9 is a block diagram that illustrates the architecture of the data query system in one embodiment;
FIG. 10 is a schematic diagram of a data query method in one embodiment;
FIG. 11 is a schematic diagram of a data query method in another embodiment;
FIG. 12 is a block diagram showing the construction of a query sentence generating apparatus in one embodiment;
FIG. 13 is a diagram showing an internal structure of a computer device in one embodiment;
FIG. 14 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The data query method provided by the application can be applied to the application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and the server 104 may be implemented by an independent server or a server cluster formed by a plurality of servers.
Specifically, the terminal 102 obtains target requirement description information, and sends the target requirement description information to the server 104, where the target requirement description information is generated according to the user requirement information and the user requirement purpose in the user requirement editing information. After receiving the target requirement description information, the server 104 generates a corresponding target query statement according to the target requirement description information, and queries to obtain target data corresponding to the target query statement. Further, the server 104 returns the target data to the terminal 102.
In one embodiment, the step of generating the target requirement description information on the terminal 102 is: the terminal 102 displays a requirement analysis selection page, acquires user requirement editing information in the requirement analysis selection page, wherein the user requirement editing information comprises user requirement information and a user requirement purpose, determines a corresponding data analysis structure according to the user requirement purpose, and generates corresponding target requirement description information according to the user requirement information and the data analysis structure, and the target requirement description information is used for generating a corresponding target query statement.
In another embodiment, after the target requirement description information is generated and obtained, the terminal 102 may generate a corresponding target query statement according to the target requirement description information, and query to obtain target data corresponding to the target query statement.
In an embodiment, as shown in fig. 2, a query statement generating method is provided, which is described by taking the application of the method to the terminal in fig. 1 as an example, and includes the following steps:
The requirement analysis selection page is used for providing the terminal user with requirement selection, and user requirements needing to be analyzed can be set in the requirement analysis selection page according to the requirements of the user. In one embodiment, the requirement analysis selection page may be as shown in fig. 2A, where fig. 2A illustrates an interface diagram of the requirement analysis selection page in one embodiment, and a requirement analysis object may be selected in the requirement analysis selection page, and so on.
The user requirement editing information refers to that a user edits a requirement in a requirement analysis selection page to generate related information, the user requirement editing information comprises user requirement information and a user requirement purpose, namely, in the requirement analysis selection page, a user requirement editing control and a user requirement purpose control are provided, user requirement editing is carried out through the user requirement editing control to obtain user requirement information, and the user requirement purpose is edited through the user requirement purpose control to obtain the user requirement purpose.
The user requirement information refers to information related to user requirements, and includes a requirement analysis object, a requirement analysis condition and the like, and a terminal user can edit the user requirements according to the service requirements of the terminal user, so that the user requirement information is obtained.
The user requirement purpose refers to a target and a result of requirement analysis performed by a user, and the purpose of the user requirement analysis can be determined by editing the user requirement purpose. For example, the user demand objective may be demand analysis object trend analysis, conversion rate analysis of demand analysis objects, and the like.
Specifically, the terminal displays a requirement analysis selection page on a front-end page, a user requirement editing control and a user requirement purpose editing control can be arranged on the requirement analysis selection page, a terminal user can edit the user requirement through the user requirement editing control to obtain user requirement information, and can edit the user requirement purpose through the user requirement purpose editing control to obtain the user requirement purpose. When the requirements of the terminal user are changed, the user requirement editing control provided by the requirement analysis selection page can be used for editing the user requirements, communication with developers is not needed, the developers are waited for development, and the user requirement editing control provided by the requirement analysis selection page can be directly used for re-editing, so that the efficiency is improved.
And step 204, determining a corresponding data analysis structure according to the user requirement purpose.
The data analysis structure is a data structure, which is a collection of data elements with one or more specific relationships among data, and different user requirements and purposes correspond to different data analysis structures. The data analysis structure corresponding to each user requirement purpose can be set in advance, so that when the user requirement purpose is obtained, the corresponding data analysis structure can be determined according to the user requirement purpose.
In one embodiment, as shown in fig. 2B, fig. 2B is a schematic diagram of a data analysis structure in one embodiment, where the data analysis structure may be a string of codes, and a code before user requirement information is entered may be referred to as a data analysis structure.
The candidate data analysis structures corresponding to the user requirement purposes in the user requirement editing information can be stored in advance, and then the data analysis structures corresponding to the user requirement purposes in the user requirement editing information are searched from the stored candidate data analysis structures.
Specifically, after the user requirement editing information is obtained, according to the user requirement purpose in the user requirement editing information, the corresponding data analysis structure is searched from the stored candidate data analysis structures.
And step 206, generating corresponding target requirement description information according to the user requirement information and the data analysis structure, wherein the target requirement description information is used for generating a corresponding target query statement.
The data analysis structure can be a code before the user demand information is not involved, so that after the data analysis structure is obtained, the user demand information can be used as a parameter of the data analysis structure to generate corresponding target demand description information. The target requirement description information is used for generating a corresponding target query statement, the target requirement description information is description of user requirement information, and the corresponding target query statement can be generated through the target requirement description information. The query statement is a programming language used to query data.
Specifically, after a data analysis structure corresponding to a user requirement purpose is determined, user requirement information in user requirement editing information is used as a parameter of the data analysis structure, that is, the user requirement information is used as a variable of the data analysis structure, and corresponding target requirement description information is obtained. The target requirement description information may be a data structure including user requirement information, for example, the target requirement description information may be a Json description.
In an embodiment, as shown in fig. 2C, fig. 2C is a schematic diagram of target demand description information in an embodiment, where the target demand description information in fig. 2C includes user demand information, such as yielding IDs 122, 127, and 142, and demand analysis objects are: number of trigger roles logged in, etc.
In the query statement generating method, user requirement editing information is acquired in a requirement analysis selection page, the user requirement editing information comprises user requirement information and a user requirement purpose, a corresponding data analysis structure is determined according to the user requirement purpose, corresponding target requirement description information is generated according to the user requirement information and the data analysis structure, and the target requirement description information is used for generating a corresponding target query statement. Therefore, when the demand changes, only new demand information needs to be edited again in the demand analysis selection page to obtain new user demand editing information, new target demand description information is finally generated, a new query statement is generated according to the target demand description information, communication with developers is not needed, and the developers can perform query after processing, so that the data query efficiency is improved.
In one embodiment, as shown in fig. 3, the query statement generation method further includes:
At step 304, target data is received.
After the target demand description information is obtained, the target demand description information can be sent to a server through a network. The target requirement description information is used for generating a corresponding target query statement, and the target requirement description information comprises user requirement information and a user requirement purpose, so that the server can generate the corresponding target query statement according to the target requirement description information after receiving the target requirement description information. Furthermore, the server queries according to the target query statement to obtain corresponding target data, and then returns the target data to the terminal, and the terminal receives the target data.
The server may generate a corresponding target query statement according to the target requirement description information by acquiring a candidate query statement template set, where the candidate query statement template set includes at least one candidate query statement template, the query statement template is used to generate a query statement, and each query statement has a corresponding query statement template, and the query statement is generated by the query statement template.
Further, after the candidate query statement template set is obtained, a corresponding target query statement template is determined from the candidate query statement template set, specifically, the target query statement template is determined according to target requirement description information, and each requirement description information has a corresponding query statement model, so that the corresponding target query statement template can be obtained according to the target requirement description information. And finally, generating a corresponding target query statement according to the target query statement template and the target requirement description information, wherein the target requirement description information comprises a plurality of sub-description information, the different sub-description information has corresponding query statement templates, and then the query statement templates corresponding to the sub-description information form the target query statement.
In one embodiment, as shown in fig. 4, the query statement generation method further includes:
In step 404, the server establishes an association relationship between the target requirement identifier and the target data.
The target requirement identification is used for uniquely identifying corresponding target requirement description information, corresponding requirement identifications exist in different requirement description information, and the corresponding requirement description information can be searched and determined through the requirement identifications. Therefore, after receiving the target demand description information, the server may determine a corresponding target demand identifier according to the target demand description information, and after determining the target demand identifier corresponding to the target demand description information, may establish an association relationship between the target demand identifier and the target data, that is, bind the target demand identifier and the target data, establish an association relationship between the target demand identifier and the target data, and subsequently may obtain the target data according to the association relationship.
And 406, the server generates a corresponding sharing link according to the target requirement identifier.
In step 408, the server broadcasts a sharing link.
The sharing link is used for sharing target data and is a connection relation pointing to a target from a webpage, an object used for hyperlink in the webpage can be a section of text or a picture, and after a browser clicks the linked text or picture, the link target is displayed on the browser and is opened or operated according to the type of the target.
Specifically, the server can generate a corresponding sharing link according to the target demand identifier, and share the target data and the target demand analysis selection page in a link form, wherein the target demand analysis selection page is a demand analysis selection page including user demand editing information, that is, a terminal user edits the user demand information and edits a user demand purpose on the demand analysis selection page, and after the editing is completed, the target demand analysis selection page is generated.
Further, after the sharing link is generated, the server may broadcast the sharing link, where the broadcast form is not limited, and may be broadcast in a short message, instant messaging, and other manners.
In one embodiment, as shown in fig. 5, the query statement generation method further includes:
After receiving the sharing link, the terminal displays the sharing link for the terminal user to check, and the terminal user can click the sharing link to trigger generation of a corresponding sharing request. The current sharing link refers to a currently processed sharing link, the terminal can display the current sharing link at the front end to a terminal user, and the terminal user can perform current click operation on the current sharing link to trigger generation of a corresponding current sharing request. The current sharing request is used for requesting to issue corresponding current data and current demand information.
Further, after the terminal generates a current sharing request, the current sharing request is sent to the server through the network, wherein the current sharing request carries a current demand identifier, the current demand identifier is used for uniquely identifying the corresponding demand description information, and after the server receives the current sharing request, the server can obtain the corresponding current demand description information according to the current demand identifier in the current sharing request.
Secondly, after the server obtains the current demand description information, the server obtains current data corresponding to the current demand identification according to the pre-established association relationship between the demand identification and the data, and finally the server returns the current demand description information and the current data to the terminal together.
Specifically, the terminal receives current requirement description information and current data returned by the server, and can render and display a corresponding requirement analysis page according to the current requirement description information, wherein the requirement analysis page is used for displaying a target requirement analysis selection page, the target requirement analysis selection page is a requirement analysis selection page including user requirement editing information, that is, a terminal user edits the user requirement information and edits a user requirement purpose on the requirement analysis selection page, and the target requirement analysis selection page is generated after the editing is finished.
Similarly, the terminal can render a corresponding demand result analysis page according to the current data, where the demand result analysis page is used to display a demand analysis result, and the demand analysis result refers to a query result corresponding to the target query statement.
In one embodiment, as shown in fig. 6, determining a corresponding data analysis structure according to the user requirement purpose includes:
And step 604, acquiring a corresponding data analysis structure according to the requirement analysis type.
The requirement analysis type is a type of a user requirement purpose, different user requirement purposes correspond to different requirement analysis types, and the requirement analysis type comprises requirement trend analysis, requirement conversion rate analysis and the like. The user can edit the corresponding user requirement purpose according to the self requirement.
Specifically, after the terminal obtains the information of the user requirement purpose, the corresponding requirement analysis type can be determined according to the user requirement purpose. Further, the corresponding data analysis structure can be determined according to the type of the demand analysis.
The association relationship between the requirement analysis type and the data analysis structure may be pre-established, and specifically, the association relationship between the requirement analysis type and the data analysis structure may be established according to a service requirement and an application scenario, or according to a service experience, by a developer, so that a corresponding data analysis structure may be determined through a user requirement purpose in the following.
In one embodiment, generating corresponding target demand description information according to the user demand information and the data analysis structure includes: and taking the user requirement information as a parameter of a data analysis structure to generate corresponding target requirement description information.
Specifically, after a data analysis structure corresponding to a user requirement purpose is determined, user requirement information in user requirement editing information is used as a parameter of the data analysis structure, that is, the user requirement information is used as a variable of the data analysis structure, and corresponding target requirement description information is obtained. The target requirement description information may be a data structure including user requirement information, for example, the target requirement description information may be a Json description.
In an embodiment, as shown in fig. 2C, fig. 2C is a schematic diagram illustrating target demand description information in an embodiment, where the target demand description information in fig. 2C includes user demand information, such as yielding IDs 122, 127, and 142, and demand analysis objects are: number of trigger roles logged in, etc.
In one embodiment, as shown in fig. 7, a data query method is provided, which is described by taking the method as an example applied to the terminal or the server in fig. 1, and includes the following steps:
step 702, obtaining target requirement description information, where the target requirement description information is generated according to user requirement information and a user requirement purpose in the user requirement editing information.
The user requirement editing information refers to that a user edits a requirement in a requirement analysis selection page to generate related information, the user requirement editing information comprises user requirement information and a user requirement purpose, namely, in the requirement analysis selection page, a user requirement editing control and a user requirement purpose control are provided, user requirement editing is carried out through the user requirement editing control to obtain user requirement information, and the user requirement purpose is edited through the user requirement purpose control to obtain the user requirement purpose.
The user requirement information refers to information related to user requirements, and includes a requirement analysis object, a requirement analysis condition and the like, and a terminal user can edit the user requirements according to the service requirements of the terminal user, so that the user requirement information is obtained.
The user requirement purpose refers to a target and a result of requirement analysis performed by a user, and the purpose of the user requirement analysis can be determined by editing the user requirement purpose. For example, the user demand objective may be demand analysis object trend analysis, conversion rate analysis of demand analysis objects, and the like.
Specifically, the terminal displays a requirement analysis selection page on a front-end page, a user requirement editing control and a user requirement purpose editing control can be arranged on the requirement analysis selection page, a terminal user can edit the user requirement through the user requirement editing control to obtain user requirement information, and can edit the user requirement purpose through the user requirement purpose editing control to obtain the user requirement purpose.
Further, a corresponding data analysis structure is determined according to the user requirement purpose, wherein the data analysis structure is a data structure and is a set of data elements with one or more specific relationships among data, and different user requirement purposes correspond to different data analysis structures.
Finally, the data analysis structure can be a code before the user demand information is entered, so after the data analysis structure is obtained, the user demand information can be used as a parameter of the data analysis structure to generate corresponding target demand description information. The target requirement description information is used for generating a corresponding target query statement, the target requirement description information is description of user requirement information, and the corresponding target query statement can be generated through the target requirement description information.
Specifically, after a data analysis structure corresponding to a user requirement purpose is determined, user requirement information in user requirement editing information is used as a parameter of the data analysis structure, that is, the user requirement information is used as a variable of the data analysis structure, and corresponding target requirement description information is obtained.
And step 706, inquiring to obtain target data corresponding to the target inquiry statement.
The target requirement description information is used for generating a corresponding target query statement, and the target requirement description information comprises user requirement information and a user requirement purpose, so that the server can generate the corresponding target query statement according to the target requirement description information after receiving the target requirement description information. And further, inquiring according to the target inquiry statement to obtain corresponding target data, returning the target data to the terminal, and receiving the target data by the terminal.
In one embodiment, as shown in fig. 8, generating a corresponding target query statement according to the target requirement description information includes:
The generating of the corresponding target query statement according to the target requirement description information may be to obtain a candidate query statement template set, where the candidate query statement template set includes at least one candidate query statement template, the query statement template is used to generate a query statement, and each query statement has a corresponding query statement template, and the query statement is generated by the query statement template.
Further, after the candidate query statement template set is obtained, a corresponding target query statement template is determined from the candidate query statement template set, specifically, the target query statement template is determined according to target requirement description information, and each requirement description information has a corresponding query statement model, so that the corresponding target query statement template can be obtained according to the target requirement description information. And finally, generating a corresponding target query statement according to the target query statement template and the target requirement description information, wherein the target requirement description information comprises a plurality of sub-description information, the different sub-description information has corresponding query statement templates, and then the query statement templates corresponding to the sub-description information form the target query statement. The sub-description information is a unit of the target requirement description information, and the target requirement description information may be divided into a plurality of sub-description information, that is, the target requirement description information is composed of the respective sub-description information.
It should be understood that, although the steps in the above-described flowcharts are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a portion of the steps in the above-described flowcharts may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the sub-steps or the stages is not necessarily sequential, but may be performed alternately or alternatingly with other steps or at least a portion of the sub-steps or stages of other steps.
In one embodiment, as shown in FIG. 9, there is provided a data query system 900, comprising: user terminal 902, application server 904 and query server 906, wherein:
the user terminal 902 is configured to display a requirement analysis selection page, perform an editing operation on the requirement analysis selection page to obtain user requirement editing information, where the user requirement editing information includes user requirement information and a user requirement purpose, determine a corresponding data analysis structure according to the user requirement purpose, generate corresponding target requirement description information according to the user requirement information and the data analysis structure, and send the target requirement description information to the application server 904.
The application server 904 is configured to receive the target requirement description information, generate a corresponding target query statement according to the target requirement description information, and send the target query statement to the query server 906.
The query server 906 is configured to, after receiving the target query statement, query to obtain target data corresponding to the target query statement, and send the target data to the user terminal 902.
The user terminal 902 is further configured to render and display a target demand analysis page corresponding to the target demand description information, and render and display a target demand result analysis page corresponding to the target data.
In a practical application scenario, as shown in fig. 10, fig. 10 shows a schematic diagram of a data query method in an embodiment, which can be described in detail by the following steps:
1. and the terminal user analyzes and selects the analysis functional components provided by the page according to the requirements, and fills the data requirement analysis and selection page to obtain user requirement editing information which comprises user requirement information and a user requirement purpose.
2. And the terminal front-end component determines a corresponding data analysis structure according to the appointed standard and the user requirement purpose, and generates a corresponding JSON description according to the user requirement information and the data analysis structure.
2-1, the application server generates the SQL queried this time according to the JSON description and the SQL template analyzed in the same type.
And 2-2, generating a target demand ID for uniquely identifying the analysis according to the JSON description by the application server.
2-2-1, the application server takes the target demand ID as a storage basis and caches the corresponding JSON description.
2-2-2, the application server generates a corresponding sharing link for distribution and tracing according to the target demand ID.
3. The application server submits a query request to the query server.
4. The query server returns a query result set.
5. And the application server generates a JSON format of the query result data according to the result set and returns the JSON format as a request response.
And 5-1, the application server takes the target requirement ID as a storage unit, and caches the data result in the JSON format.
6. The terminal front-end component performs rendering of tables and graphs of data results.
Further, as shown in fig. 11, fig. 11 shows a schematic diagram of a data query method in another embodiment, which describes a process of distribution after an end user obtains a query analysis result, and may be illustrated by the following steps:
1. the user 1 executes and completes one-time data query to obtain a page rendering result, and generates a unique identification link for sharing of the query analysis on a page.
2. User 1 sends the entire link to user 2.
3. User 2 clicks on this link and makes a request to the application server.
4. And the application server obtains the current demand identifier of the identifier analysis according to the sharing link.
5. The application server identifies the Json descriptions of the query store according to the current requirements.
And 5-1, acquiring the current JSON description of the analysis query from the storage according to the current demand identifier.
And 5-2, acquiring the analysis result data from the storage according to the current demand identification.
6. And rendering a front page of the terminal.
6-1, reversely rendering a page table single component according to the JSON description of the analysis query.
6-2, rendering the page table and the chart component again according to the analysis result data.
In one embodiment, as shown in fig. 12, there is provided a query statement generation apparatus 1200 including: a user edit information acquisition module 1202, a data analysis structure determination module 1204, and a requirement description information generation module 1206, wherein:
the user editing information obtaining module 1202 is configured to obtain user requirement editing information in the requirement analysis selection page, where the user requirement editing information includes user requirement information and a user requirement purpose.
And a data analysis structure determining module 1204, configured to determine a corresponding data analysis structure according to a user requirement.
The requirement description information generating module 1206 is configured to generate corresponding target requirement description information according to the user requirement information and the data analysis structure, where the target requirement description information is used to generate a corresponding target query statement.
In an embodiment, the data analysis structure determining module 1204 is further configured to obtain a user requirement purpose to determine a corresponding requirement analysis type, and obtain a corresponding data analysis structure according to the requirement analysis type, and the requirement description information generating module 1206 is further configured to use the user requirement information as a parameter of the data analysis structure to generate corresponding target requirement description information.
For specific limitations of the query statement generation apparatus, reference may be made to the above limitations on the query statement generation method, which is not described herein again. The modules in the query statement generation device can be wholly or partially implemented by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as shown in fig. 13. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operating system and the computer program to run on the non-volatile storage medium. The database of the computer device is used for storing target data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a data query method.
In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 14. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a query statement generation method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the configurations shown in fig. 13 or 14 are block diagrams of only some of the configurations relevant to the present disclosure, and do not constitute limitations on the computing devices to which the present disclosure may be applied, and that a particular computing device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program: acquiring user requirement editing information in a requirement analysis selection page, wherein the user requirement editing information comprises user requirement information and a user requirement purpose; determining a corresponding data analysis structure according to the user requirement purpose; and generating corresponding target demand description information according to the user demand information and the data analysis structure, wherein the target demand description information is used for generating a corresponding target query statement.
In one embodiment, the processor, when executing the computer program, further performs the steps of: and sending the target requirement description information to the server so that the server generates a corresponding target query statement according to the target requirement description information, querying to obtain target data corresponding to the target query statement, returning the target data, and receiving the target data.
In one embodiment, the processor, when executing the computer program, further performs the steps of: the server generates a target demand identifier according to the target demand description information, establishes an association relation between the target demand identifier and target data, generates a corresponding sharing link according to the target demand identifier, and broadcasts the sharing link.
In one embodiment, the processor when executing the computer program further performs the steps of: the method comprises the steps of obtaining current click operation on a current sharing link, generating a corresponding current sharing request according to the current click operation, and sending the current sharing request to a server, wherein the current sharing request carries a current demand identifier, so that the server obtains corresponding current demand description information according to the current demand identifier, obtains current data corresponding to the current demand identifier according to an incidence relation, returns the current demand description information and the current data, renders and displays a demand analysis page corresponding to the current demand description information, the demand analysis page displays a target demand analysis selection page, the target demand analysis selection page comprises user demand editing information, renders and displays a demand result analysis page corresponding to the current data, and the demand result analysis page displays a query result corresponding to a target query statement.
In one embodiment, the processor, when executing the computer program, further performs the steps of: and acquiring a user demand purpose to determine a corresponding demand analysis type, and acquiring a corresponding data analysis structure according to the demand analysis type.
In one embodiment, the processor, when executing the computer program, further performs the steps of: and taking the user requirement information as a parameter of a data analysis structure to generate corresponding target requirement description information.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: acquiring user requirement editing information in a requirement analysis selection page, wherein the user requirement editing information comprises user requirement information and a user requirement purpose; determining a corresponding data analysis structure according to the user requirement purpose; and generating corresponding target demand description information according to the user demand information and the data analysis structure, wherein the target demand description information is used for generating a corresponding target query statement.
In one embodiment, the processor, when executing the computer program, further performs the steps of: and sending the target requirement description information to the server so that the server generates a corresponding target query statement according to the target requirement description information, querying to obtain target data corresponding to the target query statement, returning the target data, and receiving the target data.
In one embodiment, the processor when executing the computer program further performs the steps of: the server generates a target demand identifier according to the target demand description information, establishes an association relation between the target demand identifier and target data, generates a corresponding sharing link according to the target demand identifier, and broadcasts the sharing link.
In one embodiment, the processor, when executing the computer program, further performs the steps of: the method comprises the steps of obtaining current click operation on a current sharing link, generating a corresponding current sharing request according to the current click operation, and sending the current sharing request to a server, wherein the current sharing request carries a current demand identifier, so that the server obtains corresponding current demand description information according to the current demand identifier, obtains current data corresponding to the current demand identifier according to an incidence relation, returns the current demand description information and the current data, renders and displays a demand analysis page corresponding to the current demand description information, the demand analysis page displays a target demand analysis selection page, the target demand analysis selection page comprises user demand editing information, renders and displays a demand result analysis page corresponding to the current data, and the demand result analysis page displays a query result corresponding to a target query statement.
In one embodiment, the processor, when executing the computer program, further performs the steps of: and acquiring a user demand purpose to determine a corresponding demand analysis type, and acquiring a corresponding data analysis structure according to the demand analysis type.
In one embodiment, the processor, when executing the computer program, further performs the steps of: and taking the user requirement information as a parameter of a data analysis structure to generate corresponding target requirement description information.
In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program: acquiring target requirement description information, wherein the target requirement description information is generated according to user requirement information and a user requirement purpose in user requirement editing information; generating a corresponding target query statement according to the target requirement description information; and querying to obtain target data corresponding to the target query statement.
In one embodiment, the processor when executing the computer program further performs the steps of: acquiring a candidate query statement template set, wherein the candidate query statement template set comprises at least one candidate query statement template, determining a target query statement template from the candidate query statement template set, and generating a corresponding target query statement according to the target query statement template and target requirement description information.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: acquiring target requirement description information, wherein the target requirement description information is generated according to user requirement information and a user requirement purpose in user requirement editing information; generating a corresponding target query statement according to the target requirement description information; and querying to obtain target data corresponding to the target query statement.
In one embodiment, the processor, when executing the computer program, further performs the steps of: acquiring a candidate query statement template set, wherein the candidate query statement template set comprises at least one candidate query statement template, determining a target query statement template from the candidate query statement template set, and generating a corresponding target query statement according to the target query statement template and the target requirement description information. It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above may be implemented by hardware instructions of a computer program, which may be stored in a non-volatile computer-readable storage medium, and when executed, may include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), rambus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
All possible combinations of the technical features in the above embodiments may not be described for the sake of brevity, but should be considered as being within the scope of the present disclosure as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, and these are all within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (8)
1. A query statement generation method, the method comprising:
acquiring user requirement editing information in a requirement analysis selection page, wherein the user requirement editing information comprises user requirement information and a user requirement purpose, the user requirement information is information related to user requirements, and the user requirement purpose is a target and a result of requirement analysis performed by a user;
determining a corresponding data analysis structure according to the user requirement purpose;
generating corresponding target demand description information according to the user demand information and the data analysis structure, wherein the target demand description information is used for generating a corresponding target query statement;
sending the target requirement description information to a server so that the server generates a corresponding target query statement according to the target requirement description information, queries to obtain target data corresponding to the target query statement, and returns the target data;
receiving the target data;
the server generates a target demand identifier according to the target demand description information;
the server establishes an incidence relation between the target demand identification and the target data;
the server generates a corresponding sharing link according to the target demand identification;
the server broadcasts the sharing link.
2. The method of claim 1, further comprising:
acquiring current click operation on a current sharing link, generating a corresponding current sharing request according to the current click operation, and sending the current sharing request to the server, wherein the current sharing request carries a current demand identifier, so that the server acquires corresponding current demand description information according to the current demand identifier, acquires current data corresponding to the current demand identifier according to the association relationship, and returns the current demand description information and the current data;
rendering and displaying a demand analysis page corresponding to the current demand description information, wherein the demand analysis page displays a target demand analysis selection page, and the target demand analysis selection page comprises the user demand editing information;
and rendering and displaying a demand result analysis page corresponding to the current data, wherein the demand result analysis page displays a query result corresponding to the target query statement.
3. The method of claim 1, wherein determining the corresponding data analysis structure according to the user requirement objective comprises:
acquiring the user demand purpose to determine a corresponding demand analysis type;
acquiring a corresponding data analysis structure according to the demand analysis type;
generating corresponding target demand description information according to the user demand information and the data analysis structure, wherein the target demand description information comprises:
and taking the user requirement information as a parameter of a data analysis structure to generate corresponding target requirement description information.
4. A method for data query, the method comprising:
acquiring target demand description information, wherein the target demand description information is generated according to user demand information and a user demand purpose in user demand editing information, the user demand information is information related to user demands, and the user demand purpose is a target and a result of demand analysis performed by a user;
generating a corresponding target query statement according to the target requirement description information;
sending the target demand description information to a server so that the server generates a corresponding target query statement according to the target demand description information, queries to obtain target data corresponding to the target query statement, returns the target data, generates a target demand identifier according to the target demand description information, establishes an association relation between the target demand identifier and the target data, generates a corresponding sharing link according to the target demand identifier, and broadcasts the sharing link;
receiving the target data;
generating a corresponding target query statement according to the target requirement description information includes:
acquiring a candidate query statement template set, wherein the candidate query statement template set comprises at least one candidate query statement template;
determining a corresponding target query statement template from the set of candidate query statement templates;
and generating a corresponding target query statement according to the target query statement template and the target requirement description information.
5. A data query system, the system comprising:
the system comprises a user terminal, a demand analysis selection page and a demand analysis server, wherein the user terminal is used for displaying the demand analysis selection page, editing operation is carried out on the demand analysis selection page to obtain user demand editing information, the user demand editing information comprises user demand information and a user demand purpose, a corresponding data analysis structure is determined according to the user demand purpose, corresponding target demand description information is generated according to the user demand information and the data analysis structure, the target demand description information is sent to an application server, the user demand information is information related to user demand, and the user demand purpose is a target and a result of demand analysis carried out by a user;
the application server is used for receiving the target demand description information, generating a corresponding target query statement according to the target demand description information, sending the target query statement to a query server, generating a target demand identifier according to the target demand description information, establishing an association relation between the target demand identifier and the target data, generating a corresponding sharing link according to the target demand identifier, and broadcasting the sharing link;
the query server is used for querying and obtaining target data corresponding to the target query statement after receiving the target query statement;
the query server is also used for sending the target data to the user terminal;
the user terminal is further configured to render and display a target demand analysis page corresponding to the target demand description information, and render and display a target demand result analysis page corresponding to the target data.
6. An apparatus for generating a query statement, the apparatus comprising:
the user editing information acquisition module is used for acquiring user requirement editing information in a requirement analysis selection page, wherein the user requirement editing information comprises user requirement information and a user requirement purpose, the user requirement information is information related to user requirements, and the user requirement purpose is a target and a result of requirement analysis performed by a user;
the data analysis structure determining module is used for determining a corresponding data analysis structure according to the user requirement purpose;
a requirement description information generation module, configured to generate corresponding target requirement description information according to the user requirement information and the data analysis structure, where the target requirement description information is used to generate a corresponding target query statement;
the device sends the target demand description information to a server so that the server generates a corresponding target query statement according to the target demand description information, queries to obtain target data corresponding to the target query statement, returns the target data, generates a target demand identifier according to the target demand description information, establishes an association relation between the target demand identifier and the target data, generates a corresponding sharing link according to the target demand identifier, and broadcasts the sharing link;
the device receives the target data.
7. A computer arrangement comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any of claims 1 to 4 when executing the computer program.
8. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010046963.0A CN111309991B (en) | 2020-01-16 | 2020-01-16 | Query statement generation method and device and data query method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010046963.0A CN111309991B (en) | 2020-01-16 | 2020-01-16 | Query statement generation method and device and data query method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111309991A CN111309991A (en) | 2020-06-19 |
| CN111309991B true CN111309991B (en) | 2023-03-31 |
Family
ID=71161366
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010046963.0A Active CN111309991B (en) | 2020-01-16 | 2020-01-16 | Query statement generation method and device and data query method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111309991B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112000903B (en) * | 2020-07-03 | 2022-11-18 | 苏宁云计算有限公司 | Data query method and device, computer equipment and storage medium |
| CN112328250B (en) * | 2020-11-17 | 2024-04-05 | 中国平安财产保险股份有限公司 | User interface generation method and device, computer equipment and storage medium |
| CN113069762A (en) * | 2021-03-15 | 2021-07-06 | 广州三七互娱科技有限公司 | Eye image generation method and device of virtual character and electronic equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107766381A (en) * | 2016-08-22 | 2018-03-06 | 北京京东尚科信息技术有限公司 | Data query method, system and electronic equipment |
| CN109062952A (en) * | 2018-06-22 | 2018-12-21 | 北京奇艺世纪科技有限公司 | A kind of data query method, apparatus and electronic equipment |
| CN109284326A (en) * | 2018-11-26 | 2019-01-29 | 北京中创碳投科技有限公司 | A kind of data bank access method and device |
| CN109408526A (en) * | 2018-10-12 | 2019-03-01 | 平安科技（深圳）有限公司 | SQL statement generation method, device, computer equipment and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9594802B2 (en) * | 2014-09-25 | 2017-03-14 | Sap Se | Graphical modeling of database query statements |
-
2020
- 2020-01-16 CN CN202010046963.0A patent/CN111309991B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107766381A (en) * | 2016-08-22 | 2018-03-06 | 北京京东尚科信息技术有限公司 | Data query method, system and electronic equipment |
| CN109062952A (en) * | 2018-06-22 | 2018-12-21 | 北京奇艺世纪科技有限公司 | A kind of data query method, apparatus and electronic equipment |
| CN109408526A (en) * | 2018-10-12 | 2019-03-01 | 平安科技（深圳）有限公司 | SQL statement generation method, device, computer equipment and storage medium |
| CN109284326A (en) * | 2018-11-26 | 2019-01-29 | 北京中创碳投科技有限公司 | A kind of data bank access method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111309991A (en) | 2020-06-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI757743B (en) | Mini program generation method and device | |
| CN111309991B (en) | Query statement generation method and device and data query method and system | |
| CN109901834B (en) | Document page generation method, device, computer equipment and storage medium | |
| CN109815471A (en) | Contract text generation method, device, computer equipment and storage medium | |
| CN110688598B (en) | Service parameter acquisition method and device, computer equipment and storage medium | |
| US11620444B2 (en) | Providing action associated with event detected within communication | |
| CN108959384B (en) | Webpage data acquisition method and device, computer equipment and storage medium | |
| CN110955418A (en) | Code generation method and device, computer equipment and storage medium | |
| CN112000903B (en) | Data query method and device, computer equipment and storage medium | |
| CN111176767A (en) | Table data processing method and device, computer equipment and storage medium | |
| CN110659938A (en) | Method and device for determining promotion channel, computer equipment and storage medium | |
| CN110910475A (en) | Picture editing method and device, computer equipment and storage medium | |
| CN110727777A (en) | Knowledge graph management method and device, computer equipment and storage medium | |
| CN111901383B (en) | Data request processing method, device, computer equipment and storage medium | |
| CN109542962B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN112905936A (en) | Page recording animation generation method, page operation log query method and computer equipment | |
| CN109243249B (en) | Method and device for generating evaluation program | |
| CN115113862A (en) | Method and device for creating derived indexes, electronic equipment and storage medium | |
| CN109871214B (en) | Program code generation method, program code generation device, computer device, and storage medium | |
| CN112346949A (en) | AOP-based operation log recording method and system, electronic device and medium | |
| CN117234512B (en) | Method, system, electronic equipment and storage medium for rapidly developing business | |
| CN111177624A (en) | Website front-back end communication method and device, computer equipment and storage medium | |
| CN109189799B (en) | Service data query method, device, computer equipment and storage medium | |
| CN111882373B (en) | Data operation method and device, computer equipment and storage medium | |
| CN108664341B (en) | Data processing method, data processing device, computer equipment and storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |