Week 13: NoSQL Query Languages

Due: Wednesday, Nov 18th

Tuesday's class covers MongoDB and Thursday covers Neo4j. There is no homework this week so that your team can work on GP5 before Thanksgiving break. Exam 2 will ask you to read a MongoDB or Cypher query and write the equivalent SQL, which is exactly what both sources below are organized around.

Prompt

Paste the standard prompt, then paste this block.

Topic: Document and graph databases, compared with relational
databases.

My learning objectives:
- Describe how the document model and the graph model differ
  from the relational model.
- Translate a MongoDB find() query into the equivalent SQL.
- Translate a Cypher MATCH query into the equivalent SQL.

Teach me these concepts. Give me an analogy or a comparison
before you give me the definition, and don't move on until I
have restated the idea in my own words.

Sources

• SQL to MongoDB Mapping Chart in the MongoDB manual.
• Comparing Cypher with SQL in the Neo4j documentation.

Both pages are side-by-side comparisons. Cover one column and try to produce the other, then check yourself. That exercise is the exam question.