CN114428815A - Data storage method, apparatus, electronic device and computer readable medium - Google Patents

Abstract

Embodiments of the present disclosure disclose data storage methods, apparatuses, electronic devices, and computer-readable media. A specific implementation of the method includes: receiving data information to be stored in the database, wherein the data information to be stored is user identity information to be stored in the target database; performing data verification on the data information to be stored to generate a database In response to the above-mentioned verification result, it indicates that the above-mentioned data information to be entered into the warehouse has passed the data verification, and the above-mentioned data to be entered into the warehouse is stored in the data table of the above-mentioned target database; If the information does not pass the data verification, abnormal prompt information is generated; the above abnormal prompt information is displayed on the display interface, so that the target user can modify the above-mentioned data information to be stored in the warehouse. This implementation ensures the accuracy and integrity of the data during the data storage process.

Description

Data storage method, apparatus, electronic device and computer readable medium

technical field

Embodiments of the present disclosure relate to the field of computer technology, and in particular, to data storage methods, apparatuses, electronic devices, and computer-readable media.

Background technique

Data storage refers to a technology that operates on a database to store data in the data tables of the database. At present, when storing data, the usual method is to perform operations on the data table one by one to input data. For example, when the data to be stored is in multiple data tables, it is necessary to operate on each data table in turn.

However, when using the above method for data storage, there are often the following technical problems:

First, data verification is not performed before data storage, so the accuracy and integrity of the data cannot be guaranteed;

Second, it is impossible to operate on multiple data tables in a unified manner, and the consistency of data cannot be guaranteed;

Third, the field length, value range, and data type of the data are not checked before the data is stored, and the accuracy of the field length, data value, and data type of the data cannot be guaranteed;

Fourth, the data is not checked for sensitive words before data storage, which makes it impossible to confirm whether the data contains sensitive words, so that the accuracy of the data stored in the database cannot be guaranteed.

SUMMARY OF THE INVENTION

This summary of the disclosure serves to introduce concepts in a simplified form that are described in detail in the detailed description that follows. The content section of this disclosure is not intended to identify key features or essential features of the claimed technical solution, nor is it intended to be used to limit the scope of the claimed technical solution. Some embodiments of the present disclosure propose data storage methods, apparatuses, electronic devices, and computer-readable media to solve the technical problems mentioned in the background section above.

In a first aspect, some embodiments of the present disclosure provide a data storage method, the method includes: receiving data information to be stored in a database, wherein the data information to be stored in a database is user identity information to be stored in a target database; Data verification is performed on the data information to be stored to generate a verification result; in response to the verification result indicating that the data information to be stored has passed the data verification, the data information to be stored is stored in the data table of the target database. ; In response to the above-mentioned verification result indicating that the above-mentioned data information to be stored in the warehouse has not passed the data verification, generate abnormal prompt information; display the above-mentioned abnormal prompt information on the display interface for the target user to modify the above-mentioned data information to be stored in the warehouse.

In a second aspect, some embodiments of the present disclosure provide a data storage device, the device includes: a receiving unit configured to receive data information to be stored in a database, wherein the data information to be stored in a database is a user to be stored in a target database identity information; a verification unit, configured to perform data verification on the above-mentioned data information to be stored in order to generate a verification result; a storage unit, configured to respond to the above verification result to indicate that the above-mentioned data information to be stored has passed the data verification. verification, storing the above-mentioned data information to be stored in the data table of the above-mentioned target database; the information prompting unit is configured to, in response to the above-mentioned verification result, represent that the above-mentioned data information to be stored in the warehouse has not passed the data verification, and generate abnormal prompt information; The display unit is configured to display the abnormal prompt information on the display interface, so that the target user can modify the data information to be stored in the warehouse.

In a third aspect, some embodiments of the present disclosure provide an electronic device, comprising: one or more processors; a storage device on which one or more programs are stored, when one or more programs are stored by one or more The processor executes, causing one or more processors to implement the method described in any implementation manner of the above first aspect.

In a fourth aspect, some embodiments of the present disclosure provide a computer-readable medium on which a computer program is stored, wherein, when the program is executed by a processor, the method described in any implementation manner of the above-mentioned first aspect is implemented.

The above-mentioned embodiments of the present disclosure have the following beneficial effects: data storage is performed through the data storage methods of some embodiments of the present disclosure, thereby improving the accuracy and integrity of the data. Specifically, the reason for low data accuracy and integrity is that data verification is not performed before data storage. Based on this, the data storage methods of some embodiments of the present disclosure include: first, receiving data information to be stored. Then, data verification is performed on the data information to be stored to generate a verification result, and the data is verified to be accurate and valid through data verification. Secondly, in response to the verification result indicating that the data information to be stored has passed the data verification, the data information to be stored is stored in the data table of the target database. Next, in response to the verification result indicating that the data information to be stored has failed the data verification, abnormal prompt information is generated. Finally, the abnormal prompt information is displayed on the display interface for the target user to modify the data information to be stored. Therefore, by adding a data verification step, the accuracy and integrity of the data can be effectively guaranteed.

