Assignment 1: Basics and Map-Reduce
Formative, Weight (10%), Learning objectives (1, 2, 3), Abstraction (4), Design (4), Communication (4), Data (5), Programming (5)
1 Overview
Assignments should be done in groups consisting of TWO students. If you have problems finding a group partner use the forum to search for group partners or contact the lecturer.
2 Assignment
Exercise 1 Suspected Pairs (10 points)
Using the information from the first lecture (or Section 1.2.3 in the textbook), what would be the number of suspected pairs if the following changes were made to the data (all changes should be applied at once).
1. The number of days of observation was raised to 5000.
2. The number of people observed was raised to 5 billion (and there were
therefore 500, 000 hotels).
3. We only reported a pair as suspect if they were at the same hotel at the
same time on four different days.
Exercise 2 Hadoop (10+10 points)
For this exercise, you have to set up and configure your system to use Hadoop. Follow the instructions in Stanford document at http://snap.stanford.edu/ class/cs246-2017/homeworks/hw0/tutorialv3.pdf and set up the virtual machine as described in Section 1. Run the example program of Section 2 and carry out the different steps given in that section.
• Run your job on the file http://www.gutenberg.org/files/100/100-0. txt in standalone mode and pseudo-distributed mode and record the out- put.
1
COMP SCI 3306, COMP SCI 7306 Mining Big Data Semester 1, 2020
Exercise 3 Friend Recommendation System (Stanford) (35 points)
Write a MapReduce program in Hadoop that implements a simple People You Might Know social network friendship recommendation algorithm. The key idea is that if two people have a lot of mutual friends, then the system should rec- ommend that they connect with each other. You have to run the program on the system setup in Exercise 2 in order to receive points for this exercise.
Input: Download the input file from the link: http://snap.stanford.edu/ class/cs246-data/hw1q1.zip. The input file contains the adjacency list and has multiple lines in the following format:
Here,
Output: The output should contain one line per user in the following for- mat:
where
For your submission
• Include your source code
• Include in your writeup a short paragraph describing your algorithm to tackle this problem.
2
COMP SCI 3306, COMP SCI 7306 Mining Big Data Semester 1, 2020
• Include in your writeup the recommendations for the users with following user IDs: 924, 8941, 8942, 9019, 9020, 9021, 9022, 9990, 9992, 9993.
Exercise 4 MapReduce (15 points)
This exercise has 4 parts. In this exercise, you will be writing and implement- ing two MapReduce programs. Both are a bit challenging, but they will help you to have a better understanding about the MapReduce implementation. Af- ter you write the programs, you will need to answer some questions about them.
Remember that neither problem is case sensitive, so transform words to lower- case or uppercase. Also remember to use the StringTokenizer to find the correct answers.
Part 1: Write a program that processes the FirstInputFile http://www.gutenberg. org/cache/epub/100/pg100.txt and the SecondInputFile http://www.gutenberg. org/files/3399/3399.txt. This program should count the number of words
with a specific amount of letters in these files – for example, the number of words
with 4 letters, 5 letters and so on. If one word is repeated 20 times in the text, count it individually 20 times.
Part 2: Answer Questions 1-6.
• Q1: How many words are there with length 10 in FirstInputFile?
• Q2: How many words are there with length 4 in FirstInputFile?
• Q3: What is the longest length between words and what is its frequency in FirstInputFile?
• Q4: How many words are there with length 2 in SecondInputFile?
• Q5: How many words are there with length 5 in SecondInputFile?
• Q6: What is the most frequent length and what is its frequency in Sec- ondInputFile?
Part 3: Write a second program that again processes the FirstInputFile http: //www.gutenberg.org/cache/epub/100/pg100.txt and the SecondInputFile http://www.gutenberg.org/files/3399/3399.txt. However, in addition to counting the number of words with a specific amount of letters, if one word is repeated several times, count it only once. So, your output should be the fre- quency of words with same length, but count a repeated word only once. Note: You may need to use 2 MapReduce jobs.
Part 4: Answer Questions 7-12.
• Q7: How many words are there with length 10 in FirstInputFile?
3
COMP SCI 3306, COMP SCI 7306 Mining Big Data Semester 1, 2020
• Q8: How many words are there with length 4 in FirstInputFile?
• Q9: What is the most frequent length and what is its frequency in FirstIn-
putFile?
• Q10: How many words are there with length 5 in SecondInputFile?
• Q11: How many words are there with length 2 in SecondInputFile?
• Q12: What is the second-most frequent length and what is its frequency in SecondInputFile?
Exercise 5 Summary of 2.4 and 2.5 (10 +10 points) (Postgraduate Stu- dents (COMP SCI 7306) only)
For this exercise you have to read Section 2.3.9-2.3.11, 2.4, and 2.5 in Leskovec, Rajara- man, Ullman (second edition, 2014).
• Summarize the content of 2.4 in your own words (600 words). • Summarize the content of 2.5 in your own words (600 words).
3 Procedure for handing in the assignment
Work should be handed in using Canvas. The submission should include:
• PDF file of your solutions for theoretical assignments.
• all source files
• descriptions as required in the statement of the exercises
• Hadoop outputs for the exercises
• a README.txt file containing instructions to run the code, the two group members’ names, student numbers, and email addresses of the group mem- bers, only one submission per group.
4