CN113297246B

CN113297246B - Data processing method, computing device and storage medium

Info

Publication number: CN113297246B
Application number: CN202010549587.7A
Authority: CN
Inventors: 林炳辰
Original assignee: Alibaba Group Holding Ltd
Current assignee: Alibaba Group Holding Ltd
Priority date: 2020-06-16
Filing date: 2020-06-16
Publication date: 2022-10-21
Anticipated expiration: 2040-06-16
Also published as: CN113297246A

Abstract

The embodiment of the application provides a data processing method, computing equipment and a storage medium. In the embodiment of the application, a first statement is created, and the first statement is used for inquiring required data; creating at least one second statement, wherein the second statement is used for processing the required data queried through the first statement; and combining the created first statement and the created second statement to generate a compound statement, so that the queried required data is processed according to the compound statement to obtain a data processing result. Therefore, a user can inquire and process data by creating the compound statement, and because at least one second statement exists in the compound statement, the user can create a plurality of second statements according to requirements, so that the user can realize more and more complex processing functions through the plurality of second statements, the over-limit of functions is overcome, and the flexibility is improved.

Description

Data processing method, computing device and storage medium

Technical Field

The present application relates to the field of computer technologies, and in particular, to a data processing method, a computing device, and a storage medium.

Background

With the rapid development of the internet, the internet of things is developed rapidly. The internet of things generates massive time series data every day, and the time series data need to be analyzed. Thus, the time-series database is generated at the same time.

The time series database is a database for storing time series data. The user can search and process the data through the database. However, many time-series databases query data using a single query language or a single function, so that the query function is limited and the query flexibility is poor.

Disclosure of Invention

Aspects of the present application provide a data processing method, a computing device, and a storage medium, so as to improve flexibility of query and reduce use cost of a user.

An embodiment of the present application provides a data processing method, including: creating a first statement, wherein the first statement is used for inquiring required data; creating at least one second statement, wherein the second statement is used for processing required data queried through the first statement; and combining the created first statement and the created second statement to generate a compound statement, so that the queried required data is processed according to the compound statement to obtain a data processing result.

The embodiment of the present application further provides a data processing method, where the method further includes: receiving a compound sentence, and dividing the compound sentence to obtain a first sentence and at least one second sentence; analyzing each statement to obtain corresponding semantics; and inquiring required data according to the semantics of the first statement, and performing data processing on the required data according to the semantics of the second statement to obtain a data processing result.

The application embodiment also provides a data processing method, which includes: generating an SQL-like execution statement according to the SQL command statement and the time sequence command statement, and inquiring the required time sequence data from the time sequence database; generating at least one API interface processing statement according to a preset API interface so as to process the inquired required time sequence data to obtain a data processing result; and combining the SQL-like execution statement and the API interface processing statement to generate a composite execution statement of the time sequence data so as to query and process the time sequence data in the time sequence database.

An application embodiment also provides a computing device, comprising: a memory and a processor; the memory for storing a computer program; the processor to execute the computer program to: creating a first statement, wherein the first statement is used for inquiring required data; creating at least one second statement, wherein the second statement is used for processing the required data queried through the first statement; and combining the created first statement and the created second statement to generate a compound statement, so that the queried required data is processed according to the compound statement to obtain a data processing result.

An embodiment of the present application further provides a computing device, including: a memory, a processor, and a communication component; the memory for storing a computer program; the processor to execute the computer program to: dividing the compound statement to obtain a first statement and at least one second statement; analyzing each statement to obtain corresponding semantics; inquiring required data according to the semantics of the first statement, and performing data processing on the required data according to the semantics of the second statement to obtain a data processing result; the communication component is used for receiving the compound statement.

An embodiment of the present application further provides a computing device, including: a memory and a processor; the memory for storing a computer program; the processor to execute the computer program to: generating an SQL-like execution statement according to the SQL command statement and the time sequence command statement, and inquiring the required time sequence data from the time sequence database; generating at least one API interface processing statement according to a preset API interface so as to process the data of the inquired required time sequence data and obtain a data processing result; and combining the SQL-like execution statement and the API interface processing statement to generate a composite execution statement of time sequence data so as to query and process the time sequence data in the time sequence database.

Embodiments of the present application also provide a computer-readable storage medium storing a computer program, which when executed by one or more processors causes the one or more processors to implement the steps of the above-mentioned method.

In the embodiment of the application, a first statement is created, and the first statement is used for inquiring required data; creating at least one second statement, wherein the second statement is used for processing the required data queried through the first statement; and combining the created first statement and the created second statement to generate a compound statement, so that the queried required data is processed according to the compound statement to obtain a data processing result. Therefore, a user can inquire and process data by creating the compound statement, and because at least one second statement exists in the compound statement, the user can create a plurality of second statements according to requirements, so that the user can realize more and more complex processing functions through the plurality of second statements, the over-limitation of the functions is overcome, and the flexibility is improved. Meanwhile, the user does not need to program to realize more complex functions due to the over-limited inquiry and processing functions, so that the time cost of the user is saved, and the experience of the user is improved.

Drawings

The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:

FIG. 1 is a block diagram of a data processing system according to an exemplary embodiment of the present application;

FIG. 2 is a flow chart illustrating a method for processing data according to an exemplary embodiment of the present application;

FIG. 3 is a schematic illustration of a further exemplary time window calculation of the present application;

FIG. 4 is a flow chart illustrating a method for processing data according to an exemplary embodiment of the present application;

FIG. 5 is a flow chart illustrating a method for processing data according to an exemplary embodiment of the present application;

