Data visualization method combined with data access and related device

Abstract

The application provides a data visualization method combined with data access and related equipment. In the data access process of data visualization, an operator only needs to determine the docking mode and data parameters of a data source system, the mapping relationship established through data mapping is used to complete data access, the operation is simple and easy, in the display interface of visualization, only the display component constructed in advance needs to be dragged to the display interface for layout, the operation is simple, after the display interface is laid out, the display parameters of the display component are set to realize association with the database table structure, the data source is imported into the display component, the combination of data access and visualization process is realized, the operation process of separate execution is reduced, the workload of the operator is reduced, and the project cycle and visualization cost are reduced.

Description

Technical Field

[0001] This application relates to the field of data visualization technology, and in particular to a data visualization method and related equipment that combines data access. Background Technology

[0002] Currently, the types and quantities of data related to information technology projects are increasing day by day. Different data structures, data sources, and communication protocols make data integration more difficult and visualization more complex. Data access and data visualization are separated into two separate processes, which are complex and require operators to master both data access and visualization knowledge, resulting in a significant increase in the workload of operators and also causing an increase in project cycle and cost. Summary of the Invention

[0003] In view of this, this application proposes a data visualization method and related equipment that combine data access to solve the above problems.

[0004] To achieve the above objectives, the first aspect of this application provides a data visualization method that combines data access, comprising:

[0005] Identify the data source system and obtain the historical data collection records;

[0006] In response to determining that the data source system is not recorded in the history, the docking method and data parameters of the data source system are obtained, and the data source system is recorded in the history.

[0007] Based on the connection method and data parameters, construct the mapping relationship between the data source system and the database table structure;

[0008] Drag and drop display components in the display interface to arrange the layout of the display interface;

[0009] Based on the mapping relationship, the data from the data source system is visualized on the display interface by associating the display parameters of the display components with the database table structure.

[0010] Optionally, data visualization methods that combine data access also include:

[0011] In response to the determination that the data source system is recorded in the history, update the mapping relationship;

[0012] Based on the updated mapping relationship, the visualization of the data source system data is completed by modifying the display parameters.

[0013] Optionally, a mapping relationship between the data source system and the database table structure is constructed based on the interface method and data parameters, including:

[0014] Determine the interface parameters of the data source system based on the connection method;

[0015] Determine the database table structure based on data parameters;

[0016] Establish a mapping relationship between interface parameters and database table structures.

[0017] Optionally, establish a mapping relationship between interface parameters and database table structures, including:

[0018] Determine the database table fields to define the database table structure;

[0019] The interface parameters are mapped one-to-one with the database table fields to obtain the mapping relationship.

[0020] Optionally, the layout of the display interface can be arranged by dragging and dropping display components; including:

[0021] Divide the display interface into display areas;

[0022] Drag the display components to the display area until there is at least one display component in the entire display area, thus completing the layout of the display interface.

[0023] Optionally, based on the mapping relationship, data visualization is performed on the display interface by associating the display parameters of the display components with the database table structure, including:

[0024] The display parameters will be associated one-to-one with the database table fields in the database table structure.

[0025] Based on the mapping relationship, the associated data is displayed using display components.

[0026] Optionally, in response to determining that the data source system is recorded in the history, the mapping relationship is updated, including:

[0027] In response to determining that the data source system is recorded in the historical record, the data source system is compared with the historical record to determine the differences in the docking method and the data parameters;

[0028] The mapping relationship is updated based on the differences.

[0029] A second aspect of this application provides a visualization device incorporating data access, comprising:

[0030] The confirmation module is configured to: determine the data source system and obtain the historical data collection records;

[0031] The acquisition module is configured to: in response to determining that the data source system is not recorded in the history record, acquire the docking method and data parameters of the data source system, and record the data source system in the history record;

[0032] The mapping module is configured to: construct a mapping relationship between the data source system and the database table structure based on the interface method and data parameters;

[0033] The layout module is configured to allow users to drag and drop display components to lay out the display interface.

[0034] The visualization module is configured to visualize the data source system data on the display interface based on the mapping relationship, by associating the display parameters of the display components with the database table structure.