Description of drawings

The above and other features, advantages and aspects of various embodiments of the present disclosure will become more apparent when taken in conjunction with the accompanying drawings and with reference to the following detailed description. Throughout the drawings, the same or similar reference numbers refer to the same or similar elements. It should be understood that the drawings are schematic and that elements and elements are not necessarily drawn to scale.

1 is a schematic diagram of an application scenario of a data storage method according to some embodiments of the present disclosure;

2 is a flowchart of some embodiments of data storage methods according to the present disclosure;

3 is a schematic structural diagram of some embodiments of a data storage device according to the present disclosure;

4 is a schematic structural diagram of an electronic device suitable for implementing some embodiments of the present disclosure.

Detailed ways

Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided for a thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes, and are not intended to limit the protection scope of the present disclosure.

In addition, it should be noted that, for the convenience of description, only the parts related to the related invention are shown in the drawings. The embodiments of this disclosure and features of the embodiments may be combined with each other without conflict.

It should be noted that concepts such as "first" and "second" mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order of functions performed by these devices, modules or units or interdependence.

It should be noted that the modifications of "a" and "a plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless the context clearly indicates otherwise, they should be understood as "one or a plurality of". multiple".

The names of messages or information exchanged between multiple devices in the embodiments of the present disclosure are only for illustrative purposes, and are not intended to limit the scope of these messages or information.

The present disclosure will be described in detail below with reference to the accompanying drawings and in conjunction with embodiments.

FIG. 1 is a schematic diagram of an application scenario of data storage methods according to some embodiments of the present disclosure.

In the application scenario of FIG. 1 , first, in step 102 , the information generating terminal may send the information 103 of the data to be stored. Then, in step 104, the data processing terminal in the computing device 101 may receive the information 103 of the data to be stored. Next, in step 105, the above-mentioned data processing terminal may perform data verification on the data information 103 to be stored in the database to generate a verification result. Next, in step 106, the data processing terminal may store the data information 103 to be stored in the data table of the target database in response to the verification result indicating that the data information 103 to be stored has passed the data verification. Afterwards, in step 107, the data processing terminal may generate abnormality prompt information 108 in response to the above verification result indicating that the above-mentioned data information 103 to be stored in the warehouse has not passed the data verification. Finally, in step 109, the display terminal may display abnormality prompt information 108 on the display interface for the target user to modify the data information 103 to be stored in the warehouse.

It should be noted that the above computing device 101 may be hardware or software. When the computing device is hardware, it can be implemented as a distributed cluster composed of multiple servers or terminal devices, or can be implemented as a single server or a single terminal device. When a computing device is embodied as software, it may be installed in the hardware devices listed above. It can be implemented, for example, as multiple software or software modules for providing distributed services, or as a single software or software module. There is no specific limitation here.

It should be understood that the number of computing devices in FIG. 1 is merely illustrative. There may be any number of computing devices depending on implementation needs.

With continued reference to FIG. 2, a flow 200 of some embodiments of data storage methods according to the present disclosure is shown. The data storage method includes the following steps:

Step 201: Receive data information to be stored in the warehouse.

In some embodiments, the execution body of the data storage method (for example, the computing device 101 shown in FIG. 1 ) may receive the above-mentioned data information to be stored in the database through a wired connection or a wireless connection. The data information to be stored may be user identity information to be stored in a target database, the target database may be a database storing user identity information, and the user identity information may be information representing user identity. For example, the above target database may be a MySQL database.

As an example, the above-mentioned data information to be stored may include a user name, a user ID, and an institution ID. Wherein, the above-mentioned user number is a number that represents the uniqueness of the user, and the above-mentioned institution number is a number that represents the institution where the user is located. For example, the above data information to be stored may be {user name: Zhang XX, user ID: 0001, institution ID: A001}.

Step 202: Perform data verification on the data information to be stored to generate a verification result.

In some embodiments, the above-mentioned execution body may perform data verification on the above-mentioned data information to be stored in the database, so as to generate the above-mentioned verification result. Wherein, the above verification result may be a result representing whether the above-mentioned data information to be stored in the database passes the data verification.

