Example database

The dataset used in the tutorials is a social network dataset of users and posts that has the following schema.

Nodes

`User`

The User node represents users within the social network. Each user has their information attached, such as:

user_id (INT64): This is an unique id which is used to sort and find users.
username (STRING): This is the unique username which each user will have.
account_creation_date (DATE): This represents the date which the account was created.

userID,username,account_creation_date
1,epicwolf202,2022-09-09
2,silentninja637,2023-01-27
3,stormcat597,2023-02-25
4,brightking765,2023-05-11
5,fastgirl798,2021-06-11

`Post`

The Post node represents the posts which has been made on the social network. Each post has its information attached, such as:

post_id (INT64): This is an unique id which is used to sort and find posts.
creation_date (DATE): This represents the date which the account was created.
like_count (INT64): This represents the amount of likes the post has received.
retweet_count (INT64): This represents the amount of retweets the post has received.

postID,creation_date,like_count,retweet_count
1,2021-12-08,427,29
2,2022-06-02,9,16
3,2023-01-14,238,51
4,2023-01-06,67,147
5,2022-10-26,103,73

Relationships

`FOLLOWS`

The relationship FOLLOWS goes from User node to User node. This relation represents a user following another user on the social network.

followerID,followeeID
1,7
1,6
2,17
2,10
2,13

`POSTS`

The relationship POSTS goes from User node to Post node. This relation represents a user posting the post on the social network.

userID,postID
17,1
4,2
15,3
7,4
14,5

`LIKES`

The relationship Likes goes from User node to Post node. This relation represents a user liking the post on the social network.

userID,postID
16,1
2,1
4,1
13,1
11,1

Define the schema in Kuzu

In the Kuzu CLI, let’s create a node table for the Users in our dataset.

CREATE NODE TABLE User(
    userID INT64 PRIMARY KEY,
    username STRING,
    account_creation_date DATE
);

┌──────────────────────────────┐
│ result                       │
│ STRING                       │
├──────────────────────────────┤
│ Table User has been created. │
└──────────────────────────────┘

We can do a similar thing for the Posts in our dataset.

CREATE NODE TABLE Post(
    postID INT64 PRIMARY KEY,
    creation_date DATE,
    like_count INT64,
    retweet_count INT64
);

┌──────────────────────────────┐
│ result                       │
│ STRING                       │
├──────────────────────────────┤
│ Table Post has been created. │
└──────────────────────────────┘

Now that we have our node tables, we can create a relationship table for the FOLLOWS and POSTS relationships in our dataset.

CREATE REL TABLE LIKES(From User To Post);
CREATE REL TABLE FOLLOWS(From User To User);
CREATE REL TABLE POSTED(From User To Post);

┌───────────────────────────────┐
│ result                        │
│ STRING                        │
├───────────────────────────────┤
│ Table LIKES has been created. │
└───────────────────────────────┘

┌─────────────────────────────────┐
│ result                          │
│ STRING                          │
├─────────────────────────────────┤
│ Table FOLLOWS has been created. │
└─────────────────────────────────┘

┌────────────────────────────────┐
│ result                         │
│ STRING                         │
├────────────────────────────────┤
│ Table POSTED has been created. │
└────────────────────────────────┘