CN115952136A - Equipment data storage method, device, computer equipment and medium - Google Patents

Equipment data storage method, device, computer equipment and medium Download PDF

Info

Publication number
CN115952136A
CN115952136A CN202310064410.1A CN202310064410A CN115952136A CN 115952136 A CN115952136 A CN 115952136A CN 202310064410 A CN202310064410 A CN 202310064410A CN 115952136 A CN115952136 A CN 115952136A
Authority
CN
China
Prior art keywords
data
relational database
equipment
associated data
file
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310064410.1A
Other languages
Chinese (zh)
Inventor
薛德方
王悦
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Puyuan Jingdian Technology Co ltd
Original Assignee
Puyuan Jingdian Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Puyuan Jingdian Technology Co ltd filed Critical Puyuan Jingdian Technology Co ltd
Priority to CN202310064410.1A priority Critical patent/CN115952136A/en
Publication of CN115952136A publication Critical patent/CN115952136A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application relates to a device data storage method, an apparatus, a computer device, a storage medium and a computer program product. The method comprises the following steps: receiving a device data configuration instruction; configuring corresponding equipment data according to the equipment data configuration instruction; acquiring and updating associated data corresponding to the equipment data; and writing the equipment data and the associated data into a relational database. The method can be used for conveniently storing the equipment data.

Description

