An analytic study of architecture, security, privacy, query processing, and performance evaluation of database-as-a-service

In the present era of technology, the pace of data generation is very high, and the biggest challenge is the manageability of data with efficient and secure storage options as well as at lower cost. Therefore, in this article, we have elaborated the database-as-a-service (DaaS) concept having its introduction, architecture, security and privacy, query processing, and an analytic performance evaluation relating to query performance on encrypted data of DaaS. We have conducted an analytic study of the state-of-the-art by analyzing CPU and query execution time. According to this evaluation, it is concluded that data encryption and decryption need heavy processing power and are time-consuming. Moreover, there is several query execution problems that exist on encrypted data. A major improvement in query performance may be achieved through parallel query execution after the deployment of multithreading having maximum possible threads.

Automated summary

This article introduces the concept of database-as-a-service (DaaS) and discusses its architecture, security and privacy, and query processing. It also evaluates the query performance of encrypted data on DaaS through an analytic study. The evaluation shows that data encryption and decryption require significant processing power and time, and there are several query execution problems with encrypted data. Parallel query execution with maximum possible threads can greatly improve query performance.