best practices on data storage?

Antonio Rohman Fernandez rohman at mahalostudio.com
Thu Jul 28 02:26:28 EDT 2011


  

Yesterday, somebody suggested that not for having the data
distributed on smaller buckets, Riak's MapReduce operations would be
faster... while nobody at Basho confirmed that yet, i'm now wondering
which is the best way for storing data... lets imagine this simple
excercise:

1. We have entities users, friends, statuses and comments in
a web app
2. Users can make friends with other users
3. Users can post
statuses
4. Friends ( Users ) can comment on user's statuses 

At first
i thought on having a bucket called "users" with all users and then for
friend linkage i was thinking on having personal buckets like
"rohman_friends", "fyodor_friends", etc... with the keys to the users
instead of a big "friends" bucket for easy querying... but seems i'm
wrong... so...

How would you distribute the data on buckets? and how
would you run MapReduce jobs? Would you use a support SQL database to
store relationship between keys? is possible on an only Riak
environment?
thanks

Rohman 

 		 [1]

 ANTONIO ROHMAN FERNANDEZ
CEO,
Founder & Lead Engineer
rohman at mahalostudio.com [2] 		 

PROJECTS
MaruBatsu.es [3]
PupCloud.com [4]
Wedding Album [5] 

  


Links:
------
[1] http://mahalostudio.com
[2]
mailto:rohman at mahalostudio.com
[3] http://marubatsu.es
[4]
http://pupcloud.com
[5] http://wedding.mahalostudio.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.basho.com/pipermail/riak-users_lists.basho.com/attachments/20110728/174f3d4e/attachment.html>


More information about the riak-users mailing list