A middleware method for realizing searchable encryption relational database caching

Abstract

The invention discloses a middleware method for realizing searchable encryption relational database caching, which specifically comprises the following steps of: 1, establishing mapping between a plaintext database and a ciphertext data connecting middleware to the plaintext database, and integrally converting the middleware and the ciphertext database into the searchable ciphertext database;using a unified searchable encryption algorithm to add, delete, modify and check newly stored data to realize fusion of a new database and an old database; Step 2, establishing a user query cache byutilizing an NOSQL data carrying out SQL analysis and routing on the middleware, cache hit and miss on the middleware, calculating column access frequency, and carrying out cache monitoring; Andstep 3, for each query operation of the user, judging whether the query request hits the cache or not, if so, returning a result from the memory database, otherwise, connecting the ciphertext database, and returning the query result. According to the method, the query speed of the searchable ciphertext database is increased and the concurrency problem is relieved while the security is ensured.

Description

technical field [0001] The invention relates to a middleware method for realizing a searchable encrypted relational database cache, and belongs to the technical field of information security. Background technique [0002] In the cloud computing environment, data security issues have always been concerned, and database encryption has become a reliable method. Aiming at the problem of difficult query after encryption, a searchable encryption scheme is proposed. At the same time, using the middleware deployed between the client and the server to realize the encryption of the database can make the encryption more flexible and easy to adjust. In the past few decades, relational systems have been the main form of data storage and manipulation, because relational databases support transaction processing to maintain data consistency, and can support complex queries such as Join. In the face of massive data, traditional relational databases have problems such as concurrency of a lar...

AI Technical Summary

Problems solved by technology

[0003] The present invention provides a middleware method for realizing a searchable encrypted relational database cache. The method solves the problem of high concurrency and slow reading and writing speed of ciphertext database query in the era of big data and the environment of explosive growth of information data. To improve the query speed of the searchable ciphertext database and alleviate the concurrency problem while ensuring security

Images