Hybrid Cloud Polyglot Bridging Sql Nosql

Download or read book Hybrid Cloud Polyglot Bridging SQL & NoSQL written by David Tauck and published by . This book was released on 2018 with total page 136 pages. Available in PDF, EPUB and Kindle. Book excerpt: The main objective of this study is to determine the influence of fragmenting a database between SQL and NoSQL on the cloud. Many factors affect the adoption of cloud computing by the enterprises and they shall be evaluated, from a system point of view, prior to making the decision to adopt a cloud-based solution. The purpose of this study is to recognize those factors and determine the extent to which they affect the adoption of cloud computing for SMEs. In addition, studying the feasibility of establishing a hybrid database structure between relational and NoSQL databases to achieve an optimal solution was also covered. Therefore, this study describes a detailed research model on implementing a hybrid database integration between SQL and NoSQL on the cloud. The need for scalable database has increased with the growing data in the web world. Those needs have been fulfilled by the NoSQL databases with its high scalability and easy programmable model. The demand for NoSQL database is growing because most of the built cloud applications support high availability, speed, failover options, fault tolerance and consistency, which a traditional relational database fails to offer to the modern web applications. Thus, dealing with huge data processing on the web has been cost effective by the NoSQL databases. Moreover, NoSQL database and cloud computing goes hand in hand when compared with SQL databases. To apply these concepts, we implemented and tested the benefits of cloud computing and NoSQL integrated with SQL database through Microsoft Azure. We uploaded a database on SQL Azure and created a tool to offload all the inactive daa in the ledger tables for years, from SQL Azure to Azure storage tables. Also another tool to retrieve the data from Azure storage table, to be available for any study or analysis.