Need stock history? How many stocks? Exchanges across the world? Just stocks or MFs, bonds?
Time of market close: assume query.
How many users? Any scalability requirements?
Any future analysis?
CAP theorem.
CA: normalized SQL with REST API for security.
Or NoSQL with composite key of stock symbol, user id & date. (CA, CP or AP depending on requirements).
Or HDFS with indexed keys as user id & stock symbol.
If needing stocks by category to suggest & want to know what friends are following, graph db linking users and/or stocks.
No comments:
Post a Comment