Research On Access And Integration Solution Of Heterogeneous Encrypted Database In Hybrid Cloud Environment

In the era of big data,increasing enterprises and organizations choose the cloud computing to store and manage their data.To solve the security problems of cloud data,some existing encryption database schemes ensure the data security through encryption technology.However,there are no schemes that can not only realize the transparent access function to the encrypted data on public cloud database but also realize the cross-database query function under heterogeneous database environment,which leads to the fact that the practicalbility of existing schemes is greatly reduced.Therefore,how to realize the transparent access service in encrypted database and integrate data among different database systems to achieve the cross-database query function under heterogeneous encryption database environment has become a key problem to be solved urgently.In view of the above problems,this paper proposes a heterogeneous encryption database access and integration scheme in hybrid cloud environment.In this scheme,an access and integration middleware is used to realize the transparent access function and cross-database query function of the client to the heterogeneous encrypted database in public cloud.In addition,by deploying the service cluster on a private cloud platform,the access and integration middleware is deployed on each processing node in the cluster and bypasses the client access based on the automatic load balancing component,which improves the efficiency of middleware and can dynamically adjust the computing resources of clusters.The research mainly includes the following aspects:Firstly,an access and integration middleware is designed,which can realize the transparent access function and cross-database query function of the client to the heterogeneous encrypted database in public cloud.The access and integration middleware consists of the transparent access component and the heterogeneous database data integration method.Aiming at the transparent access problem of encrypted database,a transparent access component is designed.The component reconstructs the protocol interaction process based on the My SQL protocol and calls the existing encrypted database schemes to encrypt and decrypt the encrypted data on public cloud database to realize the client's transparent access to the encrypted data on cloud database.Aiming at the heterogeneous database crossdatabase query problem,a heterogeneous database data integration method is proposed.The data from heterogeneous databases are firstly unified,and then integrated into the same database which acts as the queried database to realize the cross-database operation.Then,an automatic load balancing component is designed.The load balancing component reasonably schedules the tasks according to the current load state of each task processing node in the service cluster,maintaines the load status of each node at the same level to achieve load balancing.Meanwhile,combined with the cloud computing virtualization technology,the task processing nodes are automatically added or deleted,and the computing resources are dynamically adjusted according to the load situation of cluster to achieve automatic expansion of the load balancing network.In addition,by applying the load balaning component to the access and integration middleware,the client access can be bypassed through the load balancing strategy to enhance the processing performance of middleware.Finally,an experiment of heterogeneous encryption database access and integration in hybrid cloud environment is carried out.Experimental results show that the scheme achieves the transparent access function and cross-database query function in heterogeneous encryption database environment,and the application of automatic load balancing component can enhance the query performance,especially for the performance of concurrent queries.