[0035] A third aspect of this application provides an electronic device including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor, when executing the program, implements the method provided in the first aspect of this application.

[0036] A fourth aspect of this application provides a non-transitory computer-readable storage medium storing computer instructions for causing a computer to perform the method provided in the first aspect of this application.

[0037] As described above, the data visualization method and related equipment combining data access provided in this application first require identifying the data source system and obtaining the historical data collection records. If the data source system is not recorded in the historical records, it indicates that the data source of that system has not undergone visualization processing. The method then obtains the connection method and data parameters of the data source system, and constructs a mapping relationship between the data source system and the database table structure based on the connection method and data parameters, thus completing the data mapping between the data source and the database and achieving data access. Next, the display interface is laid out by dragging and dropping display components, and the data source that has established a data mapping with the database is input into the display components by associating the display parameters of the display components with the database table structure, thereby realizing the visualization of the data source system data on the display interface. During the data access process in data visualization, operators only need to determine the connection method and data parameters of the data source system. Data access is completed through the mapping relationship established by data mapping. The operation is simple and easy. In the visualization display interface, operators only need to drag and drop the pre-built display components to the display interface for layout. The operation is simple. After the layout of the display interface is completed, the display parameters of the display components are used to establish the association with the database table structure, and the data source is imported into the display components. This realizes the combination of data access and visualization process, reduces the separate operation process, reduces the workload of operators, and lowers the project cycle and visualization cost. Attached Figure Description

[0038] To more clearly illustrate the technical solutions in this application or related technologies, the drawings used in the description of the embodiments or related technologies will be briefly introduced below. Obviously, the drawings described below are only embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0039] Figure 1 This is a schematic diagram illustrating the location of data access in the data platform implementation according to an embodiment of this application;

[0040] Figure 2 This is a flowchart illustrating a data visualization method incorporating data access, as described in an embodiment of this application.

[0041] Figure 3 A flowchart illustrating the mapping relationship for embodiments of this application;

[0042] Figure 4 A flowchart illustrating the mapping relationship between interface parameters and database table structures in this application embodiment;

[0043] Figure 5 This is a flowchart illustrating the page layout of an embodiment of this application;

[0044] Figure 6 A flowchart illustrating the visualization process of an embodiment of this application;

[0045] Figure 7 A flowchart illustrating the updated mapping relationship in this application's embodiments;

[0046] Figure 8 This is a schematic diagram of the structure of the visualization device combined with data access in an embodiment of this application;

[0047] Figure 9 This is a schematic diagram of the structure of an electronic device according to an embodiment of this application. Detailed Implementation

[0048] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with specific embodiments and the accompanying drawings.

[0049] It should be noted that, unless otherwise defined, the technical or scientific terms used in the embodiments of this application should have the ordinary meaning understood by one of ordinary skill in the art to which this application pertains. The terms "first," "second," and similar terms used in the embodiments of this application do not indicate any order, quantity, or importance, but are merely used to distinguish different components. Terms such as "comprising" or "including" mean that the element or object preceding the word encompasses the elements or objects listed after the word and their equivalents, without excluding other elements or objects. Terms such as "connected" or "linked" are not limited to physical or mechanical connections, but can include electrical connections, whether direct or indirect. Terms such as "upper," "lower," "left," and "right" are only used to indicate relative positional relationships; when the absolute position of the described object changes, the relative positional relationship may also change accordingly.

[0050] In related technologies, data access refers to the process of collecting, transmitting, processing, and caching data from different data sources and with different partners, ultimately integrating it into a unified big data platform. From a data type perspective, data access mainly includes access to structured data (business databases), log data, IoT data, and file data. Specifically: Structured data access is primarily achieved through ETL tools, including Sqoop provided by the Hadoop platform, open-source tools like Kettle and Talind, and commercial products such as Informatica and DataStage. Log data access typically uses tools like Flume, FileBeats, and Logstash. IoT data access is usually streamed data and accessed to the big data platform via Kafka. File access is achieved through FTP or WebDAV protocols. Data source: Describes a data source and indicates the location of the data required by the application. Data source types include MySQL, Hive, and Tair. ETL: Extract, transform, load; extracting data from one location, transforming it, and loading it into another. Data visualization refers to the process of representing data in large datasets in graphical form and using data analysis and development tools to discover unknown information within them.

