Research and Application of Network Remote Operation Security Based on Sqlite Database
摘要
The Sqlite database occupies fewer resources and has a fast processing speed, which is widely used in embedded devices. However, the Sqlite database does not support network operations and cannot be maintained remotely through the network. For many embedded devices, remote maintenance is actually necessary. The article mainly studies how to operate the Sqlite database through the network and ensure the security of the database data. Based on the characteristics of the Sqlite database, a data engine based on the C/S architecture is developed, and the NLV method is used to encode and decode database data, taking into account the robustness, accuracy, and integrity of data transmission; Adopting a four authority mechanism for user roles; The network transmission adopts a security mechanism based on the national encryption algorithm, adding CA certificates, digital signatures, digital verification, hash encryption, etc., that is, issuing a private key certificate to the database server through the CA certificate and a public key certificate to the database client, ensuring the security and reliability of the database data through the authentication mechanism of the client's digital digest.