Requirements:
- group activity, where all my followers can see my activity
- book discovery platform, search for a book based on criteira
- discover a book by some criteria
- review and rate a book and author
- user can create his book shelf private or public
- Set reading goal
- list of generes
- listing a book with book images and details
- activity dashboard to be seen as to followers
- Show the readers user list, sorted by the order of user priority
Expectations:
running code - rating system data model what type of database high level services how do we keep book details while listing like media
Extension:
persona based recommendations recommendations based on users past activity book rating based on fixed questionnaire
database design
author book mapping: mapping book data: in sql
user book shelf what kind of DB, we will be using: sql
user review rating and activity timeline: columnar DB like Cassandra
- aggregation needed
- good performing defined query
- not a transitional data
- more wright
- horizontal scaling
Discover a book:
- need fast
- need some suggestions for users
- text based search
- search based on near to name
DB design: User Book User Activity UserActivityParticipants (followers, participants) contest/ shelf / channel Book Review Author details Configs for books and user reading goal