Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

INST0069

Exercises on graph databases

The assignment is worth 50 % of the overall assessment for this course

This assignment must be completed: As an individual piece of work.

Date work set (provisional): 27/01/2024

Date and time due in (provisional): 3pm on Monday, 11 March 2024

Standard lateness penalty will apply

Target date for return of marked work and full feedback (provisional): 8 April 2024 (tentatively within 4 working weeks, according to DIS policy)

Description

Using the Cypher statements given in the next section, you will create on Neo4j Desktop a graph database describing a fictitious social network where users share information about the books they have read. In this network, users can follow other users and rate the books they have read. The database contains information about the users (username and age), the books (id, title, genre, author and publisher), the “follows” relationships among the users, the “read” relationships between the users and the books, and the ratings of the users for the books they have read.

For the first exercise, you will create appropriate Cypher statements to retrieve information from the database (as described in the exercise). For the second exercise, you will think of some simple recommendation algorithms with which you would recommend users to follow or books to read to a user of the network and implement these algorithms using Cypher statements.

Your report must contain:

-    The Cypher statements that you created for exercise 1.

-    The Cypher statements that you created for exercise 2 along with some brief description of the recommendation algorithms they implement.

Setup

Before you attempt the exercises, follow the steps below to create the graph database on Neo4j  Desktop. Examine the csv files and the database that you created to verify that the database has been correctly implemented and to familiarise with the structure of the database.

1.   Using Neo4j Desktop, create a new graph database and name it Book Graph.

2.   Download from Moodle and copy the files books.csv, users.csv, followers.csv and ratings.csv to the import folder of your database.

3.   Run the following Cypher statements (one at a time) to populate the database with data about books, the users of a social network, the relationships among the users and the relationships  between the users and the books.

a .  LOAD  CSV  WITH  HEADERS  from   'file:///books.csv'  AS  book

CREATE  (:Book  {bookID:book.BookId ,  title:book.Title,  genre:book.Genre, author:book.Author,  publisher:book.Publisher})

This should create 101 nodes with label Book, each with a bookID, a title, a genre, an author and a publisher property.

Marking Criteria and Procedure

This set of exercises counts as 50% of the total course assessment. Exercise 1 is worth 30% (marks are divided equally among its subquestions) and Exercise 2 is worth 20% (marks are  divided equally among its subquestions). Marks will be awarded according to:

-    whether the answers are technically correct (i.e. the syntax of the Cypher statements is correct and the statements produce the correct results)

-    whether the answers given are as straightforward as possible and not more complicated than necessary

-    whether the answers are set out clearly and in good style

-    (for Exercise 2) whether the recommendation algorithms are clearly described and correctly implemented and the recommendations they produce are reasonable

Each submission will be first marked according to the criteria given above, and a sample of

submissions will also be second marked, using open and check marking, in accordance with the   guidelines in https://www.ucl.ac.uk/academic-manual/chapters/chapter-4-assessment-framework- taught-programmes/section-4-marking-moderation#4.6