The first step is to pre-process the data. As the data table contains multiple values in one cell, it cannot be used for MySQL relations. In order to use the data in any DBMS, you have to pre-process it.

To parse the data, JAVA. Once parsed, store the parsed CSV file(s) on your local machine for future use. Remember that, parsing is done only once, but the parsed data can be used as many times as we want.

Submission: Submit the code to parse the data along with the parsed data. Note that, you are creating any table inside MySQL at this point. You are preparing a code that you will use later for parsing the data and importing into the MySQL database.

Your code design will also affect your final product. Be sure to keep the final goal (recommendation engine) in mind while designing any component of the project.

Example

Following is an example of attribute "genres" of the movie Avatar. Your code should be able to parse it and extract the genre names and id's.

[{"id": 28, "name": "Action"}, {"id": 12, "name": "Adventure"}, {"id": 14, "name": "Fantasy"},

{"id": 878, "name": "Science Fiction"}]

PreviousNext