Equipment data storage method, device, computer equipment and medium
Technical Field
The present application relates to the field of digital test and measurement instruments, and in particular, to an apparatus data storage method, apparatus, computer device, and storage medium.
Background
In a digital test and measurement instrument, a combination of multiple functions will be a future trend, and thus, a plurality of scattered data sets such as configuration parameters, user data, calibration data and product data will be brought.
The conventional scheme generally stores each data set as a file or writes the data set into a special memory, such as an eepROM or FRAM memory, but the conventional scheme has the defects of difficult debugging, high cost, difficult maintenance and the like. The traditional scheme is basically divided into two types, one is to store the data storage into a disk in a file mode through coding binary system or text and the like; the second is to access different data contents through addresses by means of special memory chips. The first scheme has the problems of inconvenient data management, high development and planning difficulty and the like; the second scheme has the problems of cost increase, low storage capacity, inconvenience in debugging and the like.
Disclosure of Invention
In view of the foregoing, there is a need to provide a device data storage method, apparatus, computer device, computer readable storage medium and computer program product capable of facilitating storage of device data.
In a first aspect, the present application provides a device data storage method, including:
receiving a device data configuration instruction;
configuring corresponding equipment data according to the equipment data configuration instruction;
acquiring and updating associated data corresponding to the equipment data;
and writing the equipment data and the associated data into a relational database.
In one embodiment, before the receiving the device data configuration instruction, the method further includes:
receiving a test scene creating instruction, creating a test scene based on the test scene creating instruction, and acquiring system parameters corresponding to the test scene;
the writing the device data and the associated data into a relational database includes:
and writing the test scene, the system parameters, the equipment data and the associated data into a relational database.
In one embodiment, the method further comprises:
receiving a test scene selection instruction, and determining a corresponding test scene based on the test scene selection instruction;
and acquiring the corresponding system parameters, the equipment data and the associated data from the relational database based on the test scene, and applying the acquired equipment data and the associated data to equipment.
In one embodiment, the writing the device data and the association data into a relational database includes:
acquiring a data table corresponding to the equipment data and the associated data from the relational database;
and storing the equipment data and the associated data into a corresponding data table.
In one embodiment, the writing the device data and the association data into a relational database includes:
encrypting the device data and the associated data;
writing the encrypted device data and the encrypted associated data into a relational database;
the method further comprises the following steps:
reading corresponding equipment data and associated data from the relational database;
decrypting and verifying the encrypted device data and the encrypted associated data;
and applying the decrypted and verified device data and the associated data to the device.
In one embodiment, the method further comprises:
acquiring a newly added file in the equipment;
creating a file based on the newly added file;
updating a file directory index of the relational database based on the created file.
In one embodiment, the method further comprises:
receiving a file processing instruction;
processing the corresponding file in the relational database according to the file processing instruction;
and reading the file directory index, and updating the user file processing list based on the file directory index.
In a second aspect, the present application provides an apparatus for storing device data, the apparatus comprising:
the configuration instruction receiving module is used for receiving a device data configuration instruction;
the configuration module is used for configuring corresponding equipment data according to the equipment data configuration instruction;
the linkage module is used for acquiring and updating the associated data corresponding to the equipment data;
and the storage module is used for writing the equipment data and the associated data into a relational database.
In a third aspect, the present application provides a computer device comprising a memory storing a computer program and a processor implementing the steps of the method in any of the above embodiments when the processor executes the computer program.
In a fourth aspect, the present application provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the method in any of the above-described embodiments.
In a fifth aspect, the present application provides a computer program product comprising a computer program which, when executed by a processor, performs the steps of the method in any of the embodiments described above.
According to the equipment data storage method, the equipment data storage device, the computer equipment, the storage medium and the computer program product, the equipment data can be updated based on the configuration of the user, the coupling linkage is performed, and the equipment data and the associated data are stored in the relational database, so that the storage cost is low, and the relational database can be used for directly calling the data, so that the subsequent calling of the data is more convenient.
Drawings
FIG. 1 is a diagram of an application environment of a device data storage method according to an embodiment;
FIG. 2 is a flow diagram illustrating a method for device data storage in one embodiment;
FIG. 3 is a flow diagram of a warehousing action resulting from a change in user parameters in one embodiment;
FIG. 4 is a flow diagram of a user loading and restoring configuration in one embodiment;
FIG. 5 is a flow diagram that illustrates retrieving and configuring user settings and system settings from a database when a user loads a scene, under an embodiment;
FIG. 6 is a flow diagram that illustrates a user creating a new test scenario and storing configuration information, under an embodiment;
FIG. 7 is a flow diagram that illustrates configuration of option information by a user or vendor in one embodiment;
FIG. 8 is a flow diagram that illustrates reading of option information from a database upon initialization of a device in one embodiment;
FIG. 9 is a schematic diagram of a user performing self-calibration and recording calibration data and information in one embodiment;
FIG. 10 is a diagram illustrating an embodiment of an apparatus for performing engineering calibrations and storing the calibration results and information;
FIG. 11 is a diagram illustrating an embodiment in which a device is initially loaded with all calibration data and applied;
FIG. 12 is a diagram that illustrates a process flow for updating a file index resulting from a user creating a new file, in accordance with an embodiment;
FIG. 13 is a diagram illustrating acceleration by database indexing as a user searches or browses files, in one embodiment;
FIG. 14 is a block diagram of the architecture of a device data store in one embodiment;
FIG. 15 is a diagram showing an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of and not restrictive on the broad application.
The device data storage method provided by the embodiment of the application can be applied to the application environment shown in fig. 1. Where the terminal 102 communicates with the relational database 104 over a network and the device 106 communicates with the database 104 and the terminal 102 over the network. Wherein instances or methods of accessing the database interface are configured in the terminal 102 or the device 106 such that the database interface may be accessed by invoking the instances or methods to manipulate data in the relational database 104. The terminal 102 or the device 106 receives the device data configuration instruction, updates the corresponding device data based on the device data configuration instruction, and then acquires and updates the associated data corresponding to the device data; and finally, writing the equipment data and the associated data into a relational database.
The equipment data storage method can update the equipment data based on the configuration of the user, and is coupled and linked with the associated data associated with the updated equipment data to automatically update the associated data, and the equipment data and the associated data are stored in the relational database, so that the storage cost is low, and the relational database can directly call the data, so that the subsequent data calling is more convenient.
The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices and portable wearable devices, and the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart car-mounted devices, and the like. The portable wearable device can be a smart watch, a smart bracelet, a head-mounted device, and the like. The database 104 may be implemented as a stand-alone database or as a server cluster of multiple databases, where the database 104 is optionally a relational database, such as a SQLite database.
In one embodiment, as shown in fig. 2, a device data storage method is provided, which is described by taking the application of the method to the terminal in fig. 1 as an example, and includes the following steps:
s202: and receiving a device data configuration instruction.
Specifically, the device data configuration instruction may be at least one of a parameter instruction, a calibration parameter configuration instruction, a system parameter configuration instruction, an option information configuration instruction, and a device information configuration instruction, which is configured by a user.
Wherein the user configured parameters may include new measurement parameters, etc. The calibration parameters may include user self-calibration parameters as well as engineering calibration parameters. The system parameters are the configuration of some default parameters etc. in the system of the device. The option information may refer to an option configured by a user or a manufacturer, and the device information may refer to information of a specific device. Therefore, the main body of the device data configuration instruction can be different types of users, and the different types of users configure the device data.
It should be noted that different device data configuration instructions may be received through different pages, for example, creating new device data and updating existing device data may be performed through different pages, and different types of device data may also be configured through different pages, which is not limited herein.
S204: and updating the corresponding equipment data according to the equipment data configuration instruction.
Specifically, when a user configures new device data for a device, the configuration behavior of the user is processed first, that is, the device data in the terminal is updated. That is, the old device data is replaced by the new device data, or the corresponding parameters are newly added and the corresponding parameter values are configured.
S206: and acquiring and updating associated data corresponding to the equipment data.
The associated data corresponds to the device data, a piece of device data configured by a user may cause recalculation and updating of some columns of associated data, and all data to be updated are stored in the relational database again after being updated.
For example, there is an association relationship between parameters corresponding to the device data, so that when a parameter value of one of the parameters changes, parameter values of other parameters also need to change, and after the device data of one of the parameters is configured, the terminal can acquire the association parameter corresponding to the parameter from the relational database, and calculate the association data of the association parameter based on the logical relationship between the parameters and the association parameter, thereby implementing dynamic change.
S208: the device data and the associated data are written to a relational database.
Specifically, after the terminal completes updating the associated data and the device data, the updated device data and the updated associated data are written into the relational database, for example, an interface of the relational database is called, and the device data and the updated associated data are written into the relational database, specifically, into a corresponding data table in the relational database.
It should be noted that, if there are multiple users, multiple sets of configured different device data and associated data may be stored in multiple data tables of the database, for example, the data tables are named by the users and the devices, so that each data table stores the device data and associated data corresponding to the corresponding user and device, optionally, the data tables may further store the device data and associated data set by the same user and the same device at different times in sequence by taking time as an order, so that the device data and associated data recently configured by the user may be displayed according to time when the data is loaded subsequently, in other embodiments, the data tables may further include scene information and the like, so that the user may automatically switch to the device data and associated data most frequently used by the user according to different functional scenes.
Specifically, referring to fig. 3 and fig. 4, fig. 3 is a flowchart illustrating a warehousing action caused by a variation in user parameters in one embodiment, and fig. 4 is a flowchart illustrating a configuration loading and restoring process performed by a user in one embodiment. Where fig. 3 can be regarded as adding new parameters, and fig. 4 can be regarded as modifying or updating existing parameters. For fig. 3, the terminal creates a new parameter based on the configuration of the user, then assigns a value to the parameter value, acquires the associated parameter based on the coupling linkage, updates the parameter value of the associated parameter, and updates the associated parameter to the relational database after the update is completed. In fig. 4, the terminal loads the required parameters based on the configuration of the user, reads the corresponding parameter values from the relational database, configures new parameter values, performs coupling linkage based on the new parameter values, corrects the parameter values of the associated parameters, and updates the parameter values to the relational database after the correction is completed.
The equipment data storage method can update the equipment data based on the configuration of the user, carry out coupling linkage, and store the equipment data and the associated data into the relational database, so that the storage cost is low, and the relational database can directly carry out data calling, so that the subsequent data calling is more convenient.
In one embodiment, before receiving the device data configuration instruction, the method further includes receiving a test scenario creation instruction, creating a test scenario based on the test scenario creation instruction, and acquiring a system parameter corresponding to the test scenario; writing device data and associated data into a relational database, comprising: and writing the test scene, the system parameters, the equipment data and the associated data into a relational database.
In one embodiment, the method further includes: receiving a test scene selection instruction, and determining a corresponding test scene based on the test scene selection instruction; and acquiring corresponding system parameters, equipment data and associated data from the relational database based on the test scene, and applying the acquired equipment data and associated data to the equipment.
Specifically, in this embodiment, when the user needs to switch the usage scenario or switch the user, the last usage scenario may be loaded back from the saved parameter configuration table, for example, each table in the relational database may record all parameters and configuration information in a set of usage scenarios, including window status, vertical information, horizontal information, measurement items, and the like; the user can select the application scenes which are commonly used by the user or used last time from the 'recent scenes' and quickly call out the parameters to restore the use environment.
With reference to fig. 5 and 6, fig. 5 is a flowchart illustrating that user settings and system settings are retrieved from a database and configured when a user loads a scene in one embodiment, and fig. 6 is a flowchart illustrating that a user creates a new test scene and stores configuration information in one embodiment, in fig. 5, a terminal receives a test scene selection instruction, and establishes a connection relationship with a relational database, so as to obtain device data from a data table corresponding to the relational database, and apply the obtained device data to a corresponding device, so that a subsequent user can use the device to perform test measurement. The obtaining of the device data from the data table corresponding to the relational database may be obtaining the device data from the data table corresponding to the relational database based on data of a user, a device, and the like.
With reference to fig. 6, the user creates a new scenario and configures device data corresponding to the new test scenario, where the device data includes parameters set by the user and system parameters, and then the terminal establishes a connection relationship between the terminal and the relational database, and stores the new test scenario, the parameters set by the user, and the system parameters in the relational database.
In one embodiment, writing the device data and the associated data to the relational database comprises: acquiring a data table corresponding to the equipment data and the associated data from the relational database; and storing the equipment data and the associated data into a corresponding data table.
Different device data and associated data are stored in different data tables in the database, for example, different types of data are stored in different data tables, and a plurality of scattered data sets including configuration parameters, user data, calibration data, product data and the like are respectively stored in different data tables.
In addition, it should be noted that if parameters, data, configuration, and the like need to be debugged, the entire system can be maintained and debugged conveniently only by connecting a tool to the relational database or copying the database, that is, the relational database in this embodiment can support copying of user configuration data to the outside of the device or directly performing remote connection of the database, so as to achieve direct access to the database, thereby performing more convenient debugging and configuration work.
In one embodiment, writing the device data and the associated data to a relational database comprises: encrypting the device data and the associated data; writing the encrypted equipment data and the encrypted associated data into a relational database; the method further comprises the following steps: reading corresponding equipment data and associated data from the relational database; carrying out decryption verification on the encrypted equipment data and the encrypted associated data; and applying the decrypted and verified device data and the associated data to the device.
Specifically, in the present embodiment, in order to ensure the security of the device data and the associated data, the device data and the associated data are encrypted, wherein the device data and the associated data may be option information, calibration information, and the like.
Specifically, referring to fig. 7 to 8, fig. 7 is a flowchart illustrating option information configuration performed by a user or a manufacturer in one embodiment, and fig. 8 is a flowchart illustrating an option information reading from a database when a device is initialized in one embodiment, in fig. 7, a terminal receives an option information configuration instruction of the user or the manufacturer, acquires configured option information based on the option information configuration instruction, encrypts the option information, establishes a connection relationship between the terminal and a relational database, and stores the encrypted option information in a corresponding data table of the relational database, for example, in an option database table. When the equipment is initialized, the process of reading the option information by the terminal comprises the steps of establishing the connection of the database, reading the encrypted option information from the option data table of the relational database, decrypting and verifying the encrypted option information, and applying the encrypted option information to the equipment to realize the initialization of the equipment.
Specifically, referring to fig. 9 to 11, fig. 9 is a schematic diagram of a user performing self-calibration and recording calibration data and information in an embodiment, fig. 10 is a schematic diagram of a device performing engineering calibration and storing calibration results and information in an embodiment, and fig. 11 is a schematic diagram of a device initializing, loading all calibration data and applying in an embodiment.
Referring to fig. 9, a user performs self-calibration on the device, so that the terminal obtains self-calibration data of the device and establishes a connection with the relational database, and the self-calibration data and the log are stored in a user calibration table of the relational database, so as to apply data to the device subsequently.
Referring to fig. 10, the process of engineering calibration is shown, where a terminal acquires engineering calibration data of a device and establishes a connection with a relational database, so that the engineering calibration data and a log are stored in an engineering calibration table of the relational database, so as to facilitate subsequent application of data to the device.
Referring to fig. 11, in the process of reading calibration data during initialization of the device, a connection relationship with the relational database is established first, then the engineering calibration data is read, the engineering calibration data is decrypted and applied to the device, then the self-calibration data of the user is read, and the self-calibration data is applied to the device.
In one embodiment, the method further includes: acquiring a newly added file in the equipment; creating a file based on the newly added file; the file directory index of the relational database is updated based on the created file.
In one embodiment, the method further includes: receiving a file processing instruction; processing the corresponding file in the relational database according to the file processing instruction; and reading the file directory index, and updating the user file processing list based on the file directory index.
Specifically, in this embodiment, a function of storing a file index is mainly described, where as shown in fig. 12 and 13, fig. 12 is a schematic diagram of a file index update flow caused by a user creating a new file in one embodiment, and fig. 13 is a schematic diagram of acceleration performed by a database index when the user searches or browses a file in one embodiment.
In FIG. 12, a user stores a file in a device, thereby creating a file in the device, subsequently establishing a connection with a database, and updating a file directory index to the database.
In fig. 13, a user searches or browses a file, and needs to establish a connection between a terminal and a database, so as to read a file index database table, and subsequently update a user file browsing list.
In the above embodiment, the user performs scene switching, new construction, and call-out when operating the device; equipment engineering calibration and user calibration; in file creation and retrieval browsing, data is added, deleted, checked and modified from different libraries and tables by calling a database, and a storage, loading and debugging system of parameters, data, configuration and the like of a digitizer, which has low cost, high efficiency and is convenient for debugging and development, is realized by virtue of a relational database system.
It should be understood that, although the steps in the flowcharts related to the embodiments are shown in sequence as indicated by the arrows, the steps are not necessarily executed in sequence as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in the flowcharts related to the above embodiments may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the steps or stages is not necessarily sequential, but may be performed alternately or alternately with other steps or at least a part of the steps or stages in other steps.
Based on the same inventive concept, the embodiment of the present application further provides an apparatus data storage device for implementing the above-mentioned apparatus data storage method. The implementation scheme for solving the problem provided by the apparatus is similar to the implementation scheme described in the above method, so the specific limitations in one or more device data storage apparatus embodiments provided below may refer to the limitations on the device data storage method in the foregoing, and are not described herein again.
In one embodiment, as shown in fig. 14, there is provided a device data storage apparatus including: a configuration instruction receiving module 1401, a configuration module 1402, a linkage module 1403, and a storage module 1404, wherein:
a configuration instruction receiving module 1401, configured to receive a device data configuration instruction;
a configuration module 1402, configured to update corresponding device data according to the device data configuration instruction;
a linkage module 1403, configured to obtain and update associated data corresponding to the device data;
a storage module 1404 for writing the device data and the associated data into a relational database.
In one embodiment, the device data storage apparatus further includes:
the test scene creating instruction receiving module is used for receiving the test scene creating instruction, creating a test scene based on the test scene creating instruction and acquiring system parameters corresponding to the test scene;
the storage module 1404 is further configured to write the test scenario, the system parameters, the device data, and the associated data into the relational database.
In one embodiment, the device data storage apparatus further includes:
the test scene selection instruction receiving module is used for receiving a test scene selection instruction and determining a corresponding test scene based on the test scene selection instruction;
and the data loading module is used for acquiring corresponding system parameters, equipment data and associated data from the relational database based on the test scene and applying the acquired equipment data and associated data to the equipment.
In one embodiment, the storage module 1404 includes:
the data table determining unit is used for acquiring a data table corresponding to the equipment data and the associated data from the relational database;
and the storage unit is used for storing the equipment data and the associated data into the corresponding data table.
In one embodiment, the storage module 1404 is further configured to encrypt the device data and the associated data; writing the encrypted equipment data and the encrypted associated data into a relational database;
the above-mentioned device data storage apparatus further includes:
the reading module is used for reading corresponding equipment data and associated data from the relational database; carrying out decryption verification on the encrypted equipment data and the encrypted associated data; and applying the decrypted and verified device data and the associated data to the device.
In one embodiment, the device data storage apparatus further includes:
the index creation module is used for acquiring newly added files in the equipment; creating a file based on the newly added file; the file directory index of the relational database is updated based on the created files.
In one embodiment, the device data storage apparatus further includes:
the index processing module is used for receiving a file processing instruction; processing the corresponding file in the relational database according to the file processing instruction; and reading the file directory index, and updating the user file processing list based on the file directory index.
The various modules in the device data storage apparatus described above may be implemented in whole or in part by software, hardware, and combinations thereof. The modules can be embedded in a hardware form or independent of a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 15. The computer apparatus includes a processor, a memory, an input/output interface, a communication interface, a display unit, and an input device. The processor, the memory and the input/output interface are connected by a system bus, and the communication interface, the display unit and the input device are connected by the input/output interface to the system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The input/output interface of the computer device is used for exchanging information between the processor and an external device. The communication interface of the computer device is used for communicating with an external terminal in a wired or wireless manner, and the wireless manner can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program when executed by a processor implements a device data storage method. The display unit of the computer device is used for forming a visual picture and can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the configuration shown in fig. 15 is a block diagram of only a portion of the configuration associated with the present application, and is not intended to limit the computing device to which the present application may be applied, and that a particular computing device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory and a processor, the memory having a computer program stored therein, the processor implementing the following steps when executing the computer program: receiving a device data configuration instruction; updating corresponding equipment data according to the equipment data configuration instruction; acquiring and updating associated data corresponding to the equipment data; the device data and the associated data are written to a relational database.
In one embodiment, before the receiving device data configuration instructions implemented when the processor executes the computer program, the method further comprises: receiving a test scene creating instruction, creating a test scene based on the test scene creating instruction, and acquiring system parameters corresponding to the test scene; writing device data and associated data into a relational database, effected by a processor executing a computer program, comprising: and writing the test scene, the system parameters, the equipment data and the associated data into a relational database.
In one embodiment, the processor, when executing the computer program, further performs the steps of: receiving a test scene selection instruction, and determining a corresponding test scene based on the test scene selection instruction; and acquiring corresponding system parameters, equipment data and associated data from the relational database based on the test scene, and applying the acquired equipment data and associated data to the equipment.
In one embodiment, writing the device data and the associated data to the relational database, as implemented by the processor when executing the computer program, comprises: acquiring a data table corresponding to the equipment data and the associated data from the relational database; and storing the equipment data and the associated data into a corresponding data table.
In one embodiment, writing the device data and the associated data to the relational database, as implemented by the processor when executing the computer program, comprises: encrypting the device data and the associated data; writing the encrypted equipment data and the encrypted associated data into a relational database; the processor, when executing the computer program, further performs the steps of: reading corresponding equipment data and associated data from the relational database; carrying out decryption verification on the encrypted equipment data and the encrypted associated data; and applying the decrypted and verified device data and the associated data to the device.
In one embodiment, the processor, when executing the computer program, further performs the steps of: acquiring a newly added file in the equipment; creating a file based on the newly added file; the file directory index of the relational database is updated based on the created files.
In one embodiment, the processor, when executing the computer program, further performs the steps of: receiving a file processing instruction; processing the corresponding file in the relational database according to the file processing instruction; and reading the file directory index, and updating the user file processing list based on the file directory index.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored which, when executed by a processor, performs the steps of: receiving a device data configuration instruction; updating corresponding equipment data according to the equipment data configuration instruction; acquiring and updating associated data corresponding to the equipment data; the device data and the associated data are written to a relational database.
In one embodiment, the computer program, when executed by the processor, further comprises, prior to receiving the device data configuration instructions: receiving a test scene creating instruction, creating a test scene based on the test scene creating instruction, and acquiring system parameters corresponding to the test scene; writing device data and associated data into a relational database, the writing device data and associated data being implemented when the computer program is executed by a processor, comprising: and writing the test scene, the system parameters, the equipment data and the associated data into a relational database.
In one embodiment, the computer program when executed by the processor further performs the steps of: receiving a test scene selection instruction, and determining a corresponding test scene based on the test scene selection instruction; and acquiring corresponding system parameters, equipment data and associated data from the relational database based on the test scene, and applying the acquired equipment data and associated data to the equipment.
In one embodiment, writing the device data and the associated data to a relational database, implemented when the computer program is executed by a processor, comprises: acquiring a data table corresponding to the equipment data and the associated data from the relational database; and storing the equipment data and the associated data into the corresponding data table.
In one embodiment, writing the device data and the associated data to a relational database, implemented when the computer program is executed by a processor, comprises: encrypting the device data and the associated data; writing the encrypted equipment data and the encrypted associated data into a relational database; the computer program when executed by the processor further realizes the steps of: reading corresponding equipment data and associated data from the relational database; carrying out decryption verification on the encrypted equipment data and the encrypted associated data; and applying the decrypted and verified device data and the associated data to the device.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring a newly added file in the equipment; creating a file based on the newly added file; the file directory index of the relational database is updated based on the created files.
In one embodiment, the computer program when executed by the processor further performs the steps of: receiving a file processing instruction; processing the corresponding file in the relational database according to the file processing instruction; and reading the file directory index, and updating the user file processing list based on the file directory index.
In one embodiment, a computer program product is provided, comprising a computer program which when executed by a processor performs the steps of: receiving a device data configuration instruction; updating corresponding equipment data according to the equipment data configuration instruction; acquiring and updating associated data corresponding to the equipment data; the device data and the associated data are written to a relational database.
In one embodiment, the computer program, when executed by the processor, further comprises, prior to receiving the device data configuration instructions: receiving a test scene creating instruction, creating a test scene based on the test scene creating instruction, and acquiring system parameters corresponding to the test scene; writing device data and associated data into a relational database, the writing device data and associated data being implemented when the computer program is executed by a processor, comprising: and writing the test scene, the system parameters, the equipment data and the associated data into a relational database.
In one embodiment, the computer program when executed by the processor further performs the steps of: receiving a test scene selection instruction, and determining a corresponding test scene based on the test scene selection instruction; and acquiring corresponding system parameters, equipment data and associated data from the relational database based on the test scene, and applying the acquired equipment data and associated data to the equipment.
In one embodiment, writing the device data and the associated data to a relational database, implemented when the computer program is executed by a processor, comprises: acquiring a data table corresponding to the equipment data and the associated data from the relational database; and storing the equipment data and the associated data into a corresponding data table.
In one embodiment, writing the device data and the associated data to the relational database, as performed by the computer program when executed by the processor, includes: encrypting the device data and the associated data; writing the encrypted equipment data and the encrypted associated data into a relational database; the computer program when executed by the processor further realizes the steps of: reading corresponding equipment data and associated data from the relational database; carrying out decryption verification on the encrypted equipment data and the encrypted associated data; and applying the decrypted and verified device data and the associated data to the device.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring a newly added file in equipment; creating a file based on the newly added file; the file directory index of the relational database is updated based on the created files.
In one embodiment, the computer program when executed by the processor further performs the steps of: receiving a file processing instruction; processing the corresponding file in the relational database according to the file processing instruction; and reading the file directory index, and updating the user file processing list based on the file directory index.
It should be noted that, the user information (including but not limited to user equipment information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, displayed data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party, and the collection, use and processing of the related data need to comply with the relevant laws and regulations and standards of the relevant country and region.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high-density embedded nonvolatile Memory, resistive Random Access Memory (ReRAM), magnetic Random Access Memory (MRAM), ferroelectric Random Access Memory (FRAM), phase Change Memory (PCM), graphene Memory, and the like. Volatile Memory can include Random Access Memory (RAM), external cache Memory, and the like. 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), among others. The databases referred to in various embodiments provided herein may include at least one of relational and non-relational databases. The non-relational database may include, but is not limited to, a block chain based distributed database, and the like. The processors referred to in the various embodiments provided herein may be, without limitation, general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic devices, quantum computing-based data processing logic devices, or the like.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present application. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present application shall be subject to the appended claims.

