CN112069163A

CN112069163A - Data processing method and device, electronic equipment and storage medium

Info

Publication number: CN112069163A
Application number: CN201910495812.0A
Authority: CN
Inventors: 雷淮轲; 常盛; 刘士博
Original assignee: Alibaba Group Holding Ltd
Current assignee: Alibaba Group Holding Ltd
Priority date: 2019-06-10
Filing date: 2019-06-10
Publication date: 2020-12-11

Abstract

The disclosure relates to a data processing method and apparatus, an electronic device, and a storage medium. The method comprises the following steps: acquiring a data processing instruction submitted by a client; determining to-be-processed data in a first data table corresponding to the data processing instruction; processing the data to be processed according to the data processing instruction to obtain result data, and writing the result data into a second data table; and returning result information to the client, wherein the result information is generated at least according to the second data table. According to the data processing method and device, the data to be processed can be automatically determined according to the data processing instruction submitted by the client, and a user does not need to manually subscribe the data to be processed, so that the automation degree of data processing can be improved, and the operation complexity of data processing is reduced.

Description

Data processing method and device, electronic equipment and storage medium

Technical Field

The present disclosure relates to the field of data processing technologies, and in particular, to a data processing method and apparatus, an electronic device, and a storage medium.

Background

In the background of the era of explosive data volumes, the value of data will generally decrease gradually over time after its production. Therefore, it is preferable to process the data in real time and quickly after it is generated, rather than batch processing after the data is stored together.

Stream data is a set of sequential, large, fast, continuous arriving data sequences, and in general, stream data can be viewed as a dynamic collection of data that grows indefinitely over time. Streaming data is typically generated continuously from a large number of data sources.

Stream computation is a stream data oriented computation. A stream computing system is a real-time system that processes unbounded datasets, with the characteristics of continuous operation and low latency, relative to an offline batch process.

Currently, in stream computing, a user needs to manually subscribe to data to be processed, for example, the user needs to manually subscribe to the data to be processed from a message queue, which results in higher complexity of operation of stream computing.

Disclosure of Invention

The present disclosure proposes a data processing technical solution.

According to a first aspect of the present disclosure, there is provided a data processing method, including:

acquiring a data processing instruction submitted by a client;

determining to-be-processed data in a first data table corresponding to the data processing instruction;

processing the data to be processed according to the data processing instruction to obtain result data, and writing the result data into a second data table;

and returning result information to the client, wherein the result information is generated at least according to the second data table.

In a possible implementation manner, after obtaining the data processing instruction submitted by the client, before the writing the result data into the second data table, the method further includes:

determining attribute information of the first data table;

and determining the attribute information of the second data table according to the attribute information of the first data table.

receiving an attribute information configuration request from the client;

and determining the attribute information of the second data table according to the attribute information in the attribute information configuration request.

In a possible implementation manner, before returning result information to the client, the method further includes:

receiving a result information generation request from the client, wherein the result information generation request comprises range information of requested result data;

and screening out result data which are consistent with the range information from the second data table, and generating result information according to the result data which are consistent with the range information.

In a possible implementation manner, the result information generation request further includes presentation form information;

generating result information according to result data consistent with the range information, including:

and generating result information according to the display form information and the result data consistent with the range information.

In a possible implementation manner, after the determining the attribute information of the first data table, the method further includes:

and sending the attribute information of the first data table to the client so that the client can display the attribute information of the first data table.

In a possible implementation manner, after determining the attribute information of the second data table, the method further includes:

and sending the attribute information of the second data table to the client so that the client can display the attribute information of the second data table.

In one possible implementation, the data processing instruction is generated based on writing a structured query language, or the data processing instruction is generated based on an operation of dragging an abstraction component.

In one possible implementation, the data processing instructions are used for performing real-time data analysis, real-time early warning, or real-time monitoring.

According to a second aspect of the present disclosure, there is provided a data processing method including:

generating a data processing instruction;

submitting the data processing instruction to a server so that the server can determine to-be-processed data in a first data table corresponding to the data processing instruction, processing the to-be-processed data according to the data processing instruction to obtain result data, and writing the result data into a second data table;

and receiving result information returned by the server, wherein the result information is generated at least according to the second data table.

In a possible implementation manner, the attribute information of the second data table is determined at least according to the attribute information of the first data table.

In one possible implementation manner, the method further includes:

and sending an attribute information configuration request to the server, so that the server determines the attribute information of the second data table according to the attribute information in the attribute information configuration request.

In a possible implementation manner, before the receiving result information returned by the server, the method further includes:

and sending a result information generation request to the server, so that the server can conveniently screen out result data which are consistent with the range information according to the range information of the result data requested in the result information generation request, and generate the result information according to the result data which are consistent with the range information.

In a possible implementation manner, the result information generation request further includes presentation form information, and the result information is generated according to the presentation form information and result data conforming to the range information.

In one possible implementation manner, the method further includes:

obtaining attribute information of the first data table from the server;

and displaying the attribute information of the first data table.

In one possible implementation manner, the method further includes:

obtaining attribute information of the second data table from the server;

and displaying the attribute information of the second data table.

According to a third aspect of the present disclosure, there is provided a data processing apparatus comprising:

the first obtaining module is used for obtaining a data processing instruction submitted by a client;

the first determining module is used for determining to-be-processed data in a first data table corresponding to the data processing instruction;

