CN110968601A - Data query processing method and device - Google Patents
Data query processing method and device Download PDFInfo
- Publication number
- CN110968601A CN110968601A CN201911188064.8A CN201911188064A CN110968601A CN 110968601 A CN110968601 A CN 110968601A CN 201911188064 A CN201911188064 A CN 201911188064A CN 110968601 A CN110968601 A CN 110968601A
- Authority
- CN
- China
- Prior art keywords
- query
- database
- data query
- data
- user
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title abstract description 18
- 238000000034 method Methods 0.000 claims abstract description 78
- 238000012545 processing Methods 0.000 claims description 43
- 230000015654 memory Effects 0.000 claims description 35
- 230000006870 function Effects 0.000 claims description 27
- 238000010586 diagram Methods 0.000 description 20
- 238000003860 storage Methods 0.000 description 17
- 230000008569 process Effects 0.000 description 15
- 230000006872 improvement Effects 0.000 description 9
- 238000004590 computer program Methods 0.000 description 8
- 238000004891 communication Methods 0.000 description 6
- 230000005540 biological transmission Effects 0.000 description 5
- 230000008859 change Effects 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 5
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000000750 progressive effect Effects 0.000 description 3
- OKTJSMMVPCPJKN-UHFFFAOYSA-N Carbon Chemical compound [C] OKTJSMMVPCPJKN-UHFFFAOYSA-N 0.000 description 2
- 238000001514 detection method Methods 0.000 description 2
- 229910021389 graphene Inorganic materials 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 108010001267 Protein Subunits Proteins 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 239000007795 chemical reaction product Substances 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 229920001296 polysiloxane Polymers 0.000 description 1
- 239000000047 product Substances 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000012549 training Methods 0.000 description 1
- 239000013598 vector Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present specification provides a data query processing method and apparatus, where the method may be applied to a web page side, and a user may configure a database required by the user in advance on the web page side, that is, data query of multiple databases may be implemented on one front end. In addition, when the databases are switched, the password does not need to be input, and the database to be queried is selected directly before data query, so that the data query efficiency is improved, and the problem that the data query cannot be carried out due to password forgetting or password error is solved. Meanwhile, the embodiment of the specification also provides an input prompt function, the query key words are predefined, and the input prompt information is displayed for the user based on the data query statement input by the user. The method can help the user to quickly and accurately input the sentences needing to be queried, improves the efficiency and accuracy of data query, is suitable for the user who is not familiar with SQL query, and improves the applicability of SQL query.
Description
Technical Field
The present disclosure relates to computer technologies, and in particular, to a data query processing method and apparatus.
Background
SQL (Structured Query Language) is a special-purpose programming Language that can be understood as a database Query and programming Language that can be used to access data and Query, update, and manage a relational database system, SQL queries being understood as a subset of data retrieved from a database. SQL query in the prior art is usually applied to clients, each client has a fixed database, the format of query language used by each database may be different, the requirement on relevant knowledge of the database is high, and a large amount of training is required before non-professional technicians operate the SQL query. Moreover, when the database needs to be switched, the account password needs to be input again, so that the risk of forgetting the account password exists.
Disclosure of Invention
An object of the embodiments of the present disclosure is to provide a data query processing method and apparatus, which support data query of multiple databases, and do not require to change account passwords when switching databases.
In one aspect, an embodiment of the present specification provides a data query processing method, including:
receiving a data query request, wherein the data query request comprises: selecting a target query database and a data query statement from a pre-configured database;
displaying query prompt information corresponding to the data query statement according to a pre-stored query keyword and the target query database;
and executing the data query statement or the query prompt information selected by the user, acquiring a corresponding query result from the target query database, and returning.
Further, in some embodiments of the present description, the method further comprises:
updating the target query database according to the selection of the user;
and updating the query prompt information based on the updated target query database.
Further, in some embodiments of the present specification, the displaying query prompt information corresponding to the data query statement according to a pre-stored query keyword and the target query database includes:
comparing the query keywords with the data query sentences to obtain the query keywords with the matching degree larger than a preset threshold value as target keywords;
matching the target keywords with the target query database to obtain the target keywords in the target query database;
and generating the query prompt information according to the acquired target keywords in the target query database.
Further, in some embodiments of the present specification, the method for obtaining the query keyword includes:
according to data query sentences in the historical data query requests, sentences or terms with the occurrence frequency larger than a preset threshold value are used as query keywords;
and/or taking the table name queried by the historical data query request as a query key word.
Further, in some embodiments of the present description, the method comprises:
and if the error is reported by executing the data query statement or the query prompt information selected by the user, positioning the error reporting position and displaying a cursor at the error reporting position.
Further, in some embodiments of the present description, the method further comprises:
and setting parameters of the query interface based on the selection of the user.
Further, in some embodiments of the present description, the method further comprises:
and when the data query statement is executed, carrying out grammar rule check on the data query statement, marking statements which do not accord with grammar rules, and displaying correct statement prompt information.
In another aspect, the present specification provides a data query processing apparatus including:
a query request receiving unit, configured to receive a data query request, where the data query request includes: selecting a target query database and a data query statement from a pre-configured database;
the query prompt unit is used for displaying query prompt information corresponding to the data query statement according to a pre-stored query keyword and the target query database;
and the query statement execution unit is used for executing the data query statement or the query prompt information selected by the user, acquiring a corresponding query result from the target query database and returning the query result.
Further, in some embodiments of the present specification, the apparatus further includes a query prompt updating unit configured to:
updating the target query database according to the selection of the user;
and updating the query prompt information based on the updated target query database.
Further, in some embodiments of the present specification, the apparatus further includes an error location unit, configured to:
and if the error is reported by executing the data query statement or the query prompt information selected by the user, positioning the error reporting position and displaying a cursor at the error reporting position.
Further, in some embodiments of the present specification, the apparatus further includes a page customizing unit, configured to:
and setting parameters of the query interface based on the selection of the user.
In yet another aspect, the present specification provides a data query processing system comprising:
the function selection module is used for switching the target query database and operating the SQL data query sentences input by the sentence input module;
the statement input module is used for inputting SQL data query statements and displaying query prompt information according to the input SQL data query statements;
and the result display module is used for displaying the execution information and the execution result of the SQL data query statement.
In yet another aspect, the present specification provides a data query processing device comprising: the data query processing system comprises at least one processor and a memory for storing processor executable instructions, wherein the processor executes the instructions to realize the data query processing method.
In another aspect, an embodiment of the present specification provides a data query processing device, including: the processor executes the instruction, realizes the data query processing method and performs natural language analysis according to word vectors of all words of the text to be processed, which are obtained through optimization.
The data query processing method, device, processing equipment and system provided by the specification can be applied to a Web front end, namely, a webpage end, and a user can configure a required database at the webpage end in advance, namely, data query of a plurality of databases can be realized at one front end. In addition, when the databases are switched, the password does not need to be input, and the database to be queried is selected directly before data query, so that the data query efficiency is improved, and the problem that the data query cannot be carried out due to password forgetting or password error is solved. Meanwhile, the embodiment of the specification also provides an input prompt function, the query key words are predefined, and the input prompt information is displayed for the user based on the data query statement input by the user. The method can help the user to quickly and accurately input the sentences needing to be queried, improves the efficiency and accuracy of data query, is suitable for the user who is not familiar with SQL query, and improves the applicability of SQL query.
Drawings
In order to more clearly illustrate the embodiments of the present specification or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only some embodiments described in the present specification, and for those skilled in the art, other drawings can be obtained according to the drawings without any creative effort.
FIG. 1 is a flow chart illustrating a data query processing method according to an embodiment of the present disclosure;
FIG. 2 is a schematic flow chart of data query in another embodiment of the present disclosure;
FIG. 3 is a block diagram of an embodiment of a data query processing device provided in the present specification;
FIG. 4 is a block diagram of a data query processing device according to another embodiment of the present disclosure;
FIG. 5 is a block diagram of a data query processing device according to another embodiment of the present disclosure;
FIG. 6 is a block diagram of a data query processing device according to another embodiment of the present disclosure;
FIG. 7 is a block diagram of a data query processing system in one embodiment of the present disclosure;
fig. 8 is a block diagram of a hardware configuration of a data query processing server in one embodiment of the present specification.
Detailed Description
In order to make those skilled in the art better understand the technical solutions in the present specification, the technical solutions in the embodiments of the present specification will be clearly and completely described below with reference to the drawings in the embodiments of the present specification, and it is obvious that the described embodiments are only a part of the embodiments of the present specification, and not all of the embodiments. All other embodiments obtained by a person skilled in the art based on the embodiments in the present specification without any inventive step should fall within the scope of protection of the present specification.
SQL queries are usually applied to a client, and embodiments of the present specification provide a data query processing method, which can be applied to a Web front end, that is, a Web page end, and a user can configure a database needed by the user at the Web page end in advance, that is, data queries of multiple databases can be implemented at one front end. Moreover, when the databases are switched, the account number and the password do not need to be input, and the database to be queried is directly selected during data query, so that the data query efficiency is improved, and the problem that the data query cannot be carried out due to password forgetting or password error is solved.
Fig. 1 is a schematic flowchart of a data query processing method in an embodiment of the present specification, and as shown in fig. 1, the data query processing method provided in an embodiment of the present specification may include:
In a specific implementation process, the data query in the embodiment of the present specification may be understood as an SQL query, and may be specifically applied to a front end of a web page, a required database may be configured in the front end of the web page in advance, the number and the type of the configured databases may be adjusted, and the configured databases may be adjusted and updated at any time according to actual needs, for example: adding or deleting a configured database, etc., and the embodiments of the present specification are not particularly limited. When a user uses the front end in the embodiments of the present specification to perform a data query, a data query request may be input at the front end of the web page, where the data query request may include a target query database and a data query statement selected by the user from a database preconfigured by the front end. That is, the user may select which database to perform the data query in the front end, and then input the data query statement, i.e., the SQL query statement, after selecting the database. If the user does not select the target query database during query, the default database selected by the user is regarded as the target query database, or the database during last data query is directly regarded as the target query database.
And 104, displaying the query prompt information corresponding to the data query statement according to the pre-stored query keyword and the target query database.
In a specific implementation process, a data query statement input by a user may be incomplete or inaccurate, fig. 2 is a schematic flow chart of data query in another embodiment of the present specification, and as shown in fig. 2, a query keyword may be stored in advance after a database is configured. After receiving a data query statement input by a user, displaying query prompt information corresponding to the data query statement according to the pre-selected and stored query keyword and a target query database selected by the user. For example: after a user inputs an incomplete query statement, the query keyword with higher matching degree with the incomplete query statement can be obtained from the pre-stored query keywords, and then the query prompt information matched with the query condition of the statement required by the target query database is displayed according to the target query database selected by the user. The number of the query prompt messages can be 1 or more, and the query prompt messages can be sequentially displayed around the input box according to the sequence from high to low matching degree with the data query statement.
The query keyword may include a query sentence, a word, a table name of a database, and the like, and specifically, the corresponding query keyword may be stored according to actual needs.
In some embodiments of the present description, a statement or a term with an occurrence frequency greater than a preset threshold may be used as a query keyword according to a data query statement in a historical data query request, a table name of a database queried in the historical data query request may be used as the query keyword, or the query keyword may be automatically queried according to data query experience of a worker or expert experience, or determined by using other methods. In the embodiment of the present specification, query keywords are defined as completely as possible, so that a better follow-up syntax rule check and code prompt, that is, query prompt, are performed, and the keywords including table names in a database that has been queried can be stored in a cache for more comprehensive code prompt, which is convenient for a user to perform SQL query.
And 106, executing the data query statement or the query prompt information selected by the user, acquiring a corresponding query result from the target query database, and returning.
In a specific implementation process, after the query prompt information is displayed based on the data query statement input by the user, the user can select one of the query prompt information as the input statement according to the actual requirement of the user, execute the corresponding query statement based on the query prompt information selected by the user, acquire the corresponding query result from the target query database selected by the user, and display the query result. Of course, it is also possible that none of the displayed query prompt information is required by the user, and the user may execute the data query statement by using the data query statement input by the user as input without selecting the query prompt information, and correspondingly may obtain a corresponding query result from the target query database selected by the user and display the query result.
In addition, in some embodiments of the present specification, a syntax rule checking function may be further provided, that is, a syntax rule is checked for a data query statement input by a user or a query prompt message selected by the user, and when a syntax or spelling error is checked, a statement that does not conform to the syntax rule may be marked, and a correct statement prompt message may be displayed for reference when the user modifies the statement. The specific content of the grammar rule may be set according to the format requirement of each database or the requirement of SQL language, and the embodiments of the present specification are not specifically limited. The embodiment of the specification provides the check of the grammar rule, can check and prompt the sentence errors input by the user, provides the correct input mode for the user to select by reference, and improves the efficiency of data query and the sentence correctness.
The embodiment of the present specification provides a data query processing method, which can be applied to a Web front end, that is, a Web page end, and a user can configure a database required by the user in advance at the Web page end, that is, data query of multiple databases can be implemented at one front end. Moreover, when the databases are switched, the account number and the password do not need to be input, and the database to be queried is directly selected during data query, so that the data query efficiency is improved, and the problem that the data query cannot be carried out due to password forgetting or password error is solved. Meanwhile, the embodiment of the specification also provides an input prompt function, the query key words are predefined, and the input prompt information is displayed for the user based on the data query statement input by the user. The method can help the user to quickly and accurately input the sentences needing to be queried, improves the efficiency and accuracy of data query, is suitable for the user who is not familiar with SQL query, and improves the applicability of SQL query.
On the basis of the foregoing embodiments, in some embodiments of this specification, the displaying query prompt information corresponding to the data query statement according to a pre-stored query keyword and the target query database includes:
comparing the query keywords with the data query sentences to obtain the query keywords with the matching degree larger than a preset threshold value as target keywords;
matching the target keywords with the target query database to obtain the target keywords in the target query database;
and generating the query prompt information according to the acquired target keywords in the target query database.
In a specific implementation process, when the query prompt information is generated, the pre-cached query keywords may be compared with the data query sentences input by the user one by one, and the query keywords with the matching degree greater than a preset threshold are obtained as target keywords, for example: and if 90% of characters in the query keyword are the same as the characters in the data query sentence input by the user, taking the query keyword as a target keyword. And matching the obtained target keywords with table names, parameters and the like in a target query database to obtain the target keywords existing in the target query database, wherein the target keywords existing in the target query database can be directly used as query prompt information, and the target keywords existing in the target query database can be converted into corresponding formats according to the requirements of the data query format and the like of the target query database to generate the query prompt information.
In the embodiment of the present specification, query prompt information is generated based on a target query database selected by a user, a pre-cached query keyword, and a data query statement input by the user, and the generated query prompt information may be displayed near an input box, so that the user can click according to the user's own needs. The efficiency of data query and the accuracy of input of query sentences are accelerated, the generated query prompt information conforms to the query sentence requirements of the target query database and is also present in the target query database, the probability of obtaining query results is high, the accuracy of the query results is improved, errors in input grammar and the like caused by the fact that a user is unfamiliar with the sentence requirements of each database when in SQL query are avoided, and the method does not need high professional requirements and is suitable for common users.
On the basis of the above embodiments, in some embodiments of the present specification, data may also be switched according to a selection of a user, such as:
updating the target query database according to the selection of the user;
and updating the query prompt information based on the updated target query database.
In a specific implementation process, if a user needs to switch databases in the query process, a new database can be directly selected from the preconfigured databases to serve as a target query database. Such as: when a user carries out SQL query, the database A is selected as a target query database, a data query statement is input, and if the query result is that the user is not satisfied or the user wants to query other databases, the database B can be reselected from a configured database list to be used as the target query database. The switching of the database only needs to select from the configured database list, and the password does not need to be input again when the database is switched. After the target query database is switched to, the query prompt information can be updated according to the data query request input by the user and the query keywords cached in advance. Such as: according to the new target query database, the query keywords and the data query sentences input by the user, the query prompt information meeting the query sentence requirements of the updated target query database is generated, the query prompt information is updated in real time, the user requirements are met, and the problems that the query sentences are wrong and the query fails because the generated query prompt information does not meet the query sentence requirements of the switched database are solved. The query efficiency and the query sentence input accuracy are improved, and the data query result accuracy is further improved.
The method provided by the embodiment of the specification can directly switch the configured databases, does not need to switch account numbers and passwords, does not need to switch clients of different databases, reduces the risk of forgetting the passwords, and saves the operation time of a user. If the database does not need to be switched, the database does not need to be reselected, and the default database and the related code prompting content are provided.
On the basis of the above embodiments, in some embodiments of the present specification, the method includes:
and if the error is reported by executing the data query statement or the query prompt information selected by the user, positioning the error reporting position and displaying a cursor at the error reporting position.
In a specific implementation process, when the data query sentence input by the user or the query prompt information selected by the user is executed to report the error, the error reporting position can be positioned, and the mouse cursor is displayed at the error reporting position to help the user to quickly position and change the error, so that the tedious work of manual inspection is reduced, and the introduction of secondary problems is avoided. The error reporting may be understood as failure in executing the query statement, and may be syntax error of the statement, failure of querying specified content, failure of query data, or the like.
In addition, some embodiments of the present specification may further provide a custom setting function of the query interface, and a user may modify parameters of the query interface at a parameter setting position at the front end of the web page according to a need of the user, such as: the width and height of the input box, the number of the query prompt information displays, the position of the query prompt information displays, the background and font of the query interface, and the like can be set in a user-defined manner, and the content and number of the parameters are not particularly limited in the embodiment of the specification.
The page format of the client-side SQL query is usually fixed and unchangeable, and is set by developers during development, so that users cannot freely change the page format. The SQL query page in the embodiment of the specification can realize personalized customization of the page according to the requirements of the user, and meets the requirements of different users.
According to the data query method provided by the embodiment of the specification, a user can conveniently and quickly look up the contents of a plurality of databases at a webpage end. Mature and complete code prompt function and grammar rule detection can help a user to save the input time of the SQL statement and improve the correctness of the executed statement. If the execution is wrong, the focus of the mouse is automatically positioned to the wrong position of the information report, and the user can be helped to quickly correct the error. Compared with a database client, the method provided by the embodiment of the specification is simpler and easier to operate, the page display can be customized according to different requirements of the user, and the user experience is improved.
In the present specification, each embodiment of the method is described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. The relevant points can be obtained by referring to the partial description of the method embodiment.
Based on the data query processing method, one or more embodiments of the present specification further provide a data query processing device. The apparatus may include systems (including distributed systems), software (applications), modules, components, servers, clients, etc. that use the methods described in the embodiments of the present specification in conjunction with any necessary apparatus to implement the hardware. Based on the same innovative conception, embodiments of the present specification provide an apparatus as described in the following embodiments. Since the implementation scheme of the apparatus for solving the problem is similar to that of the method, the specific apparatus implementation in the embodiment of the present specification may refer to the implementation of the foregoing method, and repeated details are not repeated. As used hereinafter, the term "unit" or "module" may be a combination of software and/or hardware that implements a predetermined function. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated.
Specifically, fig. 3 is a schematic block diagram of an embodiment of a data query processing apparatus provided in this specification, and as shown in fig. 3, the data query processing apparatus provided in this specification may include: a query request receiving unit 31, a query prompting unit 32, and a query statement executing unit 33, wherein:
the query request receiving unit 31 may be configured to receive a data query request, where the data query request includes: selecting a target query database and a data query statement from a pre-configured database;
the query prompt unit 32 may be configured to display query prompt information corresponding to the data query statement according to a pre-stored query keyword and the target query database;
the query statement executing unit 33 may be configured to execute the data query statement or the query prompt information selected by the user, obtain a corresponding query result from the target query database, and return the query result.
The data query processing device provided in the embodiments of the present description may be applied to a Web front end, that is, may be applied to a Web page end, and a user may configure a database required by the user in advance at the Web page end, that is, may implement data query of multiple databases at one front end. In addition, when the databases are switched, the password does not need to be input, and the database to be queried is selected directly before data query, so that the data query efficiency is improved, and the problem that the data query cannot be carried out due to password forgetting or password error is solved. Meanwhile, the embodiment of the specification also provides an input prompt function, the query key words are predefined, and the input prompt information is displayed for the user based on the data query statement input by the user. The method can help the user to quickly and accurately input the sentences needing to be queried, improves the efficiency and accuracy of data query, is suitable for the user who is not familiar with SQL query, and improves the applicability of SQL query.
Fig. 4 is a schematic block diagram of a data query processing apparatus in another embodiment of this specification, and as shown in fig. 4, on the basis of the foregoing embodiment, in some embodiments of this specification, the apparatus further includes a query prompt updating unit 41 for:
updating the target query database according to the selection of the user;
and updating the query prompt information based on the updated target query database.
The embodiment of the specification can directly switch the configured databases without switching accounts and passwords or switching clients of different databases, thereby reducing the risk of forgetting the passwords and saving the operation time of a user. According to the new target query database, the query keywords and the data query sentences input by the user, the query prompt information meeting the query sentence requirements of the updated target query database is generated, the query prompt information is updated in real time, the user requirements are met, and the problems that the query sentences are wrong and the query fails because the generated query prompt information does not meet the query sentence requirements of the switched database are solved. The query efficiency and the query sentence input accuracy are improved, and the data query result accuracy is further improved.
Fig. 5 is a schematic block diagram of a data query processing apparatus in another embodiment of the present specification, and as shown in fig. 5, on the basis of the foregoing embodiment, in some embodiments of the present specification, the apparatus further includes an error reporting positioning unit 51, configured to:
and if the error is reported by executing the data query statement or the query prompt information selected by the user, positioning the error reporting position and displaying a cursor at the error reporting position.
The embodiment of the specification can help a user to quickly position errors and change the errors, reduces the manual complex inspection work, and avoids the introduction of secondary problems.
Fig. 6 is a schematic block diagram of a data query processing apparatus in another embodiment of this specification, and as shown in fig. 6, on the basis of the above embodiment, in some embodiments of this specification, the apparatus further includes a page customizing unit 61, configured to:
and setting parameters of the query interface based on the selection of the user.
The SQL query page of the embodiment of the specification can realize personalized customization of the page according to the requirements of users, and meets the requirements of different users.
It should be noted that the above-described apparatus may also include other embodiments according to the description of the method embodiment. The specific implementation manner may refer to the description of the above corresponding method embodiment, and is not described in detail herein.
Fig. 7 is a schematic block diagram of a data query processing system in an embodiment of the present specification, and as shown in fig. 7, the data query processing system in some embodiments of the present specification may include: a function selection module 71, a sentence input module 72, and a result display module 73, wherein:
the function selection module 71: the user can directly switch the database at the function selection module 71 to operate the sentences input in the sentence input module 72, including running, stopping, emptying, saving, etc.
Sentence input module 72: the user can input the SQL statements to be executed in the statement input module 72, and the syntax checking result will be displayed in the statement input module 72, and the wrong place will be red. The user can also use the code prompt function in the sentence input module 72 to quickly input keywords and table names.
The result display module 73: the result showing module 73 shows the execution information and the execution result of the statement, and can operate on the result.
Specifically, when the user performs the front-end SQL query, the user may select a database in the function selection module 71, store the queried table name in the cache, and prompt the code for standby. The sentence to be executed is input in the sentence input module 72, the input of a plurality of sentences is supported, the input time can be saved by means of a code prompting function, and the grammar detection real-time prompt helps the user to input correctly. When the execution is successful, the result display module 73 displays the execution information and the execution result (if the execution result is a table building statement, the table building statement is stored in a cache, and the code prompt is updated in real time), and if the execution failure result display module 73 displays the failure information.
The data query method, device or system in the embodiments of the present specification configures the databases to be queried in advance, supports various databases, and can continuously expand the number of databases that can be queried, thereby facilitating the use of users. The query key words needing grammar rule check are defined in advance, and a complete query key word library is provided. The content needing code prompting is stored in a cache in advance, the code prompting cache is updated in real time according to the execution statement of the user, and the code prompting content can be updated in real time according to the switched database.
An embodiment of the present specification further provides a data query processing device, including: at least one processor and a memory for storing processor-executable instructions, the processor implementing the data query processing method in the above embodiments when executing the instructions, such as:
receiving a data query request, wherein the data query request comprises: selecting a target query database and a data query statement from a pre-configured database;
displaying query prompt information corresponding to the data query statement according to a pre-stored query keyword and the target query database;
and executing the data query statement or the query prompt information selected by the user, acquiring a corresponding query result from the target query database, and returning.
It should be noted that the above-mentioned processing device may also include other implementations according to the description of the method embodiment. The specific implementation manner may refer to the description of the above corresponding method embodiment, and is not described in detail herein.
The data query processing device or processing equipment provided by the specification can also be applied to various data analysis processing systems. The system or apparatus or processing device may comprise any one of the data query processing apparatus in the above embodiments. The system or apparatus or processing device may be a single server, or may include a server cluster, a system (including a distributed system), software (applications), an actual operation device, a logic gate device, a quantum computer, etc. using one or more of the methods or one or more of the embodiments of the present disclosure, and a terminal device incorporating necessary hardware for implementation. The system for checking for discrepancies may comprise at least one processor and a memory storing computer-executable instructions that, when executed by the processor, implement the steps of the method of any one or more of the embodiments described above.
The method embodiments provided by the embodiments of the present specification can be executed in a mobile terminal, a computer terminal, a server or a similar computing device. Taking an example of the data query processing system running on a server, fig. 8 is a block diagram of a hardware structure of a data query processing server in an embodiment of the present specification, where the server may be a data query processing device or system in the above embodiment. As shown in fig. 8, the server 10 may include one or more (only one shown) processors 100 (the processors 100 may include, but are not limited to, a processing device such as a microprocessor MCU or a programmable logic device FPGA), a memory 200 for storing data, and a transmission module 300 for communication functions. It will be understood by those skilled in the art that the structure shown in fig. 8 is merely an illustration and is not intended to limit the structure of the electronic device. For example, the server 10 may also include more or fewer components than shown in FIG. 8, and may also include other processing hardware, such as a database or multi-level cache, a GPU, or have a different configuration than shown in FIG. 8, for example.
The memory 200 may be used to store software programs and modules of application software, such as program instructions/modules corresponding to the data query processing method in the embodiments of the present specification, and the processor 100 executes various functional applications and resource data updates by running the software programs and modules stored in the memory 200. Memory 200 may include high speed random access memory and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, memory 200 may further include memory located remotely from processor 100, which may be connected to a computer terminal through a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The transmission module 300 is used for receiving or transmitting data via a network. Specific examples of the network described above may include a wireless network provided by a communication provider of the computer terminal. In one example, the transmission module 300 includes a Network adapter (NIC) that can be connected to other Network devices through a base station so as to communicate with the internet. In one example, the transmission module 300 may be a Radio Frequency (RF) module, which is used for communicating with the internet in a wireless manner.
The foregoing description has been directed to specific embodiments of this disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims may be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing may also be possible or may be advantageous.
The method or apparatus provided by the present specification and described in the foregoing embodiments may implement service logic through a computer program and record the service logic on a storage medium, where the storage medium may be read and executed by a computer, so as to implement the effect of the solution described in the embodiments of the present specification.
The storage medium may include a physical device for storing information, and typically, the information is digitized and then stored using an electrical, magnetic, or optical media. The storage medium may include: devices that store information using electrical energy, such as various types of memory, e.g., RAM, ROM, etc.; devices that store information using magnetic energy, such as hard disks, floppy disks, tapes, core memories, bubble memories, and usb disks; devices that store information optically, such as CDs or DVDs. Of course, there are other ways of storing media that can be read, such as quantum memory, graphene memory, and so forth.
The data query processing method or apparatus provided in the embodiments of the present specification may be implemented in a computer by a processor executing corresponding program instructions, for example, implemented in a PC end using a c + + language of a windows operating system, implemented in a linux system, or implemented in an intelligent terminal using android, iOS system programming languages, implemented in processing logic based on a quantum computer, or the like.
It should be noted that descriptions of the apparatus, the computer storage medium, and the system described above according to the related method embodiments may also include other embodiments, and specific implementations may refer to descriptions of corresponding method embodiments, which are not described in detail herein.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the hardware + program class embodiment, since it is substantially similar to the method embodiment, the description is simple, and the relevant points can be referred to only the partial description of the method embodiment.
The embodiments of the present description are not limited to what must be consistent with industry communications standards, standard computer resource data updating and data storage rules, or what is described in one or more embodiments of the present description. Certain industry standards, or implementations modified slightly from those described using custom modes or examples, may also achieve the same, equivalent, or similar, or other, contemplated implementations of the above-described examples. The embodiments using the modified or transformed data acquisition, storage, judgment, processing and the like can still fall within the scope of the alternative embodiments of the embodiments in this specification.
In the 90 s of the 20 th century, improvements in a technology could clearly distinguish between improvements in hardware (e.g., improvements in circuit structures such as diodes, transistors, switches, etc.) and improvements in software (improvements in process flow). However, as technology advances, many of today's process flow improvements have been seen as direct improvements in hardware circuit architecture. Designers almost always obtain the corresponding hardware circuit structure by programming an improved method flow into the hardware circuit. Thus, it cannot be said that an improvement in the process flow cannot be realized by hardware physical modules. For example, a Programmable Logic Device (PLD), such as a Field Programmable Gate Array (FPGA), is an integrated circuit whose Logic functions are determined by programming the Device by a user. A digital system is "integrated" on a PLD by the designer's own programming without requiring the chip manufacturer to design and fabricate application-specific integrated circuit chips. Furthermore, nowadays, instead of manually making an integrated Circuit chip, such Programming is often implemented by "logic compiler" software, which is similar to a software compiler used in program development and writing, but the original code before compiling is also written by a specific Programming Language, which is called Hardware Description Language (HDL), and HDL is not only one but many, such as abel (advanced Boolean Expression Language), ahdl (alternate Language Description Language), traffic, pl (core unified Programming Language), HDCal, JHDL (Java Hardware Description Language), langue, Lola, HDL, laspam, hardsradware (Hardware Description Language), vhjhd (Hardware Description Language), and vhigh-Language, which are currently used in most common. It will also be apparent to those skilled in the art that hardware circuitry that implements the logical method flows can be readily obtained by merely slightly programming the method flows into an integrated circuit using the hardware description languages described above.
The controller may be implemented in any suitable manner, for example, the controller may take the form of, for example, a microprocessor or processor and a computer-readable medium storing computer-readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, an Application Specific Integrated Circuit (ASIC), a programmable logic controller, and an embedded microcontroller, examples of which include, but are not limited to, the following microcontrollers: ARC 625D, Atmel AT91SAM, Microchip PIC18F26K20, and Silicone Labs C8051F320, the memory controller may also be implemented as part of the control logic for the memory. Those skilled in the art will also appreciate that, in addition to implementing the controller as pure computer readable program code, the same functionality can be implemented by logically programming method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers and the like. Such a controller may thus be considered a hardware component, and the means included therein for performing the various functions may also be considered as a structure within the hardware component. Or even means for performing the functions may be regarded as being both a software module for performing the method and a structure within a hardware component.
The systems, devices, modules or units illustrated in the above embodiments may be implemented by a computer chip or an entity, or by a product with certain functions. One typical implementation device is a computer. In particular, the computer may be, for example, a personal computer, a laptop computer, a vehicle-mounted human-computer interaction device, a cellular telephone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
Although one or more embodiments of the present description provide method operational steps as described in the embodiments or flowcharts, more or fewer operational steps may be included based on conventional or non-inventive approaches. The order of steps recited in the embodiments is merely one manner of performing the steps in a multitude of orders and does not represent the only order of execution. When the device or the end product in practice executes, it can execute sequentially or in parallel according to the method shown in the embodiment or the figures (for example, in the environment of parallel processors or multi-thread processing, even in the environment of distributed resource data update). The terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, the presence of additional identical or equivalent elements in a process, method, article, or apparatus that comprises the recited elements is not excluded. The terms first, second, etc. are used to denote names, but not any particular order.
For convenience of description, the above devices are described as being divided into various modules by functions, and are described separately. Of course, when implementing one or more of the present description, the functions of each module may be implemented in one or more software and/or hardware, or a module implementing the same function may be implemented by a combination of multiple sub-modules or sub-units, etc. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable resource data updating apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable resource data updating apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable resource data update apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable resource data update apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage, graphene storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
As will be appreciated by one skilled in the art, one or more embodiments of the present description may be provided as a method, system, or computer program product. Accordingly, one or more embodiments of the present description may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, one or more embodiments of the present description may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
One or more embodiments of the present description may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. One or more embodiments of the present specification can also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for system embodiments, since they are substantially similar to method embodiments, the description is relatively simple, and the relevant points can be referred to only part of the description of the method embodiments. In the description of the specification, reference to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the specification. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
The above description is merely exemplary of one or more embodiments of the present disclosure and is not intended to limit the scope of one or more embodiments of the present disclosure. Various modifications and alterations to one or more embodiments described herein will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement or the like made within the spirit and principle of the present specification should be included in the scope of the claims.
Claims (13)
1. A method for processing data queries, the method comprising:
receiving a data query request, wherein the data query request comprises: selecting a target query database and a data query statement from a pre-configured database;
displaying query prompt information corresponding to the data query statement according to a pre-stored query keyword and the target query database;
and executing the data query statement or the query prompt information selected by the user, acquiring a corresponding query result from the target query database, and returning.
2. The method of claim 1, wherein the method further comprises:
updating the target query database according to the selection of the user;
and updating the query prompt information based on the updated target query database.
3. The method of claim 1, wherein the displaying the query prompt information corresponding to the data query statement according to the pre-stored query keyword and the target query database comprises:
comparing the query keywords with the data query sentences to obtain the query keywords with the matching degree larger than a preset threshold value as target keywords;
matching the target keywords with the target query database to obtain the target keywords in the target query database;
and generating the query prompt information according to the acquired target keywords in the target query database.
4. The method of claim 1, wherein the method for obtaining the query keyword comprises:
according to data query sentences in the historical data query requests, sentences or terms with the occurrence frequency larger than a preset threshold value are used as query keywords;
and/or taking the table name queried by the historical data query request as a query key word.
5. The method of claim 1, wherein the method comprises:
and if the error is reported by executing the data query statement or the query prompt information selected by the user, positioning the error reporting position and displaying a cursor at the error reporting position.
6. The method of claim 1, wherein the method further comprises:
and setting parameters of the query interface based on the selection of the user.
7. The method of claim 1, wherein the method further comprises:
and when the data query statement is executed, carrying out grammar rule check on the data query statement, marking statements which do not accord with grammar rules, and displaying correct statement prompt information.
8. A data query processing apparatus, characterized in that the apparatus comprises:
a query request receiving unit, configured to receive a data query request, where the data query request includes: selecting a target query database and a data query statement from a pre-configured database;
the query prompt unit is used for displaying query prompt information corresponding to the data query statement according to a pre-stored query keyword and the target query database;
and the query statement execution unit is used for executing the data query statement or the query prompt information selected by the user, acquiring a corresponding query result from the target query database and returning the query result.
9. The apparatus of claim 8, wherein the apparatus further comprises a query prompt update unit to:
updating the target query database according to the selection of the user;
and updating the query prompt information based on the updated target query database.
10. The apparatus of claim 8, wherein the apparatus further comprises an error location unit to:
and if the error is reported by executing the data query statement or the query prompt information selected by the user, positioning the error reporting position and displaying a cursor at the error reporting position.
11. The apparatus of claim 8, wherein the apparatus further comprises a page customization unit to:
and setting parameters of the query interface based on the selection of the user.
12. A data query processing system, comprising:
the function selection module is used for switching the target query database and operating the SQL data query sentences input by the sentence input module;
the statement input module is used for inputting SQL data query statements and displaying query prompt information according to the input SQL data query statements;
and the result display module is used for displaying the execution information and the execution result of the SQL data query statement.
13. A data query processing device, comprising: at least one processor and a memory for storing processor-executable instructions, the processor implementing the method of any one of claims 1-7 when executing the instructions.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911188064.8A CN110968601A (en) | 2019-11-28 | 2019-11-28 | Data query processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911188064.8A CN110968601A (en) | 2019-11-28 | 2019-11-28 | Data query processing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110968601A true CN110968601A (en) | 2020-04-07 |
Family
ID=70031995
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911188064.8A Pending CN110968601A (en) | 2019-11-28 | 2019-11-28 | Data query processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110968601A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111767297A (en) * | 2020-06-30 | 2020-10-13 | 平安国际智慧城市科技股份有限公司 | Big data processing method, device, equipment and medium |
| CN111857688A (en) * | 2020-07-22 | 2020-10-30 | 中国平安财产保险股份有限公司 | SQL code automatic completion method, system and storage medium |
| CN112069203A (en) * | 2020-09-22 | 2020-12-11 | 北京百家科技集团有限公司 | Data query method and device |
| CN112131247A (en) * | 2020-09-30 | 2020-12-25 | 中国银行股份有限公司 | Method and device for safety isolation of host data query |
| CN112199387A (en) * | 2020-11-16 | 2021-01-08 | 广州速威智能系统科技有限公司 | Method and system for processing database query statement |
| CN112632110A (en) * | 2021-01-06 | 2021-04-09 | 上海合合信息科技股份有限公司 | Data extraction method and device for automatically generating query statement |
| CN113517047A (en) * | 2021-06-08 | 2021-10-19 | 联仁健康医疗大数据科技股份有限公司 | Medical data acquisition method and device, electronic equipment and storage medium |
| CN113672781A (en) * | 2021-08-20 | 2021-11-19 | 平安国际智慧城市科技股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN114328572A (en) * | 2020-09-28 | 2022-04-12 | 北京鸿享技术服务有限公司 | Data query method, device, system and medium based on SQL parser |
| US11599532B1 (en) | 2021-08-11 | 2023-03-07 | Amdocs Development Limited | System, method, and computer program for preventing user mistakes when making database changes |
| CN117235107A (en) * | 2023-11-10 | 2023-12-15 | 恒生电子股份有限公司 | Data access processing method and device, electronic equipment and storage medium |
| CN117251473A (en) * | 2023-11-20 | 2023-12-19 | 摩斯智联科技有限公司 | Vehicle data query analysis method, system, device and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170185673A1 (en) * | 2015-12-25 | 2017-06-29 | Le Holdings (Beijing) Co., Ltd. | Method and Electronic Device for QUERY RECOMMENDATION |
| CN108846037A (en) * | 2018-05-29 | 2018-11-20 | 天津字节跳动科技有限公司 | The method and apparatus of prompting search word |
| CN109408526A (en) * | 2018-10-12 | 2019-03-01 | 平安科技（深圳）有限公司 | SQL statement generation method, device, computer equipment and storage medium |
| CN109710655A (en) * | 2018-11-09 | 2019-05-03 | 中国平安人寿保险股份有限公司 | Data base query method, device, terminal device and storage medium |
| CN109840257A (en) * | 2018-12-15 | 2019-06-04 | 中国平安人寿保险股份有限公司 | Data base query method, device, computer installation and readable storage medium storing program for executing |
-
2019
- 2019-11-28 CN CN201911188064.8A patent/CN110968601A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170185673A1 (en) * | 2015-12-25 | 2017-06-29 | Le Holdings (Beijing) Co., Ltd. | Method and Electronic Device for QUERY RECOMMENDATION |
| CN108846037A (en) * | 2018-05-29 | 2018-11-20 | 天津字节跳动科技有限公司 | The method and apparatus of prompting search word |
| CN109408526A (en) * | 2018-10-12 | 2019-03-01 | 平安科技（深圳）有限公司 | SQL statement generation method, device, computer equipment and storage medium |
| CN109710655A (en) * | 2018-11-09 | 2019-05-03 | 中国平安人寿保险股份有限公司 | Data base query method, device, terminal device and storage medium |
| CN109840257A (en) * | 2018-12-15 | 2019-06-04 | 中国平安人寿保险股份有限公司 | Data base query method, device, computer installation and readable storage medium storing program for executing |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111767297A (en) * | 2020-06-30 | 2020-10-13 | 平安国际智慧城市科技股份有限公司 | Big data processing method, device, equipment and medium |
| CN111767297B (en) * | 2020-06-30 | 2023-07-04 | 深圳平安智慧医健科技有限公司 | Big data processing method, device, equipment and medium |
| CN111857688A (en) * | 2020-07-22 | 2020-10-30 | 中国平安财产保险股份有限公司 | SQL code automatic completion method, system and storage medium |
| CN112069203A (en) * | 2020-09-22 | 2020-12-11 | 北京百家科技集团有限公司 | Data query method and device |
| CN114328572A (en) * | 2020-09-28 | 2022-04-12 | 北京鸿享技术服务有限公司 | Data query method, device, system and medium based on SQL parser |
| CN112131247A (en) * | 2020-09-30 | 2020-12-25 | 中国银行股份有限公司 | Method and device for safety isolation of host data query |
| CN112199387A (en) * | 2020-11-16 | 2021-01-08 | 广州速威智能系统科技有限公司 | Method and system for processing database query statement |
| CN112632110A (en) * | 2021-01-06 | 2021-04-09 | 上海合合信息科技股份有限公司 | Data extraction method and device for automatically generating query statement |
| CN113517047A (en) * | 2021-06-08 | 2021-10-19 | 联仁健康医疗大数据科技股份有限公司 | Medical data acquisition method and device, electronic equipment and storage medium |
| US11599532B1 (en) | 2021-08-11 | 2023-03-07 | Amdocs Development Limited | System, method, and computer program for preventing user mistakes when making database changes |
| CN113672781A (en) * | 2021-08-20 | 2021-11-19 | 平安国际智慧城市科技股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN117235107A (en) * | 2023-11-10 | 2023-12-15 | 恒生电子股份有限公司 | Data access processing method and device, electronic equipment and storage medium |
| CN117235107B (en) * | 2023-11-10 | 2024-01-26 | 恒生电子股份有限公司 | Data access processing method and device, electronic equipment and storage medium |
| CN117251473A (en) * | 2023-11-20 | 2023-12-19 | 摩斯智联科技有限公司 | Vehicle data query analysis method, system, device and storage medium |
| CN117251473B (en) * | 2023-11-20 | 2024-03-15 | 摩斯智联科技有限公司 | Vehicle data query analysis method, system, device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110968601A (en) | Data query processing method and device | |
| CN107239479B (en) | Block chain based data storage and query method and device | |
| CN107562467B (en) | Page rendering method, device and equipment | |
| CN107526777B (en) | Method and equipment for processing file based on version number | |
| US10169471B2 (en) | Generating and executing query language statements from natural language | |
| CN110765247B (en) | Input prompting method and device for question-answering robot | |
| CN111881019B (en) | User interface testing method and device | |
| CN107391101B (en) | Information processing method and device | |
| CN110032409B (en) | Client screen adapting method and device and electronic equipment | |
| CN110955428A (en) | Page display method and device, electronic equipment and medium | |
| CN107622080B (en) | Data processing method and equipment | |
| CN109241026B (en) | Data management method, device and system | |
| US10372760B2 (en) | Building queries directed to objects hosted on clouds | |
| CN115982416A (en) | Data processing method and device, readable storage medium and electronic equipment | |
| CN111190905A (en) | Database table processing method and device and electronic equipment | |
| CN117194389A (en) | SQL-based database compatibility method and device, electronic equipment and storage medium | |
| CN111967269A (en) | Business risk identification method and device and electronic equipment | |
| CN116028062A (en) | Target code generation method, NPU instruction display method and device | |
| CN116185389A (en) | Code generation method and device, electronic equipment and medium | |
| CN115390852A (en) | Method and device for generating uniform abstract syntax tree and program analysis | |
| CN110704742B (en) | Feature extraction method and device | |
| CN117015781A (en) | Generating a natural language interface from a graphical user interface | |
| CN112988986B (en) | Man-machine interaction method, device and equipment | |
| CN112835494A (en) | Voice recognition result error correction method and device | |
| CN110990421A (en) | Data query method, device and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200407 |