DBMS Tools

Keith VanderLinden
Calvin University

Demos

• DBMS vs flat files (CSV, JSON, etc.)
• MongoDB Atlas
• MongoDB Queries
  • CRUD
  • Aggregation
  • Joins using $lookup

1. DBMS vs flat files (CSV, JSON, etc.)
   • The SLO dataset actually is de-normalized because it repeats tweet author self-descriptions in each tweet.
2. MongoDB Atlas
   • Show the load module.
3. MongoDB Queries
   • CRUD
   • Aggregation
   • Joins using $lookup
   • The goal here is not to make ourselves MongoDB gurus, but rather to give us a taste of noSQL and some confidence that we could pick it up as needed.

4. Run the SLO queries on Codespaces.
   • Set the MongoDB connection values as GitHub secrets.
   • Whitelist the Codespaces IP address in MongoDB Atlas.
   • Run the read queries.

Snapshot

See the live demo.

Link a snapshot of the final state of the demo here.