Claims (10)

1. A method for storing device data, the method comprising:
receiving a device data configuration instruction;
configuring corresponding equipment data according to the equipment data configuration instruction;
acquiring and updating associated data corresponding to the equipment data;
and writing the equipment data and the associated data into a relational database.
2. The method of claim 1, wherein before receiving the device data configuration instruction, further comprising:
receiving a test scene creating instruction, creating a test scene based on the test scene creating instruction, and acquiring system parameters corresponding to the test scene;
the writing the device data and the associated data into a relational database includes:
and writing the test scene, the system parameters, the equipment data and the associated data into a relational database.
3. The method of claim 1, further comprising:
receiving a test scene selection instruction, and determining a corresponding test scene based on the test scene selection instruction;
and acquiring the corresponding system parameters, the equipment data and the associated data from the relational database based on the test scene, and applying the acquired equipment data and the associated data to equipment.
4. The method of claim 1, wherein writing the device data and the association data to a relational database comprises:
acquiring a data table corresponding to the equipment data and the associated data from the relational database;
and storing the equipment data and the associated data into a corresponding data table.
5. The method of claim 1, wherein writing the device data and the association data to a relational database comprises:
encrypting the device data and the associated data;
writing the encrypted device data and the encrypted associated data into a relational database;
the method further comprises the following steps:
reading corresponding equipment data and associated data from the relational database;
decrypting and verifying the encrypted device data and the encrypted associated data;
and applying the decrypted and verified device data and the associated data to the device.
6. The method according to any one of claims 1 to 5, further comprising:
acquiring a newly added file in the equipment;
creating a file based on the newly added file;
updating a file directory index of the relational database based on the created file.
7. The method of claim 6, further comprising:
receiving a file processing instruction;
processing the corresponding file in the relational database according to the file processing instruction;
and reading the file directory index, and updating the user file processing list based on the file directory index.
8. An apparatus for storing device data, the apparatus comprising:
the configuration instruction receiving module is used for receiving a device data configuration instruction;
the configuration module is used for configuring corresponding equipment data according to the equipment data configuration instruction;
the linkage module is used for acquiring and updating the associated data corresponding to the equipment data;
and the storage module is used for writing the equipment data and the associated data into a relational database.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
CN202310064410.1A 2023-01-13 2023-01-13 Equipment data storage method, device, computer equipment and medium Pending CN115952136A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310064410.1A CN115952136A (en) 2023-01-13 2023-01-13 Equipment data storage method, device, computer equipment and medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310064410.1A CN115952136A (en) 2023-01-13 2023-01-13 Equipment data storage method, device, computer equipment and medium

