Transmission Line Noise

NoSQL Article

Thu, May 13, 2010

Excel­lent overview of NoSQL data­bases, data stores here includ­ing a dia­gram that makes it eas­ier to visu­al­ize what is happening.

In brief the author clas­si­fies them as follows

  • Relato joins (joins must be han­dled within your appli­ca­tion). Obvi­ously, they store data by col­umn as oppoional sys­tems are the data­bases we’ve been using for a while now. RDBMSs and sys­tems that sup­port ACID­ity and joins are con­sid­ered relational.
  • Key-value sys­tems basi­cally sup­port get, put, and delete oper­a­tions based on a pri­mary key.
  • Column-oriented sys­tems still use tables but have nsed to tra­di­tional row-oriented data­bases. This makes aggre­ga­tions much easier.
  • Document-oriented sys­tems store struc­tured “doc­u­ments” such as JSON or XML but have no joins (joins must be han­dled within your appli­ca­tion). It’s very easy to map data from object-oriented soft­ware to these systems.