As an example, the above-mentioned execution body may perform data duplication verification on the above-mentioned data information to be stored in the database, so as to perform data verification on the above-mentioned data information to be stored in the database, so as to generate the above-mentioned verification result. The execution body may compare the data information to be stored in the database with the data stored in the data table in the target database, and in response to the data table in the target database having the same data as the data information to be stored, generate Indicates the verification result that the above-mentioned data information to be stored is repeated. In response to the fact that the data table in the target database does not have the same data as the data information to be stored in the database, a verification result indicating that the data information to be stored in the database is not repeated is generated. For example, the above data information to be stored may be {user name: Zhang XX, user ID: 0001, institution ID: A001}.

In some optional implementations of some embodiments, the above verification result may include: a target verification result set. Wherein, the target verification result in the target verification result set may be used to represent whether the above-mentioned data information passes the data missing verification. The above-mentioned execution body performs data verification on the above-mentioned data information to be stored in the database to generate a verification result, which may include the following steps:

The first step is to perform field analysis on the above-mentioned data information to be stored to generate a data information set.

Wherein, the data information in the above-mentioned data information set may be information obtained by performing field analysis on the above-mentioned data information to be stored in the database. The above-mentioned execution body can identify the fields and the values corresponding to the fields in the above-mentioned data information to be stored in the database, so as to obtain the data information, so as to generate the above-mentioned data information set. For example, the above data information may be {username: Zhang XX}.

In the second step, data missing check is performed on each data information in the above-mentioned data information set to generate a target verification result corresponding to the above-mentioned data information, and the above-mentioned target verification result set is obtained.

The execution body may compare the length of the data information with the target length, and in response to that the length of the data information is not equal to the target length, generate a verification result indicating that the data information has passed the data missing check, so as to obtain the target Check the result. The above-mentioned target length may be the data length that characterizes the absence of data.

As an example, the above-mentioned data information may be {username: Zhang San}, and the above-mentioned target length may be 0 bytes.

In the third step, the data length of the above data information is determined to obtain the data length information.

The above-mentioned data length information may be information representing the data length.

As an example, the above data information may be {username: Zhang San}, and the data length is 4 bytes.

In the fourth step, in response to determining that the data length of the data length information indicates that the data length of the data information is consistent with the target length, the check result representing the data missing is determined as the target check result corresponding to the data information.

Wherein, in response to determining that the data length information indicates that the data length of the data information is consistent with the target length, the execution body may determine the verification result representing the missing data as the target verification result corresponding to the data information.

As an example, the above data information may be {username: ""}, and the data length is 0 bytes.

In some optional implementations of some embodiments, the foregoing verification result may further include: a first verification result set, a second verification result set, and a third verification result set. The above-mentioned execution body performs data verification on the data information to be stored in the database to generate a verification result, and may further include the following steps:

The first data verification step is performed for each data information in the above-mentioned data information set:

In the first sub-step, field length verification is performed on the data information to generate a verification result corresponding to the data information, and a first verification result is obtained.

The above-mentioned first verification result may be used to represent whether the above-mentioned data information passes the field length verification. The execution body may compare the length of the data information with the preset length, and in response to the length of the data information being less than the preset length, generate a verification result indicating that the data information has passed the field length verification, so as to obtain the first verification result. . The preset length may be the maximum length of the corresponding field of the data information in the data table of the target database.

In the second sub-step, a value range check is performed on the data information to generate a check result corresponding to the data information, and a second check result is obtained.

The above-mentioned second verification result may be used to represent whether the above-mentioned data information passes the value range verification. The above-mentioned execution body may compare the value of the above-mentioned data information with the preset value range of the data table in the above-mentioned target database, and in response to the value of the above-mentioned data information being within the preset value range, generate a value indicating that the above-mentioned data information passes through. The verification result of the value range verification is used to obtain the above-mentioned second verification result. The preset value range may be the value range of the corresponding field of the data information in the data table of the target database.

In the third sub-step, data type verification is performed on the data information to generate a verification result corresponding to the data information, and a third verification result is obtained.

Wherein, the above-mentioned third verification result may be used to represent whether the above-mentioned data information passes the data type verification. The above-mentioned execution body may compare the data type of the above-mentioned data information with the preset data type, and in response to the data type of the above-mentioned data information being consistent with the above-mentioned preset data type, generate a verification result indicating that the above-mentioned data information has passed the data type verification. , to obtain the third verification result above. The preset data type may be the data type of the corresponding field of the data information in the data table of the target database.

