In CSE412: Database Management, our team made a smart book recommendation website. Users added their favorite books to the system and our website will recommend relevant books for them based on their favorite books. Our database stores more than a million rows of data, which is also a good reference for recommendations.
About Project
In this project, I was mainly responsible for the Data Processing of the whole project (including Data cleaning before Data import, SQL statement design, database maintenance), database building, and providing technical support for website builders in terms of database.
Data source provided by Goodreads.
The technologies used:
- PostgreSQL
- React.js
- Bootstrap
- Node.js
Team members:
- 索伟嘉
- Mitchell Bucklew
- Qingya Chen
- Christopher Canales
- Tsz San Chong
- Ting Xia
Now, let’s see how it’s work.
This page allows the user to create a new account, the userid is randomly assigned by the system, and the user is notified when log in.
The home page displays the user’s list of books. On the left is a list of books that we randomly generate, which changes every time. The top right shows the user’s favorite books. If you click the “Recommend?” below, system will recommend corresponding books for users based on user data of more than 1 million lines in the background.
If you have any questions, please contact me : )