[0051] like Figure 1 As shown, the part circled in the box corresponds to the data access process, while the data visualization is displayed in the access layer. It can be seen that data access and data visualization are separated into two separate processes. The operation process is complex and requires operators to master knowledge of both data access and visualization, which leads to a significant increase in the workload of operators, as well as an increase in project cycle and cost.

[0052] The data visualization method and related equipment provided in this application embodiment, which combine data access, only require the operator to determine the connection method and data parameters of the data source system during the data access process. Data access is completed through the mapping relationship established by data mapping, which is simple and easy to operate. In the visualization display interface, the operator only needs to drag and drop the pre-built display components to the display interface for layout. The operation is simple. After the layout of the display interface is completed, the display parameters of the display components are used to establish the association with the database table structure, and the data from the data source is imported into the display components. This realizes the combination of data access and visualization process, reduces the separate operation process, reduces the workload of operators, and lowers the project cycle and visualization cost.

[0053] In some embodiments, such as Figure 2 As shown, this application provides a data visualization method that combines data access, including:

[0054] Step 100: Identify the data source system and obtain the historical data collection records.

[0055] In this step, it is necessary to identify the data source system and the historical data collection history. This history records the data source system that completed the data collection and data visualization, as well as the data parameters and connection methods of the historical data source system. The historical history can simplify the data visualization process of the historical data source system recorded in the history.

[0056] Step 200: In response to determining that the data source system is not recorded in the history, obtain the docking method and data parameters of the data source system, and record the data source system in the history.

[0057] In this step, if the data source system that the data visualization process is connected to is not recorded in the history, it means that the data source system is a system that has not been used for data visualization. For example, if the history is as shown in Table 1:

[0058] Table 1 Historical Records

[0059] Data source system Data parameters Connection method other A a1 a2 x B b1 b2 x

[0060] If the data source system accessed this time is C, obtain the data parameter c1 and connection method c2 of the data source system C, and record the data source system C in the history table to obtain the updated history as shown in Table 2:

[0061] Table 2 Updated History

[0062] Data source system Data parameters Connection method other A a1 a2 x B b1 b2 x C c1 c2 x

[0063] Step 300: Construct the mapping relationship between the data source system and the database table structure based on the docking method and data parameters.

[0064] In this step, the background database of the visualization system is a collection of data stored together in a certain way, which can be shared by multiple users, has the lowest possible redundancy, and is independent of the application. It can be regarded as an electronic filing cabinet—a place to store electronic files. Users can perform operations such as adding, querying, updating, and deleting data in the files. A database is a warehouse for storing data. Its storage space is huge, capable of storing millions, tens of millions, or even hundreds of millions of data entries. However, databases do not store data arbitrarily; there are certain rules, otherwise query efficiency would be very low. The database table structure defines a table's fields, types, primary keys, foreign keys, and indexes. These basic attributes constitute the database table structure. For example: `create table student, id int primarykey, name varchar, sex varchar, age varchar`, where `id`, `name`, and `sex` are the fields of the database table structure, `int` and `varchar` are the data types of the database table structure, and `primarykey` is the primary key of the database table structure.

[0065] After determining the connection method, connect the data source system and the visualization system. At the same time, determine the interface parameters of the data source system according to the connection method, and define the database table structure of the visualization system's backend database according to the data parameters of the data source system. Match the interface parameters with the fields of the database table structure one by one to complete all data access configuration.

[0066] Step 400: Drag and drop display components in the display interface to lay out the display interface.

[0067] In this step, open the interface editor in the visualization system and design the interface layout by dragging and dropping display components. For example, drag the pie chart to the upper left corner of the display interface, drag the bar chart to the upper right corner of the display interface, and drag the line chart to the center of the display page. Modify the display properties and display parameters of the display components as needed to complete the interface design.

