A fresh approach for hybrid SQL/NoSQL database design based on data structuredness

Abstract

Nowadays the dominant databases for work with structured data are based on a relational model (also called SQL databases), while NoSQL databases have been the increasingly popular solution for unstructured data. An important requirement which contemporary enterprise information systems should address is the use of data, regardless of the level of their structuredness. That has led to the need for design a unique logical database, which includes SQL and NoSQL components, and takes advantage of both technologies, so-called a hybrid SQL/NoSQL database. In this paper, the justification of introducing a hybrid database, depending on the criteria of data structuredness in use, was analysed and a new approach for design hybrid SQL/NoSQL database was presented, with its necessary activities. Experimental results confirmed, in certain conditions, the better performances of the hybrid database compared to SQL database and opened the space for further research.