CN115658731A - Data query method, device, equipment and storage medium - Google Patents
Data query method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN115658731A CN115658731A CN202211310718.1A CN202211310718A CN115658731A CN 115658731 A CN115658731 A CN 115658731A CN 202211310718 A CN202211310718 A CN 202211310718A CN 115658731 A CN115658731 A CN 115658731A
- Authority
- CN
- China
- Prior art keywords
- data
- query
- query statement
- target
- name
- 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
Images
Abstract
The application discloses a data query method, a device, equipment and a storage medium, wherein the method comprises the following steps: acquiring data characteristics of drive test data from a plurality of data sources for aggregation, and writing the aggregated data characteristics into a new database, wherein the data characteristics comprise data names, data types and data sources; after a user determines a first query statement for querying target drive test data, verifying the first query statement, wherein the first query statement comprises a data name; if the verification is successful, a second query statement corresponding to the target data source is generated according to the target data source and the target data type which are determined in the new database by the first query statement, the target drive test data is queried in the target data source through the second query statement to obtain a query result, and the technical problem of low query efficiency when data query is carried out in different data sources in the prior art is solved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a data query method, apparatus, device, and storage medium.
Background
In an automatic driving scenario, each road test generates a large amount of metadata including logs, radar data, image data, etc., which may be stored in different ways and in different data sources due to different data types. When data screening, data mining and other work need to be carried out on the data, the data are stored in different data sources, the data query modes of the data sources are different, query needs to be carried out on the data sources, and the problem of low query efficiency exists.
Disclosure of Invention
The application provides a data query method, a data query device, data query equipment and a storage medium, which are used for solving the technical problem of low query efficiency when data query is performed in different data sources in the prior art.
In view of the above, a first aspect of the present application provides a data query method, including:
acquiring data characteristics of drive test data from a plurality of data sources for aggregation, and writing the aggregated data characteristics into a new database, wherein the data characteristics comprise data names, data types and data sources;
after a user determines a first query statement for querying target drive test data, verifying the first query statement, wherein the first query statement comprises a data name;
and if the verification is successful, analyzing and generating a second query statement corresponding to the target data source according to the target data source and the target data type determined by the first query statement in the new database, and querying the target drive test data in the target data source through the second query statement to obtain a query result.
Optionally, the query language corresponding to the first query statement includes a data group, a constant, a logical operation, and an arithmetic operation, the data group includes a data class and a data name, and the data class includes a class name, a data source, a data name, a data type, and a data check logic.
Optionally, after the user determines a first query statement used for querying the target drive test data, the first query statement is verified, and before the verifying, the method further includes:
when a user inputs characters for inquiring target drive test data in a search box, matching class names and data names which are closest to the characters in the new database, and returning an obtained matching result to the user so that the user can determine a first inquiry statement according to the matching result.
Optionally, the checking the first query statement includes:
matching the class name in the first query statement with a pre-defined class name in a query language;
if the class name in the first query statement cannot be matched with the consistent class name, judging that the verification fails;
if the class name in the first query statement is matched with a consistent class name, determining a corresponding target data source in the new database according to the class name and the data name in the first query statement, and performing data type verification according to the class name in the first query statement and the target data source;
if the data type verification is passed, the verification is judged to be successful, and if the data type verification is not passed, the verification is judged to be failed.
Optionally, the performing data type checking according to the class name in the first query statement and the target data source includes:
determining a corresponding target data type in the new database according to the class name in the first query statement and the target data source;
and checking the data type corresponding to the first query statement according to the target data type, if the data type corresponding to the first query statement is checked to be consistent with the target data type, passing the data type check, and if the data type corresponding to the first query statement is checked to be inconsistent with the target data type, failing to pass the data type check.
Optionally, the method further includes:
and acquiring new data characteristics from a plurality of data sources at regular time to update the new database, and updating the data types of all the data classes.
A second aspect of the present application provides a data query apparatus, including:
the device comprises an aggregation unit, a data processing unit and a data processing unit, wherein the aggregation unit is used for acquiring data characteristics of the drive test data from a plurality of data sources for aggregation and writing the aggregated data characteristics into a new database, and the data characteristics comprise data names, data types and data sources;
the device comprises a checking unit, a judging unit and a judging unit, wherein the checking unit is used for checking a first query statement for querying target drive test data after a user determines the first query statement, and the first query statement comprises a data name;
and the query unit is used for analyzing and generating a second query statement corresponding to the target data source according to the target data source and the target data type determined by the first query statement in the new database if the verification is successful, and querying the target drive test data in the target data source through the second query statement to obtain a query result.
Optionally, the query language corresponding to the first query statement includes a data group, a constant, a logical operation, and an arithmetic operation, the data group includes a data class and a data name, and the data class includes a class name, a data source, a data name, a data type, and a data check logic.
A third aspect of the present application provides a data querying device, comprising a processor and a memory;
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to execute the data query method of any of the first aspect according to instructions in the program code.
A fourth aspect of the present application provides a computer-readable storage medium for storing program code, which when executed by a processor implements the data query method of any one of the first aspects.
According to the technical scheme, the method has the following advantages:
the application provides a data query method, which comprises the following steps: acquiring data characteristics of drive test data from a plurality of data sources for aggregation, and writing the aggregated data characteristics into a new database, wherein the data characteristics comprise data names, data types and data sources; after a user determines a first query statement for querying target drive test data, verifying the first query statement, wherein the first query statement comprises a data name; and if the verification is successful, analyzing and generating a second query statement corresponding to the target data source according to the target data source and the target data type determined by the first query statement in the new database, and querying the target drive test data in the target data source through the second query statement to obtain a query result.
According to the method and the device, data characteristics of the drive test data, such as data names, data sources and data types, are extracted from a plurality of data sources, are aggregated and stored in a new database, after a first query statement input by a user is successfully verified, a target data source and a target data type corresponding to target drive test data are queried in the new database according to the first query statement, so that the target data source where the target drive test data is located and the target data type corresponding to the target data source are determined, and then a second query statement corresponding to the target data source is generated through analysis according to the target data source and the target data type, so that the target drive test data are queried in the target data source through the second query statement, the situation that the user queries data in each data source one by one is avoided, the query time is shortened, the query efficiency is improved, and the technical problem of low query efficiency existing in the prior art when data query is conducted in different data sources is solved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the description below are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without inventive labor.
Fig. 1 is a schematic flowchart of a data query method according to an embodiment of the present application;
fig. 2 is another schematic flow chart of a data query method according to an embodiment of the present application;
fig. 3 is a schematic structural diagram of a data query device according to an embodiment of the present application.
Detailed Description
In order to make the technical solutions of the present application better understood, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
For easy understanding, please refer to fig. 1, an embodiment of the present application provides a data query method, applied to a server, including:
The server can obtain data characteristics of the drive test data from a plurality of data sources, wherein the data characteristics include data types, data names, data sources, data ranges and the like, the data range of the numerical type data comprises an upper limit and a lower limit, and the data range of the Boolean type data comprises True (True) and False (False); and aggregating the acquired data characteristics, and writing the aggregated data characteristics into a new database, wherein each data type corresponds to a check mode, for example, the check mode corresponding to the integer data is to check whether the input is a number, and the check mode corresponding to the boolean data is to check whether the input is True or False. And configuring a corresponding verification mode for each data type, wherein the functions are that different data sources have different processing modes for different types of data, and different query statements are generated according to different data types during query.
In order to unify data of all data sources, a corresponding query language is constructed in the embodiment of the application, the query language comprises a data group, a constant, a logical operation and an arithmetic operation, the data group comprises a data class and a data name, and a built-in data class check and a data type check are provided; the data class comprises a class name, a data source, a data name, a data type and data check logic, wherein the data source, the data type and the data check logic are private attributes.
When a user queries target drive test data, a class name and a data name of a corresponding data class can be input in a search box to serve as a first query statement. Certainly, the user may also input a limiting condition for querying the target drive test data, such as a numerical range (e.g., > 2), a string fuzzy matching, a regular expression, and the like, and a logical operation of each limiting condition, the front end may send the first query statement input by the user to the server, the server may analyze the first query statement, and if the first query statement input by the user includes a class name, a data name, the limiting condition, and the logical operation of the limiting condition, the server may further screen the limiting condition on the basis of the class name and the data name, and perform a corresponding logical operation on the limiting condition.
Before the server analyzes the first query statement, the server checks the first query statement to verify whether the user inputs a correct query statement, and the specific checking process may be as follows:
matching the class name in the first query statement with a pre-defined class name in a query language;
if the class names in the first query statement cannot be matched with the consistent class names, judging that the verification fails;
if the class name in the first query statement is matched with the consistent class name, determining a corresponding target data source in the new database according to the class name and the data name in the first query statement, and performing data type verification according to the class name and the target data source in the first query statement;
if the data type verification is passed, the verification is judged to be successful, and if the data type verification is not passed, the verification is judged to be failed.
After the server side obtains the first query statement, matching is carried out according to the class name in the first query statement and the class name which is predefined when the query language is constructed, if the consistent class name cannot be matched, the first query statement is illegal, the input class name is wrong, data cannot be queried based on the class name in the first query statement, at the moment, the verification fails, and error information can be returned to the user, so that the user can correct or input the query statement again. If the consistent class name can be matched, it is indicated that the class name in the input first query statement is correct, and at this time, the server may retrieve a target data source corresponding to the class name and the data name in the new database according to the class name and the data name in the first query statement.
After the target data source is determined, data type verification may be performed according to the class name in the first query statement and the corresponding target data source, and the data type verification process may be:
determining a corresponding target data type in a new database according to the class name and the target data source in the first query statement;
and checking the data type corresponding to the first query statement according to the target data type, if the data type corresponding to the first query statement is checked to be consistent with the target data type, passing the data type check, and if the data type corresponding to the first query statement is checked to be inconsistent with the target data type, failing to pass the data type check.
According to the class name in the first query statement and the corresponding target data source, the data type corresponding to the target data source can be searched in the new database, and therefore the target data type is determined; and then, checking whether the data type corresponding to the first query statement is consistent with the target data type or not according to the target data type, namely, checking the data type of the first query statement according to a checking mode corresponding to the target data type. For example, the first query statement input by the user is city guangzhou, the corresponding target data type is determined to be a character string according to the class name city, and when data type verification is performed, it is verified that the data name guangzhou input by the user is the character string, and at this time, it is determined that the data type verification is passed; if the first query statement input by the user is a leave shanghai, the corresponding target data type is determined to be a numerical value according to the class name level, when data type verification is carried out, it is verified that the shanghai input by the user is not the numerical value, at this moment, it is judged that the data type verification fails, namely, the verification fails, and error information can be returned to the user.
And 103, if the verification is successful, analyzing the target data source and the target data type determined in the new database according to the first query statement to generate a second query statement corresponding to the target data source, and querying the target drive test data in the target data source through the second query statement to obtain a query result.
If the first query statement is successfully verified, the server side analyzes the first query statement according to the target data source and the target data type determined in the verification process to generate a second query statement corresponding to the target data source, the different data sources have different processing modes for the different data types, the corresponding second query statement is generated according to the data type corresponding to the target data source during query, and the query mode corresponding to each data source is known, so that the server side can determine the query mode corresponding to the target data source according to the target data source and the target data type, and then generate the second query statement corresponding to the target data source according to the query mode and the query field in the first query statement, so that the server side can search in the target data source through the second query statement, and after the target drive test data is queried, the query result is finally returned to the user.
In the embodiment of the application, data characteristics of drive test data such as data names, data sources and data types are extracted from a plurality of data sources, the data characteristics are aggregated and stored in a new database, after a first query statement input by a user is successfully verified, a target data source and a target data type corresponding to target drive test data are queried in the new database according to the first query statement, so that the target data source where the target drive test data is located and the target data type corresponding to the target data source are determined, and then a second query statement corresponding to the target data source is generated by analysis according to the target data source and the target data type, so that the target drive test data is queried in the target data source, the situation that the user queries data in the data sources one by one is avoided, the query time is shortened, the query efficiency is improved, and the technical problem of low query efficiency existing in the prior art when data query is performed in different data sources is solved.
The above is an embodiment of the data query method provided by the present application, and the following is another embodiment of the data query method provided by the present application.
Referring to fig. 2, a data query method provided in an embodiment of the present application includes:
The server can obtain data characteristics of the drive test data from a plurality of data sources, wherein the data characteristics comprise data types, data names, data sources, data ranges and the like, the data range of the numerical type data comprises an upper limit and a lower limit, and the data range of the Boolean type data comprises True (True) and False (False); and aggregating the acquired data characteristics, and writing the aggregated data characteristics into a new database, wherein each data type corresponds to a check mode, for example, the check mode corresponding to the integer data is to check whether the input is a number, and the check mode corresponding to the boolean data is to check whether the input is True or False. And configuring a corresponding verification mode for each data type, wherein the functions are that different data sources have different processing modes for different types of data, and different query statements are generated according to different data types during query.
Further, the server can acquire new data characteristics from a plurality of data sources at regular time to update the new database, and update the data types and the verification modes of all the data classes at the same time.
In the embodiment of the application, the class names of some data classes are considered to be long, and may be as many as 20 English characters, so that a user is difficult to accurately memorize the class names of all the data classes, and related data cannot be queried by inputting wrong class names, thereby resulting in low query efficiency. In order to improve the problem, the server in the embodiment of the present application may provide a data completion function, and provide a data name and a class name of specific metadata for a user. Specifically, when a user inputs characters for inquiring target drive test data in a search box, the front end can send the currently input characters to the server in real time, the server performs fuzzy matching on the characters according to information in the new database, returns a matching result of a class name and a data name which are closest to the characters, and returns the matching result to the user, so that reference is provided for the user, the possibility of inquiry errors is reduced, and the inquiry efficiency is improved. For example, when the user inputs the character city g, the server may match in the new database according to the character city g to obtain matching results such as city guingzhou, city guilin, city ganzhou, and the like, and the server returns the matching results to the user for reference, so that the possibility that the user inputs an incorrect query field is reduced, and the query efficiency is improved.
And 204, if the verification is successful, analyzing the target data source and the target data type determined in the new database according to the first query statement to generate a second query statement corresponding to the target data source, and querying the target drive test data in the target data source through the second query statement to obtain a query result.
The specific contents in steps 203 to 204 are the same as those in steps 102 to 103 in the foregoing steps, and are not described herein again.
In the embodiment of the application, data characteristics of drive test data such as data names, data sources and data types are extracted from a plurality of data sources, the data characteristics are aggregated and stored in a new database, after a first query statement input by a user is successfully verified, a target data source and a target data type corresponding to target drive test data are queried in the new database according to the first query statement, so that the target data source where the target drive test data is located and the target data type corresponding to the target data source are determined, and then a second query statement corresponding to the target data source is generated by analysis according to the target data source and the target data type, so that the target drive test data is queried in the target data source, the situation that the user queries data in the data sources one by one is avoided, the query time is shortened, the query efficiency is improved, and the technical problem of low query efficiency existing in the prior art when data query is performed in different data sources is solved.
Furthermore, the embodiment of the application can provide a data completion function according to characters input by a user, provide data names and class names of specific metadata for the user, reduce the possibility of query errors and improve the query efficiency.
The above is another embodiment of a data query method provided by the present application, and the following is an embodiment of a data query device provided by the present application.
Referring to fig. 3, an embodiment of the present application provides a data query apparatus, including:
the aggregation unit is used for acquiring data characteristics of the drive test data from a plurality of data sources for aggregation and writing the aggregated data characteristics into a new database, wherein the data characteristics comprise data names, data types and data sources;
the verification unit is used for verifying a first query statement used for querying target drive test data after a user determines the first query statement, wherein the first query statement comprises a data name;
and the query unit is used for analyzing and generating a second query statement corresponding to the target data source according to the target data source and the target data type determined by the first query statement in the new database if the verification is successful, and querying the target drive test data in the target data source through the second query statement to obtain a query result.
As a further improvement, the query language corresponding to the first query statement includes a data group, a constant, a logical operation and an arithmetic operation, the data group includes a data class and a data name, and the data class includes a class name, a data source, a data name, a data type and a data check logic.
As a further improvement, the method also comprises the following steps:
and the matching unit is used for matching the class name and the data name which are closest to the characters in the new database when the user inputs the characters for inquiring the target drive test data in the search box, and returning the obtained matching result to the user so that the user can determine a first inquiry statement according to the matching result.
As a further improvement, the verification unit is specifically configured to:
matching the class name in the first query statement with a pre-defined class name in a query language;
if the class names in the first query statement cannot be matched with the consistent class names, judging that the verification fails;
if the class name in the first query statement is matched with the consistent class name, determining a corresponding target data source in the new database according to the class name and the data name in the first query statement, and performing data type verification according to the class name and the target data source in the first query statement;
if the data type verification is passed, the verification is judged to be successful, and if the data type verification is not passed, the verification is judged to be failed.
As a further improvement, the method further comprises the following steps:
and the updating unit is used for acquiring new data characteristics from a plurality of data sources at regular time to update the new database and updating the data types of all the data classes at the same time.
In the embodiment of the application, data characteristics of drive test data such as data names, data sources and data types are extracted from a plurality of data sources, the data characteristics are aggregated and stored in a new database, after a first query statement input by a user is successfully verified, a target data source and a target data type corresponding to target drive test data are queried in the new database according to the first query statement, so that the target data source where the target drive test data is located and the target data type corresponding to the target data source are determined, and then a second query statement corresponding to the target data source is generated by analysis according to the target data source and the target data type, so that the target drive test data is queried in the target data source, the situation that the user queries data in the data sources one by one is avoided, the query time is shortened, the query efficiency is improved, and the technical problem of low query efficiency existing in the prior art when data query is performed in different data sources is solved.
Furthermore, the embodiment of the application can provide a data completion function according to characters input by a user, provide data names and class names of specific metadata for the user, reduce the possibility of query errors and improve the query efficiency.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
The terms "first," "second," "third," "fourth," and the like in the description of the application and the above-described figures, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are, for example, capable of operation in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
It should be understood that in the present application, "at least one" means one or more, "a plurality" means two or more. "and/or" for describing an association relationship of associated objects, indicating that there may be three relationships, e.g., "a and/or B" may indicate: only A, only B and both A and B are present, wherein A and B may be singular or plural. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship. "at least one of the following" or similar expressions refer to any combination of these items, including any combination of single item(s) or plural items. For example, at least one (one) of a, b, or c, may represent: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", wherein a, b, c may be single or plural.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments 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 units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for executing all or part of the steps of the method described in the embodiments of the present application through a computer device (which may be a personal computer, a server, or a network device). And the aforementioned storage medium includes: a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions in the embodiments of the present application.
Claims (10)
1. A method for querying data, the method comprising:
acquiring data characteristics of drive test data from a plurality of data sources for aggregation, and writing the aggregated data characteristics into a new database, wherein the data characteristics comprise data names, data types and data sources;
after a user determines a first query statement for querying target drive test data, verifying the first query statement, wherein the first query statement comprises a data name;
and if the verification is successful, analyzing and generating a second query statement corresponding to the target data source according to the target data source and the target data type determined by the first query statement in the new database, and querying the target drive test data in the target data source through the second query statement to obtain a query result.
2. The data query method according to claim 1, wherein the query language corresponding to the first query statement includes a data group, a constant, a logical operation and an arithmetic operation, the data group includes a data class and a data name, and the data class includes a class name, a data source, a data name, a data type and a data check logic.
3. The data query method according to claim 2, wherein the checking the first query statement after the user determines the first query statement for querying the target drive test data further comprises:
when a user inputs characters for inquiring target drive test data in a search box, matching class names and data names which are closest to the characters in the new database, and returning an obtained matching result to the user so that the user can determine a first inquiry statement according to the matching result.
4. The data query method of claim 2 or 3, wherein the checking the first query statement comprises:
matching the class name in the first query statement with a pre-defined class name in a query language;
if the class names in the first query statement cannot be matched with the consistent class names, judging that the verification fails;
if the class name in the first query statement is matched with the consistent class name, determining a corresponding target data source in the new database according to the class name and the data name in the first query statement, and performing data type verification according to the class name in the first query statement and the target data source;
if the data type verification is passed, the verification is judged to be successful, and if the data type verification is not passed, the verification is judged to be failed.
5. The data query method of claim 4, wherein the performing data type checking according to the class name in the first query statement and the target data source comprises:
determining a corresponding target data type in the new database according to the class name in the first query statement and the target data source;
and checking the data type corresponding to the first query statement according to the target data type, if the data type corresponding to the first query statement is checked to be consistent with the target data type, passing the data type check, and if the data type corresponding to the first query statement is checked to be inconsistent with the target data type, failing to pass the data type check.
6. The data query method of claim 2, further comprising:
and acquiring new data characteristics from a plurality of data sources at regular time to update the new database, and updating the data types of all the data classes at the same time.
7. A data query apparatus, comprising:
the device comprises an aggregation unit, a data processing unit and a data processing unit, wherein the aggregation unit is used for acquiring data characteristics of drive test data from a plurality of data sources for aggregation and writing the aggregated data characteristics into a new database, and the data characteristics comprise data names, data types and data sources;
the verification unit is used for verifying a first query statement used for querying target drive test data after a user determines the first query statement, wherein the first query statement comprises a data name;
and the query unit is used for analyzing and generating a second query statement corresponding to the target data source according to the target data source and the target data type determined by the first query statement in the new database if the verification is successful, and querying the target drive test data in the target data source through the second query statement to obtain a query result.
8. The apparatus according to claim 7, wherein the query language corresponding to the first query statement includes a data group, a constant, a logical operation, and an arithmetic operation, the data group includes a data class and a data name, and the data class includes a class name, a data source, a data name, a data type, and a data check logic.
9. A data querying device, characterized in that the device comprises a processor and a memory;
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to execute the data query method of any one of claims 1-6 according to instructions in the program code.
10. A computer-readable storage medium for storing program code, the program code implementing the data query method of any one of claims 1-6 when executed by a processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211310718.1A CN115658731A (en) | 2022-10-25 | 2022-10-25 | Data query method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211310718.1A CN115658731A (en) | 2022-10-25 | 2022-10-25 | Data query method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115658731A true CN115658731A (en) | 2023-01-31 |
Family
ID=84992041
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211310718.1A Pending CN115658731A (en) | 2022-10-25 | 2022-10-25 | Data query method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115658731A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116401177A (en) * | 2023-06-09 | 2023-07-07 | 瀚高基础软件股份有限公司 | DDL correctness detection method, device and medium |
-
2022
- 2022-10-25 CN CN202211310718.1A patent/CN115658731A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116401177A (en) * | 2023-06-09 | 2023-07-07 | 瀚高基础软件股份有限公司 | DDL correctness detection method, device and medium |
| CN116401177B (en) * | 2023-06-09 | 2023-08-15 | 瀚高基础软件股份有限公司 | DDL correctness detection method, device and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR102214297B1 (en) | Conditional validation rules | |
| CN102073640B (en) | Method, system and server for testing structured query language (SQL) statements | |
| KR102151326B1 (en) | Data processing method and device | |
| US20170228309A1 (en) | System and method for equivalence class analysis-based automated requirements-based test case generation | |
| CN110442516B (en) | Information processing method, apparatus, and computer-readable storage medium | |
| CN110474900B (en) | Game protocol testing method and device | |
| CN107016018B (en) | Database index creation method and device | |
| US20110320876A1 (en) | Systems and methods for processing source code during debugging operations | |
| EP2862101B1 (en) | Method and a consistency checker for finding data inconsistencies in a data repository | |
| CN109408385B (en) | A kind of disfigurement discovery method based on mischief rule and classifying feedback | |
| CN109445768B (en) | Database script generation method and device, computer equipment and storage medium | |
| CN109740129B (en) | Report generation method, device and equipment based on blockchain and readable storage medium | |
| CN104756113A (en) | Method, apparatus and computer program for detecting deviations in data sources | |
| US20160162539A1 (en) | Computer executable method of generating analysis data and apparatus performing the same and storage medium for the same | |
| CN115630036A (en) | Error information processing method, apparatus, device, storage medium and program product | |
| CN115658731A (en) | Data query method, device, equipment and storage medium | |
| CN111309586A (en) | Command testing method, device and storage medium thereof | |
| CN111752846A (en) | Interface testing method and device | |
| CN111736865A (en) | Database upgrading method and system | |
| CN110019762B (en) | Problem positioning method, storage medium and server | |
| CN104462311A (en) | Information displaying method and device | |
| CN113760891A (en) | Data table generation method, device, equipment and storage medium | |
| CN109558153B (en) | Method, device and system for determining version consistency | |
| US20160314035A1 (en) | Set-based bugs discovery system via sql query | |
| CN112948478A (en) | Link-based code analysis method and device, electronic 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 |