NoSQL databases: advantages and applications
Nowadays, enormous amounts of heterogeneous data with structures are generated not always reducible to “relational” formats”. The trend is to store this data on Hadoop. However, this solution is not always the most suitable due to architectural complexity, the heaviness of the components, and the difficulty of writing analytics. The database NoSQL, not necessarily linked to the world of Big Data, if used to process certain types of information, allow for the implementation more agile solutions compared to a distributed file system and to implement high-performance queries. This seminar, after describing the main types of NoSQL databases, aims to show, through the description of practical examples, the functionalities of the main products, their application fields, and their respective advantages and disadvantages.
Contents
Main data types; Small Data and Big Data; Classification of DBMS (OldSQL, NewSQL, NoSQL) and main differences; what are NoSQL databases; main characteristics; the CAP theorem; Classification of NoSQL databases.
Dictionaries and hash tables; main functionalities; data modelling; architectural models and patterns; fields of application; main key-value databases (Redis, BigTable,…); practical usage examples.
What is meant by “document”; hierarchical structure; collections of documents; main functionalities; data modelling; architectural models and patterns; fields of application; main document databases (MongoDB, CouchDB, CouchBase,...); practical examples of use.
Extended tables (row, column, and temporal index); column families and super column families; nested tables; main functionalities; data modelling; architectural models and patterns; application fields; main columnar databases (Cassandra, HBase, ...); practical usage examples.
Lattice, tree and graph structures; types of processing on graph models; main functionalities; data modelling; architectural models and patterns; fields of application; main graph databases (Neo4J, OrientDB…); practical use cases.
What is meant by object; the object-oriented paradigm; main functionalities; data modelling; architectural models and patterns; fields of application; main object-oriented databases (Redis, BigTable,...); practical examples of use.
When the DBMS implements multiple models
Research suite: SOLR and Elasticsearch; Blockchain.
Native NoSQL databases for Hadoop; integration between Hadoop and NoSQL: drawing the best from both worlds.
Integration architectures; forward and reverse engineering; conversion to and from RDBMS; usable tools (e.g. ErWin).
Key security and privacy issues in NoSQL databases; access policies; information encryption; security tools provided.
Key governance issues; metadata catalogue; roles and professional figures; lineage.
Prerequisites
Basic knowledge of Internet technologies and distributed applications.
Classroom requirements
- Video projector with a minimum native resolution of 1024x768 (preferably higher)
- Unfiltered internet connection for the teacher's laptop
- Flip chart with markers of different colours (or equivalent tools)
NOTEThe lecturer will use their own laptop, on which all course examples are installed. If this is not possible, it is necessary to agree in advance on the preparation of a PC provided by the client.
Recipients