Abstract

A cloud database is a database usually installed on cloud computing software platforms. There are several methods for query processing in cloud databases. This study tried to optimize query processing in the SeaBase cloud database and reduce query processing time. This method used adaptability for optimization. This method was designed for cloud-based databases. The algorithm is composed of three components: 1) multi cloud query separator; 2) query similarity detector based on the execution plan; and 3) replacement policy. This method is implemented as a system for a fully object-oriented simulation. The system is added to the SeaBase as an agent. The evaluation result show that this method reduced response time by 1.9 percent.

Highlights

  • Database management systems are software packages that can be used to create and maintain one or more databases

  • Different queries are sent to the SeaBase, and the database needs cost to respond to queries depending on their type and structure

  • Cloud computing and the use of SeaBase databases are a solution to integrate a variety of DBMSs and integrated access to tables in databases

Read more

Summary

INTRODUCTION

Database management systems are software packages that can be used to create and maintain one or more databases. With the rise of cloud computing, database management systems have become a new kind of service with unique advantages. In these services, DBMS is a part of a larger service which is likely to be more effective in terms of results and assigned tasks [1]. Like SQL server, DB2, Sybase, MySQL, and other similar databases, SeaBase was designed in order to integrate data taken from several heterogeneous databases and provide users with them in a unified way [4]. The CCEVP model uses three layers: 1) physical; 2) virtual; and 3) effective. The effective layer allows users to create a unified vision to the SeaBase

OPTIMIZING QUERY PROCESSING IN CLOUD DATABASE EASE OF USE
THE PROPOSED METHOD
Separator of distributed instructions
The query similarity detector based on execution plan
Replacement policy
ASSESSMENT AND PRACTICAL RESULTS
Findings
CONCLUSION
Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call