Features and Conceptual Design of NoSQL Database Modeling

Abstract

NoSQL databases has been growing in recognition and is expected to keep growing faster than that of the SQL market during the next few years, with the advent of big data technology, organizations and individuals are eager to understand why and how it fits into their developmental structures. Traditional relational databases have been the de facto choice since the 1970s, as they have been the sole option available for both developers and infrastructure teams. Traditional Relational Database Management Systems (RDBMS) use the ACID theorem for data consistency, whereas NoSQL Databases use a non-transactional approach called BASE. NoSQL, also known as not only SQL or non-relational databases, were specifically introduced to handle the rise in data types, data access, and data availability needs. This paper reviews the four types of NoSQL databases, namely, Document-oriented, Key-Value Pairs, Column-oriented and Graph.  Results showed NoSQL data modeling for document-oriented databases which is similar to data modeling for traditional RDBMS during the conceptual and logical modeling phases. Findings also showed a database modeling operation for a car sales shop using the BASE theorem, and show concepts like denormalization, joins and aggregation.