[0068] Step 500: Based on the mapping relationship, visualize the data source system data on the display interface by associating the display parameters of the display components with the database table structure.

[0069] In this step, based on the established data mapping relationship, the display parameters of the display component are associated with the fields of the database table structure. This establishes the connection between the data source system and the display component, and the display parameters are set to change the display content of the component. During the data access process for data visualization, operators only need to determine the connection method and data parameters of the data source system. Data access is completed through the mapping relationship established by the data mapping, making the operation simple and easy. In the visualization display interface, operators only need to drag and drop the pre-built display component to the display interface for layout. After the layout of the display interface is completed, the display parameters of the display component are associated with the database table structure to import the data source into the display component. This combines the data access and visualization process, reducing separate operations and decreasing the workload of operators while lowering project cycle and visualization costs.

[0070] In some embodiments, the data visualization method combined with data access further includes:

[0071] Step 600: In response to determining that the data source system is recorded in the history, update the mapping relationship.

[0072] In this step, if the data source system being accessed in this data visualization process is already recorded in the history, it indicates that the data source system is the same as the data source system used for data visualization. For example, if the history is as shown in Table 1. If the data source system being accessed is A1, obtaining the data parameter a3 and connection method a4 of data source system A1 shows that the data source system A1 being accessed is the same system as data source system A in the history. For example, if data source system A in the history is the central air conditioning system in Building A, and the central air conditioning system in Building B is also of brand D, although it is the same central air conditioning system, the connection method and data parameters selected during use may be different. In this case, by comparing data parameter a3 and a1, and connection methods a4 and a2, the data mapping relationship is updated according to the differences.

[0073] Step 700: Based on the updated mapping relationship, visualize the data source system data by modifying the display parameters.

[0074] In this step, based on the updated mapping relationship, the visualization of the data source system data can be completed by directly modifying the display parameters of the display control in the display page laid out in step 400.

[0075] In some embodiments, such as Figure 3 As shown, the mapping relationship between the data source system and the database table structure is constructed based on the interface method and data parameters, including:

[0076] Step 310: Determine the interface parameters of the data source system based on the connection method.

[0077] In this step, three connection methods are provided for heterogeneous data sources and third-party data source systems with different communication protocols: protocol connection, API connection, and database connection. After the connection is completed, data adaptation and collection are performed to achieve standardized data access and cleaning. However, different connection methods will result in different interface parameters of the data source system. For example, interface parameters include communication protocol, URL address, number of parameters, parameter values, and other information.

[0078] Step 320: Determine the database table structure based on the data parameters.

[0079] In this step, defining the database table structure involves defining a table's fields, data types, primary keys, foreign keys, and indexes. These basic attributes constitute the database table structure. For example: `create table student, id int primarykey, name varchar, sex varchar, age varchar`, where `id`, `name`, and `sex` are the database table fields, `int varchar` is the data type, and `primarykey` is the primary key. Determining the fields, data types, primary keys, foreign keys, and indexes of the corresponding database table structure based on data parameters facilitates subsequent data retrieval.

[0080] Step 330: Establish the mapping relationship between interface parameters and database table structure.

[0081] In this step, data mapping involves establishing a correspondence between data elements given two data models. This process is called data mapping. Data mapping is the first step in many data integration tasks, such as data migration, data cleaning, data integration, semantic web construction, and peer-to-peer information systems. By mapping data between the data source system and the visualization system, a mapping relationship is established between interface parameters and database table structures. The migration of data from the data source system to the visualization system includes three stages: data extraction, data transformation, and data loading. However, data extraction, transformation, and loading all require a clear mapping relationship as a guiding rule.

[0082] In some embodiments, such as Figure 4 As shown, the mapping relationship between interface parameters and database table structure is established, including:

[0083] Step 331: Determine the database table fields of the database table structure.

[0084] Step 332: Map the interface parameters to the database table fields one by one to obtain the mapping relationship.

[0085] Specifically, the interface parameters are mapped one-to-one with the database table fields, so that the extraction, transformation, and loading of data are all guided by this one-to-one mapping relationship.

