Automatic Conversion Method and System for Multivariate Data Structures for Large Screen Chart Adaptation

Abstract

The present invention discloses a method and system for automatically converting a multi-source data structure for large-screen chart adaptation. The method includes: configuring a visual large-screen chart, and using the visual large screen to configure the attributes and categories of the chart; configuring a data interface service, including configuring the type of data conversion and the data conversion process; connecting a data row-column conversion operator and a data structure conversion operator into the data conversion process; starting the data interface service to obtain the converted data; using the converted data to test the data interface service until the verification result is correct; wherein, the data row-column conversion operator specifically converts a one-dimensional / multi-dimensional array row-column into linear data through a visual arrangement method; the data structure conversion operator specifically converts a one-dimensional / multi-dimensional array structure into linear data through a visual arrangement method. The present invention can reduce the adaptation cost in the process of configuring large-screen data charts and improve the adaptation efficiency in the process of configuring large-screen data charts.

Description

Technical Field

[0001] This application relates to the field of data structure conversion, and particularly to an automatic conversion method and system for multi-source data structures for large-screen chart adaptation. Background Art

[0002] In recent years, the large-screen visualization configuration technology has developed rapidly. In the traditional large-screen configuration process, it is necessary to connect to the backend service interface, and the backend service interface needs to adapt to the large-screen visualization chart plug-in during the connection process. A large amount of adaptation programming is required during the adaptation process of the backend service, which increases the workload of the backend service coding to a certain extent, reduces the work efficiency, and increases the work cost of large-screen configuration.

[0003] In order to configure the charts for large-screen visualization and enable the charts to be normally displayed on the large screen, the data returned by the data interface docked by the large-screen charts must conform to the data structure recognizable by the large-screen charts. There are certain differences between the data structure of the large-screen charts and the interface data structure returned by the traditional data interface querying from the database. Therefore, the interface data returned by querying from the database cannot be directly used for the configuration of large-screen charts and needs to undergo a certain data structure conversion to be applicable to the configuration of large-screen charts.

[0004] The interface data returned from the database needs to undergo data structure conversion to adapt to the data structure for large-screen chart configuration. To solve the data conversion problem, generally there are two methods. One is to modify at the front end to obtain the data that conforms to the chart structure from the data returned by the interface. The other is to modify at the backend to directly convert the data returned by the database into the data structure recognizable by the large-screen charts. And now many large-screen configuration technologies have been productized. The method of modifying at the front end is very costly and does not conform to the productization concept. Because the interface data returned by the backend service does not have a very fixed format and changes quite a lot, the front end cannot fully adapt. Then it can only be modified at the backend, that is, to modify from the data service interface end docked by the large-screen charts.

[0005] There are two specific methods for backend modification. One is to modify the backend code, write a unified method that can adapt to various charts, and convert the data by a unified method. For example, if the chart connected to the interface is a radar chart, then before the interface returns the data, the radar chart data structure method converts the returned data into a data structure, and then returns the data to the large-screen chart after conversion. This method needs to adapt each returned data. If it needs to be modified later, it needs to be re-adapted and new code added, which reduces the efficiency of data structure adaptation and greatly increases the maintenance cost in the later stage, which is not conducive to promotion and use; the second is microservice docking, that is, all the data connected to the large-screen chart is first connected to the microservice, and the microservice performs a unified data structure conversion, and the large-screen chart is uniformly connected to the interface converted by the microservice. In simple terms, the interface that the original large screen is to be connected is converted by the microservice conversion interface to generate a new interface, and the large-screen chart then connects to the new interface. This method is to obtain the returned data through the request source interface and then perform structure conversion, and the large screen needs to configure many charts. This method increases the time for large-screen data structure adaptation and does not meet the requirements for fast display of large-screen data. In general, the above two methods are costly and inefficient during project implementation. Summary of the invention

[0006] In view of the above problems, the present invention provides a multi-data structure automatic conversion method and system for large-screen chart adaptation, which realizes online visualization of the entire process of large-screen data chart structure adaptation by arranging visualization large-screen data chart structure adaptation operators, with the help of visualization service arrangement method, online operator arrangement method, online service debugging method, and online service testing method. The cost of the large-screen data chart configuration process adaptation structure is reduced, and the efficiency of the large-screen data chart configuration process adaptation structure is improved.

[0007] In a first aspect of the present invention, a method for automatically converting a multi-data structure for large-screen chart adaptation is provided, the method comprising the following steps:

[0008] Configure visualization charts and use the visualization chart to configure the properties and categories of the charts;

[0009] Configure data interface services, including configuring data conversion types and data conversion processes;

[0010] Integrate the data row-column conversion operator and the data structure conversion operator into the data conversion process;

[0011] Start the data interface service to obtain the converted data;

[0012] Use the converted data to test the data interface service until the results are verified to be correct;

[0013] Among them, the data row-column conversion operator specifically converts the row-column of a one-dimensional / multi-dimensional array into linear data through a visual arrangement method; the data structure conversion operator specifically converts the structure of a one-dimensional / multi-dimensional array into linear data through a visual arrangement method.

[0014] Furthermore, the specific steps of the visual arrangement method include:

[0015] Adding and modifying the parameters of the data interface service;

[0016] Writing a data structure conversion script;

[0017] Using the data output by the data structure conversion script for debugging until the correctness of the script is verified.

[0018] Furthermore, the method also includes connecting the visual large-screen chart to the data interface service and displaying the converted data chart.

[0019] Furthermore, the method also includes configuring the database connection and permissions, as well as configuring the database language and writing the database language into the data interface service.

[0020] In the second aspect of the present invention, a multi-data structure automatic conversion system for large-screen chart adaptation is provided, including:

[0021] A visual large-screen chart configuration module for configuring the attributes and categories of the chart using the visual large screen;

[0022] A data interface service configuration module for configuring the type of data conversion and the data conversion process;

[0023] An operator arrangement module for connecting the data row-column conversion operator and the data structure conversion operator into the data conversion process;

[0024] A data conversion module for starting the data interface service to obtain the converted data;

[0025] A testing module for testing the data interface service using the converted data until the correctness of the result is verified;

[0026] Among them, the data row-column conversion operator in the operator arrangement module specifically converts the row-column of a one-dimensional / multi-dimensional array into linear data through a visual arrangement method; the data structure conversion operator specifically converts the structure of a one-dimensional / multi-dimensional array into linear data through a visual arrangement method.

[0027] Furthermore, the specific steps of the visual arrangement method in the operator arrangement module include:

[0028] Adding and modifying the parameters of the data interface service;

[0029] Writing a data structure conversion script;

[0030] Use the data structure to convert the data output by the script for debugging until the correctness of the script is verified.

[0031] Furthermore, the system further includes a display module for connecting the visual large-screen chart to the data interface service and displaying the converted data chart.

[0032] Furthermore, the system further includes a data source acquisition module for configuring database connections and permissions, as well as configuring the database language and writing the database language into the data interface service.

[0033] In a third aspect of the present invention, a terminal is provided, including: a processor; and a memory, wherein a computer-executable program is stored in the memory, and when the computer-executable program is executed by the processor, the above-mentioned automatic conversion method of multiple data structures for large-screen chart adaptation is executed.

[0034] In a fourth aspect of the present invention, a computer-readable storage medium is provided, on which instructions are stored, and when the instructions are executed by a processor, the processor executes the above-mentioned automatic conversion method of multiple data structures for large-screen chart adaptation.

[0035] An automatic conversion method, system, and computer storage medium for multiple data structures for large-screen chart adaptation provided by the present invention realize the whole-process visualization, configurability, and convertible structure of the docking interface during the large-screen configuration process. Without the need for back-end service personnel to intervene in programming, large-screen configuration personnel can complete it by themselves. The interface converted by the present invention can perfectly conform to the line charts, bar charts, pie charts, radar charts, etc. of large-screen configuration, and can also adapt to other data structures of large-screen configuration, such as tables, data indicators, etc., and can also adapt to the map layer data structure of large-screen map layer configuration, so that the interface data can be perfectly displayed on the map through the layer. During the large-screen configuration process, only one person is required to complete it, reducing the communication cost of large-screen configuration and increasing the efficiency of large-screen configuration. The ultimate beneficial effect achieved: By arranging the visual large-screen data chart structure adaptation operator, the visibility and efficiency of the large-screen data chart structure adaptation process are increased. When configuring personnel configure the large-screen visualization system, no other personnel are required to cooperate, and no complex code needs to be written. Therefore, the efficiency of the configuration personnel can be improved, enabling them to be more focused on the configuration of the large-screen visualization system without being interfered by other factors, and also increasing the maintainability of the system in the later stage. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] Figure 1 is a flowchart of an automatic conversion method of multiple data structures for large-screen chart adaptation in an embodiment of the present invention;

[0037] Figure 2It is the flowchart of the visualization orchestration method in the embodiment of the present invention;

[0038] Figure 3 It is the schematic structural diagram of the multi - data - structure automatic conversion system for large - screen chart adaptation in the embodiment of the present invention;

[0039] Figure 4 It is the schematic structural diagram of a computer terminal in the embodiment of the present invention. Detailed implementation manners

[0040] To further elaborate on the technical solution of the present invention in detail, this embodiment is implemented on the premise of the technical solution of the present invention, and detailed implementation manners and specific steps are given.

[0041] An automatic conversion method for multi - data - structures for large - screen chart adaptation of the present invention is as Figure 1 shown, and the method includes the following steps:

[0042] S01. Configure the large - screen visualization chart, and use the large - screen visualization to configure the attributes and categories of the chart, where the chart attributes include color, width, height, etc., and the chart categories include pie charts, bar charts, etc.;

[0043] S02. Configure the data interface service, including configuring the type of data conversion and the data conversion process. Specifically, create a data conversion service, including configuring the type of data service including but not limited to GET, POST, PUT, DELETE, orchestrating the process of the data service, etc. The process of orchestrating the data service includes but not limited to selecting the start node, obtaining the data source, selecting the conversion operator, and then debugging;

[0044] S03. Connect the data row - column conversion operator and the data - structure conversion operator into the data conversion process;

[0045] Among them, the data row - column conversion operator includes a one - dimensional array row - column conversion operator and a multi - dimensional array row - column conversion operator. Specifically, the one - dimensional / multi - dimensional array row - column is converted into linear data through the visualization orchestration method; the data - structure conversion operator includes a one - dimensional array structure conversion operator and a multi - dimensional array structure conversion operator. Specifically, the one - dimensional / multi - dimensional array structure is converted into linear data through the visualization orchestration method. Among them, the one - dimensional array structure means that there is only one set of data in the target data structure, and it is mostly shown as a one - dimensional line chart, a single - column bar chart, etc. in the display form of the chart; the multi - dimensional array structure means that there are 2 or more sets of data in the target data structure, and it is mostly shown as a multi - series bar chart and a radar chart, etc. in the display form of the chart; the operator is a service orchestrated through the visualization orchestration method. As a transfer method in service visualization, it is equivalent to a link in the transfer process. That is, during the process of configuring the data interface service, the above - orchestrated operator is introduced. For example, the one - dimensional array row - column conversion operator is orchestrated into the data service process.

[0046] Preferably, the row-column conversion is to convert the {key: value} structure into the {name: key, code: value} structure. This is mainly applicable to the case where both the key and value in the Json structure need to be taken out and applied in the chart.

[0047] The structure conversion is to convert the [{key1: value1, key2: value2}, {key1: value11, key2: value22}] structure into the {key: [value1, value11], code: [value2, value22]} structure. This is mainly applicable to the case where only the value in the Json structure needs to be taken out and applied in the chart.

[0048] Furthermore, the visualization arrangement method is as Figure 2 shown, and the specific steps include:

[0049] S031. Add and modify the parameters of the data interface service;

[0050] S032. Write a data structure conversion script;

[0051] S033. Use the data output by the data structure conversion script for debugging until the correctness of the script is verified.

[0052] In the specific implementation process, set the parameters for adding and modifying the data interface service, such as chartName, chartTpye, keyField, valueField, etc.; write a structured script and place the structured script in the operator process; set the output, set the failure output and success output of the structure conversion; debug, that is, verify the correctness of the operator, and introduce the operator for verification and debugging.

[0053] S04. Start the data interface service to obtain the converted data, that is, run the arranged data service process so that the data conversion service can obtain the data;

[0054] S05. Use the converted data to test the data interface service until the correctness of the result is verified. Specifically, continuously debug the data interface service until the displayed data result is correct. Here, the result display also includes the case where no result is displayed, and further debugging is required;

[0055] Furthermore, the method also includes connecting the visualization large-screen chart to the data interface service and displaying the converted data chart.

[0056] Furthermore, the method also includes configuring database connections and permissions, as well as configuring database languages, and writing the database languages ​​into data interface services. Specifically, configuring a data source means creating a data source, configuring the database link, user name, and password of the data source, and also configuring and testing the database to be connected. It is also possible to modify and retest the configured database resources. The database language includes database query statements.

[0057] Below, refer to Figure 3 To describe the embodiment of the present disclosure Figure 1 The method shown corresponds to a multi-dimensional data structure automatic conversion system for large-screen chart adaptation, the system 100 includes: a visualization large-screen chart configuration module 101, used to configure the attributes and categories of the chart using the visualization large screen; a data interface service configuration module 102, used to configure the type of data conversion and the data conversion process; an operator arrangement module 103, used to connect the data row and column conversion operator and the data structure conversion operator to the data conversion process; a data conversion module 104, used to start the data interface service and obtain the converted data; a test module 105, used to test the data interface service using the converted data until the result is verified to be correct, wherein the data row and column conversion operator in the operator arrangement module 103 is specifically to convert the one-dimensional / multi-dimensional array row and column into linear data through a visualization arrangement method; the data structure conversion operator is specifically to convert the one-dimensional / multi-dimensional array structure into linear data through a visualization arrangement method. In addition to these five modules, the system 100 further includes a display module 107, which is used to connect the visualization large-screen chart to the data interface service and display the converted data chart.

[0058] Furthermore, the specific steps of the visual orchestration method in the operator orchestration module 103 include: adding and modifying the parameters of the data interface service; writing a data structure conversion script; and debugging using the data output by the data structure conversion script until the correctness of the script is verified.

[0059] Furthermore, the system 100 also includes a data source acquisition module 106 for configuring database connection and permissions, and configuring the database language, and writing the database language into the data interface service.

[0060] In addition, the system 100 may also include other components, which are not related to the content of the embodiment of the present disclosure and are therefore omitted from illustration and description.

[0061] The specific working process of the multi-data structure automatic conversion system 100 for large-screen chart adaptation is described in the above-mentioned multi-data structure automatic conversion method for large-screen chart adaptation, which will not be repeated here.

[0062] The system of the embodiment of the present invention can also be used byFigure 4 It is implemented according to the architecture of the computer terminal shown, including: a processor; and a memory. Among them, a computer-executable program is stored in the memory. When the computer-executable program is executed by the processor, the above-mentioned automatic conversion method of the multi-element data structure for large-screen chart adaptation is executed. Figure 4 The architecture of the computer terminal is shown. As Figure 4 shown, it includes a computer system 201, a system bus 203, one or more CPUs 204, an input / output component 202, a memory 205, etc. The memory 205 can store various data or files used for computer processing and / or communication and program instructions executed by the CPU. Figure 4 The architecture shown is only exemplary. When implementing different devices, adjust one or more components in Figure 4 according to actual needs.

[0063] Embodiments of the present invention can also be implemented as a computer-readable storage medium. A computer-readable instruction is stored on the computer-readable storage medium according to the embodiment. When the computer-readable instruction runs on the processor, the automatic conversion method of the multi-element data structure for large-screen chart adaptation according to the embodiment of the present invention described with reference to the above drawings can be executed.

[0064] In summary, a method, system, and computer storage medium for automatic conversion of a multi-element data structure for large-screen chart adaptation provided by the present invention realize the whole-process visualization, configurability, and convertible structure of the docking interface during the large-screen configuration process. Without the need for backend service personnel to intervene in programming, large-screen configuration personnel can complete it by themselves. The interface after being converted by the present invention can perfectly conform to the line chart, bar chart, pie chart, radar chart, etc. of the large-screen configuration, and can also adapt to other data structures of the large-screen configuration, such as tables, data indicators, etc., and can also adapt to the map layer data structure of the large-screen map layer configuration, so that the interface data can be perfectly displayed on the map through the layer. During the large-screen configuration process, only one person is needed to complete it, reducing the communication cost of large-screen configuration and increasing the efficiency of large-screen configuration. The ultimate beneficial effect achieved: By arranging visual large-screen data chart structure adaptation operators, the visibility and efficiency of the large-screen data chart structure adaptation process are increased. When the configuration personnel configure the large-screen visualization system, no other personnel are required to cooperate, nor is it necessary to write complex codes. Therefore, it can improve the efficiency of the configuration personnel, enable them to be more focused on the configuration of the large-screen visualization system without being disturbed by other factors, and also increase the maintainability of the system in the later stage.

[0065] In this article, the term "including", "comprising", or any other variant thereof is intended to cover non-exclusive inclusion, so that a step, method, or series of elements including a series of elements not only includes those elements, but also includes other elements not explicitly listed, or also includes elements inherent to such a step, method.

[0066] The above content is a further detailed description of the present invention in combination with specific preferred embodiments. It cannot be determined that the specific implementation of the present invention is only limited to these descriptions. For those of ordinary skill in the technical field to which the present invention pertains, without departing from the concept of the present invention, several simple deductions or substitutions can be made, and all should be regarded as falling within the protection scope of the present invention.

Claims

1. An automatic conversion method for multi - element data structures for large - screen chart adaptation, characterized in that, the method comprises the following steps: Configure the visual large - screen chart, and use the visual large - screen to configure the attributes and categories of the chart; Configure the data interface service, including configuring the type of data conversion and the data conversion process; Connect the data row - column conversion operator and the data structure conversion operator into the data conversion process; Start the data interface service to obtain the converted data; Use the converted data to test the data interface service until the verification result is correct; Among them, the data row - column conversion operator specifically converts a one - dimensional / multi - dimensional array row - column into linear data through a visual arrangement method; the data structure conversion operator specifically converts a one - dimensional / multi - dimensional array structure into linear data through a visual arrangement method; The row - column conversion is to convert the data structure {key: value} into the structure {name: key, code: value}, which is used to extract the key and value in the Json structure and apply them to the chart; The structure conversion is to convert the data structure [{key1: value1, key2: value2}, {key1: value11, key2: value22}] into the structure {key: [value1, value11], code: [value2, value22]}, which is used to extract the value in the Json structure and apply it to the chart.

2. The automatic conversion method for multi - element data structures for large - screen chart adaptation according to claim 1, characterized in that, The specific steps of the visual arrangement method include: Add and modify the parameters of the data interface service; Write a data structure conversion script; Use the data output by the data structure conversion script for debugging until the correctness of the script is verified.

3. The automatic conversion method for multi - element data structures for large - screen chart adaptation according to claim 1, characterized in that, The method further includes connecting the visual large - screen chart to the data interface service and displaying the converted data chart.

4. The automatic conversion method for multi - element data structures for large - screen chart adaptation according to claim 1, characterized in that, The method further includes configuring the database connection and permissions, as well as configuring the database language, and writing the database language into the data interface service.

5. An automatic conversion system for multi - element data structures for large - screen chart adaptation, characterized in that, it includes: A visual large - screen chart configuration module for using the visual large - screen to configure the attributes and categories of the chart; A data interface service configuration module for configuring the type of data conversion and the data conversion process; An operator arrangement module for connecting the data row - column conversion operator and the data structure conversion operator into the data conversion process; A data conversion module for starting the data interface service to obtain the converted data; A testing module for using the converted data to test the data interface service until the verification result is correct; Among them, the data row-column conversion operator in the operator scheduling module specifically converts the one-dimensional / multi-dimensional array row-column into linear data through a visual scheduling method; the data structure conversion operator specifically converts the one-dimensional / multi-dimensional array structure into linear data through a visual scheduling method; Row-column conversion is to convert the data structure {key: value} into the structure {name: key, code: value}, which is used to extract the key and value in the Json structure and apply them to the chart; Structure conversion is to convert the data structure [{key1: value1, key2: value2}, {key1: value11, key2: value22}] into the structure {key: [value1, value11], code: [value2, value22]}, which is used to extract the value in the Json structure and apply it to the chart.

6. The multi-data-structure automatic conversion system for large-screen chart adaptation according to claim 5, characterized in that, The specific steps of the visual scheduling method in the operator scheduling module include: Adding and modifying the parameters of the data interface service; Writing a data structure conversion script; Using the data output by the data structure conversion script for debugging until the correctness of the script is verified.

7. The multi-data-structure automatic conversion system for large-screen chart adaptation according to claim 5, characterized in that, The system further includes a display module, which is used to connect the visual large-screen chart to the data interface service and display the converted data chart.

8. The multi-data-structure automatic conversion system for large-screen chart adaptation according to claim 5, characterized in that, The system further includes a data source acquisition module, which is used to configure the database connection and permissions, as well as configure the database language, and write the database language into the data interface service.

9. A terminal, characterized in that, comprising: a processor; and a memory, wherein the memory stores a computer-executable program, and when the computer-executable program is executed by the processor, the method described in any one of claims 1-4 is executed.

10. A computer-readable storage medium, on which instructions are stored, characterized in that, when the instructions are executed by the processor, the processor is caused to execute the method described in any one of claims 1-4.

Images