NoSQL Zone is brought to you in partnership with:

I'm Singaram Subramanian, and I work with CSC India as a Software Developer. My blog is an attempt to share my learnings with all (mainly, for those who desperately mine google finding ways to solve problems, fix issues, learn about a Java/Open source software, or deciding on tough choices etc. during software development as I do). Singaram is a DZone MVB and is not an employee of DZone and has posted 36 posts at DZone. You can read more from them at their website. View Full User Profile

NoSQL: An Analysis of the Strengths and Weaknesses

02.04.2012
| 9487 views |
  • submit to reddit

What is NoSQL, how is it different from RDBMS?

In computing, NoSQL (sometimes expanded to “not only SQL”) is a broad class of database management systems that differ from the classic model of the relational database management system (RDBMS) in some significant ways, most important being they do not use SQL as their query language. These data stores may not require fixed table schemas, usually avoid join operations, and typically scale horizontally. Academic researchers typically refer to these databases as structured storage, a term that includes classic relational databases as a subset.

More on this @ http://en.wikipedia.org/wiki/NoSQL

NoSQL databases categorization / types

Often, NoSQL databases are categorized according to the way they store the data and it falls under categories such as

  • Wide Column Store / Column Families – Hadoop / HBase, Apache Cassandra, Hypertable, Amazon SimpleDB, etc.
  • Document StoreMongoDB, CouchDB, OrientDB, etc.
  • Key Value / Tuple Store – Azure Table Storage, MemcacheDB, Berkeley DB, etc.
  • Graph Databases – Bigdata, HyperGraphDB, Infinite Graph, FlockDB etc.
  • Object Databases – db40, Objectivity, Versant, etc.
  • Grid & Cloud Database Solutions: Hazelcast, GigaSpaces, etc.
  • XML Databases – EMC Documentum xDB, eXist, Berkeley DB XML, etc.

More on this @ http://nosql-database.org/

NoSQL – SWOT Analysis

Strengths

  • Uninterrupted access/high availability
  • Scalability
  • Security and flexibility
  • Freedom to choose

Weakness

  • Porting the applications
  • No Normalization, unions or joins
  • Lost updates

Opportunities

  • Huge investments
  • Data Intensive applications

Threats

  • FOSS business model
  • FUD (Fear, uncertainity and doubt) amongst Users

The dark side of NoSQL

There is a dark side to most of the current NoSQL databases. People rarely talk about it. They talk about performance, about how easy schemaless databases are to use. About nice APIs. They are mostly developers and not operation and system administrators. No-one asks those. But it’s there where rubber hits the road.

  • ad hoc data fixing – either no query language available or no skills
  • ad hoc reporting – either no query language available or no in-house skills
  • data export – sometimes no API way to access all data

More on this @ http://codemonkeyism.com/dark-side-nosql/

Related articles

 

From http://singztechmusings.in/getting-started-with-nosql-nosql-vs-rdbms-types-of-nosql-databases-swot-analysis-and-dark-side-of-nosql/

Published at DZone with permission of Singaram Subramanian, author and DZone MVB.

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)

Tags:

Comments

Anuj Sahni replied on Fri, 2012/02/10 - 2:03am

Hi Singaram, I am product-manager of Oracle NoSQL Database and was wondering if you could include 'Oracle NoSQL Database' to the list of Key-Value databases?

There is a very nice white-paper and other product related material that you can find on OTN. If you would like to do a tech overview of Oracle NoSQL Database then I will be happy to help.

Thanks

-Anuj

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.