[0086] In some embodiments, such as Figure 5 As shown, drag and drop display components in the display interface to arrange the layout of the display interface; including:

[0087] Step 410: Divide the display area in the display interface.

[0088] In this step, the display interface is divided into multiple display areas according to the actual situation. For example, the display interface is divided into four display areas in a grid pattern.

[0089] Step 420: Drag the display components to the display area until there is at least one display component in the entire display area to complete the layout of the display interface.

[0090] In this step, display components are dragged to the display area. For example, a pie chart is dragged to the top left display area of ​​the four display areas on the display interface, a bar chart is dragged to the top right display area of ​​the four display areas on the display interface, a line chart is dragged to the bottom right display area of ​​the four display areas on the display page, and a 3D display chart is dragged to the bottom left display area of ​​the four display areas on the display page. It is necessary to ensure that there is at least one display component in each display area, and modify the display properties and display parameters of the display components as needed to complete the interface design.

[0091] In some embodiments, such as Figure 6 As shown, based on the mapping relationship, the data source system data is visualized on the display interface by associating the display parameters of the display components with the database table structure, including:

[0092] Step 510: Associate the display parameters with the database table fields of the database table structure one-to-one.

[0093] In this step, based on the established data mapping relationship, the data parameters are associated one-to-one with the database table fields of the database table structure.

[0094] Step 520: Based on the mapping relationship, use the display component to display the associated data.

[0095] In this step, based on the mapping relationship, data is accessed by connecting database table fields with interface parameters, and display parameters are set to configure the content displayed by the display components. After the display interface layout is completed, the display parameters of the display components are linked to the database table structure to import the data source into the display components. This combines data access with the visualization process, reducing separate operations and decreasing the workload of operators while also reducing project timelines and visualization costs.

[0096] In some embodiments, such as Figure 7 As shown, in response to determining that the data source system is recorded in the history, the mapping relationship is updated, including:

[0097] Step 610: In response to the determination that the data source system is recorded in the history, compare the data source system with the history to determine the differences in the docking method and data parameters;

[0098] Step 620: Update the mapping relationship based on the differences.

[0099] For example, as shown in Table 1, if the data source system A in the historical records is the central air conditioning system in Building A, and the central air conditioning system is brand D, and the central air conditioning system in Building B is also brand D, although it is the same central air conditioning system, the docking method and data parameters selected during use may be different. In this case, by comparing data parameters a3 and a1, docking methods a4 and a2, the mapping relationship of the data mapping is updated according to the differences.

[0100] It should be noted that the method in this embodiment can be executed by a single device, such as a computer or server. The method can also be applied in a distributed scenario, where multiple devices cooperate to complete the task. In such a distributed scenario, one of these devices may execute only one or more steps of the method in this embodiment, and the multiple devices will interact with each other to complete the method described.

[0101] It should be noted that the above description describes some embodiments of this application. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recorded in the claims can be performed in a different order than that shown in the above embodiments and still achieve the desired result. Furthermore, the processes depicted in the drawings do not necessarily require a specific or sequential order to achieve the desired result. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0102] Based on the same inventive concept, corresponding to any of the above embodiments, this application also provides a visualization device that combines data access.

[0103] refer to Figure 8 The visualization device that integrates data access includes:

[0104] The confirmation module 10 is configured to: determine the data source system and obtain the historical data collection records;

[0105] The acquisition module 20 is configured to: in response to determining that the data source system is not recorded in the history record, acquire the docking method and data parameters of the data source system, and record the data source system in the history record;

[0106] Mapping module 30 is configured to: construct a mapping relationship between the data source system and the database table structure based on the docking method and data parameters;

[0107] Layout module 40 is configured to: drag and drop display components in the display interface to lay out the display interface;

[0108] The visualization module 50 is configured to visualize data from the data source system on the display interface based on the mapping relationship, by associating the display parameters of the display components with the database table structure.

[0109] For ease of description, the above devices are described in terms of function, divided into various modules. Of course, in implementing this application, the functions of each module can be implemented in one or more software and / or hardware.