the processing module is used for processing the data to be processed according to the data processing instruction to obtain result data and writing the result data into a second data table;

and the return module is used for returning result information to the client, wherein the result information is generated at least according to the second data table.

In one possible implementation manner, the method further includes:

the second determining module is used for determining the attribute information of the first data table;

and the third determining module is used for determining the attribute information of the second data table according to the attribute information of the first data table.

In one possible implementation manner, the method further includes:

the first receiving module is used for receiving an attribute information configuration request from the client;

and the fourth determining module is used for determining the attribute information of the second data table according to the attribute information in the attribute information configuration request.

In one possible implementation manner, the method further includes:

a second receiving module, configured to receive a result information generation request from the client, where the result information generation request includes range information of requested result data;

and the generating module is used for screening out result data which are consistent with the range information from the second data table and generating result information according to the result data which are consistent with the range information.

the generation module is configured to:

In one possible implementation manner, the method further includes:

and the first sending module is used for sending the attribute information of the first data table to the client so that the client can display the attribute information of the first data table.

In one possible implementation manner, the method further includes:

and the second sending module is used for sending the attribute information of the second data table to the client so that the client can display the attribute information of the second data table.

According to a fourth aspect of the present disclosure, there is provided a data processing apparatus comprising:

the generating module is used for generating a data processing instruction;

the submitting module is used for submitting the data processing instruction to the server so that the server can determine to-be-processed data in a first data table corresponding to the data processing instruction, process the to-be-processed data according to the data processing instruction to obtain result data, and write the result data into a second data table;

and the receiving module is used for receiving result information returned by the server, wherein the result information is generated at least according to the second data table.

In one possible implementation manner, the method further includes:

and the third sending module is used for sending an attribute information configuration request to the server so that the server can determine the attribute information of the second data table according to the attribute information in the attribute information configuration request.

In one possible implementation manner, the method further includes:

and the fourth sending module is used for sending a result information generation request to the server, so that the server can conveniently screen out result data which accord with the range information from the second data table according to the range information of the result data requested in the result information generation request, and generate the result information according to the result data which accord with the range information.

In one possible implementation manner, the method further includes:

a second obtaining module, configured to obtain attribute information of the first data table from the server;

and the first display module is used for displaying the attribute information of the first data table.

In one possible implementation manner, the method further includes:

a third obtaining module, configured to obtain attribute information of the second data table from the server;

and the second display module is used for displaying the attribute information of the second data table.

According to a fifth aspect of the present disclosure, there is provided an electronic device comprising:

one or more processors;

a memory associated with the one or more processors for storing executable instructions that, when read and executed by the one or more processors, perform the data processing method of the first aspect described above.

According to a sixth aspect of the present disclosure, there is provided an electronic device comprising:

one or more processors;

a memory associated with the one or more processors for storing executable instructions that, when read and executed by the one or more processors, perform the data processing method of the second aspect described above.

According to a seventh aspect of the present disclosure, there is provided a non-transitory computer readable storage medium having stored thereon computer program instructions which, when executed by a processor, implement the data processing method of the first aspect described above.

According to an eighth aspect of the present disclosure, there is provided a non-transitory computer readable storage medium having stored thereon computer program instructions which, when executed by a processor, implement the data processing method of the above second aspect.

In the embodiment of the disclosure, data to be processed in the first data table corresponding to the data processing instruction is determined by obtaining the data processing instruction submitted by the client, the data to be processed is processed according to the data processing instruction to obtain result data, the result data is written into the second data table, and result information containing the result data is returned to the client.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.

Other features and aspects of the present disclosure will become apparent from the following detailed description of exemplary embodiments, which proceeds with reference to the accompanying drawings.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and, together with the description, serve to explain the principles of the disclosure.

FIG. 1 illustrates an architecture diagram of a data processing system provided by an embodiment of the present disclosure.

Fig. 2 is a schematic diagram illustrating a data processing flow provided by an embodiment of the present disclosure.

Fig. 3 shows a flowchart of a data processing method provided by an embodiment of the present disclosure.

Fig. 4 shows a flowchart of another data processing method provided by the embodiment of the present disclosure.

Fig. 5 shows a block diagram of a data processing apparatus according to an embodiment of the present disclosure.

Fig. 6 shows a block diagram of another data processing apparatus according to an embodiment of the present disclosure.

Fig. 7 illustrates a block diagram of an electronic device 800 provided by an embodiment of the disclosure.

Fig. 8 shows a block diagram of an electronic device 1900 provided by an embodiment of the disclosure.

Detailed Description

Various exemplary embodiments, features and aspects of the present disclosure will be described in detail below with reference to the accompanying drawings. In the drawings, like reference numbers can indicate functionally identical or similar elements. While the various aspects of the embodiments are presented in drawings, the drawings are not necessarily drawn to scale unless specifically indicated.

The word "exemplary" is used exclusively herein to mean "serving as an example, embodiment, or illustration. Any embodiment described herein as "exemplary" is not necessarily to be construed as preferred or advantageous over other embodiments.

The term "and/or" herein is merely an association describing an associated object, meaning that three relationships may exist, e.g., a and/or B, may mean: a exists alone, A and B exist simultaneously, and B exists alone. In addition, the term "at least one" herein means any one of a plurality or any combination of at least two of a plurality, for example, including at least one of A, B, C, and may mean including any one or more elements selected from the group consisting of A, B and C.

