Description
Designed a “Fakebook” relational and NoSQL database (Oracle SQL, MongoDB) for Social Network and built a Java application for a friend recommendation.
- Designed a “Fakebook” Oracle Database for Social Network including users, photos, albums, events, and messages.
- Built the “Fakebook” Oracle Database by extracting and purifying fields from public datasets and prepared the dataset for testing.
- Implemented a friend recommendation system based on users’ common information using Java with JDBC.
- Exported Oracle SQL data using JSON into MongoDB, and implemented queries using JavaScript.
- Designed a MapReduce program in MongoDB to find city-average friend count and count of users born in each month.
Links
Github link
https://github.com/hsinhu/eecs484-hw
Private repository because of the honor code requirement of EECS 484. But can share if request.