linkset

Tuesday, May 7, 2013

Some more facts about NoSQL databases

Pros
  • Mostly open source.
  • Horizontal scalability. 
  • There’s no need for complex joins and data can be easily sharded? and processed in parallel.
  • Support for Map/Reduce. This is a simple paradigm that allows for scaling computation on cluster of computing nodes.
  • No need to develop fine-grained data model – it saves development time.
  • Easy to use.
  • Very fast for adding new data and for simple operations/queries.
  • No need to make significant changes in code when data structure is modified.
  • Ability to store complex data types (for document based solutions) in a single item of storage.
Cons
  • Immaturity. Still lots of rough edges.
  • Possible database administration issues. NoSQL often sacrifices features that are present in SQL solutions “by default” for the sake of performance.
  • No indexing support (Some solutions like MongoDB have indexing but it’s not as powerful as in SQL solutions).
  • Bad reporting performance..
  • Absence of standardization. No standard APIs or query language. It means that migration to a solution from different vendor is more costly. Also there are no standard tools (e.g. for reporting)

No comments:

Post a Comment