fig. 6 is a schematic structural diagram of a data processing apparatus according to an exemplary embodiment of the present application;

fig. 7 is a schematic structural diagram of a data processing apparatus according to another exemplary embodiment of the present application;

fig. 8 is a schematic structural diagram of a data processing apparatus according to another exemplary embodiment of the present application;

FIG. 9 is a schematic block diagram of a computing device provided in an exemplary embodiment of the present application;

FIG. 10 is a schematic block diagram of a computing device provided in an exemplary embodiment of the present application;

fig. 11 is a schematic structural diagram of a computing device according to an exemplary embodiment of the present application.

Detailed Description

To make the objects, technical solutions and advantages of the present application more clear, the technical solutions of the present application will be clearly and completely described below with reference to specific embodiments of the present application and the accompanying drawings. It should be apparent that the described embodiments are only a few embodiments of the present application, and not all 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.

As described above, the time-series database queries data through a single query language or a single function, so that the functions are limited, and a user cannot perform complex task processing. If the user wants to perform complicated task processing, the user is required to perform additional programming by using a programming language to realize the task processing required by the user.

The embodiment of the present application provides a more flexible time sequence query method to solve the above problem.

The technical solutions provided by the embodiments of the present application are described in detail below with reference to the accompanying drawings.

Fig. 1 is a schematic structural diagram of a data processing system according to an exemplary embodiment of the present application. As shown in fig. 1, the system 100 may include: a first device 101 and a second device 102.

The first device 101 may be a device with certain computing capability, and may implement a function of sending a statement to the second device 102, and acquire response data from the second device 102. The basic structure of the first device 101 may include: at least one processor. The number of processors may depend on the configuration and type of device having a certain computing power. Devices with certain computing capabilities may also include Memory, which may be volatile, such as RAM, non-volatile, such as Read-Only Memory (ROM), flash Memory, etc., or both. The memory typically stores an Operating System (OS), one or more application programs, and may also store program data and the like. In addition to the processing unit and the memory, the device with certain computing capabilities also includes some basic configurations, such as a network card chip, an IO bus, a display component, and some peripheral devices. Alternatively, some peripheral devices may include, for example, a keyboard, a stylus, and the like. Other peripheral devices are well known in the art and will not be described in detail herein. Alternatively, the first device 101 may be a smart terminal, such as a mobile phone, a desktop computer, a notebook, a tablet computer, and the like.

The second device 102 refers to a device that can provide a computing processing service in a network virtual environment, and may refer to a device that performs data processing using a network. In physical implementation, the second device 102 may be any device capable of providing computing services, responding to service requests, and returning data processing results, and may be, for example, a cloud server, a cloud host, a virtual center, a regular server, and the like. The second device 102 mainly includes a processor, a hard disk, a memory, a system bus, and the like, and is similar to a general computer architecture.

In the embodiment of the present application, the first device 101 creates a first statement, where the first statement is used to query the required data; creating at least one second statement, wherein the second statement is used for processing the required data queried by the first statement; and combining the created first statement and the created second statement to generate a compound statement, so that the required data inquired according to the compound statement is processed to obtain a data processing result. The first device 101 sends the compound statement to the second device 102, and after receiving the compound statement, the second device 102 executes the compound statement, queries and processes data, and returns a data processing result to the first device 101 for presentation.

In an application scenario of the embodiment of the application, as shown in fig. 1, a user 103 obtains an operation interface 104 from a second device 102, such as a database server, through a first device 101, such as a computer. Such as the user 103 may access the operation interface 104 through a browser installed in the first device 101. The user performs an operation on the operation interface 104, creates a first statement, such as an SQL (Structured Query Language) execution statement, and creates a time series execution statement based on the first statement. The user 103 proceeds to create two second statements, such as processing statements for the data filtering API (Application Programming Interface) Interface and the data alert API Interface. And combining the first sentence and the second sentence through the connection identifier to generate a composite sentence, and sending the composite sentence to the database server through the computer. After receiving the compound statement, the database server obtains the semantic meaning of the compound statement through analysis, executes the semantic meaning, inquires required data, processes the required data, and sends the processed data processing result to the computer so as to be displayed to the user 103 for watching, and if alarm data is returned to the computer.

In the present embodiment described above, the first device 101 and the second device 102 perform network connection, and the network connection may be wireless connection. If the first device 101 and the second device 102 are communicatively connected, the network format of the mobile network may be any one of 2G (GSM), 2.5G (GPRS), 3G (WCDMA, TD-SCDMA, CDMA2000, UTMS), 4G (LTE), 4G + (LTE +), wiMax, 5G, and the like.

The following describes the data processing procedure in detail with reference to the method embodiment.

Fig. 2 is a flowchart illustrating a data processing method according to an exemplary embodiment of the present application. The method 200 provided by the embodiment of the present application is executed by an intelligent terminal, such as a computer. The method 200 includes the steps of:

201: a first statement is created, the first statement being used to query the desired data.

202: and creating at least one second statement, wherein the second statement is used for processing the required data queried by the first statement.

203: and combining the created first statement and the created second statement to generate a compound statement, so that the required data inquired according to the compound statement is processed to obtain a data processing result.

The following is detailed for the above steps:

The first statement may query data in the database, such as query data required by a user in the time-series database through an SQL execute statement.

Wherein creating a first statement comprises: and creating an SQL execution statement, constructing a time sequence execution statement based on the SQL execution statement, and processing time sequence data. Since the first statement is created based on the SQL execute statement, it may also be referred to as an SQL-like execute statement. The time series data may refer to data recorded in chronological order, such as daily temperature values, daily air indicators, and driving routes of monitored automobiles.

