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.

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

Research and Application of Network Remote Operation Security Based on Sqlite Database

  • Dong Xu,
  • Tingqian Ming,
  • Xianjun Deng,
  • Linlin Xie

摘要

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.