Part 9
Please read the
questions
***For each
question submit a MongoDB command and the
output from MongoDB***
***For each
question submit a MongoDB command and the
output from MongoDB***
- Part 9 Please Read The Questions For Each Question Submit A Mongodb Command And The Output From Mongodb For Eac 1 (86.28 KiB) Viewed 23 times
Part B: MapReduce Implementation in MongoDB (We will cover MapReduce technique in MongoDB in Week 10) We need to find some aggregated data from a Grocery Store (Giant, ACME etc.,) by their shoppingCarts. The document structure is: { "_id" : Number Long (1), "name":"Amelia Watson", : "Eggs, Milk, Chicken, Bacon", "shoppingCart" "discount": 1.25 } Note: If discount field is missing, it means the value of discount is zero. That is, there was no discount in that case. 1. Suppose we have the following documents. Create them. (Note: You may copy them into a text file first and then copy and paste them into MongoDB. I found that sometimes I still copy some unknown characters carried over from Word file to Text file.). (5) db.grocery.insert({name: "Bob", shopping Cart: "Milk, Corn, Chocolates", discount: 0.75}); db.grocery.insert({name: "Alice", shoppingCart: "Milk, Turkey, Apple", discount: 0}); db.grocery.insert({name: "Trudy", shopping Cart: "Cheese, Corn, Tomatoes, Ginger, Juice, Pork", discount: 1.50}); db.grocery.insert({name: "Jacob", shoppingCart: “Ice Cream, Onions, Tomatoes, Vinegar, Chicken, Fish", discount: 2.60}); db.grocery.insert({name: "Paul", shopping Cart: "Cheese, Chocolates, Fish, Bread"}); db.grocery.insert({name: "Jack", shoppingCart: "Milk, Corn, Fish", discount: 0.25}); db.grocery.insert({name: "Mary”, shoppingCart: “Milk, Turkey, Apple", discount: 0}); db.grocery.insert({name: "Kate”, shopping Cart: "Cheese, Apple, Corn, Juice, Pork", discount: 3.50}); db.grocery.insert({name: “Chris”, shoppingCart: “Ice Cream"});
2. Add the fact that you purchased the following items {Apple, Ice Cream, Chocolates} with the discount of $1.25. That is, use your first name as the name of the new document. (5) 3. Display all the data into pretty format. (5) 4. Use Map/Reduce function to count all the people who got any discount at all. Show the complete code and output (10) 5. Use Map/Reduce function to count the total value of discounts of all the customers. Show the complete code and output (10) 6. Use Map/Reduce function to find the number of times an item appears in the cart. For example, if Chicken was inserted in 5 documents (5 different Carts), the key value pair generated after map reduce should look like: {Chicken: 5}. Display the top 5 items most sold. (15)