Resource data processing method and device, computer device and storage medium
By acquiring data retrieval information and adjusting resource data types using data visualization templates, and generating data display page elements, the problem of low efficiency in resource data processing in traditional methods is solved, achieving low-cost and efficient resource data visualization.
Patent Information
- Application Number
- CN202211587317.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-12-09
- Publication Date
- 2026-02-10
- Estimated Expiration
- 2042-12-09
AI Technical Summary
Traditional methods require separate development of visualization processing for each business system, resulting in high development costs, high system coupling, high maintenance costs, high learning costs, and low efficiency in resource data processing.
By acquiring data call information from multiple data visualization tasks, raw resource data is retrieved from multiple business systems. Data types are adjusted using data visualization templates to generate data display page elements and display resource data visualization pages, thereby reducing repetitive maintenance and lowering system coupling.
It has enabled resource data visualization optimization, reduced development and maintenance costs, improved processing efficiency, and simplified the learning and usage process for business personnel.
Smart Images

Figure CN115857929B_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of computer technology, and in particular to a resource data processing method, apparatus, computer equipment, storage medium, and computer program product. Background Technology
[0002] As the types of business data related to resources gradually increase, data visualization can be used as a way to present business systems. Traditional methods require processing data from each system separately, creating charts for each system individually, and then combining them into a view for display.
[0003] Faced with a large number of business systems, it is costly to develop customized visualizations for each system separately. The systems are relatively coupled, and the maintenance costs increase accordingly. Furthermore, since the operational logic developed for different systems is different, the learning and memorization costs for relevant personnel are high, resulting in low efficiency and poor results in resource data processing. Summary of the Invention
[0004] Therefore, it is necessary to provide a resource data processing method, apparatus, computer equipment, storage medium, and computer program product that can solve the above-mentioned technical problems.
[0005] In a first aspect, this application provides a resource data processing method, the method comprising:
[0006] Obtain data call information corresponding to each of the multiple data visualization tasks, and call the original resource data corresponding to each data visualization task from multiple business systems according to the data call information.
[0007] Obtain data visualization templates for the multiple data visualization tasks, and adjust the original resource data according to the target type set for each original resource data in the data visualization template to obtain the target resource data corresponding to each data visualization task;
[0008] Based on the target resource data corresponding to each of the data visualization tasks, data display page elements corresponding to each of the data visualization tasks are generated; the data display page elements are used to display statistical information corresponding to the target resource data.
[0009] Based on the data display page elements corresponding to each of the data visualization tasks, display the resource data visualization page.
[0010] In one embodiment, obtaining the data retrieval information corresponding to each of the multiple data visualization tasks includes:
[0011] In response to configuration operations on the task configuration page, the database connection information and data table storage information corresponding to each data visualization task are obtained as data retrieval information corresponding to each data visualization task.
[0012] In one embodiment, the step of retrieving the original resource data corresponding to each data visualization task from multiple business systems based on the data retrieval information includes:
[0013] Based on the database connection information provided, establish connection relationships with databases in multiple business systems;
[0014] Based on the information stored in each of the data tables, data is read from the databases of the multiple business systems to obtain the original resource data corresponding to each of the data visualization tasks.
[0015] In one embodiment, adjusting each of the original resource data according to the target type set for each of the original resource data in the data visualization template to obtain the target resource data corresponding to each of the data visualization tasks includes:
[0016] According to the target type set for each of the original resource data in the data visualization template, adjust the data type corresponding to each of the original resource data to obtain the adjusted resource data corresponding to each of the original resource data;
[0017] Based on the data parsing results corresponding to the adjusted resource data, the target resource data corresponding to each data visualization task is obtained.
[0018] In one embodiment, generating data display page elements corresponding to each data visualization task based on the target resource data corresponding to each data visualization task includes:
[0019] Determine the data visualization library corresponding to each of the aforementioned data visualization tasks;
[0020] Based on the data visualization library corresponding to each data visualization task and the target resource data, generate data display page elements corresponding to each data visualization task.
[0021] In one embodiment, generating data display page elements corresponding to each data visualization task based on the data visualization library corresponding to each data visualization task and the target resource data includes:
[0022] The target resource data corresponding to each data visualization task is assigned to the data visualization library corresponding to each data visualization task, thereby generating the data display page elements corresponding to each data visualization task.
[0023] In one embodiment, displaying the resource data visualization page according to the data display page elements corresponding to each of the data visualization tasks includes:
[0024] Obtain preset page information; the preset page information is used to characterize the area position corresponding to each display area in the preset page;
[0025] The data display page elements corresponding to each of the data visualization tasks are imported into the display areas of the preset page to obtain and display the resource data visualization page.
[0026] Secondly, this application also provides a resource data processing apparatus, the apparatus comprising:
[0027] The raw resource data acquisition module is used to acquire the data call information corresponding to each of the multiple data visualization tasks, and to call the raw resource data corresponding to each data visualization task from multiple business systems according to the data call information.
[0028] The resource data adjustment module is used to obtain data visualization templates for the multiple data visualization tasks, and adjust each of the original resource data according to the target type set for each of the original resource data in the data visualization templates to obtain the target resource data corresponding to each of the data visualization tasks.
[0029] The page element generation module is used to generate data display page elements corresponding to each data visualization task based on the target resource data corresponding to each data visualization task; the data display page elements are used to display statistical information corresponding to the target resource data.
[0030] The resource data page display module is used to display the resource data visualization page according to the data display page elements corresponding to each data visualization task.
[0031] Thirdly, this application also provides a computer device. The computer device includes a memory and a processor, the memory storing a computer program, and the processor executing the computer program to implement the steps of the resource data processing method described above.
[0032] Fourthly, this application also provides a computer-readable storage medium. The computer-readable storage medium stores a computer program thereon, which, when executed by a processor, implements the steps of the resource data processing method described above.
[0033] Fifthly, this application also provides a computer program product. The computer program product includes a computer program that, when executed by a processor, implements the steps of the resource data processing method described above.
[0034] The aforementioned resource data processing method, apparatus, computer equipment, storage medium, and computer program product acquire data call information corresponding to multiple data visualization tasks. Based on this information, they retrieve the original resource data corresponding to each data visualization task from multiple business systems, obtain data visualization templates for the multiple data visualization tasks, adjust the original resource data according to the target type set in the data visualization templates for each original resource data, and obtain the target resource data corresponding to each data visualization task. Then, based on the target resource data, they generate data display page elements corresponding to each data visualization task. These data display page elements are used to display statistical information corresponding to the target resource data. Finally, based on the data display page elements corresponding to each data visualization task, a resource data visualization page is displayed. This achieves optimization of resource data visualization, allowing the retrieval of original resource data and adjustments based on data visualization templates, and the display of resource data visualization pages based on the generated data display page elements. It eliminates the need for separate development for each business system, avoids repetitive maintenance, reduces system coupling, and improves resource data processing efficiency. Attached Figure Description
[0035] Figure 1 This is a flowchart illustrating a resource data processing method in one embodiment;
[0036] Figure 2a This is a schematic diagram of a resource data visualization processing flow in one embodiment;
[0037] Figure 2b This is a schematic diagram of a data adjustment process in one embodiment;
[0038] Figure 2c A schematic diagram of a data cockpit generated in one embodiment;
[0039] Figure 3 This is a schematic diagram of a data cockpit in one embodiment;
[0040] Figure 4 This is a flowchart illustrating another resource data processing method in one embodiment;
[0041] Figure 5 This is a structural block diagram of a resource data processing device in one embodiment;
[0042] Figure 6This is an internal structural diagram of a computer device in one embodiment. Detailed Implementation
[0043] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application.
[0044] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for display, data used for analysis, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties; correspondingly, this application also provides a corresponding user authorization entry point for users to choose to authorize or refuse.
[0045] In one embodiment, such as Figure 1 As shown, a resource data processing method is provided. This embodiment illustrates the method applied to a terminal, but it is understood that the method can also be applied to a server, and further to a system including both a terminal and a server, and implemented through interaction between the terminal and the server. In this embodiment, the method includes the following steps:
[0046] Step 101: Obtain the data call information corresponding to each of the multiple data visualization tasks, and call the original resource data corresponding to each data visualization task from multiple business systems according to the data call information.
[0047] As an example, resource data can be data on combined resources, such as asset custody portfolio data in financial institutions; data visualization tasks can be tasks that visualize different combined resources, such as rendering pie charts showing the purchase ratios of different portfolio funds. Different data visualization tasks can correspond to different visualization styles, such as different styles of data display charts, and other visualization display methods can also be used. No specific restrictions are imposed in this embodiment.
[0048] The data retrieval information may include database connection information and data table storage information. The database connection information can be used to connect to the database in the business system, and the data table storage information can be used to read data from the database to retrieve the original resource data.
[0049] In practical applications, for multiple configured data visualization tasks, the data call information corresponding to each data visualization task can be obtained. Then, based on the data call information, the original resource data corresponding to each data visualization task can be called from multiple business systems.
[0050] For example, taking the data visualization task of rendering a pie chart of the purchase ratio of different resource combinations as an example, by obtaining data call information, we can connect to the database in the business system according to the database connection information, and query the purchase quantity corresponding to each combination of resources from the database according to the data table storage information, as the original resource data.
[0051] In one example, such as Figure 2a As shown, users can configure multiple data visualization tasks by entering the task configuration page, such as the unified resource combination data cockpit generation tool interface. In response to the configuration operation on the task configuration page, the system can obtain the database connection information and data table storage information corresponding to each data visualization task, which can then be used as data retrieval information.
[0052] Step 102: Obtain data visualization templates for the multiple data visualization tasks; adjust the original resource data according to the target type set for each original resource data in the data visualization template to obtain the target resource data corresponding to each data visualization task.
[0053] In the specific implementation, for each data visualization task, after obtaining the original resource data, a pre-configured data visualization template can be obtained. This data visualization template can include the target type set for the original resource data, such as the data type corresponding to the field. Then, the original resource data can be adjusted according to the target type to obtain the target resource data.
[0054] In one example, such as Figure 2a As shown, the resource data processing method in this embodiment mainly involves two functional modules: a data standardization processing module and a unified data dashboard generation module. The data standardization processing module can process the original resource data to obtain standardized combined resource data. Then, the standardized combined resource data can be input into the unified data dashboard generation module to generate a unified combined resource data dashboard for data visualization based on the target resource data obtained from the standardized combined resource data.
[0055] In another example, although the table structures in the databases of different business systems differ, the key data metrics that each business system focuses on are essentially the same, and the content to be presented in the data dashboard is also universal, such as the unit net value and rate of return data corresponding to combined resources. Thus, through the data standardization process, data templates can be made for multiple business system databases, enabling the processed resource data to have the ability and foundation to automatically generate a data dashboard.
[0056] Step 103: Based on the target resource data corresponding to each data visualization task, generate data display page elements corresponding to each data visualization task;
[0057] As an example, data display page elements can be used to display statistical information corresponding to the target resource data, such as charts rendered based on resource data from different combinations of resources.
[0058] After obtaining the target resource data, by using the target resource data corresponding to each data visualization task as the data source, a chart of a specified style can be rendered based on any target resource data. The rendered chart can then be used as a data display page element corresponding to each data visualization task.
[0059] Specifically, such as Figure 2a As shown, relevant data from various business systems can be processed into standardized combined resource data and then fed into a unified data dashboard generation module. Subsequently, the same set of front-end visualization code can be used to display the data information in the form of charts, i.e., the data display page elements corresponding to each data visualization task.
[0060] In one example, based on the unified data dashboard generation module, each time the chart styles or logic in the combined resource data dashboard are optimized or adjusted, only the relevant data visualization code needs to be maintained and adjusted. Compared to traditional methods, it eliminates the need for repetitive maintenance of similar chart styles, logic processing, and other related code in each system's corresponding data dashboard, thereby effectively reducing system coupling and maintenance costs.
[0061] Step 104: Display the resource data visualization page according to the data display page elements corresponding to each data visualization task.
[0062] In practical applications, based on a preset page, the data display page elements corresponding to each data visualization task can be introduced into different display areas of the preset page, thereby obtaining a resource data visualization page for display.
[0063] In one example, users only need to configure the relevant information in the business system database to obtain and view a unified combined resource data dashboard page. Compared with the traditional method, there is no need to develop a separate data dashboard for each business system to obtain a unified corresponding data dashboard page, which reduces development costs, implementation costs, maintenance costs and learning costs for relevant personnel.
[0064] To enable those skilled in the art to better understand the above steps, the following example illustrates the embodiments of this application, but it should be understood that the embodiments of this application are not limited thereto.
[0065] Taking a data visualization task of rendering a pie chart of purchase ratios for different resource combinations as an example, the front-end page can receive user input regarding the database address, port number, and authorized access information (i.e., database connection information) of the relevant business systems for the resource combinations. This allows connection to and access to the databases of the relevant business systems. Since it is necessary to query the purchase quantity data for each resource combination, the identifier field name and purchase quantity data corresponding to the resource combination in the original business system database can be determined based on the data table storage information. For example, if the identifier field name is fundId and the purchase quantity is amount, and the corresponding data table is purchase, then a constructed query statement, such as select fundId, amount from purchase groupby, can be used. The `fundId` parameter retrieves the required data (i.e., the original resource data). Then, based on the identifier field names and purchase quantity data corresponding to different combinations of resources, the data can be transformed according to preset standard data formats and fields (i.e., the target types set for the original resource data in the data visualization template) to obtain a standard dataset (i.e., the target resource data). This dataset can contain a list of multiple object pairs consisting of `fundId` and `amount`. This list can then be used as the data source for generating a pie chart. Using a corresponding data visualization library (such as ECharts), the processed list is assigned to the `data` value in ECharts to render the pie chart, thus generating data display page elements.
[0066] Compared to traditional methods, the development cost of customizing a visual data dashboard for each system is high due to the large number of systems related to the combined resources and the differences in table structures in the databases of each system. In the process of generating data dashboards for each system, the code for the data visualization part is highly repetitive, the system is highly coupled, and the maintenance cost increases accordingly. Furthermore, the data dashboards developed independently for different systems related to combined resources involve different fields and different operational logics, resulting in high learning and memorization costs for relevant business personnel.
[0067] The technical solution of this embodiment can reduce the cost of repeatedly developing visualization views for multiple systems by automatically generating a combined resource data dashboard; it can reduce the usage and maintenance costs of independent data dashboards for multiple systems by uniformly maintaining the visualization charts and related logic code in the unified data dashboard generation module; and it can help business personnel view and analyze resource data more simply, intuitively, and clearly through unified views, unified fields, and unified operations, thereby reducing the high learning cost brought about by multiple system data dashboards and contributing to the improvement of service capabilities.
[0068] In the above resource data processing method, data call information corresponding to multiple data visualization tasks is obtained. Based on the data call information, the original resource data corresponding to each data visualization task is called from multiple business systems. Data visualization templates for multiple data visualization tasks are obtained. According to the target type set for each original resource data in the data visualization template, the original resource data is adjusted to obtain the target resource data corresponding to each data visualization task. Then, based on the target resource data corresponding to each data visualization task, data display page elements corresponding to each data visualization task are generated. Finally, the resource data visualization page is displayed based on the data display page elements corresponding to each data visualization task. This method optimizes resource data visualization, allows for the calling of original resource data and adjustments based on data visualization templates, and enables the display of resource data visualization pages based on the generated data display page elements. It eliminates the need for separate development for each business system, avoids repetitive maintenance, reduces system coupling, and improves resource data processing efficiency.
[0069] In one embodiment, obtaining the data retrieval information corresponding to each of the multiple data visualization tasks may include the following steps:
[0070] In response to configuration operations on the task configuration page, the database connection information and data table storage information corresponding to each data visualization task are obtained as data retrieval information corresponding to each data visualization task.
[0071] In practical applications, such as Figure 2a As shown, users can configure multiple data visualization tasks by entering the task configuration page. In response to the configuration operation on the task configuration page, the system can obtain the database configuration information of the system related to the combined resources entered by the user, such as the database address, database port number, and object information with certain access permissions, as database connection information; and can obtain the field names of the original database of the business system corresponding to each column of combined resources in the user input template, as data table storage information.
[0072] In this embodiment, by responding to the configuration operation on the task configuration page, the database connection information and data table storage information corresponding to each data visualization task are obtained as data calling information for each data visualization task, providing data support for further data calling.
[0073] In one embodiment, retrieving the original resource data corresponding to each data visualization task from multiple business systems based on the data retrieval information may include the following steps:
[0074] Based on the database connection information, establish connections with databases in multiple business systems; according to the data table storage information, read data from the databases in the multiple business systems to obtain the original resource data corresponding to each data visualization task.
[0075] In one example, based on the obtained database connection information, such as the database address, database port number, and object information with authorized access permissions of the combined resource-related business systems, the database of the relevant business system can be connected and accessed. Furthermore, based on the obtained data table structure information (i.e., data table storage information), the corresponding resource data in the database can be dynamically read, thereby obtaining the original resource data corresponding to each data visualization task.
[0076] In this embodiment, by establishing connections with databases in multiple business systems based on the database connection information, and then reading data from the databases in multiple business systems according to the data table storage information, the original resource data corresponding to each data visualization task is obtained. By configuring the relevant information of the business system database, a unified combined resource data dashboard page can be obtained and viewed.
[0077] In one embodiment, adjusting each original resource data according to the target type set for each original resource data in the data visualization template to obtain the target resource data corresponding to each data visualization task may include the following steps:
[0078] According to the target type set for each of the original resource data in the data visualization template, adjust the data type corresponding to each of the original resource data to obtain the adjusted resource data corresponding to each of the original resource data; according to the data parsing results corresponding to each of the adjusted resource data, obtain the target resource data corresponding to each of the data visualization tasks.
[0079] In practical applications, the identifier field names and related resource data (i.e., raw resource data) corresponding to different combinations of resources can be transformed according to preset standard data formats and fields. That is, according to the target type set for each raw resource data in the data visualization template, the data type corresponding to each raw resource data is adjusted to obtain standardized combined resource data (i.e., adjusted resource data) after relevant data processing for each business system. Then, the processed standardized combined resource data can be passed into the unified data dashboard generation module. By reading and traversing the standardized combined resource data, data parsing and processing can be performed to make it the dataset (i.e., target resource data) corresponding to each chart in the data dashboard.
[0080] Specifically, such as Figure 2bAs shown, it can be determined whether the data type of the data read from the original database (i.e., the original resource data) is consistent with the data type of the corresponding field in the template. If the data types are inconsistent, the read data can be converted to the data type of the corresponding field in the template. If the data types are consistent, or after unifying the data types of the corresponding fields, the read data or the converted data can be assigned to the corresponding field in the template, thereby obtaining standardized combined resource data.
[0081] In this embodiment, by adjusting the data type of each original resource data according to the target type set for each original resource data in the data visualization template, the adjusted resource data corresponding to each original resource data is obtained. Then, based on the data parsing results corresponding to each adjusted resource data, the target resource data corresponding to each data visualization task is obtained. Based on the data standardization process, data templates for multiple business system databases can be realized, enabling the processed resource data to have the ability and foundation to automatically generate a data dashboard.
[0082] In one embodiment, generating data display page elements corresponding to each data visualization task based on the target resource data corresponding to each data visualization task may include the following steps:
[0083] Determine the data visualization library corresponding to each data visualization task; based on the data visualization library corresponding to each data visualization task and the target resource data, generate data display page elements corresponding to each data visualization task.
[0084] In one example, such as Figure 2c As shown, by assigning the processed dataset (i.e., the target resource data) to the data value of a data visualization library such as echarts or d3, the rendering process of each chart can be performed based on the dataset, thereby obtaining the data display charts (i.e., data display page elements) in the combined resource data dashboard. The specific rendering process of each chart can be maintained uniformly, such as unifying the style and logic changes of the data dashboard, so that users do not need to write the relevant code for rendering different charts in the data dashboard separately.
[0085] In this embodiment, by determining the data visualization library corresponding to each data visualization task, and then generating data display page elements corresponding to each data visualization task based on the data visualization library and target resource data, a combined resource data dashboard can be automatically generated, reducing the cost of repeatedly developing visualization views across multiple systems.
[0086] In one embodiment, generating data display page elements corresponding to each data visualization task based on the data visualization library corresponding to each data visualization task and the target resource data may include the following steps:
[0087] The target resource data corresponding to each data visualization task is assigned to the data visualization library corresponding to each data visualization task, thereby generating the data display page elements corresponding to each data visualization task.
[0088] In practice, the target resource data can be used as the data source for rendering the chart. By using a corresponding data visualization library (such as echarts), the target resource data can be assigned to the data value of echarts, thereby realizing the chart rendering, that is, generating data display page elements.
[0089] In this embodiment, by assigning the target resource data corresponding to each data visualization task to the data visualization library corresponding to each data visualization task, data display page elements corresponding to each data visualization task are generated, providing data support for automatically generating a combined resource data dashboard.
[0090] In one embodiment, displaying the resource data visualization page based on the data display page elements corresponding to each data visualization task may include the following steps:
[0091] Obtain preset page information; the preset page information is used to characterize the area position corresponding to each display area in the preset page; import the data display page elements corresponding to each data visualization task into each display area in the preset page to obtain the resource data visualization page and display it.
[0092] In practical applications, based on the corresponding locations of each display area on a preset page, various chart components (i.e., data display page elements corresponding to each data visualization task) can be imported into different display areas of the preset page, thereby obtaining a resource data visualization page for display, such as... Figure 3 As shown.
[0093] In one example, low-code generation can be used to display combined resource data from multiple business systems on a unified visual data dashboard (i.e., a resource data visualization page), such as... Figure 3 As shown, this allows multiple business systems to have a unified data dashboard with similar views, consistent fields, and consistent operating logic, avoiding the need for relevant business personnel to understand, study, and become familiar with the data dashboard of each business system, and effectively reducing the learning and usage costs of multiple systems.
[0094] In this embodiment, by acquiring preset page information, the data display page elements corresponding to each data visualization task are introduced into the respective display areas of the preset page to obtain and display the resource data visualization page. This helps users to view and analyze resource data more easily, intuitively, and clearly, and improves the efficiency of resource data processing.
[0095] In one embodiment, such as Figure 4 The diagram illustrates another resource data processing method. In this embodiment, the method includes the following steps:
[0096] In step 401, in response to the configuration operation on the task configuration page, the database connection information and data table storage information corresponding to each data visualization task are obtained as data call information for each data visualization task. In step 402, based on the database connection information, connections are established with databases in multiple business systems. Data is read from the databases in multiple business systems according to the data table storage information to obtain the original resource data corresponding to each data visualization task. In step 403, data visualization templates for multiple data visualization tasks are obtained. According to the target type set for each original resource data in the data visualization template, the data type corresponding to each original resource data is adjusted to obtain the adjusted resource data corresponding to each original resource data. In step 404, the target resource data corresponding to each data visualization task is obtained based on the data parsing results corresponding to each adjusted resource data. In step 405, the data visualization library corresponding to each data visualization task is determined. Based on the data visualization library and target resource data corresponding to each data visualization task, data display page elements corresponding to each data visualization task are generated. In step 406, preset page information is obtained; the preset page information is used to characterize the area position corresponding to each display area in the preset page. In step 407, the data display page elements corresponding to each data visualization task are imported into the respective display areas of the preset page to obtain and display the resource data visualization page. It should be noted that the specific limitations of the above steps can be found in the specific limitations of a resource data processing method described above, and will not be repeated here.
[0097] It should be understood that although the steps in the flowcharts of the embodiments described above are shown sequentially according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the embodiments described above may include multiple steps or multiple stages. These steps or stages are not necessarily completed at the same time, but can be executed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the steps or stages of other steps.
[0098] Based on the same inventive concept, this application also provides a resource data processing apparatus for implementing the resource data processing method described above. The solution provided by this apparatus is similar to the implementation scheme described in the above method; therefore, the specific limitations in one or more resource data processing apparatus embodiments provided below can be found in the limitations of the resource data processing method described above, and will not be repeated here.
[0099] In one embodiment, such as Figure 5 As shown, a resource data processing apparatus is provided, comprising:
[0100] The raw resource data acquisition module 501 is used to acquire the data call information corresponding to each of the multiple data visualization tasks, and to call the raw resource data corresponding to each data visualization task from multiple business systems according to the data call information.
[0101] The resource data adjustment module 502 is used to obtain data visualization templates for the multiple data visualization tasks, and adjust each of the original resource data according to the target type set for each of the original resource data in the data visualization templates to obtain the target resource data corresponding to each of the data visualization tasks.
[0102] The page element generation module 503 is used to generate data display page elements corresponding to each data visualization task based on the target resource data corresponding to each data visualization task; the data display page elements are used to display statistical information corresponding to the target resource data.
[0103] The resource data page display module 504 is used to display the resource data visualization page according to the data display page elements corresponding to each of the data visualization tasks.
[0104] In one embodiment, the raw resource data acquisition module 501 includes:
[0105] The data retrieval information acquisition submodule is used to retrieve the database connection information and data table storage information corresponding to each data visualization task in response to the configuration operation on the task configuration page, as the data retrieval information corresponding to each data visualization task.
[0106] In one embodiment, the raw resource data acquisition module 501 includes:
[0107] The database connection submodule is used to establish connection relationships with databases in multiple business systems based on the database connection information provided.
[0108] The data reading submodule is used to read data from the databases of the multiple business systems according to the information stored in each of the data tables, so as to obtain the original resource data corresponding to each of the data visualization tasks.
[0109] In one embodiment, the resource data adjustment module 502 includes:
[0110] The data type adjustment submodule is used to adjust the data type of each original resource data according to the target type set for each original resource data in the data visualization template, so as to obtain the adjusted resource data corresponding to each original resource data.
[0111] The target resource data acquisition submodule is used to obtain the target resource data corresponding to each data visualization task based on the data parsing results corresponding to each of the adjusted resource data.
[0112] In one embodiment, the page element generation module 503 includes:
[0113] The data visualization library determination submodule is used to determine the data visualization library corresponding to each of the data visualization tasks.
[0114] The page element generation submodule is used to generate data display page elements corresponding to each data visualization task based on the data visualization library corresponding to each data visualization task and the target resource data.
[0115] In one embodiment, the page element generation submodule includes:
[0116] The data assignment unit is used to assign the target resource data corresponding to each data visualization task to the data visualization library corresponding to each data visualization task, and generate the data display page elements corresponding to each data visualization task.
[0117] In one embodiment, the resource data page display module 504 includes:
[0118] The preset page information acquisition submodule is used to acquire preset page information; the preset page information is used to characterize the area position corresponding to each display area in the preset page;
[0119] The resource data page submodule is used to import the data display page elements corresponding to each of the data visualization tasks into the display areas of the preset page to obtain and display the resource data visualization page.
[0120] Each module in the aforementioned resource data processing device can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in or independent of the processor in a computer device, or stored in the memory of a computer device as software, so that the processor can call and execute the operations corresponding to each module.
[0121] In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as follows: Figure 6 As shown, the computer device includes a processor, memory, communication interface, display screen, and input device connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The communication interface is used for wired or wireless communication with external terminals; wireless communication can be achieved through Wi-Fi, mobile cellular networks, NFC (Near Field Communication), or other technologies. When executed by the processor, the computer program implements a resource data processing method.
[0122] Those skilled in the art will understand that Figure 6 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.
[0123] In one embodiment, a computer device is provided, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to perform the following steps:
[0124] Obtain data call information corresponding to each of the multiple data visualization tasks, and call the original resource data corresponding to each data visualization task from multiple business systems according to the data call information.
[0125] Obtain data visualization templates for the multiple data visualization tasks, and adjust the original resource data according to the target type set for each original resource data in the data visualization template to obtain the target resource data corresponding to each data visualization task;
[0126] Based on the target resource data corresponding to each of the data visualization tasks, data display page elements corresponding to each of the data visualization tasks are generated; the data display page elements are used to display statistical information corresponding to the target resource data.
[0127] Based on the data display page elements corresponding to each of the data visualization tasks, display the resource data visualization page.
[0128] In one embodiment, the processor, when executing a computer program, also implements the steps of the resource data processing method in the other embodiments described above.
[0129] In one embodiment, a computer-readable storage medium is provided having a computer program stored thereon, the computer program performing the following steps when executed by a processor:
[0130] Obtain data call information corresponding to each of the multiple data visualization tasks, and call the original resource data corresponding to each data visualization task from multiple business systems according to the data call information.
[0131] Obtain data visualization templates for the multiple data visualization tasks, and adjust the original resource data according to the target type set for each original resource data in the data visualization template to obtain the target resource data corresponding to each data visualization task;
[0132] Based on the target resource data corresponding to each of the data visualization tasks, data display page elements corresponding to each of the data visualization tasks are generated; the data display page elements are used to display statistical information corresponding to the target resource data.
[0133] Based on the data display page elements corresponding to each of the data visualization tasks, display the resource data visualization page.
[0134] In one embodiment, when the computer program is executed by a processor, it also implements the steps of the resource data processing method in the other embodiments described above.
[0135] In one embodiment, a computer program product is provided, including a computer program that, when executed by a processor, performs the following steps:
[0136] Obtain data call information corresponding to each of the multiple data visualization tasks, and call the original resource data corresponding to each data visualization task from multiple business systems according to the data call information.
[0137] Obtain data visualization templates for the multiple data visualization tasks, and adjust the original resource data according to the target type set for each original resource data in the data visualization template to obtain the target resource data corresponding to each data visualization task;
[0138] Based on the target resource data corresponding to each of the data visualization tasks, data display page elements corresponding to each of the data visualization tasks are generated; the data display page elements are used to display statistical information corresponding to the target resource data.
[0139] Based on the data display page elements corresponding to each of the data visualization tasks, display the resource data visualization page.
[0140] In one embodiment, when the computer program is executed by a processor, it also implements the steps of the resource data processing method in the other embodiments described above.
[0141] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. Any references to memory, databases, or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM). The databases involved in the embodiments provided in this application may include at least one type of relational database and non-relational database. Non-relational databases may include, but are not limited to, blockchain-based distributed databases. The processors involved in the embodiments provided in this application may be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, quantum computing-based data processing logic devices, etc., and are not limited to these.
[0142] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.
[0143] The embodiments described above are merely illustrative of several implementation methods of this application, and while the descriptions are specific and detailed, they should not be construed as limiting the scope of this patent application. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of this application, and these all fall within the protection scope of this application. Therefore, the protection scope of this application should be determined by the appended claims.
Claims
1. A resource data processing method, characterized in that, The method includes: In response to configuration operations on the task configuration page, the database connection information and data table storage information corresponding to each data visualization task are obtained as data calling information corresponding to each data visualization task; wherein, the data calling information includes database connection information and data table storage information used to connect databases in multiple business systems; Based on the database connection information provided, establish connection relationships with databases in multiple business systems; According to the information stored in each of the data tables, data is read from the databases of the multiple business systems to obtain the original resource data corresponding to each of the data visualization tasks; Obtain data visualization templates for the multiple data visualization tasks, and adjust the data types of each original resource data according to the target types set for each original resource data in the data visualization templates to obtain the adjusted resource data corresponding to each original resource data. Based on the data parsing results corresponding to the adjusted resource data, the target resource data corresponding to each data visualization task is obtained; Based on the target resource data corresponding to each of the data visualization tasks, data display page elements corresponding to each of the data visualization tasks are generated; the data display page elements are used to display statistical information corresponding to the target resource data. Based on the data display page elements corresponding to each of the data visualization tasks, display the resource data visualization page.
2. The method according to claim 1, characterized in that, The step of generating data display page elements corresponding to each data visualization task based on the target resource data corresponding to each data visualization task includes: Determine the data visualization library corresponding to each of the aforementioned data visualization tasks; Based on the data visualization library corresponding to each data visualization task and the target resource data, generate data display page elements corresponding to each data visualization task.
3. The method according to claim 2, characterized in that, The step of generating data display page elements corresponding to each data visualization task based on the data visualization library corresponding to each data visualization task and the target resource data includes: The target resource data corresponding to each data visualization task is assigned to the data visualization library corresponding to each data visualization task, thereby generating the data display page elements corresponding to each data visualization task.
4. The method according to any one of claims 1 to 3, characterized in that, The step of displaying the resource data visualization page according to the data display page elements corresponding to each data visualization task includes: Obtain preset page information; the preset page information is used to characterize the area position corresponding to each display area in the preset page; The data display page elements corresponding to each of the data visualization tasks are imported into the display areas of the preset page to obtain and display the resource data visualization page.
5. A resource data processing apparatus, used to implement the resource data processing method as described in any one of claims 1-4, characterized in that, The device includes: The raw resource data acquisition module is used to acquire the data call information corresponding to each of the multiple data visualization tasks, and to call the raw resource data corresponding to each data visualization task from multiple business systems according to the data call information. The resource data adjustment module is used to obtain data visualization templates for the multiple data visualization tasks, and adjust each of the original resource data according to the target type set for each of the original resource data in the data visualization templates to obtain the target resource data corresponding to each of the data visualization tasks. The page element generation module is used to generate data display page elements corresponding to each data visualization task based on the target resource data corresponding to each data visualization task; the data display page elements are used to display statistical information corresponding to the target resource data. The resource data page display module is used to display the resource data visualization page according to the data display page elements corresponding to each data visualization task.
6. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 4.
7. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 4.
Citation Information
Patent Citations
Page configuration method and device, electronic equipment and storage medium
CN114816568A