The above-mentioned first data verification step and its related content, as an invention point of the embodiments of the present disclosure, solve the technical problem three mentioned in the background art: “The field length, value range and data type are not verified on the data before the data is stored. It cannot guarantee the accuracy of the field length, data value and data type of the data”. Because the field length, value range, and data type of the data are not checked before data storage, the accuracy of the field length, data value, and data type of the data cannot be guaranteed. Therefore, verifying the field length, value range and data type of the data before data storage can ensure the accuracy of the field length, data value and data type of the data. In order to ensure the accuracy of the field length, data value and data type of the data, first, perform field analysis on the above-mentioned data information to be stored to generate a data information set. In actual situations, the data information to be stored often contains values corresponding to different fields, and the field lengths, value ranges and data types of different fields are often different. Therefore, it is necessary to perform field analysis on the data to be stored. Then, the field length check is performed on the data information to generate a first check result. In practice, the field length of the value corresponding to the field is often a preset value. When the length of the value corresponding to the field is greater than the preset value corresponding to the field, the value corresponding to the field cannot be stored in the database normally, resulting in data storage failure. . Secondly, the value range verification is performed on the data information to generate a second verification result. In practice, the size of the value corresponding to the field is often within the preset value range. When the size of the value corresponding to the field is outside the preset value range, the value corresponding to the field cannot be stored in the database normally, which in turn leads to Data storage failed. Next, data type verification is performed on the data information to generate a third verification result. In practice, the data type of the value corresponding to the field is often the same as the preset data type. When the data type of the value corresponding to the field is inconsistent with the preset data type, the value corresponding to the field cannot be stored in the database normally, which in turn leads to data storage. fail. Thus, the field length, value range and data type verification of the data is completed, and the accuracy of the field length, data value and data type of the data is ensured.

Optionally, the above verification result may further include: a fourth verification result set. The fourth verification result in the fourth verification result set may be used to represent whether the above-mentioned data information passes the sensitive word verification. The above-mentioned execution body performs data verification on the data information to be stored in the database to generate a verification result, and may further include the following steps:

For each data information in the above-mentioned data information set, a second data verification step is performed:

In the first sub-step, the above data information is matched with each sensitive word in the sensitive word database to generate a sensitive word matching result, and a set of sensitive word matching results is obtained.

Wherein, the above-mentioned sensitive word matching result can be used to represent whether the above-mentioned data information has sensitive words, and the above-mentioned sensitive word database can be a data file containing a plurality of sensitive words. The above-mentioned execution body may match the data in the above-mentioned data information with each sensitive word in the sensitive thesaurus, and in response to the data in the above-mentioned data information matching the sensitive words in the above-mentioned sensitive thesaurus, generate a representation of the existence of the above-mentioned data information. Sensitive word matching results for sensitive words.

As an example, the above data information may be {username: Zhang XX}. The above sensitive word database may be a data table in a MySQL database containing multiple sensitive words.

In the second sub-step, in response to the data in the data information not matching the sensitive words in the sensitive thesaurus, generating a sensitive word matching result indicating that the data information does not have the sensitive words.

In the third sub-step, in response to the presence of the target sensitive word matching result in the above-mentioned sensitive word matching result set, the above-mentioned target sensitive word matching result is determined as the fourth verification result corresponding to the above-mentioned data information.

The above target sensitive word matching result indicates that the above data information contains sensitive words.

The above-mentioned first sub-step-third sub-step and their related contents are an invention point of the embodiments of the present disclosure, and solve the technical problem mentioned in the background art four "before data storage, the data is not checked for sensitive words, resulting in inability to Confirm whether the data contains sensitive words, so that the accuracy of the data stored in the database cannot be guaranteed”. Because the data is not checked for sensitive words before data storage, it is impossible to confirm whether the data contains sensitive words, so the accuracy of the data stored in the database cannot be guaranteed. Therefore, by performing sensitive word verification on the data before data storage, it can be confirmed whether the data contains sensitive words, thereby ensuring the accuracy of the data stored in the database. In order to ensure the accuracy of the data, first, the above data information is matched with each sensitive word in the sensitive word database to generate a sensitive word matching result, and a set of sensitive word matching results is obtained. In actual situations, there may be sensitive words in the values corresponding to the fields in the data information. When the values corresponding to the fields in the data information match the sensitive words in the sensitive thesaurus, the values corresponding to the fields in the data information cannot be stored in the database normally. , which in turn causes the storage to fail. Then, in response to the data in the above-mentioned data information not matching the sensitive words in the above-mentioned sensitive word database, a sensitive word matching result indicating that the above-mentioned data information does not exist in the sensitive word is generated. Thus, it is confirmed that no sensitive words exist in the data information. Finally, in response to the presence of the target sensitive word matching result in the above-mentioned sensitive word matching result set, the above-mentioned target sensitive word matching result is determined as the fourth verification result corresponding to the above-mentioned data information. Thus, the sensitive word verification is completed on the data to confirm whether the data contains sensitive words, thereby ensuring the accuracy of the data stored in the database.

