INF553 Foundations and Applications of Data Mining Summer 2020
Assignment 5
NO LATE SUBMISSIONS
1. Overview of the Assignment
In this assignment, you are going to implement three algorithms: the Bloom filtering, Flajolet-Martin algorithm, and reservoir sampling. For the first task, you will implement Bloom Filtering for off-line Yelp business dataset. The “off-line” here means you do not need to take the input as streaming data. For the second and the third task, you need to deal with on-line streaming data directly. In the second task, you need to generate a simulated data stream with the Yelp dataset and implement Flajolet- Martin algorithm with Spark Streaming library. In the third task, you will do some analysis on Twitter stream using fixed size sampling (Reservoir Sampling).
2. Requirements
2.1 Programming Requirements
a. You must use Python and Spark to implement all tasks. There will be 10% bonus for each task if you also submit a Scala implementation and both your Python and Scala implementations are correct.
b. You will need Spark Streaming library for task1 and task2. In task3, you will use Twitter API of streaming. You can use the Python library, tweepy, and Scala library, spark-streaming-twitter.
c. You can only use Spark RDD and standard Python or Scala libraries. I.e. no point if using Spark DataFrame or DataSet
2.2 Programming Environment
Python 3.6, Scala 2.11 and Spark 2.3.2
We will use Vocareum to automatically run and grade your submission. You must test your scripts on the local machine and the Vocareum terminal before submission.
2.3 Write your own code
Do not share code with other students!!
For this assignment to be an effective learning experience, you must write your own code! We emphasize this point because you will be able to find Python implementations of some of the required functions on the web. Please do not look for or at any such code!
TAs will combine all the code we can find from the web (e.g., Github) as well as other students’ code from this and other (previous) sections for plagiarism detection. We will report all detected plagiarism.
2.4 What you need to turn in
You need to submit the following files on Vocareum: (all lowercase)
a. [REQUIRED] three Python scripts, named: task1.py, task2.py, task3.py
b. [REQUIRED FOR SCALA] three Scala scripts, named: task1.scala, task2.scala, task3.scala
c. [REQUIRED FOR SCALA] one jar package, named: hw5.jar
d. You don’t need to include your results. We will grade on your code with our testing data (data will
be in the same format).
3. Datasets
3.1.1 Yelp Business Data
For task1, you need to download the business_first.json and business_second.json from Vocareum. The first file is used to set up the bit array for Bloom filtering, and the second file is used for prediction.
3.1.2 Yelp Streaming Data Simulation
For task2, you need to download the business.json file and the generate_stream.jar on the Vocareum. Please follow the instructions below to simulate streaming on your machine:
1) Run the generate_stream.jar in the terminal to generate Yelp streaming data from the “business.json” with the command:
java -cp
– 9999 is a port number on the localhost. You can assign any available port to it.
– 100 represents 100 milliseconds (0.1 second) which is the time interval between items in the simulated data stream.
2) Keep step 1) running while testing your code. Use “Ctrl+C” to terminate if necessary.
3) Add the following code to connect the data stream in your Spark Streaming code:
ssc.socketTextStream(“localhost”, 9999)
– The first argument is the host name, which is “localhost” in this case.
– The second argument is the port number in step 1), which is 9999 in this case.
3.2 Twitter Stream Data
For task3, you need to analyze the twitter streaming data using Twitter APIs. Please follow the instruction to set up Twitter APIs.
a. CreatecredentialsforTwitterAPIs
– Register on https://apps.twitter.com/ by clicking on “Create new app” and then fill the form click on “Create your Twitter app.”
– Go to the newly created app and open the “Keys and Access Tokens”. Click on “Generate my access token.” You will need to use these tokens as arguments when executing the code.
b. Addlibrarydependenciesinthecode
– You can use Python library, tweepy. To install the library, you can use “pip install tweepy”.
– You can use Scala libraries, spark-streaming-twitter and spark-streaming. To install the
libraries, you can add the library dependencies in the sbt.
http://docs.tweepy.org/en/3.7.0/streaming_how_to.html http://bahir.apache.org/docs/spark/current/spark-streaming-twitter/
4. Tasks
4.1 Task1: Bloom Filtering (4.5 pts)
You will implement the Bloom Filtering algorithm to estimate whether the city of a coming business in the data stream has shown before. The details of the Bloom Filtering Algorithm can be found at the streaming lecture slide. You need to find proper hash functions and the number of hash functions in the Bloom Filtering algorithm.
In this task, you should keep a global filter bit array and the length is 200. Some possible the hash functions are:
f(x)= (ax + b) % m or f(x) = ((ax + b) % p) % m
where p is any prime number and m is the length of the filter bit array. You can use any combination for the parameters (a, b, p). The hash functions should keep the same once you created them.
As the city of a business is a string, you need to convert it into an integer and then apply hash functions to it., the following code shows one possible solution:
import binascii
int(binascii.hexlify(s.encode(‘utf8’)),16)
(We only treat the exact the same strings as the same cities. You do not need to consider alias.)
Execution Details
In Spark Streaming, set the batch duration to 10 seconds: ssc=StreamingContext(sc , 10)
You will get a batch of data in spark streaming every 10 seconds and you will use the Bloom Filtering algorithm to estimate whether the coming city appeared before or not since the beginning of your code.
You need to maintain a previous city set in order to calculate the false positive rate (FPR). We will test your code for 10 minutes.
Output Results
You need to save your results in a CSV file with the header “Time,FPR”. Each line stores the timestamp when you receive the batch of data and the false positive rate. The time format should be “YYYY-MM- DD hh:mm:ss” (Figure 1 shows an example). You do not need to round your answer.
Figure 1: Output file format for task1
4.2 Task2: Flajolet-Martin algorithm (4.5 pts)
In task2, you will implement the Flajolet-Martin algorithm (including the step of combining estimations from groups of hash functions) to estimate the number of unique cities within a window in the data stream. The details of the Flajolet-Martin Algorithm can be found at the streaming lecture slide. You need to find proper hash functions and the number of hash functions in the Flajolet-Martin algorithm.
Figure 2: Spark Streaming window
For this task, the batch duration should be 5 seconds, the window length should be 30 seconds and the
Execution Details
sliding interval should be 10 seconds. We will test your code for 10 minutes.
Output Results
You need to save your results in a CSV file with the header “Time,Gound Truth,Estimation”. Each line stores the timestamp when you receive the batch of data, the actual number of unique cities in the window period, and the estimation result from the Flajolet-Martin algorithm. The time format should be “YYYY-MM-DD hh:mm:ss” (Figure 3 shows an example). You do not need to round your answer.
Figure 3: Flajolet-Martin output file format
4.3 Task3: Fixed Size Sampling on Twitter Streaming (3.5pts)
You will use Twitter API of streaming to implement the fixed size sampling method (Reservoir Sampling Algorithm) and find popular tags on tweets based on the samples.
In this task, we assume that the memory can only save 100 tweets, so we need to use the fixed size sampling method to only keep part of the tweets as a sample in the streaming. When the streaming of the Twitter coming, for the first 100 tweets, you can directly save them in a list. After that, for the nth twitter, you will keep the nth tweet with the probability of 100/n, otherwise discard it. If you keep the nth tweet, you need to randomly pick one in the list to be replaced. If the coming tweet has no tag, you can directly ignore it.
You also need to keep a global variable representing the sequence number of the tweet. If the coming tweet has no tag, the sequence number will not increase, else the sequence number increases one.
Every time you receive a new tweet, you need to find the tags in the sample list with the top 3 frequencies.
Output Results: you just need to print your results in the terminal
In the first line, you should print the sequence number of this new tweet as shown in the example. Then, you should print the tags and frequencies in the descending order of frequency. If some tags share the same frequency, you should print them all and ordered in lexicographic order (Figure 4).
Figure 4: Twitter streaming printing information example
4.4 Execution Format
Python:
spark-submit task1.py
spark-submit task3.py
Scala:
spark-submit –class task1 hw5.jar
spark-submit –class task3 hw5.jar
Input parameters:
1.
2. < output_file_path>: the output file including file path, file name, and extension.
Note:
It’s OK to have the following error in your submission log:
5. Grading Criteria
(% penalty = % penalty of possible points you get)
a. There will be 10% bonus for each task if your Scala implementations are correct. Only when your Python results are correct, the bonus of Scala will be calculated. There is no partial point for Scala.
b. There will be no point if your submission cannot be executed on Vocareum.
c. There is no regrading. Once the grade is posted on the Vocareum, we will only regrade your assignments if there is a grading error. No exceptions.
d. No late submissions allowed.