Furthermore, in the following detailed description, numerous specific details are set forth in order to provide a better understanding of the present disclosure. It will be understood by those skilled in the art that the present disclosure may be practiced without some of these specific details. In some instances, methods, means, elements and circuits that are well known to those skilled in the art have not been described in detail so as not to obscure the present disclosure.

FIG. 1 illustrates an architecture diagram of a data processing system provided by an embodiment of the present disclosure. As shown in FIG. 1, the data processing system includes a server and a client. The server can be deployed in a cloud server, and the client can be deployed in terminal equipment associated with the user. In the embodiment of the disclosure, a client generates a data processing instruction and submits the data processing instruction to a server; the server side obtains a data processing instruction submitted by the client side and determines data to be processed in a first data table corresponding to the data processing instruction; the server side processes the data to be processed according to the data processing instruction to obtain result data, and writes the result data into a second data table; the server side returns result information containing result data to the client side, wherein the result information is generated at least according to the second data table; and the client receives result information containing result data returned by the server.

In some embodiments, the data to be processed may be real-time data, and the server may process the data to be processed through a stream processing framework. In other embodiments, the data to be processed may not be real-time data, and the server may process the data to be processed through a batch processing framework or other data processing frameworks.

Fig. 2 is a schematic diagram illustrating a data processing flow provided by an embodiment of the present disclosure. As shown in fig. 2, a real-time workbench system can be implemented by using the data processing method provided by the embodiment of the present disclosure. In the example shown in fig. 2, a user may write SQL (Structured Query Language) corresponding to a real-time processing service at a client, and the client generates a data processing instruction according to the SQL written by the user; the user can click and issue at the client side, so that the client side submits a data processing instruction to the server side. After the client submits a data processing instruction to the server, the server processes the data to be processed through the stream processing frame according to the data processing instruction to obtain result data, wherein the stream processing frame can be a Flink, and the result data can be written into a second data table in a database such as an HDB (high-level data base). The server side can send the attribute information of the first data table corresponding to the data processing instruction to the client side, so that the client side can display the attribute information of the first data table corresponding to the data processing instruction; the server side can also send the attribute information of the second data table to the client side, so that the client side can display the attribute information of the second data table. The attribute information of the first data table and the attribute information of the second data table corresponding to the data processing instruction may be stored in an attribute information system (also referred to as a real-time metadata system as shown in fig. 2), and the client may view the attribute information of the first data table and the attribute information of the second data table through the attribute information system. After the server obtains the result data, the result information of the result data may be contained in the client through an OLAP (On-Line Analysis Processing) and an Analysis engine, where the result information may be a visual chart.

The specific implementation flows of the server and the client can be referred to below, and are not detailed here.

Fig. 3 shows a flowchart of a data processing method provided by an embodiment of the present disclosure. The execution subject of the data processing method may be a data processing apparatus. The data processing method can be executed by a server. In some possible implementations, the data processing method may be implemented by a processor calling computer readable instructions stored in a memory. As shown in fig. 3, the method includes steps S31 through S34.

In step S31, a data processing instruction submitted by the client is obtained.

In embodiments of the present disclosure, the data processing instructions may represent rules or principles for processing data. From the data processing instructions, it can be determined how the user wishes to process the data. For example, in SQL, if the user wants to count data, the data processing instruction may be "select a, count (b) group by a".

In one possible implementation, the data processing instructions are generated based on writing a structured query language. In this implementation, the data processing instructions may be generated based on SQL written by the user.

In another possible implementation, the data processing instructions are generated based on an operation of a drag abstraction component. In one example, common processing operations may be abstracted into abstract components such that a user drags into data processing instructions in lieu of writing the operations by the user. For example, the abstraction component may include operator components such as filter, count, sum, and avg.

In other possible implementations, the data processing instructions may also be generated based on writing other programming languages, which is not limited by the embodiments of the present disclosure.

In one possible implementation, the data processing instructions are used to perform real-time data analysis, real-time pre-warning, or real-time monitoring. For example, the data processing instructions may be used for real-time data analysis, real-time early warning, or real-time monitoring of newly-brought-online products or strategies. For example, the real-time monitoring may be GMV (Gross merchandis Volume) monitoring.

It should be noted that, although the functions of the data processing instructions are described above in terms of real-time data analysis, real-time pre-warning, or real-time monitoring, those skilled in the art will appreciate that the present disclosure should not be limited thereto. The data processing instruction in the embodiments of the present disclosure may be used in various application scenarios of real-time data processing or non-real-time data processing, and those skilled in the art may determine the role of the data processing instruction according to the requirements of the actual application scenario.

In step S32, the data to be processed in the first data table corresponding to the data processing instruction is determined.

In the embodiment of the present disclosure, the first data table may represent a data table on which the data processing instruction depends, and the number of the first data tables may be one or more.

In the embodiment of the disclosure, the first data table corresponding to the data processing instruction can be automatically determined according to the data processing instruction, and a user does not need to manually subscribe the first data table, so that the data to be processed in the first data table corresponding to the data processing instruction can be automatically determined.

In one possible implementation, the data to be processed may be real-time data, and the real-time data may be carried through a message queue. For example, real-time data may be carried through message queues provided by TT, MetaQ, or Kafka, etc.