Step 203 , in response to the verification result indicating that the data information to be stored has passed the data verification, the data information to be stored is stored in the data table of the target database.

In some embodiments, the execution body may store the data information to be stored in a data table of the target database in response to the verification result indicating that the data information to be stored has passed data verification.

As an example, the execution body may, in response to the verification result indicating that the data information to be stored in the database has passed the data verification, save the data information in the data information to be stored in the data table of the target database. For example, the data table of the above target database may be a user information table in a MySQL database. The above data information to be stored may be {user name: Zhang XX, user number: 0001, institution number: A001, store number: A1}.

In some optional implementations of some embodiments, the execution body, in response to the verification result indicating that the data information to be stored in the database has passed the data verification, stores the data information to be stored in the data table of the target database, The following steps can be included:

The first step is to generate a database insert statement corresponding to the above-mentioned data information to be stored in the database.

Wherein, the above-mentioned execution body may generate a database insert statement according to the above-mentioned data information to be stored in the database.

As an example, the database insert statement corresponding to the above-mentioned data information to be stored in the database may be a MySQL insert statement with the data information to be stored into the database. For example, the above database insert statement may be: INSERT INTO first data table (userNo, vendorNo, orgNo, userName) VALUES (0001, A1, A101, "Zhang San").

In the second step, the above-mentioned database insertion statement is executed to store the above-mentioned data information to be stored in the data table of the above-mentioned target database.

Wherein, the data tables of the target database may include: a first data table, a second data table, a third data table, a fourth data table, a fifth data table, a sixth data table and a seventh data table. The execution body may run the database insertion statement to identify the data information in the database insertion statement, so as to store the data information to be stored in the data table of the target database.

As an example, the first data table may be a user information table. Wherein, the above-mentioned user information table is used to represent the user's basic information and store information, and the fields of the above-mentioned user information table may include: user name, user number, store number and institution number. The above-mentioned institution number may be a unique number representing the institution where the user is located, and the above-mentioned store number may be a unique number representing the store to which the user belongs. The second data table may be an organization table. Wherein, the above-mentioned institution table is used to represent the basic information of the institution in the store, and the fields of the above-mentioned institution table may include: institution number, institution name and store number. Among them, the institution name can be used to represent the names of different institutions under the store. The third data table may be a job table. Wherein, the above-mentioned job table is used to represent the basic information of the jobs held by users in the store, and the fields of the above-mentioned job table may include: job ID, store ID, job name and standard job code. Wherein, the above-mentioned job number can be a serial number representing the job held by the user, the above-mentioned job name can be used to represent the name of the job held by the user, and the above-mentioned standard job code can be a unique code used to identify the job held by the user. The fourth data table may be a job table. The above job table is used to represent the basic information of user positions under different positions in different institutions in the store, and the fields of the above job table may include: job ID, store ID, agency ID, agency name, and job ID. Wherein, the above-mentioned post number may be a unique number used to characterize the post. The fifth data table may be a job relationship table. Wherein, the above-mentioned job relationship table is used to represent the position and position held by the user, and the fields of the above-mentioned job relationship table may include: post number, user number, and job number. The sixth data table may be a reporting relationship table. Wherein, the above-mentioned reporting relationship table is used to represent the information of the user and the superior user to which the user belongs, and the fields of the above-mentioned reporting relationship table may include the user ID and the superior user ID. The above-mentioned superior user number is used to represent the uniqueness of the superior user, and the above-mentioned superior user may be the superior of the above-mentioned user. The seventh data table may be a post relationship table. Wherein, the above-mentioned post relationship table is used to represent the information of the post and the superior position to which the post belongs, and the fields of the above-mentioned post relationship table may include: the post number and the superior post number. Wherein, the above-mentioned superior position number is used to represent the uniqueness of the superior position, and the above-mentioned superior position may be the superior of the above-mentioned position. Wherein, the above-mentioned user number may be the primary key in the above-mentioned user information table, or may be a foreign key in the above-mentioned reporting relationship table and the above-mentioned job relationship table. The above post number may be the primary key of the above post table, or may be the foreign key of the above job relationship table and post relationship table.

Optionally, the data table of the target database may include: a first data table. Wherein, the above-mentioned first data table may be a user information table. The above-mentioned execution body stores the above-mentioned data information to be stored in the data table of the above-mentioned target database, and may include the following steps:

The first step is to generate the target database insert statement. Wherein, the above-mentioned target database insert statement may be a target database insert statement with data information to be stored in the database.

As an example, the above-mentioned execution body may generate a target database insert statement according to the above-mentioned information about the data to be stored in the database. For example, the above database insert statement may be: INSERT INTO first data table (userNo, vendorNo, orgNo, userName) VALUES (0001, A1, A101, "Zhang San").

