Download the HW from the Download Handout link and uncompress it. Use mongorestore to restore the dump into your running mongod. Validate connects to localhost: Crunching the Zipcode dataset Please calculate the average population of cities in California abbreviation CA and New York NY taken together with populations over 25, On unix, this could be done as follows: Once you have added the indexes to make those pages fast run the following. Question 1 Please homework the Enron email dataset 5.

Ok, once you get the blog posts working, validate. The answer for CT and NJ using this data set is To figure out what queries you need to optimize, you can read the blog. Validate connects to localhost: We have provided the code that creates users and allows you to login the assignment from last week. Import it into your mongod using the following command from the command line:

Omit -p from mkdir. Note that not all students in the same class have the same exact number of assessments.

m101p homework 5.2

Sunday, February 5, [Solution] Week 4: In this problem you will calculate the number of people who live in a zip code in the US where the city starts with one of the following characthers:. On unix, this could be done as follows: The project operator can extract the first digit from any field.


M101p homework 5.2 answers

There are hyperlinks from the post tags to the page that displays the 10 most recent blog entries for that tag. If you notice that while importing, there are a few duplicates fear not, this is expected and will not affect your answer.

Some students have three homework assignments, etc. Isolate those queries and use explain to explore. Type the validation code below. There are three locations for you to add code for this problem.

Study IQ World: Week 5 : AGGREGATION FRAMEWORK : MP: MongoDB for Developers

Your job is to look this functionality up in the documentation, and use it for the following problem: Your task is to calculate the class with the best average student performance. This is not the correct number; you should get a different number.

It makes connections to both to determine if your program works properly. Please round the answer to a whole number. In this homework assignment you will be adding some indexes to the post collection to make the blog fast. Also omit –fork and use start mongod with Windows compatible paths i. Posted by Unknown at 6: The output of sh.

Mp homework answers –

For this homework, there are only documents and zip codesand all of them are in New York, Connecticut, New Jersey, and California. Please use the Aggregation pipeline to solve this problem. For example, to extract the first character from the city field, you could write this pipeline:. The documents look like this: You must accept our Terms Of Service before continuing.


m101p homework 5.2

You need to group twice to solve this problem. Crunching the Zipcode dataset Please calculate the average population of cities in California abbreviation CA and New York NY taken together with populations over 25, After this, the blog will work. Monday, February 13, [Solution] Week 5: Please insert into the m collection, Homework 6.

m101p homework 5.2

As before, validate will take some optional arguments if you want to run mongod on a different host or a use an external webserver. Different states might have the same city name. Start by downloading the handout zip file for this problem. Inspect a few of the mp to get a basic homework of the 5.