Data management method, data management system, and readable storage medium

Abstract

The application discloses a data management method, a data management system and a nonvolatile computer readable storage medium. The data management method comprises the following steps: creating an integration interface, the integration interface comprising a plurality of calling units, each calling unit corresponding to a project, and at least two calling units corresponding to different serial port protocols; creating a plurality of databases, each database corresponding to a different project; establishing an association between each calling unit and the database corresponding to the project; and creating a data table in each database, and inserting data into the data table based on the serial port protocol corresponding to the associated calling unit of the database. The data management method, the data management system and the nonvolatile computer readable storage medium provided by the application can reference a plurality of databases corresponding to different communication protocols on a single host computer, so that the data recorded based on the single host computer can be applied to devices with different communication protocols, and the management and transmission of data are facilitated.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data management, in particular to a data management method, a data management system and a non-volatile computer readable storage medium. BACKGROUND

[0002] Some devices on the market need to monitor data in real time and store them in real time, and the data is often stored in the corresponding database. Different host computer engineering is needed to record and store data for devices with different communication protocols, so different host computer engineering is needed to record and store data using a single database, resulting in too many host computers, which is not conducive to data management and transmission. SUMMARY

[0003] The present application provides a data management method, a data management system and a non-volatile computer readable storage medium.

[0004] The data management method of the present application includes: creating an integrated interface, the integrated interface including a plurality of calling units, each calling unit corresponding to a project, at least two calling units corresponding to different serial port protocols; creating a plurality of databases, each database corresponding to a different project; establishing an association between each calling unit and the database corresponding to the project; and creating a data table in each database, inserting data into the data table based on the serial port protocol corresponding to the calling unit associated with the database.

[0005] The data management system of the present application includes an integrated interface and a plurality of databases. The integrated interface includes a plurality of calling units, each calling unit corresponding to a project, at least two calling units corresponding to different serial port protocols. Each database corresponds to a different project. The database includes a data table configured to insert data into the data table based on the serial port protocol corresponding to the calling unit associated with the database.

[0006] The non-volatile computer readable storage medium containing the computer program of the present application includes one or more processors, when the computer program is executed by the one or more processors, the instructions of the data management method are implemented by the processor, the data management method includes: creating an integrated interface, the integrated interface including a plurality of calling units, each calling unit corresponding to a project, at least two calling units corresponding to different serial port protocols; creating a plurality of databases, each database corresponding to a different project; establishing an association between each calling unit and the database corresponding to the project; and creating a data table in each database, inserting data into the data table based on the serial port protocol corresponding to the calling unit associated with the database.

[0007] The data management method, data management system, and non-volatile computer-readable storage medium provided in this application enable a single host computer to reference multiple databases corresponding to different communication protocols, thereby allowing data recorded on a single host computer to be applied to devices with different communication protocols, facilitating data management and transmission.

[0008] Additional aspects and advantages of the embodiments of this application will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of this application. Attached Figure Description

[0009] The above and / or additional aspects and advantages of this application will become apparent and readily understood from the description of the embodiments taken in conjunction with the following drawings, wherein:

[0010] Figure 1 This is a schematic diagram illustrating the application scenarios of existing data recording methods;

[0011] Figure 2 This is a schematic diagram illustrating an application scenario of the data management method according to certain embodiments of this application;

[0012] Figure 3 This is a flowchart illustrating a data management method according to certain embodiments of this application;

[0013] Figure 4 This is a schematic diagram of the structure of a computer-readable storage medium according to certain embodiments of this application;

[0014] Figure 5 This is a schematic diagram illustrating an application scenario of the data management method according to certain embodiments of this application;

[0015] Figure 6 This is a schematic diagram illustrating an application scenario of the data management method according to certain embodiments of this application;

[0016] Figure 7 This is a flowchart illustrating a data management method according to certain embodiments of this application;

[0017] Figure 8 This is a flowchart illustrating a data management method according to certain embodiments of this application;

[0018] Figure 9 This is a flowchart illustrating a data management method according to certain embodiments of this application;

[0019] Figure 10 This is a flowchart illustrating a data management method according to certain embodiments of this application. Detailed Implementation

[0020] Embodiments of the present application are described below in detail, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals represent the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the drawings are exemplary only, and are used only for explaining the embodiments of the present application, and cannot be understood as limiting the embodiments of the present application.

[0021] Referring to Figure 1 , some devices on the market have the need for data management. At present, different devices with different communication protocols need to use different host computers to record data according to their communication protocols, and different host computers need to use a single database to record data, resulting in too many host computers and inconvenience in management. For example, the communication protocols of device A and device B are different, device A needs to use host computer A to record data, and device B needs to use host computer B to record data.

[0022] Referring to Figure 2 , the present application provides a data management method, which can reference multiple databases corresponding to different communication protocols in a single host computer, so that the data recorded based on a single host computer can be applied to devices with different communication protocols, facilitating data management and transmission.

[0023] Referring to Figure 3 , the data management method comprises the following steps:

[0024] 01: Create an integrated interface, the integrated interface comprises multiple calling units, each calling unit corresponds to a project, and at least two calling units correspond to different serial port protocols;

[0025] 02: Create multiple databases, each database corresponds to a different project;

[0026] 03: Establish the association between each calling unit and the database corresponding to the project; and

[0027] 04: Create a data table in each database, and insert data in the data table based on the serial port protocol corresponding to the calling unit associated with the database.

[0028] Please refer to Figure 4This application also provides a non-volatile computer-readable storage medium 300 containing a computer program 301. When the computer program 301 is executed by one or more processors 302, the processors 302 can perform the data management methods in steps 01, 02, 03, and 04 described above. That is, the processor 302 can perform: creating an integrated interface, the integrated interface including multiple calling units, each calling unit corresponding to a project interface, and at least two calling units corresponding to different serial port protocols; creating multiple databases, each database corresponding to a different project; establishing an association between each calling unit and the database of the corresponding project; and creating a data table in each database, and inserting data into the data table based on the serial port protocol corresponding to the calling unit associated with the database.

[0029] This application also provides a data management system that records data using the aforementioned data management method. The data management system includes an integration interface and multiple databases. The integration interface includes multiple calling units, each corresponding to a project interface, and at least two calling units corresponding to different serial port protocols. Each database corresponds to a different project. Each database includes a data table, which is configured to insert data based on the serial port protocol corresponding to the calling unit associated with the database. In some embodiments, the data management method provided in this application can be applied based on the QT framework to obtain a data management system that applies the aforementioned data management method.

[0030] Please combine Figure 5 and Figure 6 , Figure 5 This is a schematic diagram of the UI of an integrated interface according to an embodiment of this application. The integrated interface includes multiple calling units, each of which has a corresponding UI display within the integrated interface. For example, as... Figure 5 As shown, the multiple calling units include a first unit, a second unit, a third unit, a fourth unit, and a fifth unit. The first and second units correspond to the first serial port, while the third, fourth, and fifth units correspond to the second serial port. The first and second serial ports correspond to different serial port protocols. Furthermore, the first and third units correspond to the first project, the second and fourth units correspond to the second project, and the fifth unit corresponds to the third project.

[0031] exist Figure 5 and Figure 6In the example, the integration interface includes five buttons S1, S2, S3, S4 and S5, which correspond to the first unit, the second unit, the third unit, the fourth unit and the fifth unit respectively. Each of the calling units corresponds to a project, and triggering the button corresponding to the calling unit can call the project interface of the project corresponding to the calling unit. For example, triggering the button corresponding to the first unit can call the project interface of the first project, triggering the button corresponding to the second unit can call the project interface of the second project, and triggering the button corresponding to the third unit can call the project interface of the first project. Here, the above are not listed one by one. If the communication protocol of a device A is the first serial port protocol, and the communication protocol of another device B is the second serial port protocol, and the devices A and B both need to call the data of the first project, then for the device A, the first unit corresponding to the first serial port protocol and the first project can be used to call the first project interface in the integration interface, and for the device B, the third unit corresponding to the second serial port protocol and the first project can be used to call the first project interface in the integration interface. In this way, the data management system of the application can be applied to a single host computer, so that the first project data recorded by the single host computer can be applied to the devices A and B with different communication protocols.

[0032] Referring to Figure 6 For example, taking recording data of three different projects as an example, based on the first project, the second project and the third project, the first database, the second database and the third database are respectively created, and the first database, the second database and the third database can adopt SQLite database. Hereinafter, the embodiment of the database of the data management system is introduced as the SQLite database. Among them, the first database corresponds to the first project and is used to record the first project data; the second database corresponds to the second project and is used to record the second project data; and the third database corresponds to the third project and is used to record the third project data.

[0033] Please refer to Figure 5 and Figure 6 After the first database is associated with the first unit and the third unit respectively, the first unit and the third unit can call the first project data in the first database. Thus, the first project data can be called by the first serial port protocol and the second serial port protocol, and the association between the first project data and the first serial port protocol and the second serial port protocol can be completed.

[0034] As Figure 6As shown, a corresponding data table is created in each database, and the project data corresponding to the database is managed in the data table of the database. The data tables in the same database can correspond to the same serial port protocol or different serial port protocols. For example, the first database includes a first data table and a second data table, the first data table corresponds to a first serial port protocol, and the second data table corresponds to a second serial port protocol. For example, when device A inserts first project data, the first project data can be inserted into the first data table of the first database based on the first serial port protocol associated with the host computer. When device B inserts first project data, the first project data can be inserted into the second data table of the first database based on the second serial port protocol associated with the host computer.