In the second step, the above-mentioned target database insert statement is executed to store the above-mentioned data information to be stored in the first data table included in the above-mentioned target database.

As an example, the execution body runs the target database insert statement to store the data information to be stored in the first data table included in the target database, which may include the following sub-steps:

In the first sub-step, the execution body runs the target database insert statement to store the data information to be stored in the first data table included in the target database. For example, the above executive body may store {user name: Zhang XX, user ID: 0001, institution ID: A101, store ID: A1} into the first data table.

In the second sub-step, based on the trigger and the user number, the sixth data table and the seventh data table are operated.

As an example, the above-mentioned executive body may detect that the user information table completes data storage in response to the above-mentioned trigger, and simultaneously performs data storage on the above-mentioned reporting relationship table and the above-mentioned post relationship table. The trigger may be an INSERT trigger, and the user number may be a primary key in the user information table, or a foreign key in the reporting relationship table and the job relationship table.

As another example, the execution body may detect that the user information table has completed data deletion in response to the trigger, and delete the data in the sixth data table and the seventh data table at the same time. The trigger may be a DELETE trigger, and the user number may be a primary key in the user information table, or a foreign key in the reporting relationship table and the job relationship table.

The content of step 203 solves the problem that multiple data tables cannot be operated in a unified manner, resulting in the problem that data consistency cannot be guaranteed. Due to the unclear relationship between the data tables, the operation of the data tables is complicated, and the unified operation of multiple data tables cannot be performed, which can easily lead to the destruction of data consistency. Therefore, when the problem that the relationship between the data tables is not clear is solved, the unified operation of the multiple data tables can be completed, thereby ensuring the consistency of the data. In order to achieve the effect of operating multiple data tables in a unified manner, step 203 first, by setting multiple data tables, and by setting the primary key and foreign key, the connection between the data tables is established, so as to clarify the relationship between the data tables relation. Then, use the relationship between the trigger and the data table to complete the unified operation on multiple data tables. This achieves the effect of performing unified operations on multiple data tables, solves the problem of inability to perform unified operations on multiple data tables, and ensures data consistency on the premise of improving data processing efficiency.

Step 204, in response to the verification result indicating that the data information to be stored in the database fails the data verification, generate abnormality prompt information.

In some embodiments, the above-mentioned execution body may generate abnormality prompt information in response to the verification result indicating that the data information to be stored in the database fails the data verification. Wherein, the verification result may be a verification result indicating that the data information to be stored in the database has not passed the data verification, and the abnormality prompt information may be information indicating that the data information to be stored in the database is abnormal.

As an example, the above-mentioned data information to be stored may be {user name: Zhang XX, user number: 0001, organization number: A001}, and the execution subject may respond to the verification result indicating that the user number 0001 has not passed the data repetition verification, and generate Abnormal prompt information indicating that the user ID has duplicate values.

Step 205, displaying abnormal prompt information on the display interface for the target user to modify the data information to be stored.

In some embodiments, the above-mentioned execution body may display the above-mentioned abnormal prompt information on the display interface, so that the target user can modify the data information to be stored in the database. Wherein, the above-mentioned display interface is an interface for displaying data abnormality information.

As an example, the above-mentioned execution subject may display an exception prompt message that the user name has a null value on the MySQL running result interface, so that the target user can modify the user name.

The above-mentioned embodiments of the present disclosure have the following beneficial effects: data storage is performed through the data storage methods of some embodiments of the present disclosure, thereby improving the accuracy and integrity of the data. Specifically, the reason for low data accuracy and integrity is that data verification is not performed before data storage. Based on this, the data storage methods of some embodiments of the present disclosure include: first, receiving data information to be stored. Then, data verification is performed on the data information to be stored to generate a verification result, and the data is verified to be accurate and valid through data verification. Secondly, in response to the verification result indicating that the data information to be stored has passed the data verification, the data information to be stored is stored in the data table of the target database. Next, in response to the verification result indicating that the data information to be stored has failed the data verification, abnormal prompt information is generated. Finally, the abnormal prompt information is displayed on the display interface for the target user to modify the data information to be stored. Therefore, by adding a data verification step, the accuracy and integrity of the data can be effectively guaranteed.

Further referring to FIG. 3 , as an implementation of the methods shown in the above figures, the present disclosure provides some embodiments of a data storage device, these device embodiments correspond to those method embodiments shown in FIG. 2 , the device specifically Can be used in various electronic devices.

