| Titre : | SQL , NOSQL and NewSQL Databases: A Theoretical and Practical Comparative Survey |
| Auteurs : | Zakaria Melili, Auteur ; Nadia Ben Seghier, Directeur de thèse |
| Type de document : | Monographie imprimée |
| Editeur : | Biskra [Algérie] : Faculté des Sciences Exactes et des Sciences de la Nature et de la Vie, Université Mohamed Khider, 2022 |
| Format : | 1 vol. (47 p.) / couv. ill. en coul / 30 cm |
| Langues: | Français |
| Mots-clés: | SQL, NoSql , NewSql , Mysql , Oracle , Mongodb , Cassandra, Voltdb, Nuodb, Run time. |
| Résumé : |
This project adds to the various research works in the field of Sql, NoSQL and Newsql. Each model of them offers a way of organizing and storing data. The purpose of this work is to explain the different SQL, NoSQL and Newsql databases available on the market. And to see in more depth six of them, namely: Mysql, Oracle, Mongodb, Cassandra,Voltdb,Nuodb to offer decision-makers information for possible choices of the best appropriate solution for their businesses. We used multiple tests: insert, update and delete to calculate the execution time of each one of theme and that will used to decide between these solutions.
|
| Sommaire : |
t General Introduction………1 Chapter I : SQL, NOSQL and NEWSQL Databases……..2 1. INTRODUCTION 3 2. SQL : 3 2.1. Definition 3 2.2. Architecture : 3 2.3. ACID : 4 2.4. Limitations of SQL 6 3. NoSQL 6 3.1. What is NoSQL 6 3.2. Architecture Patterns of NoSQL:. 7 3.3. BASE Properties: 9 3.4. limitations of NoSQL : 9 4. NewSQL : 10 4.1. What is NewSQL : 10 4.2. Architecture of NewSQL 10 4.3. Properties of NewSQL : 11 4.4. limitations of NewSQL 11 5. CONCLUSION . 11 Chapter II: Theoretical Comparison…12 1. INTRODUCTION 13 2. Acid vs Base : 13 3. SQL vs NOSQL vs NewSQL : 13 4. Selected SQL systems : 15 4.1. Mysql 15 4.2. Oracle : 15 4.3. Main features Between theme 15 5. Selected NoSql systems 15 5.1. Cassandra . 15 5.2. Mongodb 15 5.3. Main Features Between Theme 15 6. Selected NewSQL Systemes 17 6.1. VoltDB. 17 6.2. NuoDB 17 6.3. Main Features Between theme 17 7. General Comparison of Selected Databases: 17 8. Conclustion : 19 Chapter III : Practical Comparison….20 1. Introduction 21 2. Development environment:.21 System 21 Version 21 Operation System21 Windows10. 21 Mysql(exampp) 21 Version 3.3.0. 21 Oracle 21 Version 21c express edition. 21 Mongodb 21 Version 5.0.6 21 Cassandra 21 Version 3.11.12 21 Voltdb. 21 Nuodb. 21 3. Configuration and Installation of DB SQL for Windows 10 3.1. Configuration and creation of environment variables 3.2. Installation of mysql (exampp) : . 23 3.3. Installation of Oracle 24 4. Configuration and Installation of DB Nosql for Windows 10 4.1. Installation Mongodb version 5.0.6 msi : 25 4.2. Installation Cassandra Version 3.11.12 27 5. EXPERIMENTAL RESULT 28 6. Conclusion & Overall evaluation 45 General Conclusion 46 REFERENCES47 |
Disponibilité (1)
| Cote | Support | Localisation | Statut |
|---|---|---|---|
| MINF/731 | Mémoire master | bibliothèque sciences exactes | Consultable |
