Data management in cloud environments: NoSQL and NewSQL data stores

• Published in: Journal of cloud computing : advances, systems and applications Vol. 2; no. 1; p. 22
• Main Authors: Grolinger, Katarina, Higashino, Wilson A, Tiwari, Abhinav, Capretz, Miriam AM
• Format: Journal Article
• Language: English
• Published: Berlin/Heidelberg Springer Berlin Heidelberg 18.12.2013; BioMed Central Ltd
• Subjects: Computer Communication Networks; Computer Science; Computer System Implementation; Computer Systems Organization and Communication Networks; Information Systems Applications (incl.Internet); Software Engineering/Programming and Operating Systems; Special Purpose and Application-Based Systems; Cloud computing; Big data; NoSQL; Data management; NewSQL; Distributed storage
• ISSN: 2192-113X; 2192-113X
• DOI: 10.1186/2192-113X-2-22

Advances in Web technology and the proliferation of mobile devices and sensors connected to the Internet have resulted in immense processing and storage requirements. Cloud computing has emerged as a paradigm that promises to meet these requirements. This work focuses on the storage aspect of cloud computing, specifically on data management in cloud environments. Traditional relational databases were designed in a different hardware and software era and are facing challenges in meeting the performance and scale requirements of Big Data. NoSQL and NewSQL data stores present themselves as alternatives that can handle huge volume of data. Because of the large number and diversity of existing NoSQL and NewSQL solutions, it is difficult to comprehend the domain and even more challenging to choose an appropriate solution for a specific task. Therefore, this paper reviews NoSQL and NewSQL solutions with the objective of: (1) providing a perspective in the field, (2) providing guidance to practitioners and researchers to choose the appropriate data store, and (3) identifying challenges and opportunities in the field. Specifically, the most prominent solutions are compared focusing on data models, querying, scaling, and security related capabilities. Features driving the ability to scale read requests and write requests, or scaling data storage are investigated, in particular partitioning, replication, consistency, and concurrency control. Furthermore, use cases and scenarios in which NoSQL and NewSQL data stores have been used are discussed and the suitability of various solutions for different sets of applications is examined. Consequently, this study has identified challenges in the field, including the immense diversity and inconsistency of terminologies, limited documentation, sparse comparison and benchmarking criteria, and nonexistence of standardized query languages.