Keywords:-
Article Content:-
Abstract
Databases in general and the relational model in particular have existed for several decades. This very powerful model represented the perfect solution for the various actors in the field of data management. Nevertheless, these architectures have reached their limits for certain big data services, such as Google, Yahoo, Facebook. To meet these new needs, several reflections relating to the design of new architectures and new solutions for data management have been proposed, mainly NoSQL and NewSQL. Currently, many users of relational database management systems want to switch to these new solutions to anticipate the explosion of their data in the future and the support of data unstructured. To justify and motivate such a changeover, we are developing a comparative study on the performance of SQL, NoSQL and Newsql solutions. The purpose is to provide a set of criteria and indicators to interested actors, for possible decision-making on the appropriate solutions for their companies, by developing an experimental analysis on these solutions. The criteria for adopting each technology are also presented in order to guide the strategy for choosing one or more of them.
References:-
References
Abramova V., Bernardino J., et Furtado P., SQL ou NoSQL ? Évaluation du rendement et de l’évolutivité, Int. J. Intégration et gestion des processus opérationnels (IJBPIM), volume 7, numéro 4, 2015, p. 314-321.
Adriano Girolamo Piazza, NoSQL Etat de l’art et benchmark ; Travail de Bachelor réalisé en vue de l’obtention du Bachelor HES ; Genève, 9 octobre 2013 Haute École de Gestion de Genève (HEG-GE).
Andreas Meier, Introduction pratique aux bases de données relationnelles, Ed. 2, Springer-Verlag, 2006, p. 68.
Bruchez R., Les bases de données NoSQL Comprendre et mettre en œuvre, Paris, Eyrolles, 2013, p. 127.
Cattell R., Base de données SQL et NoSQL évolutifs. SIGMOD Record, volume 39, Issue 4, p. 12-27, Indiana, 2010.
Hadrien F., SQL, NoSQL, NewSQL stratégie de choix, Bachelor HES (Haute École de Gestion de Genève), 2015.
Hecht R., Jablonski S., Évaluation NoSQL : Enquête axée sur les cas d’utilisation, Dans Proceedings of the International Conference on Cloud and Service Computing, IEEE. 22 24 novembre 2012, Huashan Road, Shanghai, p. 336-341.
Heinrich L., Architecture NoSQL et réponse au Théorème CAP. Bachelor HES (Haute École de Gestion de Genève), 2012.
Kumar R., Gupta N., Maharwal H., Charu S., et al., Analyse critique de la gestion des bases de données à l’aide de NewSQL, International Journal of Computer Science and Mobile Computing (IJCSMC), volume 3, numéro 5, 2014, p. 434-438.
Martins G., Bezerra P., Gomes R., Albuquerque F., Costa A., Évaluer la dégradation du rendement dans les bases de données NoSQL générées par la virtualisation. Dans Proceedings IEEE of 8th Latin American Network Operations and Management Symposium (LANOMS), 1 3 octobre 2015, João Pessoa, Brésil, p. 84-91.
Piekos J., SQL vs NoSQL vs NewSQL : Trouver la bonne solution. http://dataconomy.com/2015/08/sql-vs-nosql-vs-newsql-finding-the-right-solution/ (consulté en janvier 2018).