VJC Chapter 22 NoSQL

VJC/H2Computing/9569 Chapter 22: NoSQL Contents 1 What is NoSQL 2 Differences between relational databases and NoSQL databases 3 Advantages of NoSQL 4 Applications of relational databases and NoSQL databases 5 Introduction to MongoDB 5.1 Terms used in MongoDB 5.2 Document in MongoDB 5.3 Starting the MongoDB server 6 PyMongo 6.1 Create a MongoClient 6.2 Create a Mongo database 6.3 Create a collection 6.4 Inserting documents 6.4.1 Inserting one document 6.4.2 Inserting multiple documents 6.4.3 Importing from a text file 6.4.4 Importing from a JSON file 6.5 Searching for documents 6.5.1 Find the first document 6.5.2 Find all documents 6.5.3 Find documents that satisfy certain criteria 6.5.4 Find documents that satisfy multiple criteria 6.5.5 Count the number of documents in a collection 6.6 Update documents 6.7 Remove documents 6.8 Remove a collection 6.9 Remove a database Annex 1 – Using MongoDB shell Syllabus Learning Outcomes 3.3 Databases and Data Management Understand, create and use SQL and NoSQL databases, as well as understand techniques to protect the privacy and integrity of data. 3.3.6 Understand how NoSQL database management system addresses the shortcomings of relational database management system (SQL) 3.3.7 Explain the applications of SQL and NoSQL 3.3.8 Use a programming language to work with both SQL and NoSQL databases.

1 VJC/H2Computing/9569 1 Introduction to NoSQL NoSQL, stands for “non SQL” or “not only SQL”, is a type of database management system (DBMS) that is designed to handle and store large volumes of unstructured and semi-structured data. Unlike traditional relational databases that use tables with pre-defined schemas to store data, NoSQL databases use non-relational data structures which are flexible and allows dynamic schema for unstructured data. NoSQL databases can adapt to changes in data structures and are capable of scaling horizontally to handle growing amounts of data. There are four main types of NoSQL databases: document databases, key-value databases, wide-column databases, and graph databases. 2 Differences between relational databases and NoSQL databases 2.1 Data Structure Relational databases have a fixed, predefined schema where data must fit into tables with specific columns and data types. This rigid structure ensures consistency, and it works well for applications with stable, well-structured, and predictable data requirements. In contrast, NoSQL data