Ask YC/HN: Database Resources and Help
The issue that troubles me is appropriately organizing tables and efficiently organizing the information. I am familiar with normalization and some of the basic concepts involved with such but I feel as though I am missing some possible rules of thumb or methods that individuals go about when designing the databases.
For example, take a site like HN or Digg, what would be the appropriate way to organize user accounts, profiles, each submitted site, the comments for each site, etc. Logically, I would think that if a user made a comment, it would be appropriate to insert that comment into both the table for the user as well as the table for the site be commented on, but that may be an extremely naive approach to handling such a task. I understand that to most here this seems as though it is most likely an obvious question but if I had definitive knowledge to make an educated decision, I would do so.
Ideally I would love some quality online resources or a simple explanation over the way you hackers go about the design phase. Good books would be appreciated but I am tight on cash so nothing too pricey.
Thanks for any responses you guys give. I understand this is quite a noob question and there might be a more appropriate forum out there for such a query, but I really value the analysis from most of this community. Cheers!