CN116934897A

CN116934897A - Chart drawing method and device, storage medium and electronic equipment

Info

Publication number: CN116934897A
Application number: CN202210327297.7A
Authority: CN
Inventors: 王永亮; 董志强
Original assignee: Tencent Technology Shenzhen Co Ltd
Current assignee: Tencent Technology Shenzhen Co Ltd
Priority date: 2022-03-30
Filing date: 2022-03-30
Publication date: 2023-10-24

Abstract

The application discloses a chart drawing method and device, a storage medium and electronic equipment. The method comprises the following steps: executing data access operation on a first data source to obtain first target data, wherein the first data source is determined according to first data source docking information configured by a first target system and used for drawing a first chart; executing a first processing operation on the first target data to obtain first chart data, wherein the first processing operation is indicated by the first data source docking information and is used for obtaining chart data corresponding to the first chart; and performing a graph drawing operation on the first graph data according to the graph parameters indicated by the first graph information to obtain a first graph, wherein the first graph information is the graph information of the first graph configured by the first target system. By adopting the technical scheme, the problem that the universality of graph drawing is poor due to large system coupling in the graph drawing mode in the related technology is solved.

Description

Chart drawing method and device, storage medium and electronic equipment

Technical Field

The present application relates to the field of computers, and in particular, to a chart drawing method and apparatus, a storage medium, and an electronic device.

Background

Currently, in some systems, a chart drawing function is provided, and one or more pages can be opened in the corresponding system to implement index calculation and chart drawing. However, the above-mentioned chart drawing function is usually integrated or embedded in the corresponding system as a single point capability, and only can consider the data visualization of the system where the user is located, and is highly coupled with the system itself.

As can be seen from this, the graph drawing method in the related art has a problem of poor universality of graph drawing due to large system coupling.

Disclosure of Invention

The embodiment of the application provides a chart drawing method and device, a storage medium and electronic equipment, which at least solve the problem that the universality of chart drawing is poor due to large system coupling in a chart drawing mode in the related technology.

According to an aspect of the embodiment of the present application, there is provided a chart drawing method including: performing data access operation on a first data source to obtain first target data, wherein the first data source is a data source which is determined according to first data source docking information configured by a first target system and used for drawing a first chart; executing a first processing operation on the first target data to obtain first chart data, wherein the first processing operation is indicated by the first data source docking information and is used for obtaining chart data corresponding to the first chart; and performing a graph drawing operation on the first graph data according to graph parameters indicated by first graph information, so as to obtain the first graph, wherein the first graph information is the graph information of the first graph configured by the first target system.

According to another aspect of the embodiment of the present application, there is also provided a chart drawing apparatus including: the first access unit is used for executing data access operation on a first data source to obtain first target data, wherein the first data source is a data source which is determined according to first data source docking information configured by a first target system and used for drawing a first chart; a first processing unit, configured to perform a first processing operation on the first target data to obtain first chart data, where the first processing operation is a processing operation indicated by the first data source docking information and used for obtaining chart data corresponding to the first chart; and a first drawing unit configured to perform a graph drawing operation on the first graph data according to a graph parameter indicated by first graph information, to obtain the first graph, where the first graph information is graph information of the first graph configured by the first target system.

As an alternative, the apparatus further comprises: the second access unit is used for executing data access operation on a second data source to obtain second target data, wherein the second data source is a data source which is determined according to second data source docking information configured by a second target system and used for generating a second chart; a second processing unit, configured to perform a second processing operation on the second target data to obtain second chart data, where the second processing operation is a processing operation indicated by the second data source docking information and used for obtaining chart data corresponding to the second chart; and a second drawing unit configured to perform a graph drawing operation on the second graph data according to graph parameters indicated by second graph information, to obtain the second graph, where the second graph information is graph information of the second graph configured by the second target system.

As an alternative, the first access unit includes: the first acquisition module is used for acquiring the target data document uploaded by the first target system, wherein the first data source is the target data document, and the first data source docking information comprises the target data document; the analysis module is used for executing analysis operation on the target data document to obtain the first target data; or, the connection module is configured to establish a connection with the first data source indicated by the data docking script in a process of running the data docking script uploaded by the first target system, where the first data source docking information includes the data docking script; and the query module is used for executing query operation on the first data source according to the query conditions indicated by the data docking script to obtain the first target data.

As an alternative, the apparatus further comprises: the first acquisition unit is used for acquiring a preset script execution period corresponding to the data docking script uploaded by the first target system; and the triggering unit is used for triggering the execution task of the data docking script at regular time according to the preset script execution period so as to run the data docking script at regular time.

As an alternative, the apparatus further comprises: the first receiving unit is used for receiving a chart registration request sent by the first target system before the data access operation is performed on the first data source to obtain first target data, wherein the chart registration request is used for requesting to register a chart for the first target system by using the first chart information and the first data source docking information; and the registration unit is used for responding to the chart registration request, executing chart registration operation by using the first chart information and the first data source docking information, and obtaining the registration information of the first chart.

As an alternative, the apparatus further comprises: the display unit is used for displaying a chart registration interface on terminal equipment corresponding to the first target system before receiving the chart registration request sent by the first target system, wherein the chart registration interface is used for registering charts for the first target system; the second acquisition unit is used for responding to the input operation of the chart registration interface and acquiring the first chart information and the first data source docking information; and the sending unit is used for sending the chart registration request to a target server, wherein the chart registration request carries the first chart information and the first data source docking information.

As an alternative, the apparatus further comprises: the second receiving unit is used for receiving a chart modification request sent by the first target system after the chart drawing operation is performed on the first chart data according to the chart parameters indicated by the first chart information to obtain the first chart, wherein the chart modification request is used for requesting to modify target information in the first chart information and the first data source docking information; and the modifying unit is used for responding to the chart modification request, executing modification operation on the first chart information and the target information in the first data source butt joint information, and obtaining the registration information after the first chart modification.

As an alternative, the apparatus further comprises: a third receiving unit, configured to receive a chart deletion request sent by the first target system after performing a chart drawing operation on the first chart data according to the chart parameter indicated by the first chart information to obtain the first chart, where the chart deletion request is used to request deletion of the first chart; and a deleting unit configured to perform a deleting operation on the first chart information and the first chart data in response to the chart deletion request, so as to delete the first chart.

As an alternative, the apparatus further comprises: the formatting unit is used for executing a first processing operation on the first target data to obtain first chart data, and then executing a formatting operation on the first chart data to obtain formatted first chart data; and the calling unit is used for persistently storing the formatted first chart data into the target database by calling a data storage interface of the target database, wherein the chart drawing operation is executed on the first chart data stored in the target database.

As an alternative, the first drawing unit includes: the second acquisition module is used for acquiring a target chart identifier, a target chart type and target chart description information corresponding to the chart to be drawn from the first chart information, wherein the target chart description information is chart description information displayed in the chart to be drawn; and the drawing module is used for executing graph drawing operation on the first graph data according to the target graph identifier, the target graph type and the target graph description information to obtain the first graph, wherein the graph identifier of the first graph is the target graph identifier, the graph type of the first graph is the target graph type, and the first graph comprises the target graph description information.

As an alternative, the apparatus further comprises: a rendering unit, configured to perform a graph drawing operation on the first graph data according to the graph parameter indicated by the first graph information, and render the first graph onto a first page after the first graph is obtained, where the first page is independent of a second page of the first target system and is a page jumped to by the second page, or the first page is independent of the second page of the first target system and is embedded in the second page; or the transmission unit is used for transmitting the first chart to a second page of the first target system through an application program interface so as to render the first chart onto the second page.

According to a further aspect of embodiments of the present application, there is also provided a computer-readable storage medium having a computer program stored therein, wherein the computer program is configured to perform the above-described chart drawing method when run.

According to yet another aspect of embodiments of the present application, there is provided a computer program product or computer program comprising computer instructions stored in a computer readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device performs the chart drawing method as above.

According to still another aspect of the embodiments of the present application, there is also provided an electronic apparatus including a memory in which a computer program is stored, and a processor configured to execute the above-described chart drawing method by the computer program.

In the embodiment of the application, the data docking and the chart drawing are abstracted, an independent chart drawing platform is stripped, a system with chart drawing requirements provides configured data source docking information for the chart drawing platform to conduct data docking, chart data required by chart drawing are obtained, meanwhile, a system with chart drawing requirements provides configured chart information for the chart drawing platform to conduct chart drawing, and the chart drawing process can be completed.

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 specification, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute a limitation on the application. In the drawings:

FIG. 1 is a schematic illustration of an application environment for an alternative diagramming method according to an embodiment of the present application;

FIG. 2 is a flow chart of an alternative diagramming method according to an embodiment of the present application;

FIG. 3 is a schematic diagram of an alternative multi-system docking chart drawing platform, according to an embodiment of the present application;

FIG. 4 is a schematic diagram of an alternative data entry flow in accordance with an embodiment of the application;

FIG. 5 is a schematic diagram of an alternative chart registration process according to an embodiment of the application;

FIG. 6 is a schematic diagram of an alternative schematic diagram automation to operate in accordance with an embodiment of the application;

FIG. 7 is a schematic diagram of an alternative chart rendering flow in accordance with an embodiment of the present application;

FIG. 8 is a schematic diagram of an alternative schema for graph data referencing in accordance with an embodiment of the application;

FIG. 9 is a system architecture diagram of a diagramming platform according to an embodiment of the present application;

FIG. 10 is a block diagram of an alternative diagramming apparatus according to an embodiment of the present application;

FIG. 11 is a schematic diagram of an alternative electronic device according to an embodiment of the application;

FIG. 12 is a block diagram of the architecture of a computer system of an alternative electronic device in accordance with an embodiment of the present application.

Detailed Description

In order that those skilled in the art will better understand the present application, a technical solution in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present application without making any inventive effort, shall fall within the scope of the present application.

It should be noted that the terms "first," "second," and the like in the description and the claims of the present application and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the application described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

According to an aspect of the embodiment of the present application, there is provided a graph drawing method, optionally, as an alternative implementation, the graph drawing method may be applied, but not limited to, in the environment as shown in fig. 1. Among them, may include, but are not limited to: the terminal device 102, the terminal device 102 may include, but is not limited to, a memory 104, a processor 106 and a display 108, a network 110, a server 112, which may include, but is not limited to, a database 114 and a processing engine 116.

A current page of the third party system may be run on the terminal device 102, page information of the current page may be displayed on the current page, and a button for triggering chart drawing, for example, a "form drawing" button may be displayed. By means of this button, the display of the drawn chart in the current page can be triggered.

Illustratively, the process of the above-described diagramming method may include the steps of:

in step S102, the terminal device 102 detects a click operation (or other trigger operation) performed on the "chart drawing" button, and generates a chart drawing request in response to the detected click operation, to request the chart drawing platform to perform corresponding chart drawing.

In step S104, the terminal device 102 transmits a chart drawing request to the server 112 of the chart drawing platform.

In step S106, in response to the received chart drawing request, the server 112 performs a data access operation on a data source corresponding to the chart to be drawn through the database 114 and the processing engine 116 to obtain target data, performs a processing operation on the target data to obtain chart data, performs a chart drawing operation on the chart data according to the chart parameters indicated by the chart information to obtain a drawn chart, where the processing operation and the chart drawing operation may be performed in a manner specified based on a third party system.

In step S108, the server 112 sends the drawn chart to the terminal device 102 via the network 110, and the processor 106 and the display 1108 in the terminal device 102 render the drawn chart in the current page.

In addition to the example shown in FIG. 1, the drawn chart may be displayed in a page of the chart drawing platform that jumps to in a hyperlinked manner, or may be displayed in a page of the chart drawing platform that is embedded within the current page.

Alternatively, in this embodiment, the terminal device 102 may be a desktop computer, and the mobile device may include, but is not limited to, at least one of the following: a mobile phone (e.g., android mobile phone, iOS mobile phone, etc.), a notebook computer, a tablet computer, a palm computer, a MID (Mobile Internet Devices, mobile internet device), a PAD, a desktop computer, a smart home appliance, a vehicle-mounted device, etc. The network may include, but is not limited to: a wired network, a wireless network, wherein the wired network comprises: local area networks, metropolitan area networks, and wide area networks, the wireless network comprising: bluetooth, WIFI, and other networks that enable wireless communications. The server 112 may be a single server, a server cluster including a plurality of servers, or a cloud server. The above is merely an example, and is not limited in any way in the present embodiment.

Alternatively, as an alternative implementation manner, taking the foregoing server 112 as an example to execute the chart drawing method in this embodiment, fig. 2 is a schematic flow chart of an alternative chart drawing method according to an embodiment of the present application, as shown in fig. 2, a flow chart of the chart drawing method may include the following steps:

step S202, performing data access operation on a first data source to obtain first target data, wherein the first data source is determined according to first data source docking information configured by a first target system and used for drawing a first chart.

Alternatively, in the present embodiment, the above-described chart drawing method may be applied, but not limited to, to a scene in which chart drawing is performed by a chart drawing platform independent of a plurality of systems having chart drawing requirements, and the above-described chart drawing method may be applied, for example, to the following scenes: index calculation, chart drawing scenes, custom chart drawing scenes, low-code chart drawing development scenes, data center console panel development scenes and the like. The chart drawing platform can be a unified data docking calculation and chart drawing platform, can be suitable for a plurality of systems, and provides chart drawing functions for different systems.

In the related art, the graph drawing function usually opens one or more pages on the corresponding system to implement index calculation and graph drawing, and the graph drawing function is often integrated as a single point capability or embedded in the corresponding system, and only can give consideration to the data visualization of the system where the graph drawing function is located, and is highly coupled with the system itself, so that the universality of the graph drawing function is insufficient due to the large coupling property, and the graph drawing function cannot be quickly adapted to other systems.

In this embodiment, the data interfacing and the chart drawing are abstracted, an independent platform is stripped, and the third party system only needs to provide the data access information corresponding to the data access and the chart information related to the chart drawing, so that the chart drawing can be completed through the platform. Because the chart drawing function is independent of a specific system, the coupling between the chart drawing function and the system can be reduced, the universality of the chart drawing function is improved, and the aim of quickly adapting to different systems is fulfilled.

For the first target system, the system may be a system independent of the chart drawing platform and having chart drawing requirements, which may provide the chart drawing platform with configured first data source docking information for indicating the data sources used to draw the first chart and may also indicate the data in the data sources used to draw the first chart. Here, the data source is a source of data, that is, a location where data is located, for example, a database, a spreadsheet, and the like.

The data source used to draw the first graph indicated by the first data source docking information is the first data source. The server (which may be a server of the chart drawing platform) may perform a data access operation on the first data source according to the first data source docking information, to obtain first target data. The first target data may be all data in the first data source, may be data in a preset data table in the first data source, or may be data matched with a preset field in the preset data table in the first data source, where the preset field may be a field used for drawing the first chart, and the preset field may be indicated by the first data source docking information.

Optionally, the server may execute a data access operation on the first data source according to the first data source docking information, query data in a preset data table of the first data source according to a preset query condition, and obtain data matched with a preset field in the preset data table, so as to obtain first target data.

Optionally, performing the data access operation on the first data source may be: a data access operation is performed on the first data source using a target plugin that matches the first data source. The target plugin that matches the first data source may be determined based on the data source type of the first data source when docked with the first data source, or prior to docking with the first data source. Alternatively, in the case where the target plug-in is not installed, the target plug-in may be acquired and installed onto a diagramming platform, such as a server of the diagramming platform.

In the related art, the service system cannot be compatible with different data sources, new data sources need to be adapted respectively, when a new chart is required, the data sources need to be adapted frequently, the process is complicated, and the version needs to be reissued. By docking different data sources independently of the chart drawing platform of the service system, the service system does not need to adapt to new data sources, the operation of switching the data sources can be simplified (only the corresponding data source is required to be specified for the service system, and the code modification is not involved), and the convenience of chart drawing is improved.

Alternatively, the first target system may draw multiple charts simultaneously, i.e., the first chart contains a set of charts, and the data sources used by each chart in the set of charts may be the same or different. The server may perform a data access operation on each of a set of data sources to obtain a set of target data, where the set of target data may be in a one-to-one correspondence with a set of graphs, or may be in a one-to-many correspondence, that is, the plurality of graphs use the same target data, and each of the set of target data may be obtained from one of the set of data sources through access.

In step S204, a first processing operation is performed on the first target data to obtain first chart data, where the first processing operation is a processing operation indicated by the first data source docking information and used for obtaining chart data corresponding to the first chart.

In addition to the first data source, the first data source docking information may also indicate a processing operation used to acquire chart data corresponding to the first chart, i.e., a first processing operation. Here, the graph data may be index data, and correspondingly, the plotted graph is an index graph, and the processing operation may be an index calculation operation. And calculating and counting the accessed data according to a calculation formula, wherein the obtained conclusion is the index.

The server may perform a first processing operation on the first target data to obtain first graph data, for example, the server may obtain a calculation formula of the index, and perform index calculation using the first target data according to the obtained calculation formula to obtain first index data, where the first index data is index data used by the first graph.

Optionally, when the first target data includes a set of target data and the first chart includes a set of charts, the server may perform a corresponding processing operation on each target data to obtain a set of chart data, where the processing operation corresponding to each target data is a processing operation indicated by the first data source docking information and used to obtain chart data of a corresponding chart in the set of charts.

In step S206, a chart drawing operation is performed on the first chart data according to the chart parameters indicated by the first chart information, so as to obtain a first chart, where the first chart information is chart information of the first chart configured by the first target system.

In addition to the first data source docking information, the first target system may provide configured first chart information to the chart drawing platform, where the first chart information is chart information of the first chart, which may indicate chart parameters of the first chart, may include, but is not limited to, at least one of: chart identification (e.g., chart name), chart type (which may include, but is not limited to, bar chart, line chart, pie chart, area chart, perspective chart, radar chart, etc.), chart description information (e.g., vertical, horizontal fields, description, additional information, etc.), and may also contain other description information that draws the first chart.

When the chart drawing is required, the server can draw the chart according to the chart parameters indicated by the first chart information, namely, the chart drawing operation is performed on the first chart data, so that the first chart is obtained. Here, the graph drawing refers to an operation of converting data into a visual graph, that is, an operation of converting graph data into a graph, and may be a graph generation operation, without including a graph rendering operation. The first chart can be obtained and displayed through a page in the browser, and the page for displaying the first chart can be a page of the first target system or a page of a chart drawing platform which is independent of or embedded into the page of the first target system.

Optionally, when the first chart to be rendered includes a plurality of charts, the server may perform chart drawing operation on each chart data in the set of chart data separately with respect to the chart parameter indicated by the first chart information, so as to obtain a set of charts.

In this embodiment, different scenarios, different data sources and different target charts are abstracted, and the abstract is a capability exclusive platform (and a platform with data docking and chart drawing functions), the platform provides the capability of the chart drawing full life cycle, releases the service productivity, enables the service party to concentrate more on the service itself, reduces the development threshold of chart drawing requirements, can realize the function of chart drawing in a low-code even code-free manner, and greatly improves the development efficiency.

According to the embodiment of the application, the data access operation is carried out on the first data source to obtain the first target data, wherein the first data source is determined according to the first data source docking information configured by the first target system and used for drawing the first chart; executing a first processing operation on the first target data to obtain first chart data, wherein the first processing operation is indicated by the first data source docking information and is used for obtaining chart data corresponding to the first chart; and executing graph drawing operation on the first graph data according to graph parameters indicated by the first graph information to obtain a first graph, wherein the first graph information is configured by a first target system, so that the problem that graph drawing universality is poor due to high system coupling in a graph drawing mode in the related technology is solved, the universality of graph drawing is improved, and the efficiency of service development is improved.

As an alternative, the method further includes:

s11, performing data access operation on a second data source to obtain second target data, wherein the second data source is determined according to second data source docking information configured by a second target system and used for generating a second chart;

s12, performing a second processing operation on the second target data to obtain second chart data, wherein the second processing operation is indicated by the second data source docking information and is used for acquiring chart data corresponding to the second chart;

and S13, performing a chart drawing operation on the second chart data according to the chart parameters indicated by the second chart information to obtain a second chart, wherein the second chart information is the chart information of the second chart configured by the second target system.

In addition to the first target system, the chart drawing platform may provide chart drawing functions for other systems, for example, providing chart drawing functions for a second target system, where the chart to be drawn by the second target system is a second chart. When drawing the second chart, the server may access the second data source to obtain the second target data in the same or similar manner as in the foregoing embodiment, process the second target data to obtain the second chart data, and use the second chart data to draw the chart, thereby obtaining the second chart, which is already described and will not be described herein.

For example, as shown in fig. 3, the chart drawing platform may provide chart drawing functions for a plurality of business systems, which may include a first business system (one example of a first target system) and a second business system (one example of a second target system), and different business systems may respectively dock information and chart information to data sources configured by the chart drawing platform. The chart drawing platform acquires data from corresponding data sources by using the data source docking information and chart information provided by different service systems, draws charts, obtains charts required by the service systems, and sends the charts (i.e. drawn charts) required by the service systems to the corresponding service systems.

In the related art, if a graph drawing function developed in one system is laterally expanded on the same system, repeated adaptation development is required, and the code multiplexing rate is low. The unified graph drawing platform is used for drawing the graph, so that the complexity of the lateral expansion of the graph drawing function can be reduced, and the efficiency of the lateral expansion of the graph drawing function can be improved.

According to the embodiment of the application, the data source docking information and the chart information provided by different systems are used for drawing charts for different systems, so that the efficiency of developing different services can be improved.

As an alternative, when performing data access, data interfacing may be performed in a plurality of manners, where data interfacing refers to a method or path for accessing data, and aims to communicate data with a system. The data interfacing means employed may include, but is not limited to, at least one of: and realizing data docking by using the uploaded data document, and reading data from a data source by using a data docking script to realize data docking.

As an optional implementation manner, performing a data access operation on a first data source to obtain first target data includes:

s21, acquiring a target data document uploaded by a first target system, wherein a first data source is the target data document, and the first data source docking information comprises the target data document;

s22, analyzing the target data document to obtain first target data.

In this embodiment, the server may use the data document uploaded by the first target system to implement data docking, and may correspond to a scenario in which data is manually entered, where the data is manually entered to access or synchronize the data by using manual operation. The timing of uploading the target data document may be: the target data document may be uploaded when the first target system performs the chart registering operation, or may be uploaded during chart drawing, which may be a manually uploaded data document, which is not limited in this embodiment.

After the target data document is obtained, the server may perform an parsing operation on the target data document to obtain the first target data, where the parsing operation may be performed based on the foregoing preset field, that is, the server may parse the target data document to obtain data corresponding to the preset field, or obtain data corresponding to the preset field in a preset period of time, or may be other data parsing manners.

For example, a user may manually upload a data document. When the chart registration is performed, a user can firstly log in a client provided by the chart drawing platform by using an account corresponding to the first target system, trigger chart registration, and manually upload a target data document on a chart registration interface.

When the data is recorded, the server can acquire the data document file uploaded during chart registration, analyze the content of the data document, acquire a calculation formula appointed during registration, and calculate indexes according to the formula to obtain index data (an example of first target data).

Alternatively, the target data document may be a target form document, the document type of which may include, but is not limited to, one of the following: XLS, CSV (common-Separated Values, a plain text file format containing a list of data).

As another alternative embodiment, performing a data access operation on a first data source to obtain first target data includes:

s23, in the process of running the data docking script uploaded by the first target system, establishing connection with a first data source indicated by the data docking script, wherein the first data source docking information comprises the data docking script;

s24, query operation is carried out on the first data source according to the query conditions indicated by the data docking script, and first target data are obtained.

In this embodiment, the server may use the data docking script uploaded by the first target system to read data from the data source, so as to implement data docking, and may correspond to a scenario in which data is automatically input, where the data is automatically input by accessing or synchronizing data in an automatic manner, and the automatic input may configure the docking script, and the docking script completes the functions of docking and inputting data, where the first data source docking information includes the data docking script. The timing of uploading the data docking script may be: the data docking script may be uploaded when the first target system performs the chart registration operation, or may be uploaded in the process of chart drawing, which is not limited in this embodiment.

The data docking script that the first target system has uploaded may indicate the data source used to draw the first chart, i.e., the first data source. In the process of running the data docking script, the server can establish connection with the first data source indicated by the data docking script.

In addition to the first data source, the data docking script may also indicate query conditions for the data query, i.e., conditions that the data retrieved from the first data source is required to satisfy, which may include at least one of: a preset data table, a preset time period, etc. The server may perform a query operation on the first data source according to the query conditions indicated by the data docking script, thereby obtaining first target data.

For example, when performing chart registration, a user may first log in a client provided by the chart drawing platform using an account corresponding to the first target system, trigger chart registration, and upload a data docking script on a chart registration interface.

When the data is recorded, the server can execute the data docking script when the data docking script is determined to need to be executed. When executing the data docking script, the data source is first connected, and then data query is performed according to the query condition of the data in the data docking script, so as to obtain target data (an example of the first target data).

According to the embodiment of the application, the data used for the drawing is acquired by adopting a mode of carrying out data analysis on the uploaded data document or a mode of acquiring the data from the data source in a butt joint way according to the data butt joint script, so that the flexibility of data acquisition can be improved.

As an alternative, the method further includes:

s31, acquiring a preset script execution period corresponding to the data docking script uploaded by the first target system;

s32, triggering the execution task of the data docking script at regular time according to the execution period of the preset script so as to run the data docking script at regular time.

The automatic data input mode can be suitable for data sources needing periodic synchronous updating and indexes needing long-term detection. For example, the data docking script is configured and executed at fixed time, so that the data docking and recording functions are completed by the data docking script.

When the data is automatically recorded, a preset script execution period corresponding to the data docking script uploaded by the first target system can be obtained, wherein the preset script execution period can be an execution period of the data docking script configured during chart registration; according to the preset script execution period, a planned task executed by the data docking script, that is, an execution task of the data docking script, which is a task taking the preset script execution period as an execution period, may be set.

According to the preset script execution period, the server can trigger the execution task of the data docking script at regular time, and when the execution task is executed, the server can dock with the first data source according to the data docking script, so as to execute the step of acquiring the chart data.

By the embodiment of the application, the data acquisition convenience can be improved by executing the task to run the data docking script at regular time, and the timeliness of data update synchronization can be ensured.

As an alternative, after performing the first processing operation on the first target data to obtain the first chart data, the method further includes:

s41, formatting operation is carried out on the first chart data, and formatted first chart data are obtained;

s42, the formatted first chart data is stored in the target database in a lasting mode through calling a data storage interface of the target database, wherein the chart drawing operation is executed on the first chart data stored in the target database.

The acquired first graph data may be stored in a cache of the server. In a period from acquisition of the first chart data to drawing of the first chart, if an abnormality occurs, a data loss is liable to occur. And if the first chart data is not used in time, more cache resources are occupied. If the first chart is required to be drawn for many times, the first chart data is required to be used for many times, when the first chart data is required to be stored for a long time, more cache resources are occupied, and if the first chart data is deleted after each use, operations such as data docking, data processing and the like are required to be executed for many times, so that the waste of calculation resources is caused.

In this embodiment, after the first chart data is obtained, the first chart data may be persisted to the database. When the first chart data is stored in a lasting mode, the server can perform formatting operation on the first chart data to obtain formatted first chart data, and the first chart data is converted into a format which is allowed to be saved in a target database.

The server may persist the formatted first schema data to the target database. Alternatively, the target database may provide a data storage interface that is invoked to store data into the target database. The server may invoke a data storage interface of the target database to persist the formatted first schema data to the target database. When performing the graph plotting operation, the first graph data stored therein may be acquired from the target database, and the graph plotting operation may be performed using the acquired first graph data.

Optionally, the architecture of the diagramming platform is divided into a multi-layer structure, which may include, but is not limited to: a data docking layer (or data source docking layer) and a data layer, wherein,

The data docking layer may be used to perform operations related to data docking, while the data layer may be used to persist data. Here, the data docking layer may be responsible for docking a variety of data sources, including external data sources (e.g., data sources corresponding to the aforementioned data docking script) and internal data sources (e.g., the aforementioned uploaded target data document), and may perform the following operations: the data source is connected, the data is formatted, the index is calculated, the association is put in storage, and the most basic data resource can be provided for drawing the chart;

the data layer can input the result of the data docking layer, and can perform persistent storage, so that direct data support can be provided for drawing the chart.

The data entry flow in the chart drawing method in the embodiment of the present application is explained below in conjunction with an alternative example. In this alternative example, the data document is a table document, and the chart data is index data.

The data source butt-joint input modes can be two, namely means input and automatic input, and different data input flows can be adopted for different data source butt-joint input modes.

The manual input is suitable for the scene of the table document with the manually maintained data source, only needs to be input once when registering the chart, designates the fields and the calculation formulas which participate in calculation, and inputs the data in the table document once. As shown in fig. 4, the data manual entry process may include the steps of:

Step S401, obtaining a data document file uploaded during chart registration;

step S402, analyzing the content of the data document;

step S403, acquiring a calculation formula appointed during registration, and calculating indexes of the analyzed data according to the formula;

step S404, uniformly formatting the analyzed data and the calculated index data;

step S405, a data storage interface is called to store the formatted data.

Through the steps, the data can be stored permanently, and the manual data input is finished.

The automatic input is suitable for data sources needing periodical synchronous updating, indexes needing long-term detection, a data docking script can be configured when the chart is registered, and the docking script completes the data docking and input functions. As shown in fig. 4, the data automatic entry process may include the steps of:

step S406, obtaining a data docking script uploaded during chart registration;

step S407, obtaining script execution period configured during registration;

step S408, setting a timing task executed by the data docking script, wherein the timing task is executed according to a configured script execution period;

in step S409, when the specified execution time is reached, execution of the timing task, that is, execution of the data docking script is triggered.

When executing the data docking script, the docking script internal execution flow may include the steps of:

step S4091, connecting a data source;

step S4092, inquiring target data;

step S4093, calculating index data by using the inquired target data to obtain corresponding index data;

step S4094, uniformly formatting the target data and the index data;

step S4095, the data storage interface is called to store data.

Through the steps, the data can be stored permanently when the timing task is executed each time, and one round of data is automatically input until the last round of data is finished.

By adopting different data input flows for different data source butt-joint input modes through the selectable example, the flexibility of data input can be improved.

As an alternative, before performing the data access operation on the first data source to obtain the first target data, the method further includes:

s51, receiving a chart registration request sent by a first target system, wherein the chart registration request is used for requesting to register a chart for the first target system by using first chart information and first data source docking information;

s52, in response to the chart registration request, performing chart registration operation by using the first chart information and the first data source docking information to obtain registration information of the first chart.

In this embodiment, the chart drawing platform may support a custom chart operation, where the chart operation may include: chart registration operations. The user can firstly log in the client provided by the chart drawing platform by using the account corresponding to the first target system, and trigger chart registration, and the areas for configuring the data source docking information and the chart information can be provided on the chart registration interface. When detecting an input operation performed on the graph registration interface, the client may acquire the configured first graph information and first data source docking information, and send a graph registration request to the graph drawing platform to request that the graph be registered for the first target system using the first graph information and the first data source docking information.

The chart drawing platform can receive the chart registration request, respond to the received chart registration request, execute chart registration operation by using the first chart information and the first data source docking information to obtain registration information of the first chart, wherein the registered first chart can be allowed to be called by the first target system, and the chart identification which can be the first chart can be called or other information which can uniquely identify the first chart can be used.

In the present embodiment, the flow of chart registration is described by taking the client provided by the chart drawing platform as an example, but chart registration may be performed on the client provided by the first target system based on interaction between the chart drawing platform and the first target system, and chart registration may be performed through other media such as a web page and an applet, in addition to the client, as long as a chart registration request can be sent to the chart drawing platform.

By the embodiment of the application, the chart registration is performed based on the information carried in the chart registration request, so that the convenience of chart registration can be improved, and the use experience of a user can be improved.

As an alternative, before receiving the chart registration request sent by the first target system, the method further includes:

s61, displaying a chart registration interface on a terminal device corresponding to the first target system, wherein the chart registration interface is used for chart registration for the first target system;

s62, responding to the input operation of the chart registration interface, and acquiring first chart information and first data source docking information;

s63, sending a chart registration request to the target server, wherein the chart registration request carries first chart information and first data source butt joint information.

The user can input the data source docking information and the chart information through the chart registration interface displayed on the terminal equipment corresponding to the first target system, so that chart registration is triggered. A chart registration interface may be displayed on the terminal device, which may be used to perform chart registration for the first target system. The chart registration interface can provide a plurality of information input areas, prompts the information type input by each information input area through prompt information, can also indicate the information range allowed to be input by each information input area, and can also prompt other information related to chart registration.

The user may input data source docking information and chart information corresponding to a chart to be registered within the chart registration interface, the input information including, for a first chart: first data source docking information and first schema information. Because the data source docking information and the chart information are information for indicating a data docking mode, a data processing mode and a chart drawing mode and do not relate to the code implementation of the bottom layer, a user can customize a required chart only according to the needs without concern about the code implementation of the data docking and the chart drawing, the chart drawing efficiency is improved, and the service development efficiency is further improved.

In response to performing an input operation on the chart registration interface, the terminal device may acquire first chart information and first data source docking information, and send a chart registration request carrying the first chart information and the first data source docking information to a server of the chart drawing platform, so as to trigger registration of the first chart.

The chart registration flow in the chart drawing method in the embodiment of the application is explained below in conjunction with an alternative example. In this alternative example, the data document is a table document, and the chart data is index data.

The chart registration can be in a self-defined form, and all information can be self-defined and specified by a user, so that the flexibility of chart drawing is improved. As shown in fig. 5, the chart registration process may include the steps of:

step S501, inputting a chart name and chart additional information, where the chart additional information may include, but is not limited to, at least one of the following: responsible person information, remarks/descriptive information.

In step S502, the necessary information for drawing the chart is input, which may be chart information, and the chart information for drawing the chart may include, but is not limited to, at least one of the following: description of the graph type, ordinate/abscissa (description information of the ordinate/abscissa displayed in the graph), data field of the ordinate/abscissa (data field associated with the ordinate/abscissa).

Step S503, inputting data source butt joint input information.

Data entry provides two methods, manual entry and automatic entry, respectively, wherein,

for the manual entry mode, the configuration mode of the manual entry may include the following steps:

step S5031, uploading a form document (e.g., XLsX/CSV document);

in step S5032, a calculation formula of the index, a field of parameter index calculation, and the like are defined.

For the automatic entry mode, the automatic entry configuration mode may include the following steps:

step S5033, configuring and generating a data docking script according to the script template.

The system can provide a data docking script template, according to which a user can specify a data source connection mode (namely, specify a data source type), query conditions of specified data, fields for parameter calculation, an index calculation formula and the like, and the supplementation and perfecting of the data docking script are completed.

Step S5034, uploading a data docking script, wherein the uploaded data docking script can be tested on a chart drawing platform;

step S5035, obtain the running result of the data docking script test, determine whether to conform to the expectation according to the back display of the running result, if yes, execute step S5037, otherwise, execute step S5036.

Step S5036, the modified docking script is re-edited and re-uploaded until the expected result is met.

In step S5037, the execution cycle of the data docking script is specified, and the data is automatically updated by automatically executing the data docking script at regular intervals.

Step S504, submitting all registration information.

By performing the above steps, chart registration can be completed.

Through the optional example, chart registration is performed through configuration chart information and data source docking entry information, so that convenience of chart registration can be improved, and flexibility of chart drawing is improved.

As an alternative, after performing a chart drawing operation on the first chart data according to the chart parameter indicated by the first chart information to obtain the first chart, the method further includes:

s71, receiving a chart modification request sent by a first target system, wherein the chart modification request is used for requesting to modify target information in first chart information and first data source butt joint information;

s72, in response to the chart modification request, modification operation is performed on the first chart information and the target information in the first data source butt joint information, and registration information after the first chart modification is obtained.

In this embodiment, the chart drawing platform may support a custom chart operation, where the chart operation may include: graph modification operations. For the first chart, the user may send a chart modification request to a server of the chart drawing platform through the client or the terminal device, where the chart modification request is used to request modification of the first chart information and the target information in the first data source docking information. The target information may be information in the first chart information, or may include both information in the first chart information and information in the first chart information, which is not limited in this embodiment.

In response to the chart modification request, the server may perform a modification operation on the first chart information and the target information in the first data source docking information to obtain modified first chart information, modified first data source docking information, or modified first chart information and modified first data source docking information, thereby obtaining first chart modified registration information.

Note that, the registration information of the first chart may include the first chart information and the first data source docking information, and may further include other information, for example, additional information of the foregoing chart, etc., which is not limited in this embodiment.

For the user (the user corresponding to the first target system may be a service developer thereof), a graph modification interface of the first graph may be displayed on the client or the terminal device, and current graph information and data source docking information of the first graph, that is, the first graph information and the first data source docking information, may be displayed in the graph modification interface. The user may perform an input operation on the chart modification interface to modify the target information.

In response to the detected input operation performed on the graph modification interface, the client or the terminal device may send a graph modification request to the target server, where the graph modification request may carry first graph information and first data source docking information that are complete after modification of the target information, or may only carry indication information of the target information, and information to be modified by the target information, so as to reduce a data amount required to be transmitted by data transmission, which is not limited in this embodiment.

It should be noted that, in the related art, in a system with a chart drawing function, the index calculation logic is usually implemented by background hard coding, the calculation logic is opaque to the user, and cannot customize the chart operation, and the period of online (the online needs to be re-online after the chart operation is modified), so that the modification efficiency is too low. In this embodiment, when the chart is modified, only the chart drawing platform needs to be requested to be modified through the chart modification request, and for the first target system, code modification is not needed, so that the chart modification efficiency can be improved without re-online.

By the embodiment of the application, the chart modification is carried out based on the information carried in the chart modification request, so that the convenience of the chart modification can be improved, and the use experience of a user can be improved.

s81, receiving a chart deletion request sent by a first target system, wherein the chart deletion request is used for requesting deletion of a first chart;

s82, in response to the chart deletion request, a deletion operation is performed on the first chart information and the first chart data to delete the first chart.

In this embodiment, the chart drawing platform may support a custom chart operation, where the chart operation may include: graph deletion operation. For the first chart, the user may send a chart deletion request to a server of the chart drawing platform through the client or the terminal device, where the chart deletion request is used to request deletion of the first chart.

In response to the chart deletion request, the server may perform a deletion operation on the first chart information and the first chart data to delete the first chart. Here, the chart deletion deleted information may include: the first graph data, the first graph information, and the first graph information may include the foregoing graph description information. Other information may be deleted, for example, the chart additional information (if any), the first target data (if any) may be deleted, and other information related to the first chart may be deleted, which is not limited in this embodiment.

For the user, a chart deletion button (other controls, components, etc. may be displayed) of the first chart on the client or the terminal device. The user may perform a trigger operation on the chart deletion button to trigger deletion of the first chart. In response to the detected triggering operation performed by the chart deletion button, the client or the terminal device may send a chart deletion request to the target server to trigger deletion of the first chart.

By the embodiment of the application, the chart deletion is performed based on the chart deletion request, so that the convenience of the chart deletion can be improved, and the use experience of a user can be improved.

The operation of the custom chart is explained below in conjunction with fig. 6. As shown in FIG. 6, allowing the custom chart operation may include at least one of:

a chart registration operation, which may be performed based on description information such as a chart name, a chart type, chart description information, data source docking description information, and the like;

a chart modification operation that may be performed based on description information such as a chart name, chart type, chart description information, data source docking description information, etc., i.e., modifying at least one of description information such as a chart name, chart type, chart description information, data source docking description information;

A chart deletion operation, which may be performed based on the chart description information and the chart association new data, i.e., deleting the chart description information and the chart association new data, where the chart association data includes, but is not limited to, at least one of: and (3) reading data used for drawing the chart from the data source, and calculating index data (or first chart data).

The related art has serious limitation in integrating the graph drawing function in the service system, and affects the maintenance of the system, and the updating of the graph drawing function has a plurality of limitations, the code updating of the service system can be related when the graph drawing function is longitudinally expanded, the gray level test of most functions can be performed when new characteristics are updated or added each time, the efficiency is low, and the related problems are easy to generate. Also, business developers cannot customize chart operations, which may include, but are not limited to: registration, modification, deletion, etc., the diagramming operation requires modification of the system code itself.

And through the unified chart drawing platform, the chart operation can be conveniently customized, the complexity of the longitudinal expansion of the chart drawing function can be reduced, and the efficiency of the longitudinal expansion of the chart drawing function can be improved. And the longitudinal (and transverse) expansion is more convenient and safer, the influence on other services is avoided, the change range is greatly reduced, and the expansion risk is reduced.

As an alternative, performing a graph drawing operation on the first graph data according to the graph parameters indicated by the first graph information to obtain a first graph, including:

s91, acquiring a target chart identifier, a target chart type and target chart description information corresponding to a chart to be drawn from the first chart information, wherein the target chart description information is chart description information displayed in the chart to be drawn;

and S92, performing graph drawing operation on the first graph data according to the target graph identifier, the target graph type and the target graph description information to obtain a first graph, wherein the graph identifier of the first graph is the target graph identifier, the graph type of the first graph is the target graph type, and the first graph comprises the target graph description information.

In the related art, there are two general modes of drawing a chart, namely, background drawing front-end rendering, and drawing and rendering by a front-end component directly. In either way, the graph drawing function is integrated or embedded in the corresponding system as a single point capability, and the graph drawing functions in different systems are different in implementation form, various in page effect, different in style and influence on the use experience. And, need to constantly adjust the adaptation to different data sources, have a big influence on the development efficiency and quality. And moreover, a set of codes cannot be maintained, unified management and maintenance are inconvenient, and the maintenance cost is high.

In the embodiment, the unified chart drawing platform is used for drawing the chart, so that the unified style of chart rendering can be ensured, only one unified platform code is required to be maintained, the updating and the maintenance are more convenient and concise, and the maintenance cost is greatly reduced.

The first chart information may indicate a variety of chart parameters, which may include, but is not limited to, at least one of: chart identification (i.e., target chart identification), chart type (i.e., target chart type), chart description information (i.e., target chart description information) shown in the chart. When the first chart drawing is performed, the server may acquire a target chart identifier, a target chart type, and target chart description information corresponding to the chart to be drawn from the first chart information.

According to the target chart identifier, the target chart type and the target chart description information, the server can execute chart drawing operation on the first chart data to obtain a first chart, the drawn chart identifier of the first chart is the target chart identifier, the chart type is the target chart type, and the drawn first chart can contain the target chart description information.

Optionally, the target chart description information may include, but is not limited to, at least one of: description information of the ordinate/abscissa of the first chart. Further, to increase flexibility of chart drawing, the first chart information may further indicate chart parameters of at least one of: the unit information of the vertical/horizontal coordinates (for example, index parameters corresponding to each unit length) may indicate other chart parameters, which are not limited in this embodiment.

By the embodiment of the application, the chart identification, the chart type, the description information displayed in the chart and the like are obtained from the chart information to draw the chart, so that the uniformity of the chart rendering style can be ensured, and the use experience of a user can be improved.

The chart drawing flow in the chart drawing method in the embodiment of the application is explained below in conjunction with an alternative example. In this alternative example, the data document is a table document, and the chart data is index data.

As shown in fig. 7, the chart registration flow in the chart drawing method in this alternative example may include the steps of:

step S701, after drawing of a chart is started, obtaining a user-defined chart name during registration;

step S702, obtaining a graph type designated during registration;

step S703, acquiring chart description information, such as a longitudinal and transverse coordinate field, description, additional information, etc., specified at the time of registration;

step S704, other description information is acquired;

step S705, drawing a chart;

step S706, returning the drawing data;

step S707, the browser renders the chart data, performs visual display and ends chart drawing.

Through the optional example, by maintaining a set of platform codes, the chart drawing platform draws charts according to chart information provided by different systems according to a unified flow, and on the basis of a unified chart style, required charts can be provided for different systems, so that maintenance cost of chart drawing functions can be reduced, and use experience of users is improved.

s101, rendering a first chart onto a first page, wherein the first page is independent of a second page of a first target system and is a page jumped to by the second page, or the first page is independent of the second page of the first target system and is embedded in the second page; or alternatively, the process may be performed,

s103, transmitting the first chart to a second page of the first target system through the application program interface so as to render the first chart onto the second page.

For the drawn first chart, it may be rendered onto a page for visual display. In this embodiment, the first chart may be rendered in a variety of ways, as shown in fig. 8, and may include, but is not limited to, at least one of the following:

the jump mode (i.e., independent presentation) may be to jump to a new page for rendering, for example, the jump may be performed in a hyperlink mode directly from the page of the service system to a new page (may be a page corresponding to the page drawing platform) for rendering;

The embedded mode can be used for directly embedding other pages (such as pages of other systems) in the form of embedded pages, and rendering is carried out in the embedded pages;

the API (Application Programming Interface, application program interface) call mode may return drawing data (i.e., chart data) of a calling party (e.g., a page of a service system) when the API interface is called, and the calling party performs custom drawing.

As an alternative embodiment, the server may render the first graph onto the first page, where the first page may be a second page independent of the first target system and a page jumped to by the second page, in which case the manner of rendering used is the above-mentioned jumped manner, or the first page may be a second page independent of the first target system (i.e., not the same page), and a page embedded within the second page, in which case the manner of rendering used is the above-mentioned embedded manner.

For example, the architecture of the diagramming platform may include: the WEB (World Wide WEB) layer, i.e. the presentation layer, can realize presentation of the chart view, and can be used alone (corresponding to the above-mentioned jump mode) or can be packaged as an embedded page (corresponding to the above-mentioned embedded mode).

As another alternative, the server may transmit the first chart to the second page of the first target system through an application program interface (i.e., API), through which the first chart may be rendered onto the second page. In this case, the rendering method used is an API call method. Through the API interface of the chart drawing, the data access and the chart drawing can be abstractly stripped, the chart drawing is highly customized, and the chart drawing with low codes or even no codes can be realized.

For example, the architecture of the diagramming platform may include: the API layer can realize chart drawing, the data input bottom layer is realized, an API interface is externally provided, and independent calling can be realized. The calling and accessing of API level can be provided relative to the existing service system.

By adopting the embodiment of the application, the chart rendering is carried out in different rendering modes under different scenes, so that the flexibility of the chart rendering can be improved, and the use experience of a user can be improved.

The chart drawing method in the embodiment of the present application is explained below in conjunction with alternative examples. For the data organization and the chart drawing part in the chart drawing, in the alternative example, the plug-in data docking script is adopted to realize docking and arrangement of data, and the chart drawing is carried out in a unified mode, so that the development difficulty can be greatly reduced.

In the alternative example, the plug-in data docking and visualization chart drawing system is provided, and corresponding to a chart drawing platform, data updating and chart maintenance can be unified on one platform, so that subsequent maintenance cost can be reduced. As shown in fig. 9, the architecture of the system may include: a data source butt joint layer, a data layer, an API layer and a WEB layer, wherein,

the data source docking layer may dock external system data (corresponding to a data automatic entry mode) or manually maintained data (corresponding to a data manual entry mode). For different types of data sources, the data source docking layer can adopt different data docking modes.

For external system data, a plug-in data docking script can be used to realize data docking and arrangement (such as index calculation), and the external system data and the calculated index data can be subjected to data formatting. And a timing task can be set for the data docking script, and the data docking script is automatically executed through the timing task, so that the timing update of the data is realized. In addition, the data source docking layer can perform grammar checking, sensitive operation checking, execution environment configuration and the like on the accessed external system data. The data source docking layer may also associate an index description information base with the data.

For manually maintained data, the data source docking layer can conduct data import and update, index calculation and description input, can conduct data preprocessing, data formatting, index calculation and the like, and can conduct data update and data warehousing.

After data entry is started, different workflows can be selected by judging whether the data entry is manual or automatic, target data are accessed according to a certain standard to carry out cleaning, calculation, organization and drawing into a target chart, and calculation logic of index data is provided by a calling party.

The data layer may contain an index description information base and a database of index data, and may provide direct data support for the API layer.

The API layer may implement database operations and index description operations, and may perform chart addition, deletion, modification, and query operations, and may obtain presentation/rendering data acquisition, e.g., chart drawing data, additional information, chart descriptions, index data, other descriptions, etc., through the API layer.

Here, independent calling of data is realized by setting a data layer and an API layer, and the result of the data docking layer is input and stored in a lasting mode.

The WEB layer can display the chart view and can render index data, for example, rendering description information, drawn charts and the like. In addition, when index registration/query interaction is performed, data description and rendering description can be obtained through the WEB layer, and other information can be obtained.

Here, the display of the visual chart view is realized by setting the WEB layer, and the visual chart view can be used alone or can be packaged as an embedded page.

By this alternative example, the third party system (e.g., the foregoing business system) can complete the corresponding chart drawing only by following the data access specification, the index calculation description, and the chart drawing description; in addition, by providing two access modes of a WEB view and an API interface, development time can be reduced, and the drawing difficulty of the chart can be reduced.

It should be noted that, for simplicity of description, the foregoing method embodiments are all described as a series of acts, but it should be understood by those skilled in the art that the present application is not limited by the order of acts described, as some steps may be performed in other orders or concurrently in accordance with the present application. Further, those skilled in the art will also appreciate that the embodiments described in the specification are all preferred embodiments, and that the acts and modules referred to are not necessarily required for the present application.

According to another aspect of the embodiment of the present application, there is also provided a chart drawing apparatus for implementing the chart drawing method described above. Fig. 10 is a block diagram of an alternative diagramming apparatus according to an embodiment of the present application, as shown in fig. 10, which may include:

a first access unit 1002, configured to perform a data access operation on a first data source to obtain first target data, where the first data source is a data source determined according to first data source docking information configured by the first target system and used for drawing a first chart;

a first processing unit 1004, configured to perform a first processing operation on the first target data to obtain first chart data, where the first processing operation is a processing operation indicated by the first data source docking information and used for obtaining chart data corresponding to a first chart;

the first drawing unit 1006 is configured to perform a chart drawing operation on the first chart data according to the chart parameter indicated by the first chart information, to obtain a first chart, where the first chart information is chart information of the first chart configured by the first target system.

It should be noted that, the first access unit 1002 in this embodiment may be configured to perform the above-mentioned step S202, the first processing unit 1004 in this embodiment may be configured to perform the above-mentioned step S204, and the first drawing unit 1006 in this embodiment may be configured to perform the above-mentioned step S206.

As an alternative, the apparatus further includes:

the second access unit is used for executing data access operation on a second data source to obtain second target data, wherein the second data source is determined according to second data source docking information configured by a second target system and used for generating a second chart;

The second processing unit is used for executing a second processing operation on the second target data to obtain second chart data, wherein the second processing operation is indicated by the second data source docking information and is used for acquiring chart data corresponding to the second chart;