The SQL execution statement refers to an execution statement created by SQL syntax. Such as the execution statements built by select, from, where, group by, etc. SQL command statements.

The time-series execution statement is an execution statement created by a time-series syntax, and is a syntax for a time-series field or a time-series scene. Such as an execution statement built BY a sequence command statement such as WHEN, WINDOW BY, PERIOD, DELAY, etc.

The WHEN start _ time, end _ time [, timezone ] defines a time range [ start _ time, end _ time ] of the time sequence data to be queried, the timezone is an optional parameter, the geographic time zone where the input time parameter is located is determined as a default value WHEN the parameter is not input, and the default value can be 0.

WINDOW BY defines the parameters of the calculation WINDOW. In addition, window _ step, window _ st is an optional parameter, and the default value is 0.window _ len is the window size, window _ step is the window step size, window _ st is the alignment position of the starting window, and the default value is 0 (aligned with unix timestamp) = 0).

PERIOD is the PERIOD representing the query in seconds. DELAY represents the DELAY of query from real time.

For example, as described above, the user may access the time sequence database through a web interface installed in the computer, the time sequence database may provide a query interface through the web interface, or a query interface on which or through which the user may perform the sentence creating operation. The sequential database may also provide a plurality of SQL command statements and sequential command statements, as described above, for the user to select to create the first statement. For example, the user creates an SQL execution statement according to the SQL syntax through the provided SQL command statement on the query interface. The computer can respond to the creation operation or the input operation of the user, acquire the corresponding SQL execution statement and display the SQL execution statement on the query interface. Such as: SELECT _ expr [, SELECT _ expr. ]

