Cloud Database Management System

 A cloud computing term refer to delivery of computing resources over the internet, that is, we are using the services over internet at another location to store information instead of keeping data on your own hard-disk or application for your need. We use software and hardware resources which are managed by third parties at remote location. A cloud services reduces the cost and complexity of owning and operating computer networks and provide scalability, reliability and efficiency. In cloud computing the database outsourcing has become very important component nowadays. To the third parties there is very growing interest in outsourcing database management task, which provide task for lower cost due to economy scale. Outsourcing model reduces cost for running DBMS.

The DBMS is a software that user use to create, delete and maintain a database. Due to introduction of cloud computing DBMS has emerged into a new type of a service having its own benefit. A cloud database is a database that involves variety of designing, developing of hardware and software. It is a system in which variety of computers are connected through network such as internet. Traditional DBMS are not well versed to deal with the growing demands of cloud computing. If DBMS is used as service for a larger package, it would likely be effective in its duties and cheaper in long run. The concept of the DBMS has been around since the beginning of electronic computing. Database management systems are one of the oldest integral components of computing, essentially making it possible and easy to scan, retrieve and organize data on hard drives and networks. All DBMS, whether traditional or cloud based, act as communicators between the operating system and the database.

CDBMS Architecture:

The figure is a DBMS in Cloud Architecture, the first layer contains the storage layer, followed by databases layer and the upper layer is application layer. It provides efficient data access with a better distribution of values for the data. It stores frequently used SQL statements in memory in terms of performance and avoids the need for time-consuming recompilation at run-time. At the storage layer data is encrypted when stored in the database or backed up with no need of programming to encrypt and decrypt the database .The application layer produces a detailed report on each step used for data access and allows to accurately implement the performance.

Why DBMS in cloud? :

Database Management Systems as a cloud service are designed to run as a scalable, elastic service available on a cloud platform. Cloud based DBMS are structured only as a cloud offering and are not relational. For example, SQL Azure built by Microsoft is fully relational DBMS, while SQL services by Microsoft, Amazon’s simple-db and Google’s Big Table solution are distributed database cluster and have different persistence models. Cloud based DBMS services are dynamic and have distributed environment with elastic resources allocation, for use in simple as well as complex transactions. Most of the currently available DBMS engines will run on cloud infrastructure, but are not enhancements specifically structured to take advantage of the cloud.

Pros:

  • The technology has changed the way of business, and now the people use to shop over the internet and they rely on shopping for saving their time. This change in the business has let the companies think about the fastest way they can do business over the internet. There was a time when software needed to be installed to access the database of the company but now a day the employees even don’t have time to install software on their computer rather they prefer to use a ready to available resources. They prefer to use the cloud database so that they can access the information stored in their database without wasting any time.
  • The other advantage of using a cloud database is that it saves a lot of money. The company does not need to invest money in setting up their own data centers and then managing it by hiring extra staff for this purpose. Moreover, after setting up a data center, the company will need to buy the software’s as well and their maintenance is also required.
  • Cloud computing has given the freedom to access the information from anywhere without any boundaries of getting to your personal computer at home. This makes it a very powerful technology and the companies prefer it as the customers, employees or the authorities of the companies can get the formation they want from anywhere at any time

Cons:

  • The companies have to pay for the usage of the cloud database as per decided. Every time the data is transferred from the database, the company will have to pay each time. If the traffic of the company for transferring data with the database is high then the company may be paying then its expectations.

  • The other disadvantage of using a cloud database is that we do not have a full control over the server where our database is being held. We do not have the control over the software’s installed on those computers. You cannot do anything to make the security of the cloud database strong. The client will have to rely on the provider only. The security issues can be a big problem for the companies.

  • In case of cloud database, the data is to be fetched via the internet, so if the server is down, then it may cause inability to access the data from the server. This causes huge losses when the information is not available when needed.

Conclusion:

As suggested in this paper clouds can be used with distributed database for handling large volume of data. It enhances reliability, elasticity, availability, scalability and all these capabilities are provided at low cost with enhanced performance compared to the dedicated infrastructure. Cloud services based on DBMS are gaining acceptance from vendors desiring low cost of developmental platform. It present the idea of cloud service based on DBMS. It proposed architecture of cloud based on database management system. There are advantages and disadvantages as well; however the adoption the cloud database has proven that the advantages are more than the disadvantages

We are using the DBMS to improve the data sharing in the application, it provides enforcement of data privacy and security policies, for better access, for effective data integration and it increase the productivity of the users. It helps our developers to make better, faster decisions to facilitate data quality information in an organization. For Effective Database designs Contact Us or drop us a line at info@spgon.com

Author :Rajkumar Adapa – Web Developer
Source : https://www.ijact.in/index.php/ijact/article/viewFile/61/49