Programming Main Page

NoSQL Reference Links

http://globalbigdataconference.com/news/6712/its-time-to-say-yes-to-nosql.html

It’s Time To Say Yes to NoSQL

Data Volume,  (scale out on commodity hardware)
Elasticity, (scale up, scale down for cloud work)
Administration, (simpler data models lead to lower admin)
Flexible Data Models,  (less rigid than RDBMS, allows for easier innovation)
Economics (cheap generic servers)

 

Two Cons against NoSQL. Part I.

http://www.odbms.org/blog/2012/10/two-cons-against-nosql-part-i/

Prof. Roberto V. Zicari is editor of ODBMS.ORG (www.odbms.org) .

Transfer between NoSQL databases is hard.  But it is early.   JSON is an early standard that is making it easier.

There is not standard way to access a NoSQL data store.   How do you get a query of the database into Excel?

Comment from :Dwight Merriman: …Also I think there is a bit of an illusion of portability with relational. There are subtle differences in the SQL, medium differences in the features, and there are giant differences in the stored procedure languages.

Export to Excel:

Dwight Merriman: So with MongoDB what I would do would be to use the mongoexport utility to dump to a CSV file and then load that into excel. That is done often by folks today. And when there is nested data that isn’t tabular in structure, you can use the new Aggregation Framework to “unwind” it to a more matrix-like format for Excel before exporting.

You’ll see more and more tooling for stuff like that over time. Jaspersoft and Pentaho have mongo integration today, but the more the better.