Publications (1)

Publication Number Publication Date
CN115952136A true CN115952136A (en) 2023-04-11

Family

ID=87287546

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310064410.1A Pending CN115952136A (en) 2023-01-13 2023-01-13 Equipment data storage method, device, computer equipment and medium

Country Status (1)

Country Link
CN (1) CN115952136A (en)

Similar Documents

Publication Publication Date Title
US20180107725A1 (en) Data Storage Method and Apparatus, and Data Read Method and Apparatus
CN110022558B (en) Method for encrypting and decrypting upgrade package, electronic device and storage medium
CN114115844A (en) Page generation method and device, computer equipment and storage medium
CN112416710A (en) User operation recording method and device, electronic equipment and storage medium
US20150186060A1 (en) Selective disk volume cloning for virtual disk creation
CN116628773A (en) Data processing method, device, electronic equipment and storage medium
CN112148709A (en) Data migration method, system and storage medium
CN115952136A (en) Equipment data storage method, device, computer equipment and medium
JP4866858B2 (en) Data processing apparatus and processing method
CN115878655A (en) Data operation method and device, computer equipment and storage medium
CN104615941A (en) Fast encryption method and device for Android user partition and terminal equipment
CN114792016A (en) Processing method and electronic equipment
CN115221852A (en) Vxe-table based dynamic calculation table implementation method, device and computer equipment
CN115017543A (en) Flash memory data reading method and device, computer equipment and storage medium
CN114327435A (en) Technical document generation method and device and computer readable storage medium
CN112835886A (en) Data table field adding method and device
US20210141771A1 (en) Method of managing files by mobile device and mobile device for implementing the same
US20210097028A1 (en) Information Processing Apparatus And Information Processing System
CN117389989A (en) Data synchronization method, apparatus, computer device, storage medium, and program product
CN114528045B (en) Plug-in operation method, device, computer equipment and storage medium
CN118193083A (en) Software resource loading method and device, computer equipment and storage medium
CN115437935A (en) Test case generation method and device, computer equipment and storage medium
CN114647630A (en) File synchronization method, information generation method, file synchronization device, information generation device, computer equipment and storage medium
CN116774909A (en) Method for writing data partition and electronic equipment
CN115510130A (en) Report generation method and device, computer equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination