+

CN114064772B - Multi-dimensional data structure automatic conversion method and system for large-screen chart adaptation - Google Patents

Multi-dimensional data structure automatic conversion method and system for large-screen chart adaptation Download PDF

Info

Publication number
CN114064772B
CN114064772B CN202111352117.2A CN202111352117A CN114064772B CN 114064772 B CN114064772 B CN 114064772B CN 202111352117 A CN202111352117 A CN 202111352117A CN 114064772 B CN114064772 B CN 114064772B
Authority
CN
China
Prior art keywords
data
conversion
chart
screen
data structure
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202111352117.2A
Other languages
Chinese (zh)
Other versions
CN114064772A (en
Inventor
庄建新
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Aerospace Smart City System Technology Co ltd
Original Assignee
Shenzhen Aerospace Smart City System Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shenzhen Aerospace Smart City System Technology Co ltd filed Critical Shenzhen Aerospace Smart City System Technology Co ltd
Priority to CN202111352117.2A priority Critical patent/CN114064772B/en
Publication of CN114064772A publication Critical patent/CN114064772A/en
Application granted granted Critical
Publication of CN114064772B publication Critical patent/CN114064772B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/451Execution arrangements for user interfaces

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Software Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Human Computer Interaction (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

本发明公开了一种用于大屏图表适配的多元数据结构自动转化方法及系统,该方法包括:配置可视化大屏图表,利用可视化大屏配置图表的属性和类别;配置数据接口服务,包括配置数据转换的类型和数据转换流程;将数据行列转换算子和数据结构转换算子接入数据转换流程中;启动数据接口服务,得到转换后的数据;利用转换后的数据对数据接口服务进行测试,直至验证结果的正确;其中,数据行列转换算子具体为通过可视化编排方法将一维/多维数组行列转换为线性数据;数据结构转换算子具体为通过可视化编排方法将一维/多维数组结构转换为线性数据。本发明能够降低大屏数据图表配置过程适配的成本,提高了大屏数据图表配置过程适配的效率。

The present invention discloses a multi-dimensional data structure automatic conversion method and system for large-screen chart adaptation, the method comprising: configuring a visualized large-screen chart, using the visualized 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 to 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 result is verified to be correct; wherein the data row-column conversion operator is specifically for converting one-dimensional/multi-dimensional array rows and columns into linear data through a visualized arrangement method; and the data structure conversion operator is specifically for converting one-dimensional/multi-dimensional array structures into linear data through a visualized arrangement method. The present invention can reduce the cost of large-screen data chart configuration process adaptation and improve the efficiency of large-screen data chart configuration process adaptation.

Description

Automatic conversion method and system for multi-metadata structure for large screen chart adaptation
Technical Field
The application relates to the field of data structure conversion, in particular to a method and a system for automatically converting a multi-metadata structure for large-screen chart adaptation.
Background
In recent years, large screen visual configuration technology has rapidly developed. In the traditional large screen configuration process, a rear-end service interface needs to be docked, and in the docking process, the rear-end service interface needs to be matched with a large screen visual chart plug-in. The back-end service needs to carry out a large amount of adaptation programming in the adaptation process, so that the workload of back-end service coding is increased to a certain extent, the working efficiency is reduced, and the working cost of large-screen configuration is increased.
In order to configure a large screen visual chart so that the chart can be normally displayed on a large screen, the data returned by the data interface for the large screen chart docking must conform to the data structure identifiable by the large screen chart. The data structure of the large screen chart is different from the interface data structure of the traditional data interface which is queried and returned from the database. Therefore, the interface data which is inquired and returned from the database cannot be directly used for the configuration of the large-screen chart, and the interface data can be suitable for the configuration of the large-screen chart only by certain data structure conversion.
Interface data returned from the database is subjected to data structure conversion to adapt to the data structure of the large-screen chart configuration. In order to solve the problem of data conversion, two general methods are used, namely, front-end modification, wherein data returned from an interface is obtained and accords with a chart structure, and back-end modification, wherein the data returned from a database is directly converted into a data structure which can be identified by a large-screen chart. While large screen configuration technology is now largely commercialized. The method modified from the front end is very costly and cannot be adapted to the idea of productization. Because the interface data returned by the back-end service has no very fixed format, the variation is relatively large, and the front-end cannot be completely adapted. Then only the back-end modification, i.e. the data service interface end of the large screen diagram docking, can be modified.
Back-end modification there are two approaches specifically. The method is characterized in that the method comprises the steps of modifying back-end codes, writing a unified method which can adapt to various charts, and converting data by the unified method. For example, the interface docking chart is a radar chart, namely before the interface returns data, the data structure of the returned data is converted by a radar chart data structure method, the data is returned to the large screen chart after conversion, the method needs to adapt each returned data, and later, if the data needs to be modified, new codes need to be re-adapted and added, so that the data structure adapting efficiency is reduced, the later maintenance cost is greatly increased, the popularization and the use are not facilitated, and secondly, the micro service docking is realized, namely, the data of all the large screen charts are firstly subjected to micro service docking, the micro service is subjected to uniform data structure conversion, and the large screen charts are uniformly docked with the interface after micro service conversion. In short, the interface to be docked of the original large screen is converted by the micro service conversion interface to generate a new interface, and the large screen chart is docked with the new interface. The method is that the structure conversion is carried out after the returned data is obtained through the request source interface, and a large screen is required to be configured with a plurality of charts. Overall, both of the above methods are costly and inefficient in project implementation.
Disclosure of Invention
Aiming at the problems, the invention provides a multi-metadata structure automatic conversion method and a multi-metadata structure automatic conversion system for large-screen chart adaptation, which are used for realizing the online visualization of the whole process of the large-screen data chart structure adaptation by arranging a visual service arranging method, an online operator arranging method, an online service debugging method and an online service testing method. The cost of the adaptation structure of the large-screen data chart configuration process is reduced, and the efficiency of the adaptation structure of the large-screen data chart configuration process is improved.
In a first aspect of the present invention, there is provided a method for automatically transforming a multi-metadata structure for large screen diagram adaptation, the method comprising the steps of:
Configuring a visual large screen chart, and configuring the attribute and the category of the chart by utilizing the visual large screen;
Configuring data interface service, including configuring data conversion type and data conversion flow;
The data line-column conversion operator and the data structure conversion operator are connected into a data conversion flow;
starting a data interface service to obtain converted data;
testing the data interface service by using the converted data until the verification result is correct;
The data line-row conversion operator specifically converts a one-dimensional/multi-dimensional array line 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.
Further, the visual arrangement method specifically comprises the following steps:
Adding and modifying parameters of the data interface service;
writing a data structure conversion script;
and converting the data output by the script by using the data structure to adjust until the correctness of the script is verified.
Furthermore, the method also comprises the step of accessing the visualized large screen chart into a data interface service and displaying the converted data chart.
Further, the method also includes configuring the database connection and permissions, and configuring the database language, writing the database language into the data interface service.
In a second aspect of the present invention, there is provided an automatic multi-data structure conversion system for large screen diagram adaptation, comprising:
the visual large screen chart configuration module is used for configuring the attribute and the category of the chart by utilizing the visual large screen;
The data interface service configuration module is used for configuring the type and the flow of data conversion;
the operator arranging module is used for connecting the data rank conversion operator and the data structure conversion operator into the data conversion flow;
The data conversion module is used for starting the data interface service to obtain converted data;
The test module is used for testing the data interface service by using the converted data until the verification result is correct;
The operator arrangement module is used for arranging the data line and row conversion operators in the operator arrangement module, wherein the operator arrangement module is used for converting the one-dimensional/multi-dimensional array line and row 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.
Further, the visual arrangement method in the operator arrangement module specifically includes the steps of:
Adding and modifying parameters of the data interface service;
writing a data structure conversion script;
and converting the data output by the script by using the data structure to adjust until the correctness of the script is verified.
Further, the system also comprises a display module for accessing the visual large screen chart into the data interface service and displaying the converted data chart.
Further, the system also comprises a data source acquisition module for configuring database connection and authority and configuring database language, and writing the database language into the data interface service.
In a third aspect of the present invention, a terminal is provided, comprising a processor, and a memory, wherein the memory stores a computer executable program, which when executed by the processor, performs the above-described method for automatically transforming a multi-data structure for large screen diagram adaptation.
In a fourth aspect of the present invention, a computer readable storage medium is provided, on which instructions are stored, which instructions, when executed by a processor, cause the processor to perform the above-described method of automatically transforming a multi-data structure for large screen diagram adaptation.
The method, the system and the computer storage medium for automatically converting the multi-metadata structure for adapting the large screen chart realize the whole-course visualization, the configurability and the conversion structure of the interface in the large screen configuration process, the large screen configuration personnel can finish the process by themselves without programming intervention of the rear end service personnel, the interface converted by the invention can perfectly conform to a line graph, a column graph, a pie graph, a radar graph and the like of the large screen configuration, can also adapt to other data structures of the large screen configuration, such as a table, a data index and the like, and can also adapt to the map layer data structure of the map layer configuration of the large screen map, so that interface data can be displayed on a map through the map layer perfectly. In the large screen configuration process, only one person is needed to complete the large screen configuration, so that the communication cost of the large screen configuration is reduced, and the efficiency of the large screen configuration is increased. The method has the beneficial effects that the visibility and efficiency of the large-screen data chart structure adapting process are improved by arranging the visualized large-screen data chart structure adapting operator. When a configurator configures the large-screen visual system, other personnel are not required to cooperate, and complex codes are not required to be written. Therefore, the efficiency of configuration personnel can be improved, the configuration personnel can be more focused on the configuration of the large-screen visual system, the configuration is not interfered by other factors, and the later maintenance of the system is improved.
Drawings
FIG. 1 is a flowchart of a method for automatically transforming a multi-metadata structure for large screen diagram adaptation in an embodiment of the present invention;
FIG. 2 is a flow chart of a method of visually orchestrating according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of an automatic transformation system for a multi-metadata structure for large-screen diagram adaptation in an embodiment of the present invention;
Fig. 4 is a schematic diagram of an architecture of a computer terminal in an embodiment of the present invention.
Detailed Description
In order to further describe the technical scheme of the invention in detail, the embodiment is implemented on the premise of the technical scheme of the invention, and detailed implementation modes and specific steps are given.
The invention discloses a multi-data structure automatic conversion method for large-screen chart adaptation, which is shown in fig. 1, and comprises the following steps:
S01, configuring a visual large screen chart, and configuring attributes and categories of the chart by utilizing the visual large screen, wherein the chart attributes comprise colors, widths, heights and the like, and the chart categories comprise pie charts, bar charts and the like;
S02, configuring data interface service, including the type of configuration data conversion and the data conversion flow, specifically creating data conversion service, including the type of configuration data service including but not limited to GET, POST, PUT, DELETE, the flow of arranging data service, etc., arranging data service flow including but not limited to selecting a starting node, obtaining a data source, selecting a conversion operator, and then debugging;
S03, accessing a data line-column conversion operator and a data structure conversion operator into a data conversion flow;
The data structure conversion operator comprises a one-dimensional array structure conversion operator and a multi-dimensional array structure conversion operator, and particularly converts a one-dimensional/multi-dimensional array structure into linear data through a visual arrangement method. The one-dimensional array structure represents that only one group of data is in the target data structure, the one-dimensional array structure is represented by a one-dimensional line graph, a single column bar graph and the like on the display form of the chart, the multi-dimensional array structure represents that the target data structure contains 2 groups of data and more than 2 groups of data, the multi-series bar graph, the radar graph and the like on the display form of the chart, operators are services which are arranged through a visual arrangement method and serve as circulation methods in service visualization, and the operators are equivalent to a ring in a transfer flow, namely, the arranged operators are introduced in the process of configuring a data interface service, for example, the one-dimensional array line-column conversion operators are arranged into the data service flow.
Preferably, the line-column conversion is to convert the { key: value } structure into a { name: key, code: value } structure. The method is mainly applicable to the situation that both keys and values in the Json structure are taken out to be applied to the graph.
The structure conversion is to convert the [ { key1: value1, key2: value2}, { key1: value11, key2: value22} ] structure into { key: [ value1, value11], code: [ value2, value22] } structure. The method is mainly applicable to the situation that only the value in the Json structure is taken out to be applied to the chart.
Further, the visual arrangement method is shown in fig. 2, and the specific steps include:
s031, adding and modifying parameters of the data interface service;
s032, writing a data structure conversion script;
S033, converting the data output by the script by using the data structure to adjust until the correctness of the script is verified.
In the specific implementation process, parameters of the data interface service, such as CHARTNAME, CHARTTPYE, KEYFIELD, VALUEFIELD, are set and added, modified, a structured script is written, the structured script is put into an operator flow, output is set, failure output and success output of structure conversion are set, debugging, namely operator correctness is verified, and operators are introduced for verification and debugging.
S04, starting a data interface service to obtain converted data, namely, operating the well-arranged data service flow to enable the data conversion service to obtain the data;
s05, testing the data interface service by using the converted data until the verification result is correct, specifically, continuously debugging the data interface service until the displayed data result is correct, and further debugging is needed when the result display includes no display result;
Furthermore, the method also comprises the step of accessing the visualized large screen chart into a data interface service and displaying the converted data chart.
Further, the method further comprises configuring database connection and authority, configuring a database language, writing the database language into the data interface service, specifically configuring a data source, namely creating the data source, configuring a database link, a user name and a password of the data source, configuring and testing a database to be connected, and modifying and retesting configured database resources, wherein the database language comprises database query sentences.
The following describes a multi-metadata structure automatic conversion system for large-screen chart adaptation corresponding to the method shown in fig. 1 according to an embodiment of the present disclosure with reference to fig. 3, where the system 100 includes a visual large-screen chart configuration module 101 configured to configure attributes and categories of a chart by using a visual large-screen, a data interface service configuration module 102 configured to configure types and data conversion processes of data conversion, an operator arrangement module 103 configured to access a data line conversion operator and a data structure conversion operator into the data conversion processes, a data conversion module 104 configured to start a data interface service to obtain converted data, and a test module 105 configured to test the data interface service by using the converted data until a verification result is correct, where the data line conversion operator in the operator arrangement module 103 specifically converts a one-dimensional/multi-dimensional array into linear data by a visual arrangement method, and the data structure conversion operator specifically converts the one-dimensional/multi-dimensional array structure into linear data by a visual arrangement method. In addition to these 5 modules, the system 100 further includes a display module 107 for accessing the visual large screen chart to a data interface service and displaying the converted data chart.
Further, the visual arrangement method in the operator arrangement module 103 specifically includes the steps of adding and modifying parameters of the data interface service, writing a data structure conversion script, and adjusting by using data output by the data structure conversion script until correctness of the script is verified.
Further, the system 100 also includes a data source acquisition module 106 for configuring database connections and permissions, and configuring a database language, writing the database language into the data interface service.
In addition, the system 100 may include other components, which are not illustrated and described herein, as they are not relevant to the context of the disclosed embodiments.
The specific working process of the automatic multi-data structure conversion system 100 for large-screen chart adaptation refers to the description of the automatic multi-data structure conversion method for large-screen chart adaptation, and is not repeated.
The system of the embodiment of the invention can also be realized by means of the architecture of the computer terminal shown in fig. 4, and comprises a processor and a memory, wherein the memory stores a computer executable program, and when the processor executes the computer executable program, the automatic transformation method of the multi-data structure for large-screen chart adaptation is executed. Fig. 4 shows the architecture of the computer terminal. As shown in fig. 4, includes a computer system 201, a system bus 203, one or more CPUs 204, input/output components 202, memory 205, and the like. The memory 205 may store various data or files used for computer processing and/or communication and program instructions executed by the CPU. The architecture shown in fig. 4 is merely exemplary, and one or more of the components in fig. 4 may be adapted as needed to implement different devices.
Embodiments of the present invention may also be implemented as a computer-readable storage medium. The computer-readable storage medium according to an embodiment has computer-readable instructions stored thereon. The method for automatically transforming a multi-data structure for large screen diagram adaptation according to an embodiment of the present invention described with reference to the above drawings may be performed when the computer readable instructions are executed by a processor.
In summary, the method, the system and the computer storage medium for automatically converting the multi-metadata structure for large-screen chart adaptation realize the whole-course visualization, the configurability and the convertible structure of the interface in the large-screen configuration process, the large-screen configuration personnel can finish the process by themselves without programming intervention of the rear-end service personnel, the interface converted by the invention can perfectly conform to a line graph, a column graph, a pie graph, a radar graph and the like of the large-screen configuration, can also adapt to other data structures of the large-screen configuration, such as a table, a data index and the like, and can also adapt to a map layer data structure of the large-screen map layer configuration, so that interface data can be perfectly displayed on a map through a map layer. In the large screen configuration process, only one person is needed to complete the large screen configuration, so that the communication cost of the large screen configuration is reduced, and the efficiency of the large screen configuration is increased. The method has the beneficial effects that the visibility and efficiency of the large-screen data chart structure adapting process are improved by arranging the visualized large-screen data chart structure adapting operator. When a configurator configures the large-screen visual system, other personnel are not required to cooperate, and complex codes are not required to be written. Therefore, the efficiency of configuration personnel can be improved, the configuration personnel can be more focused on the configuration of the large-screen visual system, the configuration is not interfered by other factors, and the later maintenance of the system is improved.
In this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, or apparatus.
The foregoing is a further detailed description of the invention in connection with the preferred embodiments, and it is not intended that the invention be limited to the specific embodiments described. It will be apparent to those skilled in the art that several simple deductions or substitutions may be made without departing from the spirit of the invention, and these should be considered to be within the scope of the invention.

Claims (10)

1.一种用于大屏图表适配的多元数据结构自动转化方法,其特征在于,所述方法包括如下步骤:1. A method for automatically converting a multi-data structure for large-screen chart adaptation, characterized in that the method comprises the following steps: 配置可视化大屏图表,利用可视化大屏配置图表的属性和类别;Configure visualization charts and use the visualization chart to configure the properties and categories of the charts; 配置数据接口服务,包括配置数据转换的类型和数据转换流程;Configure data interface services, including configuring data conversion types and data conversion processes; 将数据行列转换算子和数据结构转换算子接入数据转换流程中;Integrate 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 results are verified to be correct; 其中,数据行列转换算子具体为通过可视化编排方法将一维/多维数组行列转换为线性数据;数据结构转换算子具体为通过可视化编排方法将一维/多维数组结构转换为线性数据;Among them, the data row and column conversion operator specifically converts the one-dimensional/multi-dimensional array rows and columns into linear data through a visual arrangement method; the data structure conversion operator specifically converts the one-dimensional/multi-dimensional array structure into linear data through a visual arrangement method; 行列转换是将数据结构{key:value}转化为结构{name:key,code:value},用于将Json结构中的key和value取出并应用于图表中;Row-column conversion converts 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; 结构转换是将数据结构[{key1:value1,key2:value2},{key1:value11,key2:value22}]转化为结构{key:[value1,value11],code:[value2,value22]},用于将Json结构中的value值取出并应用在图表中。Structural conversion converts 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.根据权利要求1所述的用于大屏图表适配的多元数据结构自动转化方法,其特征在于,可视化编排方法具体步骤包括:2. The method for automatically converting multi-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 parameters of data interface services; 编写数据结构转化脚本;Write data structure conversion scripts; 利用数据结构转化脚本输出的数据进行调式,直至验证脚本的正确性。Use the data structure to convert the output of the script for debugging until the correctness of the script is verified. 3.根据权利要求1所述的用于大屏图表适配的多元数据结构自动转化方法,其特征在于,方法还包括将可视化大屏图表接入数据接口服务,将转换好的数据图表展示出来。3. According to the method for automatic conversion of multi-data structure for large-screen chart adaptation described in claim 1, it is characterized in that the method also includes connecting the visualized large-screen chart to the data interface service and displaying the converted data chart. 4.根据权利要求1所述的用于大屏图表适配的多元数据结构自动转化方法,其特征在于,方法还包括配置数据库连接和权限,以及配置数据库语言,将数据库语言写入数据接口服务中。4. The method for automatic conversion of multi-data structure for large-screen chart adaptation according to claim 1 is characterized in that the method also includes configuring database connection and permissions, and configuring database language, and writing the database language into the data interface service. 5.一种用于大屏图表适配的多元数据结构自动转化系统,其特征在于,包括:5. A multi-data structure automatic conversion system for large-screen chart adaptation, characterized by comprising: 可视化大屏图表配置模块,用于利用可视化大屏配置图表的属性和类别;Visual large screen chart configuration module, used to configure the properties and categories of charts using the visual large screen; 数据接口服务配置模块,用于配置数据转换的类型和数据转换流程;Data interface service configuration module, used to configure the type and process of data conversion; 算子编排模块,用于将数据行列转换算子和数据结构转换算子接入数据转换流程中;Operator orchestration module, used to connect data row and column conversion operators and data structure conversion operators into the data conversion process; 数据转换模块,用于启动数据接口服务,得到转换后的数据;The data conversion module is used to start the data interface service and obtain the converted data; 测试模块,用于利用转换后的数据对数据接口服务进行测试,直至验证结果的正确;The test module is used to test the data interface service using the converted data until the correctness of the result is verified; 其中,算子编排模块中的数据行列转换算子具体为通过可视化编排方法将一维/多维数组行列转换为线性数据;数据结构转换算子具体为通过可视化编排方法将一维/多维数组结构转换为线性数据;Among them, the data row and column conversion operator in the operator arrangement module specifically converts the one-dimensional/multi-dimensional array rows and columns into linear data through a visual arrangement method; the data structure conversion operator specifically converts the one-dimensional/multi-dimensional array structure into linear data through a visual arrangement method; 行列转换是将数据结构{key:value}转化为结构{name:key,code:value},用于将Json结构中的key和value取出并应用于图表中;Row-column conversion converts 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; 结构转换是将数据结构[{key1:value1,key2:value2},{key1:value11,key2:value22}]转化为结构{key:[value1,value11],code:[value2,value22]},用于将Json结构中的value值取出并应用在图表中。Structural conversion converts 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.根据权利要求5所述的用于大屏图表适配的多元数据结构自动转化系统,其特征在于,算子编排模块中的可视化编排方法具体步骤包括:6. The multi-data structure automatic conversion system for large-screen chart adaptation according to claim 5 is characterized in that the specific steps of the visual arrangement method in the operator arrangement module include: 添加、修改数据接口服务的参数;Add and modify parameters of data interface services; 编写数据结构转化脚本;Write data structure conversion scripts; 利用数据结构转化脚本输出的数据进行调式,直至验证脚本的正确性。Use the data structure to convert the output of the script for debugging until the correctness of the script is verified. 7.根据权利要求5所述的用于大屏图表适配的多元数据结构自动转化系统,其特征在于,系统还包括显示模块,用于将可视化大屏图表接入数据接口服务,将转换好的数据图表展示出来。7. According to the multi-data structure automatic conversion system for large-screen chart adaptation described in claim 5, it is characterized in that the system also includes a display module for connecting the visualized large-screen chart to the data interface service and displaying the converted data chart. 8.根据权利要求5所述的用于大屏图表适配的多元数据结构自动转化系统,其特征在于,系统还包括数据源获取模块,用于配置数据库连接和权限,以及配置数据库语言,将数据库语言写入数据接口服务中。8. According to claim 5, the multi-data structure automatic conversion system for large-screen chart adaptation is characterized in that the system also includes a data source acquisition module for configuring database connections and permissions, and configuring database languages, and writing database languages into data interface services. 9.一种终端,其特征在于,包括:处理器;以及存储器,其中,所述存储器中存储有计算机可执行程序,当由所述处理器执行所述计算机可执行程序时,执行权利要求1-4中任一项所述的方法。9. A terminal, characterized in that it comprises: 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 method according to any one of claims 1 to 4 is executed. 10.一种计算机可读存储介质,其上存储有指令,其特征在于,所述指令在被处理器执行时,使得所述处理器执行如权利要求1-4中任一项所述的方法。10. A computer-readable storage medium having instructions stored thereon, wherein when the instructions are executed by a processor, the processor is caused to execute the method according to any one of claims 1 to 4.
CN202111352117.2A 2021-11-16 2021-11-16 Multi-dimensional data structure automatic conversion method and system for large-screen chart adaptation Active CN114064772B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111352117.2A CN114064772B (en) 2021-11-16 2021-11-16 Multi-dimensional data structure automatic conversion method and system for large-screen chart adaptation

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111352117.2A CN114064772B (en) 2021-11-16 2021-11-16 Multi-dimensional data structure automatic conversion method and system for large-screen chart adaptation

Publications (2)

Publication Number Publication Date
CN114064772A CN114064772A (en) 2022-02-18
CN114064772B true CN114064772B (en) 2025-05-30

Family

ID=80272584

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111352117.2A Active CN114064772B (en) 2021-11-16 2021-11-16 Multi-dimensional data structure automatic conversion method and system for large-screen chart adaptation

Country Status (1)

Country Link
CN (1) CN114064772B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115048096B (en) * 2022-08-15 2022-11-04 广东工业大学 A method and system for dynamic visualization of data structure

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109597613A (en) * 2017-12-21 2019-04-09 南京数睿数据科技有限公司 A kind of big screen display system and method for towed combination report
CN113536748A (en) * 2020-04-15 2021-10-22 北京沃东天骏信息技术有限公司 Method and device for generating chart data

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9299173B2 (en) * 2011-06-07 2016-03-29 International Business Machines Corporation Automatic selection of different visualizations for the organization of multivariate data
KR101494844B1 (en) * 2014-08-28 2015-02-25 그린캣소프트(주) System for Transforming Chart Using Metadata and Method thereof
CN106708860A (en) * 2015-11-13 2017-05-24 阿里巴巴集团控股有限公司 Chart processing method and system
KR101798149B1 (en) * 2017-04-17 2017-11-16 주식회사 뉴스젤리 Chart visualization method by selecting some areas of the data table
CN110019189A (en) * 2017-09-18 2019-07-16 飞狐信息技术(天津)有限公司 A kind of generation method and generation system of chart
US20190171648A1 (en) * 2017-12-01 2019-06-06 Jpmorgan Chase Bank, N.A. System and method for implementing an extract transform and load (etl) migration tool
AU2020100703A4 (en) * 2020-05-05 2020-06-11 Li, Xiaolan Miss A method of spatial accessibility evaluation of urban facility services based on GIS
CN113360559A (en) * 2021-06-04 2021-09-07 武汉一格空间科技有限公司 Configurable one-stop large-screen visualization method and device

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109597613A (en) * 2017-12-21 2019-04-09 南京数睿数据科技有限公司 A kind of big screen display system and method for towed combination report
CN113536748A (en) * 2020-04-15 2021-10-22 北京沃东天骏信息技术有限公司 Method and device for generating chart data

Also Published As

Publication number Publication date
CN114064772A (en) 2022-02-18

Similar Documents

Publication Publication Date Title
CN112163025B (en) Database data export method and device, computer equipment and storage medium
CN110399294A (en) Method for generating test case, device, computer equipment and storage medium
CN105808437A (en) Automation testing method and system based on test case data table
CN106503268B (en) Data comparison methods, devices and systems
CN110109981B (en) Information display method and device for work queue, computer equipment and storage medium
CN111190587A (en) Method and system for automatically generating engineering front-end code based on JDBC
CN112487112B (en) A method, device, computer equipment and storage medium for component linkage configuration
CN107480262A (en) A kind of general management system of database based on webpage
CN104102511A (en) SQL (structured query language) Server based automatic script upgrading system and method
CN114064772B (en) Multi-dimensional data structure automatic conversion method and system for large-screen chart adaptation
CN114742014B (en) Few-shot text style transfer method based on correlation attention
CN111596899A (en) Database migration method, system, equipment and storage medium based on Java development
CN113297251A (en) Multi-source data retrieval method, device, equipment and storage medium
CN110717315B (en) System data batch modification method and device, storage medium and electronic equipment
US20240097934A1 (en) Vehicle bus topological graph display method and apparatus, and device
US20040249849A1 (en) Conversion system
CN114566212A (en) Method and device for carrying Hi-C genome larger than 10G
CN112328231A (en) Quick conversion method between python dictionary and structure
US20240403051A1 (en) Instruction Parsing Method and Apparatus, and Electronic Device
CN117389986A (en) Database compatibility assessment method, device, electronic equipment and storage medium
CN110851446B (en) Data table generation method and device, computer equipment and storage medium
CN101382891A (en) Statistical method and apparatus for constructing log output every day
CN115687356A (en) Method and system for realizing data verification in automatic test clinical trial
CN115525321A (en) Distributed task generation method, device, equipment and storage medium
CN111290745A (en) Device and method for realizing general data export

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
EE01 Entry into force of recordation of patent licensing contract
EE01 Entry into force of recordation of patent licensing contract

Application publication date: 20220218

Assignee: Beijing Ji Aerospace Intelligent Technology Co.,Ltd.

Assignor: SHENZHEN AEROSPACE SMART CITY SYSTEM TECHNOLOGY CO.,LTD.

Contract record no.: X2025980011688

Denomination of invention: Method and system for automatic conversion of multi-dimensional data structures for large screen chart adaptation

Granted publication date: 20250530

License type: Common License

Record date: 20250702

点击 这是indexloc提供的php浏览器服务,不要输入任何密码和下载