| With the rapid development of Internet technology,massive amounts of data are generated on the Internet every day.Including privacy data such as personal id information,bank card number,various account passwords,patient medical information,etc.,so the protection of users' privacy data becomes crucial.The database server can effectively protect the privacy data by encrypting the data into the database,but there are some problems such as difficult operation of ciphertext data,increasing the burden of server hardware in the process of encryption and decryption and difficult user access control.Therefore,the design and implementation of a middleware system to complete data encryption and decryption operations in the form of agents has become a hot research topic,and this is a meaningful research.According to the process of software design and development,the requirements of middleware system are analyzed by use case diagram,and the functional modules of middleware system are abstracted.Then the overall structure of the middleware system is designed and the overall process of the system is determined.Then each functional module is designed in detail,and the interaction and dependency between each module are determined through the sequence diagram.Java programming language combined with NIO interface and JSQLParser is used to implement the middleware system for ciphertext database.In order to improve the usability of the system,this paper use JavaFX technology to design and implement a friendly human-computer interaction interface.The innovation of this system is in the following three aspects.First the architecture of the middleware system is designed,which runs between the front and rear ends of the ciphertext database and supports a variety of database clients.The searchable encryption scheme is used to support direct operation of ciphertext data and reduce the hardware pressure of the ciphertext database.Second,the data transmission scheme is implemented based on the database message protocol,which supports byte flow processing,improves the commonality of the middleware system,reduces the connection frequency with the database,and has high data transmission efficiency.Finally,in order to achieve effective user access control,the user identity attribute is used for permission calculation to prevent unauthorized operation.Each login of the user is authenticated and the authentication information is updated dynamically. |