As shown in FIG. 3 , the data storage device 300 of some embodiments includes: a receiving unit 301 , a verification unit 302 , a storage unit 303 , an information prompt unit 304 and a display unit 305 . The receiving unit 301 is configured to receive data information to be stored in the database, wherein the data information to be stored is the user identity information to be stored in the target database; the verification unit 302 is configured to perform data processing on the data information to be stored. verification to generate a verification result; the storage unit 303 is configured to store the above-mentioned data information to be stored in the data table of the above-mentioned target database in response to the above-mentioned verification result indicating that the above-mentioned data information to be stored has passed the data verification; The information prompting unit 304 is configured to generate abnormal prompting information in response to the above-mentioned verification result indicating that the above-mentioned data information to be stored in the warehouse has not passed the data verification; the display unit 305 is configured to display the above-mentioned abnormal prompting information on the display interface for the target user. Modify the above data to be stored.

It can be understood that the units recorded in the apparatus 300 correspond to the respective steps in the method described with reference to FIG. 2 . Therefore, the operations, features, and beneficial effects described above with respect to the method are also applicable to the apparatus 300 and the units included therein, and details are not described herein again.

Referring next to FIG. 4 , a schematic structural diagram of an electronic device (such as the computing device 101 shown in FIG. 1 ) 400 suitable for implementing some embodiments of the present disclosure is shown. The electronic device shown in FIG. 4 is only an example, and should not impose any limitation on the function and scope of use of the embodiments of the present disclosure.

As shown in FIG. 4 , an electronic device 400 may include a processing device (eg, a central processing unit, a graphics processor, etc.) 401 that may be loaded into random access according to a program stored in a read only memory (ROM) 402 or from a storage device 408 Various appropriate actions and processes are executed by the programs in the memory (RAM) 403 . In the RAM 403, various programs and data necessary for the operation of the electronic device 400 are also stored. The processing device 401 , the ROM 402 , and the RAM 403 are connected to each other through a bus 404 . An input/output (I/O) interface 405 is also connected to bus 404 .

Typically, the following devices may be connected to the I/O interface 405: input devices 404 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; including, for example, a liquid crystal display (LCD), speakers, vibration An output device 407 of a computer, etc.; a storage device 408 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 409. Communication means 409 may allow electronic device 400 to communicate wirelessly or by wire with other devices to exchange data. Although FIG. 4 shows electronic device 400 having various means, it should be understood that not all of the illustrated means are required to be implemented or provided. More or fewer devices may alternatively be implemented or provided. Each block shown in FIG. 4 can represent one device, and can also represent multiple devices as required.

In particular, according to some embodiments of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, some embodiments of the present disclosure include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the method illustrated in the flowchart. In some such embodiments, the computer program may be downloaded and installed from the network via the communication device 409 , or from the storage device 408 , or from the ROM 402 . When the computer program is executed by the processing device 401, the above-mentioned functions defined in the methods of some embodiments of the present disclosure are performed.

It should be noted that the computer-readable medium described in some embodiments of the present disclosure may be a computer-readable signal medium or a computer-readable storage medium, or any combination of the above two. The computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus or device, or a combination of any of the above. More specific examples of computer readable storage media may include, but are not limited to, electrical connections with one or more wires, portable computer disks, hard disks, random access memory (RAM), read only memory (ROM), erasable Programmable read only memory (EPROM or flash memory), fiber optics, portable compact disk read only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing. In some embodiments of the present disclosure, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. Rather, in some embodiments of the present disclosure, a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code therein. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing. A computer-readable signal medium can also be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device . Program code embodied on a computer readable medium may be transmitted using any suitable medium including, but not limited to, electrical wire, optical fiber cable, RF (radio frequency), etc., or any suitable combination of the foregoing.

In some embodiments, the client and server can communicate using any currently known or future developed network protocol such as HTTP (HyperText Transfer Protocol), and can communicate with digital data in any form or medium (eg, a communications network) interconnected. Examples of communication networks include local area networks ("LAN"), wide area networks ("WAN"), the Internet (eg, the Internet), and peer-to-peer networks (eg, ad hoc peer-to-peer networks), as well as any currently known or future development network of.

The above-mentioned computer-readable medium may be included in the above-mentioned electronic device; or may exist alone without being assembled into the electronic device. The above-mentioned computer-readable medium carries one or more programs, and when the above-mentioned one or more programs are executed by the electronic device, the electronic device: receives the data information to be stored, wherein the data information to be stored is to be stored in the User identity information for the target database. Data verification is performed on the data information to be stored to generate verification results. In response to the verification result indicating that the data information to be stored has passed the data verification, the data information to be stored is stored in the data table of the target database. In response to the verification result indicating that the data information to be stored in the warehouse fails the data verification, abnormal prompt information is generated. Display abnormal prompt information on the display interface for the target user to modify the data information to be stored.