In another possible implementation, the data to be processed may be non-real-time data.

In the embodiment of the disclosure, the server automatically obtains and processes the data to be processed, and the user does not need to manually subscribe to the message queue.

In a possible implementation manner, after obtaining the data processing instruction submitted by the client, before writing the result data into the second data table, the method further includes: determining attribute information of a first data table; and determining the attribute information of the second data table according to the attribute information of the first data table. In this implementation, the attribute information of the first data table may be automatically determined, and the attribute information of the second data table may include the automatically determined attribute information of each first data table.

In the embodiment of the present disclosure, the attribute information may refer to description information of the table. For example, the description information of the table may include the name of the table, the description of the table, the type of the table, the fields of the table, the type of the fields, the meaning of the fields, the Owner information, and the like. The attribute information of the first data table may refer to description information of the first data table, and the attribute information of the second data table may refer to description information of the second data table.

In a possible implementation manner, the server may synchronize the attribute information of the first data table to the attribute information system, so that the client views the attribute information of the first data table through the attribute information system.

In a possible implementation manner, after obtaining the data processing instruction submitted by the client, before writing the result data into the second data table, the method further includes: receiving an attribute information configuration request from a client; and determining the attribute information of the second data table according to the attribute information in the attribute information configuration request. In this implementation, the attribute information of the first data table may be configured by the user, the attribute information of the first data table may include the attribute information in the attribute information configuration request, and the attribute information of the second data table may include the attribute information of the first data table configured according to the attribute information configuration request.

In one possible implementation, the attribute information of the first data table may include the attribute information of the first data table automatically determined according to the data processing instruction, and the attribute information in the attribute information configuration request. The attribute information of the second data table may include automatically determined attribute information of each of the first data tables, and attribute information of the first data table configured according to the attribute information configuration request.

In a possible implementation manner, after determining the attribute information of the first data table, the method further includes: and sending the attribute information of the first data table to the client so that the client can display the attribute information of the first data table. In this implementation, the server may send attribute information of the first data table to the client based on a request of the client; or, the server may actively send the attribute information of the first data table to the client.

In step S33, the data to be processed is processed according to the data processing instruction to obtain result data, and the result data is written into the second data table.

In one possible implementation, the attribute information of the second data table is determined according to the attribute information of the first data table.

In the embodiment of the present disclosure, the second data table represents a data table for storing result data, and the number of the second data table may be one or more.

In the embodiment of the present disclosure, if the data to be processed is real-time data, the data to be processed may be processed according to the data processing instruction through the stream processing framework. The stream processing framework encapsulates the stream processing code and provides a corresponding API (Application Programming Interface), and the server can call the corresponding API when processing data through the stream processing framework. The stream processing framework in the embodiments of the present disclosure may be Flink, Spark, Storm, or the like, and is not limited herein.

In one possible implementation manner, processing data to be processed according to a data processing instruction includes: generating an execution instruction corresponding to the stream processing framework according to the data processing instruction; and processing the data to be processed by adopting the execution instruction. In this implementation manner, the data processing instruction submitted by the client is converted into an execution instruction that can be executed by the stream processing framework, so that the stream processing framework processes the data to be processed by using the execution instruction. In this implementation manner, the data processing instruction and the execution instruction corresponding to the stream processing framework may use different languages, for example, the data processing instruction uses SQL, and the execution instruction corresponding to the stream processing framework uses java. Because the user can write and generate the data processing instruction based on SQL, and does not need to write an execution instruction suitable for the stream processing frame by the user, the difficulty is lower for the user, the user does not need to care about the stream processing frame in the development process, and therefore, the user does not need to spend a large amount of time on learning the stream processing frame, and the learning cost of using the stream processing technology is reduced.

In a possible implementation manner, after obtaining a data processing instruction submitted by a client, a server may continuously run an execution instruction corresponding to the data processing instruction, so as to process data to be processed according to the execution instruction, and obtain result data.

The database in the embodiment of the present disclosure may be an OLAP database HDB, or may also be ADS or TiDB, and is not limited herein.

In one possible implementation manner, the attribute information of the second data table can be automatically determined according to the attribute information of the first data table without manually setting the attribute information of the second data table by a user. According to the implementation, the second data table can be automatically generated without manually establishing the second data table by a user.

In another possible implementation manner, an attribute information setting request from the client may be received, and the attribute information of the second data table may be set according to the attribute information setting request.

In a possible implementation manner, the server may synchronize the attribute information of the second data table to the attribute information system, so that the client views the attribute information of the second data table through the attribute information system.

In a possible implementation manner, after determining the attribute information of the second data table, the method further includes: and sending the attribute information of the second data table to the client so that the client can display the attribute information of the second data table. In this implementation, the server may send the attribute information of the second data table to the client based on a request of the client; or the server may actively send the attribute information of the second data table to the client.

In step S34, result information including result data is returned to the client, where the result information is generated from at least the second data table.

In one possible implementation, the result information may be visual information. For example, the result information may include one or both of a graph of visualizations and a table of visualizations.

In a possible implementation manner, before returning result information containing result data to the client, the method further includes: receiving a result information generation request from a client, wherein the result information generation request comprises range information of requested result data; and screening out result data which are consistent with the range information from the second data table, and generating result information containing the result data according to the result data which are consistent with the range information.

In this implementation, result information containing result data may be returned to the client based on the client's request. The range information of the requested result data may include attribute information and time range information of the requested result data, and the like, which is not limited in this disclosure. For example, the attribute information of the requested result data may include a field of the requested result data, and the like.

In one example, the result information generation request further includes presentation form information; generating result information including result data based on the result data corresponding to the range information, including: and generating result information containing result data according to the display form information and the result data consistent with the range information.

In other possible implementation manners, result information containing result data may be returned to the client according to a preset frequency, or result information containing result data may be returned to the client at regular time. For example, result information containing the last hour of result data may be returned to the client at a frequency of once per hour.

Fig. 4 shows a flowchart of another data processing method provided by the embodiment of the present disclosure. The execution subject of the data processing method may be a data processing apparatus. For example, the data processing method may be performed by a client. In some possible implementations, the data processing method may be implemented by a processor calling computer readable instructions stored in a memory. As shown in fig. 4, the method includes steps S41 through S43.

In step S41, a data processing instruction is generated.

The user in the embodiment of the present disclosure may be any user, for example, a service person or a developer such as an analyst.

In one possible implementation, the data processing instructions are used to perform real-time data analysis, real-time pre-warning, or real-time monitoring. For example, the data processing instructions may be used for real-time data analysis, real-time early warning, or real-time monitoring of newly-brought-online products or strategies. For example, the real-time monitoring may be GMV monitoring.

In step S42, a data processing instruction is submitted to the server, so that the server determines to-be-processed data in the first data table corresponding to the data processing instruction, processes the to-be-processed data according to the data processing instruction to obtain result data, and writes the result data in the second data table.

In one possible implementation manner, the data processing instruction can be submitted to the server side in response to the user clicking the issued operation at the client side.

In one possible implementation, the attribute information of the second data table is determined at least according to the attribute information of the first data table.

In one possible implementation, the attribute information of the second data table may include automatically determined attribute information of each first data table.

In one possible implementation manner, the server may synchronize the attribute information of the first data table to the attribute information system. The client can view the attribute information of the first data table through the attribute information system.

In one possible implementation manner, the method further includes: and sending an attribute information configuration request to the server, so that the server determines the attribute information of the second data table according to the attribute information in the attribute information configuration request. In this implementation, the client may generate the attribute information configuration request based on an operation of configuring the attribute information by the user, so that the attribute information of the first data table may be configured by the user, the attribute information of the first data table may include the attribute information in the attribute information configuration request, and the attribute information of the second data table may include the attribute information of the first data table configured according to the attribute information configuration request.

In one possible implementation manner, the attribute information of the first data table may be determined according to the attribute information of the first data table automatically determined by the data processing instruction and the attribute information in the attribute information configuration request. In this implementation, the attribute information of the first data table may include both the attribute information of the first data table automatically determined according to the data processing instruction and the attribute information in the attribute information configuration request.

In one possible implementation manner, the server may synchronize the attribute information of the second data table to the attribute information system. And the client checks the attribute information of the second data table through the attribute information system. The attribute information of the second data table may include automatically determined attribute information of each of the first data tables, and attribute information of the first data table configured according to the attribute information configuration request.

In step S43, result information including result data returned by the server is received, where the result information is generated at least according to the second data table.

In the embodiment of the disclosure, a data processing instruction is generated, the data processing instruction is submitted to a server, so that the server determines to-be-processed data in a first data table corresponding to the data processing instruction, the to-be-processed data is processed according to the data processing instruction to obtain result data, the result data is written into a second data table, and result information including the result data returned by the server is received.

In a possible implementation manner, before receiving result information including result data returned by the server, the method further includes: and sending a result information generation request to the server side, so that the server side can screen out result data which are consistent with the range information according to the range information of the result data requested in the result information generation request, and generate result information containing the result data according to the result data which are consistent with the range information. In this implementation, the result information generation information may be generated based on a user request, and the result information generation request may be sent to the server.

In a possible implementation manner, the result information generation request further includes presentation form information, and the result information is generated according to the presentation form information and the result data corresponding to the range information.

In one example, a user can customize the presentation form of the result information by dragging the chart component, and the client can generate the presentation form information based on the operation of dragging the chart component by the user.

According to the implementation mode, the processing result of the data to be processed can be visually displayed in a form required by a user.

In one possible implementation manner, the method further includes: obtaining attribute information of a first data table from a server; and displaying the attribute information of the first data table.

According to the implementation mode, the attribute information of the first data table is displayed at the client, so that the attribute information is visualized, and a user can conveniently and timely check the attribute information of the first data table.

In one possible implementation manner, the method further includes: obtaining attribute information of a second data table from a server; and displaying the attribute information of the second data table.

According to the implementation mode, the attribute information of the second data table is displayed at the client, so that the attribute information is visualized, and a user can conveniently and timely check the attribute information of the second data table.

It is understood that the above-mentioned method embodiments of the present disclosure can be combined with each other to form a combined embodiment without departing from the logic of the principle, which is limited by the space, and the detailed description of the present disclosure is omitted.

It will be understood by those skilled in the art that in the method of the present invention, the order of writing the steps does not imply a strict order of execution and any limitations on the implementation, and the specific order of execution of the steps should be determined by their function and possible inherent logic.

In addition, the present disclosure also provides a data processing apparatus, an electronic device, a computer-readable storage medium, and a program, which can be used to implement any data processing method provided by the present disclosure, and the corresponding technical solutions and descriptions and corresponding descriptions in the method section are not repeated.

Fig. 5 shows a block diagram of a data processing apparatus according to an embodiment of the present disclosure. As shown in fig. 5, the data processing apparatus includes: a first obtaining module 51, configured to obtain a data processing instruction submitted by a client, and obtain data to be processed; the first determining module 52 is configured to determine to-be-processed data in a first data table corresponding to the data processing instruction; the processing module 53 is configured to process the data to be processed according to the data processing instruction to obtain result data, and write the result data into the second data table; a returning module 54, configured to return result information including result data to the client, where the result information is generated according to at least the second data table.

In one possible implementation manner, the method further includes: the second determining module is used for determining the attribute information of the first data table; and the third determining module is used for determining the attribute information of the second data table according to the attribute information of the first data table.

In one possible implementation manner, the method further includes: the first receiving module is used for receiving an attribute information configuration request from a client; and the fourth determining module is used for determining the attribute information of the second data table according to the attribute information in the attribute information configuration request.

In one possible implementation manner, the method further includes: receiving a result information generation request from a client, wherein the result information generation request comprises range information of requested result data; and screening out result data which are consistent with the range information from the second data table, and generating result information containing the result data according to the result data which are consistent with the range information.

In one possible implementation, the result information generation request further includes presentation form information; the generation module is to: and generating result information containing result data according to the display form information and the result data consistent with the range information.

In one possible implementation manner, the method further includes: and the first sending module is used for sending the attribute information of the first data table to the client so that the client can display the attribute information of the first data table.

In one possible implementation manner, the method further includes: and the second sending module is used for sending the attribute information of the second data table to the client so that the client can display the attribute information of the second data table.

In one possible implementation, the data processing instructions are generated based on writing a structured query language, or alternatively, the data processing instructions are generated based on an operation of dragging an abstract component.

In one possible implementation, the data processing instructions are used to perform real-time data analysis, real-time pre-warning, or real-time monitoring.

Fig. 6 shows a block diagram of another data processing apparatus according to an embodiment of the present disclosure. As shown in fig. 6, the data processing apparatus includes: a generating module 61, configured to generate a data processing instruction; the submitting module 62 is configured to submit a data processing instruction to the server, so that the server determines to-be-processed data in the first data table corresponding to the data processing instruction, processes the to-be-processed data according to the data processing instruction to obtain result data, and writes the result data into the second data table; and the receiving module 63 is configured to receive result information including result data returned by the server, where the result information is generated at least according to the second data table.

In one possible implementation manner, the method further includes: and the third sending module is used for sending the attribute information configuration request to the server so that the server determines the attribute information of the second data table according to the attribute information in the attribute information configuration request.

In one possible implementation manner, the method further includes: and the fourth sending module is used for sending the result information generation request to the server, so that the server can screen the result data which are consistent with the range information from the second data table according to the range information of the result data requested in the result information generation request, and generate the result information containing the result data according to the result data which are consistent with the range information.

In one possible implementation manner, the method further includes: the second obtaining module is used for obtaining the attribute information of the first data table from the server; and the first display module is used for displaying the attribute information of the first data table.

In one possible implementation manner, the method further includes: a third obtaining module, configured to obtain attribute information of the second data table from the server; and the second display module is used for displaying the attribute information of the second data table.

In some embodiments, functions of or modules included in the apparatus provided in the embodiments of the present disclosure may be used to execute the method described in the above method embodiments, and specific implementation thereof may refer to the description of the above method embodiments, and for brevity, will not be described again here.

The disclosed embodiments also provide a non-volatile computer-readable storage medium on which computer program instructions are stored, which when executed by a processor implement the above-mentioned data processing method.

An embodiment of the present disclosure further provides an electronic device, including: one or more processors; a memory associated with the one or more processors for storing executable instructions that, when read and executed by the one or more processors, perform the data processing method described above.

The electronic device may be provided as a terminal, server, or other form of device.

Fig. 7 illustrates a block diagram of an electronic device 800 provided by an embodiment of the disclosure. For example, the electronic device 800 may be a mobile phone, a computer, a digital broadcast terminal, a messaging device, a game console, a tablet device, a medical device, a fitness device, a personal digital assistant, or the like terminal.

Referring to fig. 7, electronic device 800 may include one or more of the following components: processing component 802, memory 804, power component 806, multimedia component 808, audio component 810, input/output (I/O) interface 812, sensor component 814, and communication component 816.

The processing component 802 generally controls overall operation of the electronic device 800, such as operations associated with display, telephone calls, data communications, camera operations, and recording operations. The processing components 802 may include one or more processors 820 to execute instructions to perform all or a portion of the steps of the methods described above. Further, the processing component 802 can include one or more modules that facilitate interaction between the processing component 802 and other components. For example, the processing component 802 can include a multimedia module to facilitate interaction between the multimedia component 808 and the processing component 802.

The memory 804 is configured to store various types of data to support operations at the electronic device 800. Examples of such data include instructions for any application or method operating on the electronic device 800, contact data, phonebook data, messages, pictures, videos, and so forth. The memory 804 may be implemented by any type or combination of volatile or non-volatile memory devices such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disks.