[FROM measurement

[WHERE where_condition]

After the user creates the SQL execution statement, the user may create a timing execution statement on the SQL statement. The user can create a time sequence execution statement according to the time sequence grammar through the provided time sequence command statement. The computer can respond to the creation operation or the input operation of the user, acquire the corresponding time sequence execution statement and display the time sequence execution statement on the query interface. Such as:

WHEN start_time,end_time[,timezone]

[GROUP BY tag_name,...]

[WINDOW BY window_len[,window_step[,window_st]]]

PERIOD period_seconds

[DELAY delay_seconds]

after the user creates the first statement, the time sequence database can execute the first statement according to the first statement after receiving the first statement, and acquire the required data, where the required data may be obtained by direct query or by time sequence processing.

It should be noted that [ GROUP BY tag _ name, ] belongs to the SQL execution statement, which may be set in the time-series execution statement to perform the combination of the statements to generate the first statement.

In addition, the embodiment of the application expands the original SQL grammar and increases the support to the time sequence data field. However, the embodiment of the application is based on the SQL grammar, so that a user who will use the SQL programming language can quickly enter the SQL programming language.

In addition, in addition to the above statement forms, the user can perform random combination according to the needs of the user. The form of the random combination may be as follows:

specifically, creating a first statement includes: and creating an SQL execution statement, and constructing the execution statement for inquiring the time range based on the SQL execution statement.

Since the above description is omitted, and the description is only given, the execution statement for querying the time range may refer to the above-mentioned WHEN start _ time, end _ time [, timeout ].

Specifically, the method 200 further includes: based on the SQL execution statement, an execution statement for time window calculation is constructed.

Since the foregoing has been described, it is not repeated herein, and only for explanation, the execution statement for time window calculation may refer to the foregoing:

[WINDOW BY window_len[,window_step[,window_st]]]。

in addition, according to the WHEN syntax, the time series data of the time range [ start _ time, end _ time ] is obtained firstly, and then according to the WINDOW BY syntax, the time series data is divided into a plurality of calculation WINDOWs which are responsible for different time ranges. Each time window is responsible for calculating time sequence data in a fixed time range, the calculation result of the time window is still the time sequence data, and each time window finally calculates a binary group (time, value), wherein the time is the starting time of the time window in charge of calculation, and the value is the calculation result of the data set in the time window.

Where fig. 3 shows the process of time window calculation, in fig. 3, the raw time series data times are 0-6, the raw time series data values are 1-7, and correspond. In the first time window portion calculation 301, the window size is 3. The time range [ start _ time, end _ time ] of window 1 (i.e. time window 1) is [0, 3), the corresponding time series data value is 1-3, the calculation result of window 1 is summation, and the summation result is binary (time, value): (0,6). In addition, the same calculation is performed for window 2 (i.e. time window 2) and window 3 (i.e. time window 3), and the calculation result is obtained, which is not described herein again, but only for the explanation, since the step size of the window is 0, the start time of window 2 and window 3 is the same as that of window 3

In the second time window portion calculation 302, the window size is 3 and the step size is 2. The time range [ start _ time, end _ time ] of window 1 (i.e. time window 1) is [0, 3), the corresponding time series data value is 1-3, the calculation result of window 1 is summation, and the summation result is binary (time, value): (0,6). In addition, the same calculation is performed for window 2 (i.e. time window 2) and window 3 (i.e. time window 3), and the calculation result is obtained, which is not described herein again, but only describes that, since the step size is 2, the difference between window 2 and window 3 and the previous window is 2.

In the third time window portion calculation 303, the window size is 3, the step size is 2, and the alignment position of the start window is 1. The time range [ start _ time, end _ time ] of window 1 (i.e. time window 1) is [1, 3), the corresponding time series data value is 2-3, the calculation result of window 1 is summation, and the summation result is binary (time, value): (1,5). In addition, the same calculation is performed for window 2 (i.e. time window 2) and window 3 (i.e. time window 3), and the calculation result is obtained, which is not described herein again, but only describes that, since the step size is 2, the difference between window 2 and window 3 and the previous window is 2.

Specifically, the method 200 further includes: and constructing a periodic execution statement based on the SQL execution statement so as to carry out timed data query and processing according to the periodic execution statement.

Since the above description has been provided, it is not repeated herein, and only the periodic execution statement may refer to the PERIOD mentioned above. Then when the next cycle is reached, it will return

Data of [ start _ time + window _ step, end _ time + window _ step), and then

start _ time + = window _ step, end _ time + = window _ step. May be expressed as performing the next time window calculation.

It should be noted that, in the embodiment of the present application, the periodic execution statements may allow a timing query and a real-time query, and a timing server may be made to periodically execute tasks, such as a timing anomaly analysis task and an alarm task, without requiring a user to write a lengthy code through a programming language, and only by writing a more simplified composite statement, and then hosting the composite statement to a timing database, so that a background thereof manages the composite statement and periodically executes the composite statement. The user does not need to maintain the statement execution tasks himself, but can be assisted by the timing database.

Specifically, the method 200 further includes: and constructing a query delayed execution statement on the SQL execution statement.

Since the above description has been provided, it is not repeated herein, and only the query DELAY execution statement refers to DELAY as described above. If, for example, the current time is 12.

Further, before creating the first statement, the method 200 may further include: providing a plurality of SQL command statements and time sequence command statements; creating a first sentence comprising: responding to the creating operation of the SQL execution statement, and acquiring the SQL execution statement generated based on the SQL command statement in the creating operation; in response to a creation operation of a time-series execution statement, a time-series execution statement generated based on a time-series command statement in the creation operation is acquired.

Since the foregoing has been set forth, it will not be described in detail herein.

It should be noted that, in addition to the creation by the user, the intelligent terminal may automatically generate an execution statement according with the syntax of the programming language according to the requirement of the user. For example, the computer may automatically generate an instruction according to an automatic generation instruction issued by a user, where the instruction may carry a query target, such as query data, and thus the computer may automatically generate an SQL execution statement and a time-sequential execution statement.

202: and creating at least one second statement, wherein the second statement is used for processing the required data queried through the first statement.

The second statement refers to a statement for data processing, such as an API interface processing statement, and the API interface processing statement may input the first statement as its own data.

For example, according to the foregoing, the user may create an API interface processing statement on the query interface of the computer through the provided API interface, such as obtaining the timing API interface: getTimeSeries (start _ time, end _ time, step), and the like. The computer can respond to the calling operation, the input operation, the selection operation and the like of the user to obtain the corresponding API interface, so that the API interface processing statement is generated.

Specifically, creating at least one second sentence includes: and creating a data filtering API interface so as to filter the required data according to the data filtering API interface to obtain abnormal data meeting the abnormal filtering condition.

For example, as described above, a user may create a data FILTER API interface processing statement (e.g., FILTER API interface processing statement) on a query interface of a computer through a provided data FILTER API interface, where the statement may have a FILTER condition. After the time sequence database receives the processing statement, the statement is executed, filtering is carried out according to the filtering condition, and abnormal time sequence data which do not accord with the filtering condition or abnormal time sequence data which accord with the filtering condition can be obtained.

In addition, when there are at least two second sentences, the manner of creating at least one second sentence may include: and connecting at least one second statement through the connection identification of the statement so as to generate at least two second statements, wherein the data result obtained through the previous statement is used as the input data of the next statement.

The connection identifier refers to a symbol used for connecting statements, such as a symbol of a connection execution statement, which may be "|".

For example, according to the foregoing, after the user creates a plurality of API interface processing statements, such as two API interface processing statements, on the query interface of the computer. The two API interface processing statements may be concatenated via the concatenation identifier. E.g., C1| C2, where C1 and C2 represent API processing statements.

Specifically, creating at least one second sentence includes: creating a data filtering API interface so as to filter the required data according to the data filtering API interface to obtain the data to be processed which does not accord with the filtering condition; and creating a data alarm API interface so as to receive the data to be processed according to the data alarm API interface and alarm the data to be processed through the alarm API interface.

For example, as described above, a user may create a data FILTER API interface processing statement (e.g., FILTER API interface processing statement) on a query interface of a computer through a provided data FILTER API interface, where the statement may have a FILTER condition. It is also possible to create a data ALARM API interface processing statement (e.g., ALARM API interface processing statement) through the provided data ALARM API interface, and connect the two processing statements through a connection identifier, so that the time sequence database executes the two statements after receiving the two processing statements. And the time sequence database filters according to the filtering condition, can acquire time sequence data which do not accord with the filtering condition, takes the time sequence data which do not accord with the filtering condition as the input of a data alarm API interface processing statement to carry out alarm processing, and returns the data to a query interface of the computer for a user to check.

Furthermore, the method 200 may further include: providing a plurality of API interfaces; creating at least one second sentence comprising: and responding to the calling operation of the API interface, acquiring the corresponding API interface, and generating an API interface processing statement.

Since the foregoing has been set forth, further description is omitted herein.

It should be further noted that the second statement may include the first statement in addition to the API interface processing statement, and then the second statement may include the first statement and/or the API interface processing statement. For example, the first statement may be used as the input of the first statement in the second statement after the data is queried, and may query other data based on the queried data, or directly query the data according to the first statement in the second statement, and combine the queried data obtained before to be used as the input of the API interface processing statement.

It should be noted that, in addition to the API interface provided by the database, the user may also customize the API interface, so that the user can use the API more flexibly. The specific implementation can be as follows:

specifically, the method 200 further includes: responding to the creation operation of the API interface, and acquiring the API interface; responding to a registration request of the API interface, and registering the API interface to the database; creating at least one second sentence comprising: and responding to the calling operation of the API interface, acquiring the corresponding API interface, and generating an API interface processing statement.

For example, as previously described, a user may register with the time series database via the query interface. The user can create a custom API interface through an input operation or a creation operation and send a registration request to the timing database. And the computer responds to the registration request and sends the custom API interface to the time sequence database for registration. After the registration is successful, the computer receives the message that the registration is successful. The user can then create a second statement using this custom API interface. Since the foregoing has been set forth, the detailed description is omitted here.

203: and combining the created first statement and the created second statement to generate a compound statement, so that the queried required data is processed according to the compound statement to obtain a data processing result.

Wherein the compound statement can be used to process time series data in a database.

Specifically, combining the created first sentence and the created second sentence includes: and connecting the first statement and at least one second statement through the connection identifier of the statements so as to combine the statements, wherein the data result obtained through the previous statement is used as the input data of the next statement.

For example, according to the foregoing, after the user creates the first sentence and the second sentence on the query interface of the computer, the connection can be performed by the connection identifier conforming to "|". E.g., c0| c1| c2| c3 \8230 |/cn-1, where n > =1, cn-1 is processed using the output of ck-2 as its own input. c0 may be a first sentence and c1 to cn-1 may be a second sentence.

After the user creates the compound statement, the compound statement is sent to a database, such as a time sequence database, and executed to obtain processed data.

According to the method and the device, the flexibility of query is improved through the compound statement, and more complex tasks can be performed. Because the compound statement can allow the SQL-like execution statement to be freely combined with the API interface, a plurality of statements can be combined in series to realize more complex tasks. And complex tasks needing to be realized by a programming language in the past can be directly finished by a compound statement, such as an exception analysis task, an alarm task and the like. In addition, the compound statement can be formed by the SQL-like execution statement and the API interface, so that the readability of the compound statement is higher.

Specifically, the method 200 further includes: and sending the composite statement to a database so that the database analyzes the statement according to the composite statement, processes data according to the analyzed semantics, returns a data processing result, and displays the data processing result to a user.

For example, as described above, the computer sends the compound sentence to the time-series database in response to a user's request for sending. And after receiving the composite statement, the time sequence database analyzes the statement according to a preset grammar rule to obtain corresponding semantics such as an SQL grammar rule, a time sequence grammar rule and an API grammar rule. And processing data according to the corresponding semantics, and returning a final data processing result to a query interface of the computer for a user to check.

It should be understood that the compound sentence is grammatically compound grammatical rules and free of grammatical errors and the like before execution of the compound sentence is performed. If the error occurs, an error message needs to be returned to the intelligent terminal, so that the user can modify the intelligent terminal until the error does not exist, the time sequence database can perform normal statement analysis to obtain semantics, and the statement is executed.

Based on the similar inventive concept, fig. 4 shows a flow chart of a data processing method provided in another exemplary embodiment of the present application. The method 400 provided by the embodiments of the present application is performed by a server, such as a database server. The method 400 includes the steps of:

401: and receiving the compound statement, and dividing the compound statement to obtain a first statement and at least one second statement.

402: and analyzing each statement to obtain corresponding semantics.

403: and inquiring the required data according to the semantics of the first statement, and performing data processing on the required data according to the semantics of the second statement to obtain a data processing result.

Since the detailed description of the steps 401-403 has already been provided above, it is not repeated here. Only, in step 401, the compound sentence may be divided by recognizing the connection identifier to obtain the first sentence and the second sentence, and the first sentence and the second sentence are analyzed according to the grammar rule corresponding to the different sentences, so as to execute the sentences.

In addition, for the time-series database, the grammar rules may be defined in the time-series database, that is, the grammar rules may be preset. Then, grammar parsing and sentence execution can be performed according to preset grammar rules.

In addition, the method 400 further includes: and when the compound statement has a periodic execution statement, performing timed data query and processing according to the corresponding semantics.

Since the foregoing has been described, it is not repeated herein, but only the time-series database has a periodic execution statement, namely PERIOD, in the compound statement, and the PERIOD database can perform periodic data query and processing according to the PERIOD. And returning the data processing result to the query interface of the computer periodically for the user to check. For example, for a user to view monitored anomaly data for alerting.

In addition, reference may also be made to various steps in the method 200 described above, where the method 400 is not described in detail.

Based on the similar inventive concept, fig. 5 is a flowchart illustrating a data processing method according to another exemplary embodiment of the present application. The method 500 provided by the embodiment of the present application is executed by an intelligent terminal, such as a computer. The method 500 includes the steps of:

501: and generating an SQL-like execution statement according to the SQL command statement and the time sequence command statement, wherein the SQL-like execution statement is used for inquiring the required time sequence data from the time sequence database.

502: and generating at least one API interface processing statement according to a preset API interface so as to perform data processing on the inquired required time sequence data to obtain a data processing result.

503: and combining the SQL-like execution statement and the API interface processing statement to generate a composite execution statement of the time sequence data so as to query and process the time sequence data in the time sequence database.

Since the detailed description of the embodiments of steps 501-503 has been provided above, the detailed description is omitted here.

In addition, reference may also be made to various steps in the method 200 described above, where the method 500 is not described in detail.

Fig. 6 shows a schematic structural framework diagram of a data processing apparatus according to an exemplary embodiment of the present application. The apparatus 600 may be applied to an intelligent terminal, such as a computer. The apparatus 600 comprises: the creating module 601 and the generating module 602 are described in detail below with respect to functions of each module:

the creating module 601 is configured to create a first statement, where the first statement is used to query the required data.

The creating module 601 is configured to create at least one second statement, where the second statement is used to process the required data queried by the first statement.

The generating module 602 is configured to combine the created first statement and the created second statement to generate a compound statement, so that the queried required data is processed according to the compound statement to obtain a data processing result.

Specifically, the generating module 602 is specifically configured to: and connecting the first sentence and at least one second sentence through the connection identifier of the sentence, so as to combine the sentences, and using the data result obtained by the previous sentence as the input data of the next sentence.

In addition, when the second statement is at least two, the creating module 601 is specifically configured to: and connecting at least one second statement through the connection identifier of the statement so as to generate at least two second statements, so that the data result obtained by the previous statement is used as the input data of the next statement.

In addition, the creating module 601 is specifically configured to: and creating an SQL execution statement, constructing a time sequence execution statement based on the SQL execution statement, and processing time sequence data.

Specifically, the creating module 601 is specifically configured to: and creating an SQL execution statement, and constructing the execution statement for inquiring the time range based on the SQL execution statement.

Further, the creating module 601 is further configured to: based on the SQL execution statement, an execution statement for time window calculation is constructed.

Further, the creating module 601 is further configured to: and constructing a periodic execution statement based on the SQL execution statement so as to carry out timed data query and processing according to the periodic execution statement.

Furthermore, the creating module 601 is further configured to: and constructing an execution statement of the query delay based on the SQL execution statement.

Wherein the second statement comprises the first statement and/or the API interface processing statement.

In addition, the apparatus 600 further comprises: and the sending module is used for sending the compound sentences to the database so that the database can analyze the sentences according to the compound sentences, process data according to the semantics obtained after analysis, return data processing results and display the data processing results to the user.

The compound statement is used for processing time sequence data in the database.

Specifically, the creating module 601 includes: the first creating unit is used for creating a data filtering API interface so as to filter the required data according to the data filtering API interface and obtain the data to be processed which does not accord with the filtering condition; and the second creating unit is used for creating a data alarm API interface so as to receive the data to be processed according to the data alarm API interface and give an alarm to the data to be processed through the alarm API interface.

Specifically, the first creating unit is configured to create a data filtering API interface, so that the required data is filtered according to the data filtering API interface, and the abnormal data meeting the abnormal filtering condition is obtained.

In addition, the apparatus 600 further comprises: a providing module for providing a plurality of SQL command statements, a time sequence command statement and a plurality of API interfaces; a creating module 601, comprising: the system comprises a first establishing unit, a second establishing unit and a third establishing unit, wherein the first establishing unit is used for responding to establishing operation of an SQL execution statement and acquiring the SQL execution statement generated based on an SQL command statement in the establishing operation; a second creating unit configured to acquire, in response to a creation operation of a time-series execution statement, a time-series execution statement generated based on a time-series command statement in the creation operation; the creating module 601 is specifically configured to, in response to a call operation of the API interface, obtain the corresponding API interface, and generate an API interface processing statement.

In addition, the apparatus 600 further comprises: the acquisition module is used for responding to the creation operation of the API interface and acquiring the API interface; the registration module is used for responding to the registration request of the API interface and registering the API interface to the database; the creating module 601 is specifically configured to: and responding to the calling operation of the API interface, acquiring the corresponding API interface, and generating an API interface processing statement.

Fig. 7 is a schematic structural framework diagram of a data processing apparatus according to an exemplary embodiment of the present application. The apparatus 700 may be applied to a server, such as a database server. The apparatus 700 comprises: the receiving module 701, the parsing module 702, and the processing module 703 are described in detail below with respect to functions of each module:

a receiving module 701, configured to receive a compound statement, and divide the compound statement to obtain a first statement and at least one second statement.

And the analysis module 702 is configured to analyze each statement to obtain a corresponding semantic meaning.

The processing module 703 is configured to query the required data according to the semantics of the first statement, and perform data processing on the required data according to the semantics of the second statement to obtain a data processing result.

In addition, the processing module 703 is further configured to: and when the compound statement has a periodic execution statement, carrying out timed data query and processing according to the corresponding semantics.

For some contents that cannot be mentioned in the apparatus 700, reference may be made to the contents of the apparatus 600 described above.

Fig. 8 is a schematic structural framework diagram of a data processing apparatus according to an exemplary embodiment of the present application. The apparatus 800 may be applied to an intelligent terminal, such as a computer. The apparatus 800 comprises: the generating module 801 and the combining module 802 are described in detail below with respect to functions of the respective modules:

the generating module 801 is configured to generate an SQL-like execution statement according to the SQL command statement and the timing command statement, and is configured to query the timing database for the required timing data.

The generating module 801 is configured to generate at least one API interface processing statement according to a preset API interface, so as to perform data processing on the queried required time sequence data to obtain a data processing result.

The combination module 802 is configured to combine the SQL-like execution statement with the API interface processing statement to generate a composite execution statement of the time sequence data, so as to query and process the time sequence data in the time sequence database.

For some contents that cannot be mentioned by the apparatus 800, reference may be made to the contents of the apparatus 600 described above.

While the internal functions and structures of the apparatus 600 shown in FIG. 6 have been described above, in one possible design, the structures of the apparatus 600 shown in FIG. 6 may be implemented as a computing device, such as a computer. As shown in fig. 9, the apparatus 900 may include: a memory 901 and a processor 902;

a memory 901 for storing a computer program.

A processor 902 for executing a computer program for: creating a first statement, wherein the first statement is used for inquiring required data; creating at least one second statement, wherein the second statement is used for processing the required data queried through the first statement; and combining the created first statement and the created second statement to generate a compound statement, so that the queried required data is processed according to the compound statement to obtain a data processing result.

Specifically, the processor 902 is specifically configured to: and connecting the first statement and at least one second statement through the connection identifier of the statements so as to combine the statements, wherein the data result obtained through the previous statement is used as the input data of the next statement.

In addition, when there are at least two second statements, the processor 902 is specifically configured to: and connecting at least one second statement through the connection identifier of the statement so as to generate at least two second statements, so that the data result obtained by the previous statement is used as the input data of the next statement.

Further, the processor 902 is specifically configured to: and creating an SQL execution statement, constructing a time sequence execution statement based on the SQL execution statement, and processing time sequence data.

Specifically, the processor 902 is specifically configured to: and creating an SQL execution statement, and constructing the execution statement for inquiring the time range based on the SQL execution statement.

Further, the processor 902 is further configured to: based on the SQL execution statement, an execution statement for time window calculation is constructed.

Further, the processor 902 is further configured to: and constructing a periodic execution statement based on the SQL execution statement so as to carry out timed data query and processing according to the periodic execution statement.

Further, the processor 902 is further configured to: and constructing an execution statement of the query delay based on the SQL execution statement.

Further, the processor 902 is further configured to: and sending the compound sentences to a database so that the database analyzes the sentences according to the compound sentences, processes data according to the semantics obtained after analysis, returns a data processing result and displays the data processing result to the user.

Specifically, the processor 902 is specifically configured to: creating a data filtering API interface so as to filter the required data according to the data filtering API interface and obtain the data to be processed which does not accord with the filtering condition; and creating a data alarm API interface so as to receive the data to be processed according to the data alarm API interface and alarm the data to be processed through the alarm API interface.

Specifically, the processor 902 is specifically configured to: and creating a data filtering API interface so as to filter the required data according to the data filtering API interface to obtain abnormal data meeting the abnormal filtering condition.

Further, the processor 902 is further configured to: providing a plurality of SQL command statements, a time sequence command statement and a plurality of API interfaces; the processor 902 is specifically configured to: responding to the creating operation of the SQL execution statement, and acquiring the SQL execution statement generated based on the SQL command statement in the creating operation; responding to the creation operation of the time sequence execution statement, and acquiring the time sequence execution statement generated based on the time sequence command statement in the creation operation; and responding to the calling operation of the API interface, acquiring the corresponding API interface, and generating an API interface processing statement.

Further, the processor 902 is further configured to: responding to the creation operation of the API interface, and acquiring the API interface; responding to a registration request of the API interface, and registering the API interface to the database; the processor 902 is specifically configured to: and responding to the calling operation of the API interface, acquiring the corresponding API interface, and generating an API interface processing statement.

In addition, embodiments of the present invention provide a computer storage medium, and when being executed by one or more processors, the computer program causes the one or more processors to implement the steps of a data processing method in the method embodiment of fig. 2.

While the internal functions and structures of the apparatus 700 shown in FIG. 7 are described above, in one possible design, the structures of the apparatus 700 shown in FIG. 7 may be implemented as a computing device, such as a server. As shown in fig. 10, the apparatus 1000 may include: memory 1001, processor 1002, and communications component 1003;

a memory 1001 for storing a computer program;

a processor 1002 for executing a computer program for: dividing the compound statement to obtain a first statement and at least one second statement; analyzing each statement to obtain corresponding semantics; and inquiring the required data according to the semantics of the first statement, and performing data processing on the required data according to the semantics of the second statement to obtain a data processing result.

A communication component 1003 for receiving the compound sentence.

Further, the processor 1002 is further configured to: and when the compound statement has a periodic execution statement, carrying out timed data query and processing according to the corresponding semantics.

It should be noted that, for some contents that cannot be mentioned by the apparatus 1000, reference may be made to the contents of the apparatus 900 described above.

In addition, embodiments of the present invention provide a computer storage medium, and the computer program, when executed by one or more processors, causes the one or more processors to implement the steps of a method for processing data in the method embodiment of fig. 4.

While the internal functions and structure of the apparatus 800 shown in FIG. 8 have been described above, in one possible design, the structure of the apparatus 800 shown in FIG. 8 may be implemented as a computing device, such as a computer. As shown in fig. 11, the apparatus 1100 may include: a memory 1101 and a processor 1102;

a memory 1101 for storing a computer program;

a processor 1102 for executing a computer program for: generating an SQL-like execution statement according to the SQL command statement and the time sequence command statement, and inquiring the required time sequence data from the time sequence database; generating at least one API interface processing statement according to a preset API interface so as to process the inquired required time sequence data to obtain a data processing result; and combining the SQL-like execution statement and the API interface processing statement to generate a composite execution statement of the time sequence data so as to query and process the time sequence data in the time sequence database.

For some contents that the device 1100 fails to mention, reference may be made to the contents of the device 900 described above.

In addition, embodiments of the present invention provide a computer storage medium, and the computer program, when executed by one or more processors, causes the one or more processors to implement the steps of a method for processing data in the method embodiment of fig. 5.

In addition, in some of the flows described in the above embodiments and the drawings, a plurality of operations are included in a specific order, but it should be clearly understood that the operations may be executed out of the order presented herein or in parallel, and the sequence numbers of the operations, such as 201, 202, 203, etc., are merely used for distinguishing different operations, and the sequence numbers themselves do not represent any execution order. Additionally, the flows may include more or fewer operations, and the operations may be performed sequentially or in parallel. It should be noted that, the descriptions of "first", "second", etc. in this document are used for distinguishing different messages, devices, modules, etc., and do not represent a sequential order, nor do they limit the types of "first" and "second".

The above-described embodiments of the apparatus are merely illustrative, and 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 modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.

Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment may be implemented by a necessary general hardware platform, and may also be implemented by a combination of hardware and software. With this understanding in mind, the above-described aspects and portions of the present technology which contribute substantially or in part to the prior art may be embodied in the form of a computer program product, which may be embodied on one or more computer-usable storage media having computer-usable program code embodied therein, including without limitation disk storage, CD-ROM, optical storage, and the like.

The present invention has been described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations 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 multimedia data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable multimedia data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable multimedia data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable multimedia data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.

The memory may include forms of volatile memory in a computer readable medium, random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.

Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.

Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will 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 of the embodiments of the present invention.

Claims

1. A method of processing data, comprising:

creating a first statement, wherein the first statement is used for inquiring required data;

creating at least one second statement, wherein the second statement is used for processing the required data queried through the first statement;

combining the created first statement and the created second statement to generate a composite statement, so that the queried required data is processed according to the composite statement to obtain a data processing result;

the first statement is an SQL-like execution statement created based on an SQL execution statement, and the SQL-like execution statement is used for constructing a time sequence execution statement and processing time sequence data; the at least one second statement includes an API interface processing statement created based on the API interface.

2. The method of claim 1, the combining according to the created first sentence and the created second sentence, comprising:

and connecting the first statement and at least one second statement through the connection identifier of the statements so as to combine the statements, wherein the data result obtained through the previous statement is used as the input data of the next statement.

3. The method of claim 1, when the second sentences are at least two, the creating at least one second sentence comprising:

and connecting the at least one second statement through the connection identifier of the statement so as to generate at least two second statements, so that the data result obtained through the previous statement is used as the input data of the next statement.

4. The method of claim 1, further comprising:

based on the SQL execution statement, an execution statement for querying a time range is constructed.

5. The method of claim 1, further comprising:

based on the SQL execution statement, an execution statement for time window calculation is constructed.

6. The method of claim 4 or 5, further comprising:

and constructing a periodic execution statement based on the SQL execution statement so as to query and process data in a timing manner according to the periodic execution statement.

7. The method of claim 6, further comprising:

and constructing an execution statement of the query delay based on the SQL execution statement.

8. The method of claim 1, the second statement comprising a first statement and/or an API interface processing statement.

9. The method of claim 1, further comprising:

and sending the composite statement to a database so that the database analyzes the statement according to the composite statement, processes data according to the analyzed semantics, returns a data processing result, and displays the data processing result to a user.

10. The method of claim 9, the compound statement for processing time-series data in a database.

11. The method of claim 1, the creating at least one second statement comprising:

creating a data filtering API interface so as to filter the required data according to the data filtering API interface to obtain the data to be processed which does not accord with the filtering condition;

and creating a data alarm API interface so as to receive the data to be processed according to the data alarm API interface and alarm the data to be processed through the alarm API interface.

12. The method of claim 1, the creating at least one second statement, comprising:

and creating a data filtering API interface so as to filter the required data according to the data filtering API interface to obtain abnormal data meeting abnormal filtering conditions.

13. The method of claim 1, further comprising:

providing a plurality of SQL command statements, a time sequence command statement and a plurality of API interfaces;

the creating of the first statement comprises:

responding to the creating operation of the SQL execution statement, and acquiring the SQL execution statement generated based on the SQL command statement in the creating operation;

responding to the creation operation of the time sequence execution statement, and acquiring the time sequence execution statement generated based on the time sequence command statement in the creation operation;

the creating at least one second sentence comprises:

and responding to the calling operation of the API interface, acquiring the corresponding API interface, and generating an API interface processing statement.

14. The method of claim 1, further comprising:

responding to the creation operation of the API interface, and acquiring the API interface;

responding to a registration request of the API interface, and registering the API interface to a database;

the creating at least one second sentence comprises:

15. A method of processing data, the method further comprising:

receiving a composite statement, and dividing the composite statement to obtain a first statement and at least one second statement;

analyzing each statement to obtain corresponding semantics;

inquiring required data according to the semantics of the first statement, and performing data processing on the required data according to the semantics of the second statement to obtain a data processing result;

16. The method of claim 15, further comprising:

and when the compound statement has a periodic execution statement, carrying out timed data query and processing according to the corresponding semantics.

17. A method of processing data, comprising:

generating an SQL-like execution statement according to the SQL command statement and the time sequence command statement, and inquiring the required time sequence data from the time sequence database;

generating at least one API interface processing statement according to a preset API interface so as to process the inquired required time sequence data to obtain a data processing result;

and combining the SQL-like execution statement and the API interface processing statement to generate a composite execution statement of the time sequence data so as to query and process the time sequence data in the time sequence database.

18. A computing device, comprising: a memory and a processor;

the memory for storing a computer program;

the processor to execute the computer program to:

19. A computing device, comprising: a memory, a processor, and a communication component;

the memory for storing a computer program;

the processor to execute the computer program to:

dividing the compound statement to obtain a first statement and at least one second statement;

analyzing each statement to obtain corresponding semantics;

the communication component is used for receiving a compound statement;

20. A computing device, comprising: a memory and a processor;

the memory for storing a computer program;

the processor to execute the computer program to:

and combining the SQL-like execution statement and the API interface processing statement to generate a composite execution statement of time sequence data so as to query and process the time sequence data in the time sequence database.

21. A computer readable storage medium storing a computer program which, when executed by one or more processors, causes the one or more processors to carry out the steps of the method of any one of claims 1-17.