Computer program code for carrying out operations of some embodiments of the present disclosure may be written in one or more programming languages, including object-oriented programming languages—such as Java, Smalltalk, C++, or a combination thereof, Also included are conventional procedural programming languages - such as the "C" language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer, or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (eg, using an Internet service provider to via Internet connection).

The flowchart and block diagrams in the Figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code that contains one or more logical functions for implementing the specified functions executable instructions. It should also be noted that, in some alternative implementations, the functions noted in the blocks may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It is also noted that each block of the block diagrams and/or flowchart illustrations, and combinations of blocks in the block diagrams and/or flowchart illustrations, can be implemented in dedicated hardware-based systems that perform the specified functions or operations , or can be implemented in a combination of dedicated hardware and computer instructions.

The units described in some embodiments of the present disclosure may be implemented by means of software, and may also be implemented by means of hardware. The described unit can also be provided in the processor, for example, it can be described as: a processor includes a receiving unit, a checking unit, a storage unit, an information prompting unit and a display unit. Among them, the names of these units do not constitute a limitation of the unit itself under certain circumstances. For example, the verification unit can also be described as "the data verification of the above-mentioned data information to be stored in order to generate the verification result. unit".

The functions described herein above may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: Field Programmable Gate Arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Products (ASSPs), Systems on Chips (SOCs), Complex Programmable Logical Devices (CPLDs) and more.

The above descriptions are merely some preferred embodiments of the present disclosure and illustrations of the applied technical principles. Those skilled in the art should understand that the scope of the invention involved in the embodiments of the present disclosure is not limited to the technical solution formed by the specific combination of the above-mentioned technical features, and should also cover, without departing from the above-mentioned inventive concept, the above-mentioned Other technical solutions formed by any combination of technical features or their equivalent features. For example, a technical solution is formed by replacing the above-mentioned features with the technical features disclosed in the embodiments of the present disclosure (but not limited to) with similar functions.

Claims (8)

1. A method of data storage, comprising:

receiving data information to be put in storage, wherein the data information to be put in storage is user identity information to be stored in a target database;

carrying out data verification on the data information to be put in storage to generate a verification result;

responding to the verification result to represent that the data information to be warehoused passes data verification, and storing the data information to be warehoused into a data table of the target database;

responding to the verification result that the data information to be put in storage does not pass data verification, and generating abnormal prompt information;

and displaying the abnormal prompt information on a display interface so that a target user can modify the information of the data to be put in storage.

2. The method of claim 1, wherein the verification result comprises: a target verification result set; and

the data verification of the data information to be put into storage to generate a verification result includes:

performing field analysis on the data information to be put in storage to generate a data information set;

and performing data missing verification on each data information in the data information set to generate a target verification result corresponding to the data information, so as to obtain the target verification result set.

3. The method of claim 2, wherein the performing data missing check on each data information in the data information set to generate a target check result corresponding to the data information includes:

determining the data length of the data information to obtain data length information;

and in response to the fact that the data length of the data information represented by the data length information is consistent with the target length, determining a verification result representing data missing as a target verification result corresponding to the data information.

4. The method according to claim 1, wherein the storing the data information to be warehoused into the data table of the target database in response to the verification result indicating that the data information to be warehoused passes data verification comprises:

generating a database insertion statement corresponding to the to-be-put-in data information;

and operating the database insertion statement to store the data information to be put into a database into a data table of the target database.

5. The method of claim 4, wherein the data table of the target database comprises: a first data table; and

the step of storing the information of the data to be put into the warehouse into a data table of the target database comprises the following steps:

generating a target database insertion statement;

and operating the target database insertion statement to store the data information to be put into a warehouse into a first data table included in the target database.

6. A data storage device comprising:

the system comprises a receiving unit, a storage unit and a storage unit, wherein the receiving unit is configured to receive data information to be stored in a database, and the data information to be stored in the database is user identity information to be stored in a target database;

the checking unit is configured to perform data checking on the data information to be put into a warehouse so as to generate a checking result;

the storage unit is configured to respond to the verification result that the data information to be warehoused passes data verification, and store the data information to be warehoused into a data table of the target database;

the information prompt unit is configured to respond to the verification result that the data information to be warehoused does not pass the data verification, and generate abnormal prompt information;

and the display unit is configured to display the abnormal prompt information on a display interface so that a target user can modify the information of the data to be put into storage.

7. An electronic device, comprising:

one or more processors;

a storage device having one or more programs stored thereon;

when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-5.

8. A computer-readable medium, on which a computer program is stored, wherein the program, when executed by a processor, implements the method of any one of claims 1-5.

Images