[0035] In summary, the data management method, the data management system, and the non-volatile computer readable storage medium 300 provided by the present application can reference multiple databases corresponding to different communication protocols by a single host computer, so that the data recorded based on a single host computer can be applied to devices with different communication protocols, facilitating data management and transmission.

[0036] Referring to Figure 5 and Figure 6 In some embodiments, the calling unit triggers the calling of the corresponding project based on the slot function. Specifically, the click triggering function of the slot function is used to call the interface corresponding to different projects. For example, the first unit is associated with the first database and corresponds to the button S1, and clicking the button S1 can trigger the calling of the first database, and the interface of the first project is displayed on the integrated interface.

[0037] Referring to Figure 5 In some embodiments, the data management system is configured to display the interface of the corresponding project in a new window when the data of the database is called, and close the serial port corresponding to the data when the interface window of the project is closed. In this way, crosstalk between different serial ports can be avoided to some extent.

[0038] Referring to Figure 7 In some embodiments, the calling unit can be created using the class of QDadabase. In some embodiments, step 02: creating multiple databases includes:

[0039] 021: Configure the serial port and pointer of the calling unit, and at least two calling units are configured to declare different serial ports.

[0040] Correspondingly, in some embodiments, at least two calling units of the data management system are configured to declare different serial ports.

[0041] Please refer to Figure 4In some embodiments, the processor 302 can perform the data management method in step 02 above. That is, the processor 302 can perform: configuring the serial port and pointer of the calling unit, and at least two calling units are configured to declare different serial ports.

[0042] In some embodiments, the serial port and pointer of the calling unit are declared by using the QSerialPort class and the Tool class. For example, *serial1 in the QSerialPort class is declared for the first unit configuration, and *pTool1 in the Tool class is declared for the first unit configuration, *serial2 in the QSerialPort class is declared for the second unit configuration, and *pTool2 in the Tool class is declared for the second unit configuration.

[0043] Referring to Figure 8 In some embodiments, step 03: establishing the association between each calling unit and the corresponding database of the project, includes:

[0044] 031: setting the link name of the database; and

[0045] 032: adding the link name of the corresponding database to the calling unit.

[0046] Correspondingly, in some embodiments, the database of the data management system is configured with a link name, and the calling unit is configured with the link name of the corresponding database.

[0047] Referring to Figure 4 In some embodiments, the processor 302 can perform the data management method in steps 031 and 032 above. That is, the processor 302 can perform: setting the link name of the database; and adding the link name of the corresponding database to the calling unit.

[0048] Referring to Figure 6 In some embodiments, the link names of the first database, the second database and the third database are set respectively, for example, the link names of the first database, the second database and the third database are set as database1, database2 and database3 respectively. The first unit corresponds to the first database, so the link name database1 of the first database is added to the first unit to establish the association between the first unit and the first database. The second unit corresponds to the second database, so the link name database2 of the second database is added to the second unit to establish the association between the second unit and the second database. Other calling units are not listed one by one.

[0049] In some embodiments, step 031: setting the link name of the database, includes checking whether the link name of the database exists, if the link name of the database exists, setting the link name of the database as the current link name of the database; if the link name of the database does not exist, establishing the link name of the database.

[0050] Referring to Figure 6 In some embodiments, the data table created in the database includes data in the energy storage system, such as data of the BMS battery system, data of the DC converter, data of the inverter, data of the mainboard, and the like, which are not limited herein. In one embodiment, based on different data types in the energy storage system, corresponding data tables are respectively created in the database. For example, data table M1 is created based on the data of the BMS battery system, data table M2 is created based on the data of the DC converter, data table M3 is created based on the data of the inverter, and data table M4 is created based on the data of the mainboard.

[0051] Further, in some embodiments, based on different data types in the energy storage system and corresponding serial port protocols, corresponding data tables are respectively created in the database. For example, data tables M1a and M1b are created based on the data of the BMS battery system, wherein data table M1a corresponds to a first serial port protocol, and devices using the first serial port protocol can insert corresponding data in data table M1a; data table M1b corresponds to a second serial port protocol, and devices using the second serial port protocol can insert corresponding data in data table M1b.

[0052] In some embodiments, for the data in the data table, QsqlQuert class can be used for operations such as inserting data, querying data, deleting data, and modifying data, which are not limited herein.

[0053] Referring to Figure 9 In some embodiments, the data management method further includes:

[0054] 05: establishing a data model corresponding to each data table, the data model being configured to display data based on a query statement.

[0055] Correspondingly, in some embodiments, the database of the data management system includes a data model corresponding to the data table, the data model being configured to display data based on a query statement.

[0056] Please refer to Figure 4 In some embodiments, the processor 302 can execute the data management method in step 05 described above. That is, the processor 302 can execute: establishing a data model corresponding to each data table, the data model being configured to display data based on a query statement.

[0057] In some embodiments, the data model is associated with a corresponding database and a sql statement, and the selected data by the sql statement is displayed on the corresponding data model.

[0058] In some embodiments, the query of the data can use a select * from query statement, and different data tables can be selected according to the currentIndex of the Combobox. The data query method can be searching in the corresponding database according to the time range and the timestamp of the data, which is not limited herein. Accordingly, the data header label can be added to the selected data table to facilitate the data export.

[0059] Please refer to Figure 10 , Figure 10 A flow of the data management method of the present application is shown as follows: based on the first project, the second project and the third project, an integrated interface is created, and a plurality of project corresponding databases are created, and the plurality of project corresponding databases are initialized respectively. The initialization processing includes the following flow: checking whether the link name of the database exists, if the link does not exist, establishing the link name and adding the link name in the calling unit, if the link exists, adding the link name in the calling unit. After adding the link name in the calling unit, the data table is created in the database, and the data is inserted into the data table according to the serial port protocol corresponding to the data table. After creating the data table, the data model corresponding to the data table is established, and the corresponding query statement is added to the data model.

[0060] In the description of the present specification, the description of the terms "one embodiment", "some embodiments", "exemplary embodiment", "example", "specific example" or "some examples" means that the specific features, structures, materials or characteristics described in connection with the embodiment or example are included in at least one embodiment or example of the present application. In the present specification, the exemplary description of the above terms does not necessarily mean the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described can be combined in any one or more embodiments or examples in a suitable manner. In addition, the skilled in the art can combine and combine the different embodiments or examples described in the present specification and the features of the different embodiments or examples without contradiction.

[0061] Any process or method descriptions in flow charts or described herein in other ways can be understood as representing code modules, segments, or portions of code that include one or more executable instructions for performing specific logic functions or steps in the process, and the preferred embodiments of the present application include additional implementations in which the functions described with or without reference to flow charts are implemented with fewer than or more than the described sequences and / or with additional sequences not shown or described herein.

[0062] Although the embodiments of the present application have been shown and described above, it is understood that the above-described embodiments are exemplary and are not to be construed as limiting the present application, and that those skilled in the art can make changes, modifications, substitutions and variations to the above-described embodiments within the scope of the present application.

Claims

1. A data management method, characterized in that, The data management method includes: Create an integrated interface, which includes multiple calling units, each of which corresponds to a project. Triggering a calling unit enables the calling unit to call the project interface of the project it corresponds to. At least two calling units correspond to different serial port protocols. Create multiple databases, each corresponding to a different project; Establish an association between each of the calling units and the database of the corresponding project; and A data table is created in each of the databases, and data is inserted into the data table based on the serial port protocol corresponding to the calling unit associated with the database. The data tables in the same database may correspond to different serial port protocols. The creation of the integrated interface includes: Configure the serial port and pointer of the calling unit, and at least two calling units shall be configured to declare different serial ports; The process of establishing the association between each calling unit and the database of the corresponding project includes: Set the connection name for the database; and Add the corresponding database link name to the calling unit.

2. The data management method according to claim 1, characterized in that, The calling unit triggers the call to the corresponding project based on the slot function.

3. The data management method according to claim 1, characterized in that, The data management method also includes: Establish a data model for each of the data tables, and configure the data model to display data based on query statements.

4. A data management system, characterized in that, The data management system includes: An integrated interface includes multiple calling units, each corresponding to a project. Triggering a calling unit allows it to access the project interface of the corresponding project. At least two calling units correspond to different serial port protocols. Multiple databases, each corresponding to a different project; The database includes data tables, which are configured to insert data based on the serial port protocol corresponding to the calling unit associated with the database. Data tables in the same database can correspond to different serial port protocols. The database is configured with a link name, and the calling unit is configured with the corresponding link name of the database.

5. The data management system according to claim 4, characterized in that, The calling unit triggers the call to the corresponding project based on the slot function.

6. The data management system according to claim 5, characterized in that, The database includes a data model corresponding to the data table, and the data model is configured to display data based on query statements.

7. A non-volatile computer-readable storage medium comprising a computer program, including one or more processors, wherein when the computer program is executed by the one or more processors, the processors cause the processors to implement the instructions of the data management method according to any one of claims 1 to 3.

Images