Hacker News new | past | comments | ask | show | jobs | submit login
Secondary Indexes - How would you do it (in Riak) (facility9.com)
23 points by ihumanable on Dec 16, 2010 | hide | past | favorite | 2 comments



While perhaps not intentional, this is a great illustration of why RDMBS are so great for general purpose data storage. If your data have fields like "birthdate" and "last_name" and you need to be able to do quick retrievals based on equality or ranges of those values, use a relational database. They've had indexing and index maintenance figured out for decades.


That thought did cross my mind while I was writing it. Indexes give you the ability to do ad hoc querying, but they have a tremendous cost to them, at least in terms of the complexity that they add to the database. Part of the point (since I don't actually work on Riak) is to point out what RDBMSes give you out of the box.

Thanks for reading it all.




Consider applying for YC's Spring batch! Applications are open till Feb 11.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: