CS377: Database Design - Indexing a Denormalized NoSQL Datastore

Activity Goals

The goals of this activity are:
  1. To create an index in a NoSQL database

Supplemental Reading

Feel free to visit these resources for supplemental background reading material.

The Activity


Consider the activity models and answer the questions provided. First reflect on these questions on your own briefly, before discussing and comparing your thoughts with your group. Appoint one member of your group to discuss your findings with the class, and the rest of the group should help that member prepare their response. Answer each question individually from the activity on the Class Activity Questions discussion board. After class, think about the questions in the reflective prompt and respond to those individually in your notebook. Report out on areas of disagreement or items for which you and your group identified alternative approaches. Write down and report out questions you encountered along the way for group discussion.

Model 1: Indexes in NoSQL databases


  1. Look up which sort order is specified by 1 and which by -1.
  2. Insert many records with a loop into a MongoDB database, and query it with and without an index. What speedup do you observe for varying numbers of N documents in your collection? You can use the .explain() method on the cursor returned by your call to find() to obtain information about the time required to execute the query, as well as whether an index (BtreeCursor) was used or not (BasicCursor).


Submit your answers to the questions using the Class Activity Questions discussion board. You may also respond to questions or comments made by others, or ask follow-up questions there. Answer any reflective prompt questions in the Reflective Journal section of your OneNote Classroom personal section.