CN110413634B - Data query method, system, device and computer readable storage medium - Google Patents
Data query method, system, device and computer readable storage medium Download PDFInfo
- Publication number
- CN110413634B CN110413634B CN201910570481.2A CN201910570481A CN110413634B CN 110413634 B CN110413634 B CN 110413634B CN 201910570481 A CN201910570481 A CN 201910570481A CN 110413634 B CN110413634 B CN 110413634B
- Authority
- CN
- China
- Prior art keywords
- dimension
- identifier
- target data
- data table
- query
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
- G06F16/2445—Data retrieval commands; View definitions
Abstract
The embodiment of the invention provides a data query method, a data query system, a data query device and a computer readable storage medium. The data query method of the invention comprises the following steps: the method comprises the steps of receiving a query request, wherein the query request comprises an identification of a target data source and an identification of a first dimension, determining the identification of a target data table which is associated with the identification of the target data source and is associated with the identification of the first dimension and a second dimension which is associated with the first dimension according to configuration information stored in a server, wherein the first dimension does not belong to the dimension in the target data table, and the second dimension belongs to the dimension in the target data table.
Description
Technical Field
The present invention relates to the field of data query technologies, and in particular, to a data query method, system, device, and computer-readable storage medium.
Background
In the data query system currently used in the industry, the dimension of the data query must be limited to the dimension contained in the data table. For example, if the data table contains 10 dimensions, the user can only query for the 10 dimensions.
If the data query system is to query derived dimensions other than the 10 dimensions (derived dimensions refer to dimensions that do not belong to the table but are related to existing dimensions in the table), the derived dimensions must be added to the table through manual intervention, that is, the table must be modified manually to query data related to the added derived dimensions. Therefore, when the number of the data tables to be modified is large, the task of modifying the data tables is large, the process is complex, and errors are easy to occur.
Disclosure of Invention
In view of the above problems, embodiments of the present invention are proposed to provide a data query method, system, device and computer-readable storage medium that overcome or at least partially solve the above problems.
In a first aspect of the embodiments of the present invention, a data query method is provided, which is applied to a system including a server and a terminal device; the method comprises the following steps:
the terminal equipment sends a query request to the server, wherein the query request comprises an identifier of a target data source and an identifier of a first dimension;
the server responds to the query request, and determines an identifier of a target data table which is associated with the identifier of the target data source and is associated with the identifier of the first dimension and a second dimension which is associated with the first dimension according to configuration information, wherein the first dimension does not belong to the dimension in the target data table, and the second dimension belongs to the dimension in the target data table;
the server generates a Structured Query Language (SQL) instruction according to the identifier of the target data table and the second dimension, and acquires a target query result from the target data table by using the SQL instruction;
and the server sends the target query result to the terminal equipment.
In a second aspect of the embodiments of the present invention, there is provided a data query method, executed on a server, including:
receiving a query request, wherein the query request comprises an identifier of a target data source and an identifier of a first dimension;
determining, according to configuration information stored in the server, an identifier of a target data table associated with the identifier of the target data source and associated with the identifier of the first dimension, and a second dimension associated with the first dimension, the first dimension not belonging to a dimension in the target data table, the second dimension belonging to a dimension in the target data table;
generating a Structured Query Language (SQL) instruction according to the identifier of the target data table and the second dimension, and acquiring a target query result from the target data table by using the SQL instruction;
and sending the target query result to the terminal equipment.
Alternatively to this, the first and second parts may,
determining the identifier of the target data table according to a first incidence relation among the identifier of the data source, the identifier of the data table and the identifier of the first dimension; determining a second dimension associated with the first dimension according to a second association relationship between the target data table and the existing dimensions of the target data table;
alternatively, the first and second electrodes may be,
checking the identifier of the target data source and the identifier of the first dimension to judge whether the query request passes the checking; and if the query request passes the verification, determining the identifier of the target data table according to the first incidence relation, and determining a second dimension associated with the first dimension according to the second incidence relation.
Optionally, the verifying the identifier of the target data source and the identifier of the first dimension to determine whether the query request passes the verification includes:
judging whether the identification of the target data source is matched with the identification of the data source in the first incidence relation;
if the identifier of the target data source is matched with the identifier of the data source in the first incidence relation, judging whether the identifier of the first dimension is matched with the identifier of the first dimension in the first incidence relation;
and if the identifier of the first dimension is matched with the identifier of the first dimension in the first incidence relation, determining that the query request passes the verification.
Optionally, the obtaining a target query result from the target data table by using the SQL instruction includes:
and querying a query result associated with the second dimension by using the SQL instruction, and performing specified operation on the query result associated with the second dimension according to the relation between the first dimension and the second dimension to obtain the target query result.
Optionally, the query request further includes a time range of the data to be queried;
the determining that the query request checks comprises:
acquiring a target data table corresponding to the identifier of the target data table;
judging whether the time range is within the range of the time information or not according to the time information in the target data table;
and if the time range is within the range of the time information, determining that the query request passes the verification.
In a third aspect of the embodiments of the present invention, there is provided a data query system, including:
the terminal equipment is used for sending a query request to the server, wherein the query request comprises an identifier of a target data source and an identifier of a target dimension;
the server is used for responding to the query request, and determining an identifier of a target data table which is associated with the identifier of the target data source and is associated with the identifier of the first dimension and a second dimension which is associated with the first dimension according to configuration information stored in the server, wherein the first dimension does not belong to the dimension in the target data table, and the second dimension belongs to the dimension in the target data table;
the server is used for generating a Structured Query Language (SQL) instruction according to the identifier of the target data table and the second dimension, and acquiring a target query result from the target data table by using the SQL instruction;
and the server is used for sending the target query result to the terminal equipment.
A fourth aspect of the embodiments of the present invention provides a data query apparatus, which is disposed in a server, and includes:
the receiving module is used for receiving a query request, wherein the query request comprises an identifier of a target data source and an identifier of a first dimension;
a determining module, configured to determine, according to configuration information stored in the server, an identifier of a target data table associated with the identifier of the target data source and associated with the identifier of the first dimension, and a second dimension associated with the first dimension, where the first dimension does not belong to a dimension in the target data table, and the second dimension belongs to a dimension in the target data table;
the acquisition module is used for generating a Structured Query Language (SQL) instruction according to the identifier of the target data table and the second dimension, and acquiring a target query result from the target data table by using the SQL instruction;
and the sending module is used for sending the target query result to the terminal equipment.
Optionally, the determination module includes a first determination sub-module and a second determination sub-module, or the determination module includes a verification sub-module and a third determination sub-module, wherein,
the first determining submodule is used for determining the identifier of the target data table according to a first incidence relation among the identifier of the data source, the identifier of the data table and the identifier of the first dimension;
the second determining submodule is used for determining a second dimension associated with the first dimension according to a second association relation between the target data table and the existing dimension of the target data table;
the verification submodule is used for verifying the identifier of the target data source and the identifier of the first dimension so as to judge whether the query request passes the verification;
and the third determining submodule is used for determining the identifier of the target data table according to the first association relation and determining a second dimension associated with the first dimension according to the second association relation if the query request passes the verification.
Optionally, the check submodule includes:
a judging unit, configured to judge whether the identifier of the target data source matches the identifier of the data source in the first association;
the determining unit is further configured to determine whether the identifier of the first dimension matches the identifier of the first dimension in the first association relationship if the identifier of the target data source matches the identifier of the data source in the first association relationship;
and the checking unit is used for determining that the query request passes the checking if the identifier of the first dimension is matched with the identifier of the first dimension in the first association relation.
Optionally, the obtaining module is specifically configured to query, by using the SQL instruction, a query result associated with the second dimension, and perform a specified operation on the query result associated with the second dimension according to a relationship between the first dimension and the second dimension to obtain the target query result.
Optionally, the query request further includes a time range of the data to be queried;
the verification unit is further used for acquiring a target data table corresponding to the identifier of the target data table; and judging whether the time range is within the range of the time information or not according to the time information in the target data table.
In a fifth aspect of the embodiments of the present invention, a computer-readable storage medium is provided, on which a computer program is stored, and the computer program, when executed by a processor, implements the data query method as described in any one of the above.
The embodiment of the invention has the following advantages:
receiving a query request, wherein the query request comprises an identifier of a target data source and an identifier of a first dimension, determining an identifier of a target data table which is associated with the identifier of the target data source and is associated with the identifier of the first dimension and a second dimension which is associated with the identifier of the first dimension according to configuration information stored in a server, wherein the first dimension does not belong to the dimension in the target data table, the second dimension belongs to the dimension in the target data table, generating an SQL instruction according to the identifier of the target data table and the second dimension, acquiring a target query result from the target data table by using the SQL instruction, and sending the target query result to a terminal device. Because the dimension (i.e., the first dimension) included in the query request does not belong to the existing dimension in the target data table, the server can determine the existing dimension (i.e., the second dimension) in the target data table associated with the dimension included in the query request according to the dimension included in the query request and the identifier of the target data source, and generate the SQL instruction according to the identifier of the target data table and the second dimension, and can acquire the target query result from the target data table by using the SQL instruction (i.e., the target query result conforming to the dimension included in the query request can be acquired from the target data table by using the SQL instruction), on the premise that the first dimension does not belong to the target data table, the query on the target data table can be simply and conveniently realized, and therefore, data of derived dimensions can be queried without adding derived dimensions in the data table as in the prior art, therefore, the data query method provided by the embodiment of the invention simplifies the operation process, thereby saving manpower.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
FIG. 1 is a block diagram of a data query system provided in an embodiment of the present invention;
FIG. 2 is a flowchart illustrating steps of a data query method according to an embodiment of the present invention;
FIG. 3 is a flow chart illustrating steps of another data query method according to an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of a data query device according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of another data query apparatus according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of another data query apparatus according to an embodiment of the present invention.
Detailed Description
In order to make the aforementioned objects, features and advantages of the present invention comprehensible, embodiments accompanied with figures are described in further detail below.
It should be understood that the specific embodiments described herein are merely illustrative of the invention, but do not limit the invention to only some, but not all embodiments.
Referring to fig. 1, fig. 1 is a block diagram of a data query system according to an embodiment of the present invention. The data query system comprises the terminal device 101 and the server 102, a database is deployed on the server 102, a data table can be stored in the database, data associated with the existing dimensions of the data table are stored in the data table, the terminal device 101 can send a query request to the server 102 to query the data associated with the existing dimensions in the data table, and is responsible for providing the queried data for a user, that is, the terminal device 101 can access the database on the server 102, so as to access the data in the data table. Specifically, the terminal device 101 sends a Query request to the server 102, where the Query request may specify data that a user needs to Query, and the server 102 executes a Structured Query Language (SQL) Query instruction according to the Query request and obtains a Query result, and returns the Query result to the terminal device 101.
Based on fig. 1, an embodiment of the present invention provides a data query method, where a terminal device 101 sends a query request to a server 102, where the query request includes an identifier of a target data source and an identifier of a first dimension; the server responds to the query request, and determines an identifier of a target data table which is associated with the identifier of the target data source and is associated with the identifier of the first dimension and a second dimension which is associated with the first dimension according to the configuration information, wherein the first dimension does not belong to the dimension in the target data table, and the second dimension belongs to the dimension in the target data table; the server generates a Structured Query Language (SQL) instruction according to the identifier and the second dimension of the target data table, and acquires a target query result from the target data table by using the SQL instruction; and the server sends the target query result to the terminal equipment. The terminal device includes, but is not limited to, a mobile phone, a tablet computer, a notebook computer, a palm computer, and the like.
In the embodiment of the invention, the server stores the configuration information, so that the server can respond to the query request, determine the identifier of the target data table which is associated with the identifier of the target data source and is associated with the identifier of the first dimension and the second dimension which is associated with the first dimension according to the configuration information, generate a Structured Query Language (SQL) instruction according to the identifier of the target data table and the second dimension, acquire the target query result from the target data table by using the SQL instruction, and send the target query result to the terminal device, thereby realizing the purpose of querying the data of the dimension which does not exist in the target data table. Since the first dimension does not belong to the dimension in the target data table, it is not necessary to add a derived dimension (derived dimension refers to a dimension not belonging to the data table but related to the existing dimension in the data table) in each data table to be modified when the number of data tables to be modified is large as in the prior art, namely, the data tables are not required to be saved after each data table is modified, the embodiment of the invention can realize the query of the data based on the first dimension sent by the terminal equipment by configuring the incidence relation and the configuration information of the first dimension and the second dimension in the server, on the premise that the first dimension does not belong to the data table, the query of the data table can be simply and conveniently realized, therefore, the data query method provided by the embodiment of the invention simplifies the operation process, improves the query efficiency and can save manpower. The above-mentioned data query method is described in detail below.
Referring to fig. 2, fig. 2 is a flowchart of steps of a data query method according to an embodiment of the present invention, and the method according to the embodiment is suitable for a case where derived dimensions can be queried without changing existing dimensions of a data table in a database. The method provided by the embodiment can be executed in the server. The data query method provided by the embodiment comprises the following steps:
s201, receiving a query request, wherein the query request comprises the identification of the target data source and the identification of the first dimension.
The query request may describe the user's specific query requirements. The query request includes an identifier of a target data source and an identifier of the first dimension, where the identifier of the target data source may indicate a data source that the user wishes to query, and the data source includes, for example, exposure data, click data, and the like. The identifier of the first dimension represents specific data that the user wishes to query, and the identifier of the first dimension may be a name of the first dimension, for example, the name of the first dimension is week or month, that is, the user wishes to query the weekly statistical data or monthly statistical data in the data table, for example, if the user needs to query the number of times that the advertisement is clicked per month (click data), the user may select or input "month" through a query interface provided on the terminal device, and when the user selects or inputs "month" and clicks on the query, the server may receive a query request containing the identifier of the target data source and "month".
It should be noted that, in the embodiment of the present invention, the identifier of the dimension included in the query request sent by the terminal device to the server may not belong to an existing dimension in the data table, whereas in the prior art, the identifier of the dimension included in the query request sent by the terminal device to the server belongs to an existing dimension in the data table.
S202, according to configuration information stored in the server, an identifier of a target data table which is associated with an identifier of a target data source and is associated with an identifier of a first dimension and a second dimension which is associated with the first dimension are determined, wherein the first dimension does not belong to a dimension in the target data table, and the second dimension belongs to a dimension in the target data table.
The configuration information may include an identification of the data source, an identification of the data table, a first association between the identification of the first dimension, and a second association of the target data table with an existing dimension of the target data table. As shown in table 1 below, there is a horizontal association relationship between the identifier of the data source, the identifier of the data table, the identifier of the first dimension, and the existing dimension of the data table, that is, the association relationship between the identifier of the data source (for example, data source 1), the identifier of the data table (for example, data table 1), the identifier of the first dimension (for example, first dimension 1), and the existing dimension of the data table (for example, the existing dimension of the data table 1 is existing dimension 1) is configured in the configuration information, for example, the configuration information is shown in table 1 below:
| identification of data sources | Identification of data tables | Identification of a first dimension | Existing dimensions of a data table |
| Data source 1 | Data table 1 | First dimension 1 | Existing dimension 1 |
| Data source 2 | Data table 2 | First dimension 2 | Existing dimension 2 |
| Data source 3 | Data table 3 | First dimension 3 | Existing dimension 3 |
TABLE 1
Thus, an identification of the target data table associated with the identification of the target data source and associated with the identification of the first dimension, and a second dimension associated with the first dimension may be determined from the configuration information. For example, if the identifier of the target data source is data source 1, and the identifier of the first dimension is first dimension 1, it may be determined that the target data table is data table 1, the existing dimension associated with data table 1 is existing dimension 1, and existing dimension 1 is the second dimension associated with first dimension 1.
S203, generating a Structured Query Language (SQL) instruction according to the identifier and the second dimension of the target data table, and acquiring a target query result from the target data table by using the SQL instruction.
It should be noted that, since the server stores the configuration information, it is possible to determine the identifier of the target data table and the second dimension associated with the first dimension based on the first dimension sent by the terminal device, where the second dimension belongs to a dimension in the target data table, that is, the second dimension is an existing dimension of the target data table, generate an SQL instruction according to the identifier of the target data table and the second dimension, and obtain a target query result conforming to the first dimension from the target data table by using the SQL instruction, so that the data can be queried based on the first dimension sent by the terminal device, and on the premise that the first dimension does not belong to the data table, the data table can still be queried simply and conveniently. For example, taking the target data table as the data table 1 in the above table as an example, if the existing dimension 1 in the target data table is "date", the data associated with the existing dimension 1 is the number of times that the advertisement is clicked each day in 2018, and the existing dimension in the target data table does not include "month", that is, the target data table does not include the number of times that the advertisement is clicked each month in 2018, the SQL instruction may be generated according to the identifier and the second dimension of the target data table determined in S202. For example, if the second dimension is "date" and the target data table is data table 1, the derivative dimension month (dt) "is derived according to the second dimension dt (date), and then the data table 1 and the derivative dimension month (dt) are combined to generate an SQL instruction, for example, the generated SQL instruction is:
Select
month(dt),
From
data table 1
Where
dt>＝‘2018-09-11’
And dt<＝‘2018-10-10’
Group By
month(dt)
The data of one month from 2018-09-11 to 2018-10-10 is obtained from the data table 1 by using an SQL instruction, and the data is calculated by 30 days per month, it should be noted that the data of each month may be counted according to a natural month, or the data of one month closest to the current date may be obtained by calculating one month forward according to the current query date, and finally the data of the month is summed and calculated to obtain the data of the month, that is, the data obtained by summing the data of which the target query result is 30 days. For another example, if the existing dimensions in the target data table include the name and gender of the employee, and the work completion amount of each month from 1 month to 12 months in 2018, then the derived dimensions like year can be derived from month, and the total work completion amount of the employee in 2018 is counted.
And S204, sending the target query result to the terminal equipment.
The data query method provided by this embodiment does not modify the original data table (e.g., it is not necessary to add a derivative dimension "month" in the data table), that is, it does not add a derivative dimension in the original data table, but determines the identifier of the target data table associated with the identifier of the target data source and the second dimension associated with the first dimension according to the configuration information stored in the server, generates a structured query language SQL instruction according to the identifier of the target data table and the second dimension associated with the first dimension, and obtains the target query result from the target data table by using the SQL instruction, and sends the target query result to the terminal device, because the first dimension does not belong to a dimension in the target data table, the data query method provided by this embodiment does not need to add a derivative dimension in each data table that needs to be modified when the number of data tables that need to be modified is larger as in the prior art, the data table is not required to be saved after each data table is modified, so that the data query method provided by the embodiment of the invention simplifies the operation process, and greatly saves manpower.
Referring to fig. 3, fig. 3 is a flowchart of steps of another data query method according to an embodiment of the present invention, where the method according to the embodiment includes the following steps:
s301, receiving a query request, wherein the query request comprises the identification of the target data source and the identification of the first dimension.
Specifically, the implementation manner of this step may refer to the above S201, which is not described herein again.
It should be noted that the query request may also include a time range of the data to be queried.
S302, the identification of the target data source and the identification of the first dimension are checked to judge whether the query request passes the check.
If the query request passes the verification, S303 is executed.
The checking of the identifier of the target data source and the identifier of the first dimension to judge whether the query request is checked can be realized by the following method:
and checking the identifier of the target data source and the identifier of the first dimension according to the first association relation so as to judge whether the query request passes the checking.
Optionally, a first association relationship may be configured in the configuration file or configured in the data table, the configuration information 306 includes the first association relationship, and the configuration information 306 may be stored in the server 102 in which the database is deployed, referring to fig. 2, before verifying the identifier of the target data source and the identifier of the first dimension, the configuration information 306 needs to be acquired from the server, so that the identifier of the target data source and the identifier of the first dimension may be verified according to the first association relationship in the configuration information 306.
Optionally, verifying the identifier of the target data source and the identifier of the first dimension according to the first association relationship to determine whether the query request passes the verification may include the following steps:
judging whether the identifier of the target data source is matched with the identifier of the data source in the first incidence relation; if the identification of the target data source is matched with the identification of the data source in the first incidence relation, judging whether the identification of the first dimension is matched with the identification of the first dimension in the first incidence relation; and if the identifier of the first dimension is matched with the identifier of the first dimension in the association relationship, determining that the query request passes the verification.
It should be noted that the identifier of the target data source is matched with the identifier of the data source in the first association relationship, that is, there is an identifier of the data source in the first association relationship, if the identifier of the target data source is matched with the identifier of the data source in the first association relationship, it may be determined whether the identifier of the first dimension is matched with the identifier of the first dimension in the first association relationship, that is, it is determined whether there is an identifier in the first association relationship, which is consistent with the identifier of the first dimension, and if there is an identifier in the first association relationship, it is determined that the query request is verified. That is, the identifier of the data source consistent with the identifier of the target data source exists in the first association relationship, and the identifier consistent with the identifier of the first dimension exists in the first association relationship, so that the query request is determined to pass the verification. If the first association relationship does not have the identifier of the data source consistent with the identifier of the target data source or the identifier consistent with the identifier of the first dimension does not exist in the first association relationship, or the first association relationship does not have the identifier of the data source consistent with the identifier of the target data source or the identifier consistent with the identifier of the first dimension, it is determined that the query request is not verified. Or whether an identifier consistent with the identifier of the first dimension exists in the first association relationship may be determined, if the identifier consistent with the identifier of the first dimension exists in the first association relationship, whether an identifier of a data source consistent with the identifier of the target data source exists in the first association relationship may be determined, and if the identifier of a data source consistent with the identifier of the target data source exists in the first association relationship, it may be determined that the query request is verified. The embodiment of the invention does not specifically limit the sequence of the verification target data source and the first dimension.
It should be noted that, when the query request includes the time range of the data to be queried, in S302, in addition to checking the identifier of the target data source and the identifier of the first dimension, the time range of the data to be queried included in the query request also needs to be checked to determine whether the query request passes the check. The query request can only be determined to check through if all of the time ranges satisfying the identification of the target data source, the identification of the first dimension, and the data to be queried pass.
Correspondingly, in the case that the query request further includes a time range of the data to be queried, before determining that the query request is verified, the method may further include the following steps:
acquiring a target data table corresponding to the identifier of the target data table; and judging whether the time range is within the range of the time information or not according to the time information in the target data table.
The time range of the data to be queried, which is included in the query request, can be checked in the following two ways:
in a possible implementation manner, the target data table corresponding to the identifier of the target data table may be obtained, and it is determined whether the time range is within the range of the time information included in the target data table, that is, the time range of the data to be queried is checked, if the time range of the data to be queried is within the range of the time information included in the target data table (that is, the starting time of the time range of the data to be queried is greater than or equal to the starting time in the target data table, and the ending time of the time range of the data to be queried is less than or equal to the ending time in the target data table, for example, the time range of the data to be queried is 2018, month 1, day to 4, month 30 days, and the starting time in the target data table is 2018, month 1, day to 5, month 31 days, it may be determined that the time range of the data to be queried is within the range of the time information included in the target data table), it is determined that the time range of the data to be queried passes the check. That is, when the query request includes the identifier of the target data source, the identifier of the target dimension, and the time range, the identifier of the target data source, the identifier of the target dimension, and the time range need to be checked, and the query request can be determined to pass the check if all the identifiers of the target data source, the identifier of the target dimension, and the time range pass the check. The sequence of respectively verifying the identifier of the target data source, the identifier of the target dimension and the time range is not particularly limited in the embodiment of the invention.
In another possible implementation manner, it may be determined whether the start time of the time range is less than the end time, and if the start time is less than the end time, the check on the time range is passed. If the time range is not checked, prompt information can be sent to the terminal equipment, so that the terminal equipment can display the prompt information to prompt a user to input a reasonable time range. For example, the start time input by the user is 2018, 5/month 1, and the end time is 2018, 1/month 1, and since the start time is greater than the end time, the time range is not verified.
S303, according to the first incidence relation, determining the identification of the target data table, and according to the second incidence relation, determining a second dimension associated with the first dimension.
Referring to fig. 3, since the configuration information 306 stored in the server stores the identifier of the data source, the identifier of the data table, the first association between the identifiers of the first dimension, and the second association between the target data table and the existing dimension of the target data table, the first association and the second association can be obtained from the configuration information 306 stored in the server, so that the identifier of the target data table can be determined according to the first association; and determining a second dimension associated with the first dimension according to a second association relation between the target data table and the existing dimensions of the target data table. For example, referring to the description in the above embodiment S202, a first association relationship exists between the data source 1, the data table 1, and the first dimension 1, and a second association relationship exists between the data table 1 and the existing dimension 1; a first association relationship exists among the data source 2, the data table 2 and the first dimension 2, and a second association relationship exists between the data table 2 and the existing dimension 2.
S304, generating a Structured Query Language (SQL) instruction according to the identification and the second dimension of the target data table, and acquiring a target query result from the target data table by using the SQL instruction.
The SQL instruction is generated BY generating FROM < table name >, WHERE query conditions (for example, introduction dt > ═ 2018-09-11 'And dt < ═ 2018-10-10' in S203), GROUP BY conditions (conditions, for example, specify summing according to the existing dimensions), ORDER BY conditions (conditions, for example, specify sorting according to the existing dimensions or derived dimensions), LIMIT & OFFSET (how many rows the query result has are defined BY LIMIT, which row the query starts FROM is defined BY OFFSET, for example, LIMIT 5001OFFSET 0, that is, the query starts FROM row 0, And data of line 5001 is queried together), And SELECT conditions (conditions, for example, including the derived dimensions that need to be queried And the existing dimensions that need to be summed And calculated) respectively.
In the prior art, the query dimension can only be the existing dimension in the data table, such as data of a certain day, data of a certain city, and the like, but the data of the dimension that does not exist in the data table can be queried in the embodiment of the present invention, and the implementation manner of this step may refer to the above S203, which is not described herein again.
The method for acquiring the target query result from the target data table by using the SQL instruction can be realized by the following steps:
and querying a query result associated with the second dimension by using an SQL instruction, and performing specified operation on the query result associated with the second dimension according to the relation between the first dimension and the second dimension to obtain a target query result.
For example, referring to fig. 3, if the first dimension is a month, the second dimension is a day, and the data associated with the second dimension is the number of times that the advertisement is clicked per day, then the query result associated with the second dimension is queried from the database 307 by using SQL instructions as the number of times that the advertisement is clicked per day, and then a specified operation is performed on the query result associated with the second dimension according to the relationship between the first dimension and the second dimension (for example, if the first dimension is a month, the second dimension is a day, the specified operation performed according to the relationship between the month and the day is accumulation, that is, month data is accumulated, that is, the number of times that the advertisement is clicked per day is monthly accumulated into total times per month). If the first dimension is a monthly average (e.g., average number of clicks per month of advertisement) and the second dimension is a month, the specified operation performed according to the relationship between the monthly average and the day is to accumulate the number of clicks per day of advertisement and then divide the number of clicks per month to obtain the average number of clicks per month of advertisement.
S305, sending the target inquiry result to the terminal equipment.
It should be noted that the query request may further include a filtering condition of the data to be queried, such as filtering data of a certain day, that is, the queried data does not include data of a certain day. For example, referring to the exemplary description in S120 in the above embodiment, if the identifier of the target dimension included in the query request is "month", the filtering condition of the data to be queried is: and on day 3 and 1 in 2018, the number of times that the advertisement with the date of 3 and 1 in 2018 is clicked can be filtered out, and for the click data of the statistic day 3, the total number of times that the advertisement is clicked from day 2 to day 31 in 3 and 3 in 2018 is only counted.
In the data query method provided by this embodiment, a query request is received, where the query request includes an identifier of a target data source and an identifier of a first dimension, the identifier of the target data source and the identifier of the first dimension are checked to determine whether the query request passes the check, if the query request passes the check, the identifier of a target data table is determined according to a first association relationship, a second dimension associated with the first dimension is determined according to a second association relationship, a structured query language SQL instruction is generated according to the identifier of the target data table and the second dimension, a target query result is obtained from the target data table by using the SQL instruction, and the target query result is sent to a terminal device. According to the data query method provided by the embodiment of the invention, as in the prior art, when the number of the data tables to be modified is large, a derivative dimension is not required to be added in each data table to be modified, that is, each data table is not required to be modified and then stored.
Fig. 4 is a schematic structural diagram of a data query apparatus according to an embodiment of the present invention, where the data query apparatus may be disposed in a server, and as shown in fig. 4, the data query apparatus 400 may include: a receiving module 410, a determining module 420, an obtaining module 430, and a sending module 440.
The receiving module 410 is configured to receive a query request, where the query request includes an identifier of a target data source and an identifier of a first dimension; the determining module 420 is configured to determine, according to the configuration information stored in the server, an identifier of the target data table associated with the identifier of the target data source and associated with the identifier of the first dimension, and a second dimension associated with the first dimension, where the first dimension does not belong to a dimension in the target data table, and the second dimension belongs to a dimension in the target data table; the obtaining module 430 is configured to generate a Structured Query Language (SQL) instruction according to the identifier and the second dimension of the target data table, and obtain a target query result from the target data table by using the SQL instruction; the sending module 440 is configured to send the target query result to the terminal device.
The data query apparatus provided in this embodiment determines, according to configuration information stored in the server, an identifier of a target data table associated with an identifier of a target data source and a second dimension associated with the first dimension, generates a structured query language SQL instruction according to the identifier of the target data table and the second dimension associated with the first dimension, and obtains a target query result from the target data table by using the SQL instruction, and sends the target query result to the terminal device, because the first dimension does not belong to a dimension in the target data table, the data query method provided in this embodiment does not require, as in the prior art, to add a derivative dimension to each data table to be modified when the number of data tables to be modified is large, i.e., does not require to modify each data table and then store the data table, and therefore, the data query apparatus provided in the embodiment of the present invention simplifies an operation flow, thereby saving manpower.
Optionally, referring to fig. 5, fig. 5 is a schematic structural diagram of another data querying device according to an embodiment of the present invention, where the determining module 420 in the data querying device 500 includes a first determining submodule 501 and a second determining submodule 502, or referring to fig. 6, fig. 6 is a schematic structural diagram of another data querying device according to an embodiment of the present invention, where the determining module 420 in the data querying device 600 includes a checking submodule 601 and a third determining submodule 602.
The first determining submodule 501 is configured to determine the identifier of the target data table according to a first association relationship among the identifier of the data source, the identifier of the data table, and the identifier of the first dimension; the second determining submodule 502 is configured to determine, according to a second association relationship between the target data table and an existing dimension of the target data table, a second dimension associated with the first dimension; the checking submodule 601 is configured to check the identifier of the target data source and the identifier of the first dimension to determine whether the query request passes the check; the third determining sub-module 602 is configured to determine, if the query request passes verification, an identifier of the target data table according to the first association relationship, and determine, according to the second association relationship, a second dimension associated with the first dimension.
Optionally, the check sub-module 601 includes:
a determining unit 6011, configured to determine whether the identifier of the target data source matches the identifier of the data source in the first association relationship;
the determining unit 6011 is further configured to determine whether the identifier of the first dimension matches the identifier of the first dimension in the first association relationship if the identifier of the target data source matches the identifier of the data source in the first association relationship;
a checking unit 6012, configured to determine that the query request passes the checking if the identifier of the first dimension matches the identifier of the first dimension in the first association relationship.
Optionally, the obtaining module 430 is specifically configured to query, by using an SQL instruction, a query result associated with the second dimension, and perform specified operation on the query result associated with the second dimension according to a relationship between the first dimension and the second dimension to obtain a target query result.
Optionally, the query request further includes a time range of the data to be queried;
the verification unit 6012 is further configured to obtain a target data table corresponding to the identifier of the target data table; and judging whether the time range is within the range of the time information or not according to the time information in the target data table.
For the device embodiment, since it is basically similar to the method embodiment, the description is simple, and for the relevant points, refer to the partial description of the method embodiment.
The embodiments in the present specification are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, apparatus, or computer program product. Accordingly, embodiments of the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, embodiments of the present invention 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.
In a typical configuration, the computer 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 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, computer readable media does not include non-transitory computer readable media (fransitory media), such as modulated data signals and carrier waves.
Embodiments of the present invention are described with reference to flowchart illustrations and/or block diagrams of methods, terminal devices (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 live interaction terminal device to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable live interaction terminal device, 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 live interaction terminal 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 live interaction terminal device to cause a series of operational steps to be performed on the computer or other programmable terminal device to produce a computer implemented process such that the instructions which execute on the computer or other programmable terminal device provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
While preferred embodiments of the present invention have been described, additional variations and modifications of these embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the embodiments of the invention.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or terminal 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 terminal. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or terminal that comprises the element.
The live broadcast interaction method, system, device and computer-readable storage medium provided by the present invention are introduced in detail, and a specific example is applied in the text to explain the principle and the implementation of the present invention, and the description of the above embodiment is only used to help understanding the method and the core idea of the present invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
Claims (13)
1. A data query method is characterized by being applied to a system comprising a server and a terminal device; the method comprises the following steps:
the terminal equipment sends a query request to the server, wherein the query request comprises an identifier of a target data source and an identifier of a first dimension;
the server responds to the query request, and determines an identifier of a target data table which is associated with the identifier of the target data source and is associated with the identifier of the first dimension and a second dimension which is associated with the first dimension, wherein the first dimension does not belong to the dimension in the target data table, the second dimension belongs to the dimension in the target data table, and the configuration information comprises the identifier of the data source, the identifier of the data table, a first association relation between the identifiers of the first dimension and a second association relation between the target data table and the existing dimension of the target data table;
the server generates a Structured Query Language (SQL) instruction according to the identifier of the target data table and the second dimension, and acquires a target query result from the target data table by using the SQL instruction;
and the server sends the target query result to the terminal equipment.
2. A data query method, implemented in a server, comprising:
receiving a query request, wherein the query request comprises an identifier of a target data source and an identifier of a first dimension;
determining an identifier of a target data table associated with the identifier of the target data source and associated with the identifier of the first dimension and a second dimension associated with the first dimension, wherein the first dimension does not belong to a dimension in the target data table, the second dimension belongs to a dimension in the target data table, and the configuration information comprises the identifier of the data source, the identifier of the data table, a first association relation between the identifiers of the first dimension and the identifier of the target data table, and a second association relation between the target data table and an existing dimension of the target data table;
generating a Structured Query Language (SQL) instruction according to the identifier of the target data table and the second dimension, and acquiring a target query result from the target data table by using the SQL instruction;
and sending the target query result to the terminal equipment.
3. The method of claim 2, wherein determining, from configuration information stored in the server, an identification of a target data table associated with the identification of the target data source and associated with the identification of the first dimension, and a second dimension associated with the first dimension comprises:
determining the identifier of the target data table according to a first incidence relation among the identifier of the data source, the identifier of the data table and the identifier of the first dimension; determining a second dimension associated with the first dimension according to a second association relationship between the target data table and the existing dimensions of the target data table;
alternatively, the first and second electrodes may be,
checking the identifier of the target data source and the identifier of the first dimension to judge whether the query request passes the checking; and if the query request passes the verification, determining the identifier of the target data table according to the first incidence relation, and determining a second dimension associated with the first dimension according to the second incidence relation.
4. The method of claim 3, wherein the checking the identification of the target data source and the identification of the first dimension to determine whether the query request is checked, comprises:
judging whether the identification of the target data source is matched with the identification of the data source in the first incidence relation;
if the identifier of the target data source is matched with the identifier of the data source in the first incidence relation, judging whether the identifier of the first dimension is matched with the identifier of the first dimension in the first incidence relation;
and if the identifier of the first dimension is matched with the identifier of the first dimension in the first incidence relation, determining that the query request passes the verification.
5. The method according to any of claims 2 to 4, wherein the obtaining a target query result from the target data table using the SQL instruction comprises:
and querying a query result associated with the second dimension by using the SQL instruction, and performing specified operation on the query result associated with the second dimension according to the relation between the first dimension and the second dimension to acquire the target query result.
6. The method of claim 4, wherein the query request further contains a time range of the data to be queried;
before the determining that the query request check passes, further comprising:
acquiring a target data table corresponding to the identifier of the target data table;
and judging whether the time range is within the range of the time information or not according to the time information in the target data table.
7. A data query system, comprising:
the terminal equipment is used for sending a query request to the server, wherein the query request comprises an identifier of a target data source and an identifier of a target dimension;
the server is used for responding to the query request, and determining an identifier of a target data table which is associated with the identifier of the target data source and is associated with the identifier of a first dimension and a second dimension which is associated with the first dimension according to configuration information stored in the server, wherein the first dimension does not belong to a dimension in the target data table, the second dimension belongs to a dimension in the target data table, and the configuration information comprises the identifier of the data source, the identifier of the data table, a first association relation between the identifiers of the first dimension and a second association relation between the target data table and an existing dimension of the target data table;
the server is used for generating a Structured Query Language (SQL) instruction according to the identifier of the target data table and the second dimension, and acquiring a target query result from the target data table by using the SQL instruction;
and the server is used for sending the target query result to the terminal equipment.
8. A data query device provided in a server, comprising:
the receiving module is used for receiving a query request, wherein the query request comprises an identifier of a target data source and an identifier of a first dimension;
a determining module, configured to determine, according to configuration information stored in the server, an identifier of a target data table that is associated with the identifier of the target data source and is associated with the identifier of the first dimension, and a second dimension that is associated with the first dimension, where the first dimension does not belong to a dimension in the target data table, and the second dimension belongs to a dimension in the target data table, and the configuration information includes the identifier of the data source, the identifier of the data table, a first association relationship between the identifiers of the first dimension, and a second association relationship between the target data table and an existing dimension of the target data table;
the acquisition module is used for generating a Structured Query Language (SQL) instruction according to the identifier of the target data table and the second dimension, and acquiring a target query result from the target data table by using the SQL instruction;
and the sending module is used for sending the target query result to the terminal equipment.
9. The apparatus of claim 8, wherein the determination module comprises a first determination sub-module and a second determination sub-module, or wherein the determination module comprises a check sub-module and a third determination sub-module, wherein,
the first determining submodule is used for determining the identifier of the target data table according to a first incidence relation among the identifier of the data source, the identifier of the data table and the identifier of the first dimension;
the second determining submodule is used for determining a second dimension associated with the first dimension according to a second association relation between the target data table and the existing dimension of the target data table;
the verification submodule is used for verifying the identifier of the target data source and the identifier of the first dimension so as to judge whether the query request passes the verification;
and the third determining submodule is used for determining the identifier of the target data table according to the first association relation and determining a second dimension associated with the first dimension according to the second association relation if the query request passes the verification.
10. The apparatus of claim 9, wherein the check submodule comprises:
a judging unit, configured to judge whether the identifier of the target data source matches the identifier of the data source in the first association;
the determining unit is further configured to determine whether the identifier of the first dimension matches the identifier of the first dimension in the first association relationship if the identifier of the target data source matches the identifier of the data source in the first association relationship;
and the checking unit is used for determining that the query request passes the checking if the identifier of the first dimension is matched with the identifier of the first dimension in the first association relation.
11. The apparatus according to any one of claims 8 to 10, wherein the obtaining module is specifically configured to query, by using the SQL instruction, a query result associated with the second dimension, and perform a specified operation on the query result associated with the second dimension according to a relationship between the first dimension and the second dimension to obtain the target query result.
12. The apparatus of claim 10, wherein the query request further contains a time range of data to be queried;
the verification unit is further used for acquiring a target data table corresponding to the identifier of the target data table; and judging whether the time range is within the range of the time information or not according to the time information in the target data table.
13. A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, implements a data query method as claimed in any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910570481.2A CN110413634B (en) | 2019-06-27 | 2019-06-27 | Data query method, system, device and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910570481.2A CN110413634B (en) | 2019-06-27 | 2019-06-27 | Data query method, system, device and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110413634A CN110413634A (en) | 2019-11-05 |
| CN110413634B true CN110413634B (en) | 2022-03-29 |
Family
ID=68359956
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910570481.2A Active CN110413634B (en) | 2019-06-27 | 2019-06-27 | Data query method, system, device and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110413634B (en) |
Families Citing this family (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111125092A (en) * | 2019-11-18 | 2020-05-08 | 贝壳技术有限公司 | Service index query method and device |
| CN111241111B (en) * | 2020-02-12 | 2023-09-26 | 网易（杭州）网络有限公司 | Data query method and device, data comparison method and device, medium and equipment |
| CN111309729A (en) * | 2020-02-13 | 2020-06-19 | 湖南快乐阳光互动娱乐传媒有限公司 | Data query method and device |
| CN111522881B (en) * | 2020-04-26 | 2023-04-28 | 北京三快在线科技有限公司 | Service data processing method, device, server and storage medium |
| CN112069174A (en) * | 2020-08-25 | 2020-12-11 | 北京锐安科技有限公司 | Data extraction method, device, equipment and storage medium |
| CN112883073B (en) * | 2021-03-22 | 2024-04-05 | 北京同邦卓益科技有限公司 | Data screening method, device, equipment, readable storage medium and product |
| CN113569110B (en) * | 2021-07-23 | 2022-09-27 | 用友汽车信息科技（上海）股份有限公司 | Data processing method, data processing system, computer device, and storage medium |
| CN114117187B (en) * | 2022-01-25 | 2022-06-21 | 深圳希施玛数据科技有限公司 | Data query method and related device |
| CN115099922B (en) * | 2022-08-29 | 2022-11-08 | 江西科技学院 | Financial data query method, system, readable storage medium and computer equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106933906A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The querying method and device of data multidimensional degree |
| CN108415964A (en) * | 2018-02-07 | 2018-08-17 | 平安科技（深圳）有限公司 | Tables of data querying method, device, terminal device and storage medium |
| CN108932257A (en) * | 2017-05-25 | 2018-12-04 | 北京国双科技有限公司 | The querying method and device of multi-dimensional data |
| CN109213829A (en) * | 2017-06-30 | 2019-01-15 | 北京国双科技有限公司 | Data query method and device |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002075598A1 (en) * | 2001-03-19 | 2002-09-26 | Exie As | Methods and system for handling mulitple dimensions in relational databases |
| CN103020158B (en) * | 2012-11-26 | 2016-09-07 | 中兴通讯股份有限公司 | A kind of report form creation, device and system |
-
2019
- 2019-06-27 CN CN201910570481.2A patent/CN110413634B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106933906A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The querying method and device of data multidimensional degree |
| CN108932257A (en) * | 2017-05-25 | 2018-12-04 | 北京国双科技有限公司 | The querying method and device of multi-dimensional data |
| CN109213829A (en) * | 2017-06-30 | 2019-01-15 | 北京国双科技有限公司 | Data query method and device |
| CN108415964A (en) * | 2018-02-07 | 2018-08-17 | 平安科技（深圳）有限公司 | Tables of data querying method, device, terminal device and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 数据仓库在酒店CRM系统中的应用研究;刘芬;《科技信息》;20090515(第14期);第557-558页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110413634A (en) | 2019-11-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110413634B (en) | Data query method, system, device and computer readable storage medium | |
| CN106202235B (en) | Data processing method and device | |
| CN108932257B (en) | Multi-dimensional data query method and device | |
| CN109828993B (en) | Statistical data query method and device | |
| CN111190901B (en) | Business data storage method and device, computer equipment and storage medium | |
| CN111241122B (en) | Task monitoring method, device, electronic equipment and readable storage medium | |
| CN110647562B (en) | Data query method and device, electronic equipment and storage medium | |
| CN110971571A (en) | Website domain name verification method and related device | |
| CN112581018B (en) | Method, system, device and storage medium for managing process tasks | |
| CN110888922B (en) | Method and device for creating target table during data synchronization | |
| CN111198772A (en) | Method and system for generating application program interface API | |
| CN111309729A (en) | Data query method and device | |
| CN110765151A (en) | Calculation formula processing method and device | |
| CN111857981A (en) | Data processing method and device | |
| CN106156185B (en) | Method, device and system for inquiring service request execution state | |
| CN110019357B (en) | Database query script generation method and device | |
| CN111177093A (en) | Method, device and medium for sharing scientific and technological resources | |
| CN108121733B (en) | Data query method and device | |
| CN110750271B (en) | Service aggregation, method and device for executing aggregated service and electronic equipment | |
| CN108228604B (en) | Model construction method based on memory object, information query method and device | |
| CN111966892A (en) | Data processing method and device, computer storage medium and electronic equipment | |
| CN107948738B (en) | Method and device for calculating number of users for internet protocol television reuse | |
| CN106569791B (en) | Data object processing method and device | |
| CN110990466B (en) | Data synchronization method and device | |
| CN110019356B (en) | Data query method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |