CS340 · Chapter 10 · Annotated SlidesNoSQL and Object-Oriented Databases
Original
Overview

NoSQL and Object-Oriented Databases

Relational vs. non-relational databases, NoSQL families, MongoDB documents and collections, JSON and BSON, CRUD operations in MongoDB, Compass and Atlas, and object-oriented DBMSs compared with RDBMSs.

How to read this page

Every original slide is shown unchanged. Yellow marks on a slide point to a numbered note: hover or tap a mark to jump to its note, and hover a note to see its marks. Questions tagged Past exam appeared on a real paper; Prediction questions are likely angles, not confirmed. Pick an answer to each question: a wrong pick tells you why it is wrong, so you can try again.

All 34 slides
  1. 1 NoSQL and Object-Oriented Databases
  2. 2 LEARNING GOALS
  3. 3 TOPICS
  4. 4 RELATIONAL DATABASES
  5. 5 NON-RELATIONAL DATABASES
  6. 6 NON-RELATIONAL
  7. 7 NOSQL EXAMPLES
  8. 8 NON-RELATIONAL DATABASES (NOSQL)- MONGODB
  9. 9 MONGODB DOCUMENT EXAMPLE
  10. 10 NON-RELATIONAL DATABASES (NOSQL)- MONGODB
  11. 11 NON-RELATIONAL DATABASES (NOSQL)- MONGODB
  12. 12 QUICK COMPARISON OF ELEMENTS
  13. 13 MongoDB Relational DB
  14. 14 MONGODB FEATURES
  15. 15 JSON IN MONGODB
  16. 16 JSON OBJECT AND ARRAY
  17. 17 JSON DATA TYPES
  18. 18 JSON USED IN MONGODB
  19. 19 JSON USED IN MONGODB
  20. 20 DISADVANTAGE OF JSON
  21. 21 DISADVANTAGE OF JSON
  22. 22 Slide 22
  23. 23 DATA TYPES USED IN MONGODB
  24. 24 CRUD Operations in MongDB
  25. 25 CREATE OPERATIONS
  26. 26 READ OPERATIONS
  27. 27 UPDATE OPERATIONS
  28. 28 UPDATE OPERATIONS
  29. 29 DELETE OPERATIONS
  30. 30 MONGODB COMPASS AND ATLAS
  31. 31 OO DATABASE MANAGEMENT SYSTEMS
  32. 32 OODBMS HISTORY
  33. 33 RDBMS VS OODBMS: EXAMPLE
  34. 34 RDBMS VS OODBMS (2)
Slide 1 / 34

NoSQL and Object-Oriented Databases

Slide 1: NoSQL and Object-Oriented Databases
Slide 2 / 34

LEARNING GOALS

Slide 2: LEARNING GOALS
Slide 3 / 34

TOPICS

Slide 3: TOPICS
Slide 4 / 34

RELATIONAL DATABASES

Slide 4: RELATIONAL DATABASES
Slide 5 / 34

NON-RELATIONAL DATABASES

Slide 5: NON-RELATIONAL DATABASES

Notes

  1. NoSQL ("not only SQL"): flexible or no schema, horizontal scaling, high availability, often relaxed consistency.

Exam angle

PredictionQ1

Horizontal scaling (scaling out) means:

Slide 6 / 34

NON-RELATIONAL

Slide 6: NON-RELATIONAL
Slide 7 / 34

NOSQL EXAMPLES

Slide 7: NOSQL EXAMPLES

Notes

  1. Families: document (MongoDB), key–value (Redis), column-family (Cassandra), graph (Neo4j).

Exam angle

PredictionQ1

MongoDB is a:

Slide 8 / 34

NON-RELATIONAL DATABASES (NOSQL)- MONGODB

Slide 8: NON-RELATIONAL DATABASES (NOSQL)- MONGODB
Slide 9 / 34

MONGODB DOCUMENT EXAMPLE

Slide 9: MONGODB DOCUMENT EXAMPLE
Slide 10 / 34

NON-RELATIONAL DATABASES (NOSQL)- MONGODB

Slide 10: NON-RELATIONAL DATABASES (NOSQL)- MONGODB
Slide 11 / 34

NON-RELATIONAL DATABASES (NOSQL)- MONGODB

Slide 11: NON-RELATIONAL DATABASES (NOSQL)- MONGODB
Slide 12 / 34

QUICK COMPARISON OF ELEMENTS

Slide 12: QUICK COMPARISON OF ELEMENTS

Notes

  1. MongoDB ↔ relational: database ↔ database, collection ↔ table, document ↔ row, field ↔ column, embedding/linking ↔ joins.

Exam angle

PredictionQ1

In MongoDB, a collection corresponds to a relational:

Slide 13 / 34

MongoDB Relational DB

Slide 13: MongoDB Relational DB
Slide 14 / 34

MONGODB FEATURES

Slide 14: MONGODB FEATURES
Slide 15 / 34

JSON IN MONGODB

Slide 15: JSON IN MONGODB

Notes

  1. Documents are JSON-like (stored as BSON): objects { } and arrays [ ].

Slide 16 / 34

JSON OBJECT AND ARRAY

Slide 16: JSON OBJECT AND ARRAY
Slide 17 / 34

JSON DATA TYPES

Slide 17: JSON DATA TYPES
Slide 18 / 34

JSON USED IN MONGODB

Slide 18: JSON USED IN MONGODB
Slide 19 / 34

JSON USED IN MONGODB

Slide 19: JSON USED IN MONGODB
Slide 20 / 34

DISADVANTAGE OF JSON

Slide 20: DISADVANTAGE OF JSON
Slide 21 / 34

DISADVANTAGE OF JSON

Slide 21: DISADVANTAGE OF JSON
Slide 22 / 34

Slide 22

Slide 22: Slide 22
Slide 23 / 34

DATA TYPES USED IN MONGODB

Slide 23: DATA TYPES USED IN MONGODB
Slide 24 / 34

CRUD Operations in MongDB

Slide 24: CRUD Operations in MongDB

Notes

  1. CRUD: insertOne/insertMany, find, updateOne/updateMany ($set), deleteOne/deleteMany.

Exam angle

PredictionQ1

Which MongoDB call changes a field in matching documents?

Slide 25 / 34

CREATE OPERATIONS

Slide 25: CREATE OPERATIONS
Slide 26 / 34

READ OPERATIONS

Slide 26: READ OPERATIONS
Slide 27 / 34

UPDATE OPERATIONS

Slide 27: UPDATE OPERATIONS
Slide 28 / 34

UPDATE OPERATIONS

Slide 28: UPDATE OPERATIONS
Slide 29 / 34

DELETE OPERATIONS

Slide 29: DELETE OPERATIONS
Slide 30 / 34

MONGODB COMPASS AND ATLAS

Slide 30: MONGODB COMPASS AND ATLAS
Slide 31 / 34

OO DATABASE MANAGEMENT SYSTEMS

Slide 31: OO DATABASE MANAGEMENT SYSTEMS

Notes

  1. OODBMS: stores objects directly (identity, encapsulation, inheritance); good for complex objects (CAD, multimedia).

Exam angle

Slide 32 / 34

OODBMS HISTORY

Slide 32: OODBMS HISTORY
Slide 33 / 34

RDBMS VS OODBMS: EXAMPLE

Slide 33: RDBMS VS OODBMS: EXAMPLE

Notes

  1. RDBMS: tables, SQL, simple types. OODBMS: objects with methods, OIDs, no impedance mismatch with OO code.

Slide 34 / 34

RDBMS VS OODBMS (2)

Slide 34: RDBMS VS OODBMS (2)