and a second drawing unit configured to perform a graph drawing operation on the second graph data according to the graph parameters indicated by the second graph information, to obtain a second graph, wherein the second graph information is graph information of a second graph configured by the second target system.

An optional example of this embodiment may refer to an example shown in the above-described chart drawing method, and will not be described here in detail.

As an alternative, the first access unit includes:

the first acquisition module is used for acquiring the target data document uploaded by the first target system, wherein the first data source is the target data document, and the first data source docking information comprises the target data document;

the analysis module is used for executing analysis operation on the target data document to obtain first target data; or alternatively, the process may be performed,

the connection module is used for establishing connection with a first data source indicated by the data docking script in the process of running the data docking script uploaded by the first target system, wherein the first data source docking information comprises the data docking script;

And the query module is used for executing query operation on the first data source according to the query conditions indicated by the data docking script to obtain first target data.

As an alternative, the apparatus further includes:

the first acquisition unit is used for acquiring a preset script execution period corresponding to the data docking script uploaded by the first target system;

the triggering unit is used for triggering the execution task of the data docking script at regular time according to the execution period of the preset script so as to run the data docking script at regular time.

As an alternative, the apparatus further includes:

the first receiving unit is used for receiving a chart registration request sent by the first target system before performing data access operation on the first data source to obtain first target data, wherein the chart registration request is used for requesting to register a chart for the first target system by using first chart information and first data source docking information;

And the registration unit is used for responding to the chart registration request, executing chart registration operation by using the first chart information and the first data source docking information, and obtaining the registration information of the first chart.

As an alternative, the apparatus further includes:

the display unit is used for displaying a chart registration interface on the terminal equipment corresponding to the first target system before receiving the chart registration request sent by the first target system, wherein the chart registration interface is used for registering a chart for the first target system;

the second acquisition unit is used for responding to the input operation of the chart registration interface and acquiring first chart information and first data source docking information;

and the sending unit is used for sending a chart registration request to the target server, wherein the chart registration request carries first chart information and first data source butt joint information.

As an alternative, the apparatus further includes:

The second receiving unit is used for receiving a chart modification request sent by the first target system after performing chart drawing operation on the first chart data according to the chart parameters indicated by the first chart information to obtain a first chart, wherein the chart modification request is used for requesting to modify the first chart information and target information in the first data source docking information;

and the modification unit is used for responding to the chart modification request, executing modification operation on the first chart information and the target information in the first data source butt joint information, and obtaining the registration information after the first chart modification.

As an alternative, the apparatus further includes:

a third receiving unit, configured to receive a chart deletion request sent by the first target system after performing a chart drawing operation on the first chart data according to the chart parameter indicated by the first chart information to obtain a first chart, where the chart deletion request is used to request deletion of the first chart;

and a deleting unit configured to perform a deleting operation on the first chart information and the first chart data in response to the chart deletion request, to delete the first chart.

As an alternative, the apparatus further includes:

the formatting unit is used for executing a first processing operation on the first target data to obtain first chart data, and then executing a formatting operation on the first chart data to obtain formatted first chart data;

and the calling unit is used for persistently storing the formatted first chart data into the target database by calling a data storage interface of the target database, wherein the chart drawing operation is executed on the first chart data stored in the target database.

As an alternative, the first drawing unit includes:

the second acquisition module is used for acquiring a target chart identifier, a target chart type and target chart description information corresponding to the chart to be drawn from the first chart information, wherein the target chart description information is chart description information displayed in the chart to be drawn;

And the drawing module is used for executing graph drawing operation on the first graph data according to the target graph identifier, the target graph type and the target graph description information to obtain a first graph, wherein the graph identifier of the first graph is the target graph identifier, the graph type of the first graph is the target graph type, and the first graph comprises the target graph description information.

As an alternative, the apparatus further includes:

a rendering unit, configured to perform a chart drawing operation on the first chart data according to the chart parameter indicated by the first chart information, and then render the first chart onto a first page, where the first page is independent of and jumped to by a second page of the first target system, or the first page is independent of and embedded in the second page of the first target system; or alternatively, the process may be performed,

and the transmission unit is used for transmitting the first chart to a second page of the first target system through the application program interface so as to render the first chart onto the second page.

According to still another aspect of the embodiment of the present application, there is also provided an electronic device for implementing the above-mentioned chart drawing method, which may be a terminal device or a server shown in fig. 1. The present embodiment is described taking the electronic device as a terminal device as an example. As shown in fig. 11, the electronic device comprises a memory 1102 and a processor 1104, the memory 1102 having stored therein a computer program, the processor 1104 being arranged to perform the steps of any of the method embodiments described above by means of the computer program.

Alternatively, in this embodiment, the electronic device may be located in at least one network device of a plurality of network devices of the computer network.

Alternatively, in the present embodiment, the above-described processor may be configured to execute the following steps by a computer program:

s1, performing data access operation on a first data source to obtain first target data, wherein the first data source is determined according to first data source docking information configured by a first target system and used for drawing a first chart;

S2, executing a first processing operation on the first target data to obtain first chart data, wherein the first processing operation is indicated by the first data source docking information and is used for obtaining chart data corresponding to the first chart;

and S3, performing a chart drawing operation on the first chart data according to the chart parameters indicated by the first chart information to obtain a first chart, wherein the first chart information is the chart information of the first chart configured by the first target system.

Alternatively, it will be understood by those skilled in the art that the structure shown in fig. 11 is only schematic, and the electronic device may also be a smart phone (such as an Android mobile phone, an iOS mobile phone, etc.), a tablet computer, a palm computer, and terminal devices such as MID, PAD, etc. Fig. 11 is not limited to the structure of the electronic device described above. For example, the electronic device may also include more or fewer components (e.g., network interfaces, etc.) than shown in FIG. 11, or have a different configuration than shown in FIG. 11.

The memory 1102 may be used to store software programs and modules, such as program instructions/modules corresponding to the chart drawing methods and apparatuses in the embodiments of the present application, and the processor 1104 executes the software programs and modules stored in the memory 1102 to perform various functional applications and data processing, i.e., implement the chart drawing methods described above. Memory 1102 may include high-speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, memory 1102 may further include memory located remotely from processor 1104, which may be connected to the terminal via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof. The memory 1102 may be used for, but is not limited to, serializing files and compiling files. As an example, as shown in fig. 11, the memory 1102 may include, but is not limited to, the first access unit 1002, the first processing unit 1004, and the first drawing unit 1006 in the graph drawing apparatus. In addition, other module units in the above-mentioned chart drawing device may be included, but are not limited to, and are not described in detail in this example.

Optionally, the transmission device 1106 is used to receive or transmit data via a network. Specific examples of the network described above may include wired networks and wireless networks. In one example, the transmission device 1106 includes a network adapter (Network Interface Controller, NIC) that may be connected to other network devices and routers via a network cable to communicate with the internet or a local area network. In one example, the transmission device 1106 is a Radio Frequency (RF) module for communicating wirelessly with the internet.

In addition, the electronic device further includes: a display 1108 for displaying the above-described chart registration interface, chart modification interface, etc.; and a connection bus 1410 for connecting the respective module parts in the above-described electronic device.

In other embodiments, the terminal device or the server may be a node in a distributed system, where the distributed system may be a blockchain system, and the blockchain system may be a distributed system formed by connecting the plurality of nodes through a network communication. Among them, the nodes may form a Peer-To-Peer (P2P) network, and any type of computing device, such as a server, a terminal, etc., may become a node in the blockchain system by joining the Peer-To-Peer network.

According to one aspect of the present application, there is provided a computer program product comprising a computer program/instruction containing program code for executing the method shown in the flow chart. In such an embodiment, the computer program can be downloaded and installed from a network via the communication portion 1209, and/or installed from the removable media 1211. When executed by the central processor 1201, performs various functions provided by embodiments of the present application. The foregoing embodiment numbers of the present application are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.

Fig. 12 schematically shows a block diagram of a computer system of an electronic device for implementing an embodiment of the application. As shown in fig. 12, the computer system 1200 includes a central processing unit 1201 (Central Processing Unit, CPU) which can perform various appropriate actions and processes according to a program stored in a Read-Only Memory 1202 (ROM) or a program loaded from a storage section 1208 into a random access Memory 1203 (Random Access Memory, RAM). In the random access memory 1203, various programs and data necessary for the system operation are also stored. The cpu 1201 and the ram 1202 are connected to each other via a bus 1204. An Input/Output interface 1205 (i.e., an I/O interface) is also connected to the bus 1204.

The following components are connected to the input/output interface 1205: an input section 1206 including a keyboard, a mouse, and the like; an output portion 1207 including a Cathode Ray Tube (CRT), a liquid crystal display (Liquid Crystal Display, LCD), and a speaker, etc.; a storage section 1208 including a hard disk or the like; and a communication section 1209 including a network interface card such as a lan card, a modem, or the like. The communication section 1209 performs communication processing via a network such as the internet. The driver 1210 is also connected to the input/output interface 1205 as needed. A removable medium 1211 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is installed as needed on the drive 1210 so that a computer program read out therefrom is installed into the storage section 1208 as needed.

In particular, the processes described in the various method flowcharts may be implemented as computer software programs according to embodiments of the application. For example, embodiments of the present application include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method shown in the flowcharts. In such an embodiment, the computer program can be downloaded and installed from a network via the communication portion 1209, and/or installed from the removable media 1211. The computer programs, when executed by the central processor 1201, perform the various functions defined in the system of the present application.

It should be noted that, the computer system 1200 of the electronic device shown in fig. 12 is only an example, and should not impose any limitation on the functions and the application scope of the embodiments of the present application.

According to one aspect of the present application, there is provided a computer-readable storage medium, from which a processor of a computer device reads the computer instructions, the processor executing the computer instructions, causing the computer device to perform the methods provided in the various alternative implementations of the above embodiments.

Alternatively, in the present embodiment, the above-described computer-readable storage medium may be configured to store a computer program for performing the steps of:

Alternatively, in this embodiment, it will be understood by those skilled in the art that all or part of the steps in the methods of the above embodiments may be performed by a program for instructing a terminal device to execute the steps, where the program may be stored in a computer readable storage medium, and the storage medium may include: flash disk, read-Only Memory (ROM), random-access Memory (Random Access Memory, RAM), magnetic or optical disk, and the like.

The integrated units in the above embodiments may be stored in the above-described computer-readable storage medium if implemented in the form of software functional units and sold or used as separate products. Based on such understanding, the technical solution of the present application may be embodied in essence or a part contributing to the prior art or all or part of the technical solution in the form of a software product stored in a storage medium, comprising several instructions for causing one or more computer devices (which may be personal computers, servers or network devices, etc.) to perform all or part of the steps of the method described in the embodiments of the present application.

In the foregoing embodiments of the present application, the descriptions of the embodiments are emphasized, and for a portion of this disclosure that is not described in detail in this embodiment, reference is made to the related descriptions of other embodiments.

In several embodiments provided by the present application, it should be understood that the disclosed client may be implemented in other manners. The above-described embodiments of the apparatus are merely exemplary, and the division of the units, such as the division of the units, is merely a logical function division, and may be implemented in another manner, for example, multiple units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some interfaces, units or modules, or may be in electrical or other forms.

The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

In addition, each functional unit in the embodiments of the present application may be integrated in one processing unit, or each unit may exist alone physically, or at least two units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.

The foregoing is merely a preferred embodiment of the present application and it should be noted that modifications and adaptations to those skilled in the art may be made without departing from the principles of the present application, which are intended to be comprehended within the scope of the present application.

Claims

1. A graph plotting method, characterized by comprising:

performing data access operation on a first data source to obtain first target data, wherein the first data source is a data source which is determined according to first data source docking information configured by a first target system and used for drawing a first chart;

executing a first processing operation on the first target data to obtain first chart data, wherein the first processing operation is indicated by the first data source docking information and is used for obtaining chart data corresponding to the first chart;

And performing a graph drawing operation on the first graph data according to graph parameters indicated by first graph information, so as to obtain the first graph, wherein the first graph information is the graph information of the first graph configured by the first target system.

2. The method according to claim 1, wherein the method further comprises:

performing data access operation on a second data source to obtain second target data, wherein the second data source is a data source which is determined according to second data source docking information configured by a second target system and used for generating a second chart;

performing a second processing operation on the second target data to obtain second chart data, wherein the second processing operation is indicated by the second data source docking information and is used for acquiring chart data corresponding to the second chart;

and performing a chart drawing operation on the second chart data according to chart parameters indicated by second chart information to obtain the second chart, wherein the second chart information is the chart information of the second chart configured by the second target system.

3. The method of claim 1, wherein performing a data access operation on the first data source results in the first target data, comprising:

acquiring a target data document uploaded by the first target system, wherein the first data source is the target data document, and the first data source docking information comprises the target data document; performing analysis operation on the target data document to obtain the first target data; or alternatively, the process may be performed,

establishing connection with the first data source indicated by the data docking script in the process of running the data docking script uploaded by the first target system, wherein the first data source docking information comprises the data docking script; and executing query operation on the first data source according to the query conditions indicated by the data docking script to obtain the first target data.

4. A method according to claim 3, characterized in that the method further comprises:

acquiring a preset script execution period corresponding to the data docking script uploaded by the first target system;

and triggering the execution task of the data docking script at regular time according to the execution period of the preset script so as to run the data docking script at regular time.

5. The method of claim 1, wherein prior to performing the data access operation on the first data source to obtain the first target data, the method further comprises:

receiving a chart registration request sent by the first target system, wherein the chart registration request is used for requesting to register a chart for the first target system by using the first chart information and the first data source docking information;

and responding to the chart registration request, and executing chart registration operation by using the first chart information and the first data source docking information to obtain registration information of the first chart.

6. The method of claim 5, wherein prior to said receiving the chart registration request sent by the first target system, the method further comprises:

displaying a chart registration interface on a terminal device corresponding to the first target system, wherein the chart registration interface is used for chart registration for the first target system;

responding to the input operation of the chart registration interface, and acquiring the first chart information and the first data source docking information;

and sending the chart registration request to a target server, wherein the chart registration request carries the first chart information and the first data source docking information.

7. The method according to claim 1, wherein after the first chart data is subjected to a chart drawing operation in accordance with the chart parameter indicated by the first chart information, the method further comprises:

receiving a chart modification request sent by the first target system, wherein the chart modification request is used for requesting to modify target information in the first chart information and the first data source docking information;

and responding to the chart modification request, and executing modification operation on the first chart information and target information in the first data source butt joint information to obtain registration information after the first chart modification.

8. The method according to claim 1, wherein after the first chart data is subjected to a chart drawing operation in accordance with the chart parameter indicated by the first chart information, the method further comprises:

receiving a chart deletion request sent by the first target system, wherein the chart deletion request is used for requesting deletion of the first chart;

and in response to the chart deletion request, performing a deletion operation on the first chart information and the first chart data to delete the first chart.

9. The method of claim 1, wherein after said performing a first processing operation on said first target data to obtain first chart data, said method further comprises:

formatting the first chart data to obtain formatted first chart data;

and the formatted first chart data is stored in the target database in a lasting way through calling a data storage interface of the target database, wherein the chart drawing operation is executed on the first chart data stored in the target database.

10. The method of claim 1, wherein performing a chart drawing operation on the first chart data according to the chart parameters indicated by the first chart information to obtain the first chart, comprises:

acquiring a target chart identifier, a target chart type and target chart description information corresponding to a chart to be drawn from the first chart information, wherein the target chart description information is chart description information displayed in the chart to be drawn;

and executing a chart drawing operation on the first chart data according to the target chart identifier, the target chart type and the target chart description information to obtain the first chart, wherein the chart identifier of the first chart is the target chart identifier, the chart type of the first chart is the target chart type, and the target chart description information is contained in the first chart.

11. The method according to any one of claims 1 to 10, characterized in that after the first chart data is subjected to a chart drawing operation in accordance with the chart parameter indicated by the first chart information, the method further comprises:

rendering the first chart onto a first page, wherein the first page is independent of and jumped to by a second page of the first target system, or is independent of and embedded within a second page of the first target system; or alternatively, the process may be performed,

the first chart is transmitted to a second page of the first target system through an application program interface so as to be rendered on the second page.

12. A graph plotting device, characterized by comprising:

the first access unit is used for executing data access operation on a first data source to obtain first target data, wherein the first data source is a data source which is determined according to first data source docking information configured by a first target system and used for drawing a first chart;

a first processing unit, configured to perform a first processing operation on the first target data to obtain first chart data, where the first processing operation is a processing operation indicated by the first data source docking information and used for obtaining chart data corresponding to the first chart;

And a first drawing unit configured to perform a graph drawing operation on the first graph data according to a graph parameter indicated by first graph information, to obtain the first graph, where the first graph information is graph information of the first graph configured by the first target system.

13. A computer readable storage medium, characterized in that the computer readable storage medium comprises a stored program, wherein the program when run performs the method of any one of claims 1 to 11.

14. A computer program product comprising computer programs/instructions which, when executed by a processor, implement the steps of the method of any one of claims 1 to 11.

15. An electronic device comprising a memory and a processor, characterized in that the memory has stored therein a computer program, the processor being arranged to execute the method according to any of the claims 1 to 11 by means of the computer program.