An integration approach of hybrid databases based on SQL in cloud computing environment. (26th November 2018)

• Record Type: Journal Article
• Authors: Li, Changqing; Gu, Jianhua
• Is Part Of: Software, practice & experience. Volume 49:Number 3(2019)
• Page Start: 401
• Page End: 422
• Publication Date: 2018-11-26
• Subjects: big data -- cloud computing -- database services -- hybrid databases -- integration -- NoSQL; Computer software -- Periodicals; Computer programming -- Periodicals; Computer programs -- Periodicals; 005.3
• DOI: 10.1002/spe.2666
• Languages: English
• ISSNs: 0038-0644

Abstract

Summary: As the applications with big data in cloud computing environment grow, many existing systems expect to expand their service to support the dramatic increase of data, and modern software development for services computing and cloud computing software systems is no longer based on a single database but on existing multidatabases and this convergence needs new software architecture design. This paper proposes an integration approach to support hybrid database architecture, including MySQL, MongoDB, and Redis, to make it possible of allowing users to query data simultaneously from both relational SQL systems and NoSQL systems in a single SQL query. Two mechanisms are provided for constructing Redis's indexes and semantic transforming between SQL and MongoDB API to add the SQL feature for these NoSQL databases. With the proposed approach, hybrid database systems can be performed in a flexible manner, ie, access can be either relational database or NoSQL, depending on the size of data. The approach can effectively reduce development complexity and improve development efficiency of the software systems with multidatabases. This is the result of further research on the related topic, which fills the gap ignored by relevant scholars in this field to make a little contribution to the further development of NoSQL technology.