[0110] The apparatus described above is used to implement the corresponding visualization method combining data access in any of the foregoing embodiments, and has the beneficial effects of the corresponding method embodiments, which will not be repeated here.

[0111] Based on the same inventive concept, corresponding to any of the above embodiments, this application also provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the visualization method combined with data access as described in any of the above embodiments.

[0112] Figure 9 This embodiment illustrates a more specific hardware structure of an electronic device, which may include a processor 1010, a memory 1020, an input / output interface 1030, a communication interface 1040, and a bus 1050. The processor 1010, memory 1020, input / output interface 1030, and communication interface 1040 are interconnected internally via the bus 1050.

[0113] The processor 1010 can be implemented using a general-purpose CPU (Central Processing Unit), microprocessor, application-specific integrated circuit (ASIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solutions provided in the embodiments of this specification.

[0114] The memory 1020 can be implemented in the form of ROM (Read Only Memory), RAM (Random Access Memory), static storage device, dynamic storage device, etc. The memory 1020 can store the operating system and other applications. When the technical solutions provided in the embodiments of this specification are implemented by software or firmware, the relevant program code is stored in the memory 1020 and is called and executed by the processor 1010.

[0115] The input / output interface 1030 is used to connect input / output modules to realize information input and output. Input / output modules can be configured as components within the device (not shown in the figure) or externally connected to the device to provide corresponding functions. Input devices may include keyboards, mice, touchscreens, microphones, various sensors, etc., while output devices may include displays, speakers, vibrators, indicator lights, etc.

[0116] The communication interface 1040 is used to connect a communication module (not shown in the figure) to enable communication between this device and other devices. The communication module can communicate via wired means (such as USB, Ethernet cable, etc.) or wireless means (such as mobile network, WIFI, Bluetooth, etc.).

[0117] Bus 1050 includes a pathway for transmitting information between various components of the device, such as processor 1010, memory 1020, input / output interface 1030, and communication interface 1040.

[0118] It should be noted that although the above-described device only shows the processor 1010, memory 1020, input / output interface 1030, communication interface 1040, and bus 1050, in specific implementations, the device may also include other components necessary for normal operation. Furthermore, those skilled in the art will understand that the above-described device may only include the components necessary for implementing the embodiments of this specification, and not necessarily all the components shown in the figures.

[0119] The electronic devices described above are used to implement the corresponding visualization methods that combine data access in any of the foregoing embodiments, and have the beneficial effects of the corresponding method embodiments, which will not be repeated here.

[0120] Based on the same inventive concept, corresponding to the methods of any of the above embodiments, this application also provides a non-transitory computer-readable storage medium that stores computer instructions for causing the computer to execute the visualization method combined with data access as described in any of the above embodiments.

[0121] The computer-readable medium of this embodiment includes permanent and non-permanent, removable and non-removable media, and information storage can be implemented by any method or technology. Information can be computer-readable instructions, data structures, program modules, or other data. Examples of computer storage media include, but are not limited to, phase-change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, CD-ROM, digital versatile optical disc (DVD) or other optical storage, magnetic tape, magnetic magnetic disk storage or other magnetic storage devices, or any other non-transfer medium that can be used to store information accessible by a computing device.

[0122] The computer instructions stored in the storage medium of the above embodiments are used to cause the computer to execute the visualization method combined with data access as described in any of the above embodiments, and have the beneficial effects of the corresponding method embodiments, which will not be repeated here.

[0123] Those skilled in the art should understand that the discussion of any of the above embodiments is merely exemplary and is not intended to imply that the scope of this application (including the claims) is limited to these examples; within the framework of this application, the technical features of the above embodiments or different embodiments can also be combined, the steps can be implemented in any order, and there are many other variations of different aspects of the embodiments of this application as described above, which are not provided in the details for the sake of brevity.

[0124] Additionally, to simplify the description and discussion, and to avoid obscuring the embodiments of this application, the well-known power / ground connections to integrated circuit (IC) chips and other components may or may not be shown in the provided drawings. Furthermore, the apparatus may be shown in block diagram form to avoid obscuring the embodiments of this application, and this also takes into account the fact that the details of the implementation of these block diagram apparatuses are highly dependent on the platform on which the embodiments of this application will be implemented (i.e., these details should be fully understood by those skilled in the art). While specific details (e.g., circuits) have been set forth to describe exemplary embodiments of this application, it will be apparent to those skilled in the art that the embodiments of this application can be implemented without these specific details or with variations thereof. Therefore, these descriptions should be considered illustrative rather than restrictive.

[0125] Although this application has been described in conjunction with specific embodiments thereof, many substitutions, modifications, and variations of these embodiments will be apparent to those skilled in the art from the foregoing description. For example, other memory architectures (e.g., dynamic RAM (DRAM)) may be used with the embodiments discussed.

[0126] The embodiments of this application are intended to cover all such substitutions, modifications, and variations that fall within the broad scope of the appended claims. Therefore, any omissions, modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the embodiments of this application should be included within the protection scope of this application.

Claims

1. A data visualization method incorporating data access, characterized by, The method comprises: determining a data source system and obtaining a history record of data collection; in response to determining that the data source system is not recorded in the history record, obtaining an interfacing mode and data parameters of the data source system, and recording the data source system in the history record; constructing a mapping relationship between the data source system and a database table structure based on the interfacing mode and the data parameters; wherein constructing the mapping relationship between the data source system and the database table structure based on the interfacing mode and the data parameters comprises: determining interface parameters of the data source system based on the interfacing mode; determining the database table structure based on the data parameters; establishing the mapping relationship between the interface parameters and the database table structure; the establishment of the mapping relationship between the interface parameters and the database table structure comprises: determining database table fields of the database table structure; and establishing a one-to-one correspondence between the interface parameters and the database table fields to obtain the mapping relationship; dragging display components in a display interface to layout the display interface; based on the mapping relationship, associating display parameters of the display components with the database table structure in the display interface to visualize data of the data source system.

2. The method of claim 1, wherein, The method further comprises: in response to determining that the data source system is recorded in the history record, updating the mapping relationship; based on the updated mapping relationship, modifying the display parameters to complete the visualization of the data of the data source system.

3. The method of claim 1, wherein, The dragging of display components in a display interface to layout the display interface comprises: dividing a display area in the display interface; dragging the display components to the display area until there is at least one display component in each of the display areas to complete the layout of the display interface.

4. The method of claim 1, wherein, The visualization of data of the data source system in the display interface based on the mapping relationship by associating display parameters of the display components with the database table structure comprises: associating the display parameters with the database table fields of the database table structure one by one; based on the mapping relationship, displaying the associated data using the display components.

5. The method of claim 2, wherein, The updating of the mapping relationship in response to determining that the data source system is recorded in the history record comprises: in response to determining that the data source system is recorded in the history record, comparing the data source system with the history record to determine differences in the interfacing mode and the data parameters; updating the mapping relationship based on the differences.

6. A visualizing device incorporating data access, characterized by, The method comprises: a confirmation module configured to determine a data source system and obtain a history record of data collection; a obtaining module configured to, in response to determining that the data source system is not recorded in the history record, obtain an interfacing mode and data parameters of the data source system, and record the data source system in the history record; The mapping module is configured to construct a mapping relationship between the data source system and the database table structure based on the interfacing mode and the data parameters; wherein the mapping relationship between the data source system and the database table structure is constructed based on the interfacing mode and the data parameters, including: determining interface parameters of the data source system based on the interfacing mode; determining the database table structure based on the data parameters; establishing the mapping relationship between the interface parameters and the database table structure; the establishment of the mapping relationship between the interface parameters and the database table structure includes: determining database table fields of the database table structure; and one-to-one corresponding the interface parameters and the database table fields to obtain the mapping relationship; The layout module is configured to perform layout of the display interface by dragging and displaying components in the display interface. The visualization module is configured to perform visualization of the data source system data in the display interface by associating display parameters of the display components and the database table structure based on the mapping relationship. 7.An electronic device comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any one of claims 1 to 5 when executing the program. 8.A non-transitory computer-readable storage medium storing computer instructions for causing a computer to execute the method of any one of claims 1 to 5.

Images