The power supply component 806 provides power to the various components of the electronic device 800. The power components 806 may include a power management system, one or more power supplies, and other components associated with generating, managing, and distributing power for the electronic device 800.

The multimedia component 808 includes a screen that provides an output interface between the electronic device 800 and a user. In some embodiments, the screen may include a Liquid Crystal Display (LCD) and a Touch Panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive an input signal from a user. The touch panel includes one or more touch sensors to sense touch, slide, and gestures on the touch panel. The touch sensor may not only sense the boundary of a touch or slide action, but also detect the duration and pressure associated with the touch or slide operation. In some embodiments, the multimedia component 808 includes a front facing camera and/or a rear facing camera. The front camera and/or the rear camera may receive external multimedia data when the electronic device 800 is in an operation mode, such as a shooting mode or a video mode. Each front camera and rear camera may be a fixed optical lens system or have a focal length and optical zoom capability.

The audio component 810 is configured to output and/or input audio signals. For example, the audio component 810 includes a Microphone (MIC) configured to receive external audio signals when the electronic device 800 is in an operational mode, such as a call mode, a recording mode, and a voice recognition mode. The received audio signals may further be stored in the memory 804 or transmitted via the communication component 816. In some embodiments, audio component 810 also includes a speaker for outputting audio signals.

The I/O interface 812 provides an interface between the processing component 802 and peripheral interface modules, which may be keyboards, click wheels, buttons, etc. These buttons may include, but are not limited to: a home button, a volume button, a start button, and a lock button.

The sensor assembly 814 includes one or more sensors for providing various aspects of state assessment for the electronic device 800. For example, the sensor assembly 814 may detect an open/closed state of the electronic device 800, the relative positioning of components, such as a display and keypad of the electronic device 800, the sensor assembly 814 may also detect a change in the position of the electronic device 800 or a component of the electronic device 800, the presence or absence of user contact with the electronic device 800, orientation or acceleration/deceleration of the electronic device 800, and a change in the temperature of the electronic device 800. Sensor assembly 814 may include a proximity sensor configured to detect the presence of a nearby object without any physical contact. The sensor assembly 814 may also include a light sensor, such as a CMOS or CCD image sensor, for use in imaging applications. In some embodiments, the sensor assembly 814 may also include an acceleration sensor, a gyroscope sensor, a magnetic sensor, a pressure sensor, or a temperature sensor.

The communication component 816 is configured to facilitate wired or wireless communication between the electronic device 800 and other devices. The electronic device 800 may access a wireless network based on a communication standard, such as WiFi, 2G or 3G, or a combination thereof. In an exemplary embodiment, the communication component 816 receives a broadcast signal or broadcast related information from an external broadcast management system via a broadcast channel. In an exemplary embodiment, the communication component 816 further includes a Near Field Communication (NFC) module to facilitate short-range communications. For example, the NFC module may be implemented based on Radio Frequency Identification (RFID) technology, infrared data association (IrDA) technology, Ultra Wideband (UWB) technology, Bluetooth (BT) technology, and other technologies.

In an exemplary embodiment, the electronic device 800 may be implemented by one or more Application Specific Integrated Circuits (ASICs), Digital Signal Processors (DSPs), Digital Signal Processing Devices (DSPDs), Programmable Logic Devices (PLDs), Field Programmable Gate Arrays (FPGAs), controllers, micro-controllers, microprocessors or other electronic components for performing the above-described methods.

In an exemplary embodiment, a non-transitory computer-readable storage medium, such as the memory 804, is also provided that includes computer program instructions executable by the processor 820 of the electronic device 800 to perform the above-described methods.

Fig. 8 shows a block diagram of an electronic device 1900 provided by an embodiment of the disclosure. For example, the electronic device 1900 may be provided as a server. Referring to fig. 8, electronic device 1900 includes a processing component 1922 further including one or more processors and memory resources, represented by memory 1932, for storing instructions, e.g., applications, executable by processing component 1922. The application programs stored in memory 1932 may include one or more modules that each correspond to a set of instructions. Further, the processing component 1922 is configured to execute instructions to perform the above-described method.

The electronic device 1900 may also include a power component 1926 configured to perform power management of the electronic device 1900, a wired or wireless network interface 1950 configured to connect the electronic device 1900 to a network, and an input/output (I/O) interface 1958. The electronic device 1900 may operate based on an operating system stored in memory 1932, such as Windows Server, Mac OS XTM, UnixTM, LinuxTM, FreeBSDTM, or the like.

In an exemplary embodiment, a non-transitory computer readable storage medium, such as the memory 1932, is also provided that includes computer program instructions executable by the processing component 1922 of the electronic device 1900 to perform the above-described methods.

The present disclosure may be systems, methods, and/or computer program products. The computer program product may include a computer-readable storage medium having computer-readable program instructions embodied thereon for causing a processor to implement various aspects of the present disclosure.

The computer readable storage medium may be a tangible device that can hold and store the instructions for use by the instruction execution device. The computer readable storage medium may be, for example, but not limited to, an electronic memory device, a magnetic memory device, an optical memory device, an electromagnetic memory device, a semiconductor memory device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a Static Random Access Memory (SRAM), a portable compact disc read-only memory (CD-ROM), a Digital Versatile Disc (DVD), a memory stick, a floppy disk, a mechanical coding device, such as punch cards or in-groove projection structures having instructions stored thereon, and any suitable combination of the foregoing. Computer-readable storage media as used herein is not to be construed as transitory signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through a waveguide or other transmission medium (e.g., optical pulses through a fiber optic cable), or electrical signals transmitted through electrical wires.

The computer-readable program instructions described herein may be downloaded from a computer-readable storage medium to a respective computing/processing device, or to an external computer or external storage device via a network, such as the internet, a local area network, a wide area network, and/or a wireless network. The network may include copper transmission cables, fiber optic transmission, wireless transmission, routers, firewalls, switches, gateway computers and/or edge servers. The network adapter card or network interface in each computing/processing device receives computer-readable program instructions from the network and forwards the computer-readable program instructions for storage in a computer-readable storage medium in the respective computing/processing device.

The computer program instructions for carrying out operations of the present disclosure may be assembler instructions, Instruction Set Architecture (ISA) instructions, machine-related instructions, microcode, firmware instructions, state setting data, or source or object code written in any combination of one or more programming languages, including an object oriented programming language such as Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The computer-readable program instructions may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider). In some embodiments, the electronic circuitry that can execute the computer-readable program instructions implements aspects of the present disclosure by utilizing the state information of the computer-readable program instructions to personalize the electronic circuitry, such as a programmable logic circuit, a Field Programmable Gate Array (FPGA), or a Programmable Logic Array (PLA).

Various aspects of the present disclosure are described herein with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the disclosure. It will be understood that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer-readable program instructions.

These computer-readable program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks. These computer-readable program instructions may also be stored in a computer-readable storage medium that can direct a computer, programmable data processing apparatus, and/or other devices to function in a particular manner, such that the computer-readable medium storing the instructions comprises an article of manufacture including instructions which implement the function/act specified in the flowchart and/or block diagram block or blocks.

The computer readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other devices to cause a series of operational steps to be performed on the computer, other programmable apparatus or other devices to produce a computer implemented process such that the instructions which execute on the computer, other programmable apparatus or other devices implement the functions/acts specified in the flowchart and/or block diagram block or blocks.

The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of instructions, which comprises one or more executable instructions for implementing the specified logical function(s). In some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

Having described embodiments of the present disclosure, the foregoing description is intended to be exemplary, not exhaustive, and not limited to the disclosed embodiments. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the described embodiments. The terms used herein were chosen in order to best explain the principles of the embodiments, the practical application, or technical improvements to the techniques in the marketplace, or to enable others of ordinary skill in the art to understand the embodiments disclosed herein.

Claims

1. A data processing method, comprising:

acquiring a data processing instruction submitted by a client;

2. The method of claim 1, after obtaining the data processing instruction submitted by the client, and before said writing the result data into the second data table, further comprising:

determining attribute information of the first data table;

3. The method according to claim 1 or 2, wherein after said obtaining the data processing instruction submitted by the client, before said writing the result data into the second data table, further comprising:

receiving an attribute information configuration request from the client;

4. The method of claim 1, prior to said returning result information to said client, further comprising:

5. The method of claim 4, wherein the result information generation request further includes presentation form information;

6. The method of claim 2, further comprising, after said determining attribute information of said first data table:

7. The method of claim 2, after determining the attribute information of the second data table, further comprising:

8. The method of claim 1, wherein the data processing instructions are generated based on writing a structured query language or wherein the data processing instructions are generated based on an operation of dragging an abstraction component.

9. The method of claim 1, wherein the data processing instructions are used for real-time data analysis, real-time forewarning, or real-time monitoring.

10. A data processing method, comprising:

generating a data processing instruction;

11. The method of claim 10, wherein the attribute information of the second data table is determined based at least on the attribute information of the first data table.

12. The method of claim 10 or 11, further comprising:

13. The method according to claim 10, further comprising, before said receiving result information returned by said server:

14. The method according to claim 13, wherein the result information generation request further includes presentation form information, and the result information is generated based on the presentation form information and result data conforming to the range information.

15. The method of claim 11, further comprising:

obtaining attribute information of the first data table from the server;

and displaying the attribute information of the first data table.

16. The method of claim 11, further comprising:

obtaining attribute information of the second data table from the server;

and displaying the attribute information of the second data table.

17. The method of claim 10, wherein the data processing instructions are generated based on writing a structured query language or wherein the data processing instructions are generated based on an operation of dragging an abstraction component.

18. The method of claim 10, wherein the data processing instructions are used for real-time data analysis, real-time forewarning, or real-time monitoring.

19. A data processing apparatus, comprising:

20. A data processing apparatus, comprising:

the generating module is used for generating a data processing instruction;

21. An electronic device, comprising:

one or more processors;

a memory associated with the one or more processors for storing executable instructions that, when read and executed by the one or more processors, perform the method of any one of claims 1 to 9.

22. An electronic device, comprising:

one or more processors;

a memory associated with the one or more processors for storing executable instructions that, when read and executed by the one or more processors, perform the method of any one of claims 10 to 18.

23. A non-transitory computer readable storage medium having stored thereon computer program instructions, wherein the computer program instructions, when executed by a processor, implement the method of any one of claims 1 to 9.

24. A non-transitory computer readable storage medium having stored thereon computer program instructions, wherein the computer program instructions, when executed by a processor, implement the method of any one of claims 10 to 18.