Jim Lawrence
accessd at shaw.ca
Sun Apr 13 13:26:40 CDT 2014
Hi Stewart: Anyone or company that thinks the NoSQL is a solution to all their database problems does not understand databases at all. MapReduce databases are built for huge amounts of very random data, received at very high rates and volumes, where complex queries are needed to extract it and all this has to be done in real time. If your data requirements are under a few million don't bother. Straight SQL is your solution. The limits of traditional SQL databases are rigid schemas, limited query joins, limited data sizes (as SQL by nature is a vertical data store), limit performance (designed for single server structure) and so on. OTOH, no modern major data search, analysis, warehouse or Cloud company would exist if it were not for NoSQL databases...yes, not even the threat of the NSA would exist. Most people buy Pickups instead of Euclid trucks for a good reason and it is not just that they are easier to park. The NOSQL databases, like the Cloud solutions, are still in their infancy and unless a company has the talent, can learn fast, creative enough to think outside the box and ability to rough it, they are at the wrong end of the business pool. Note: Many of the new data solutions are using mixed SQL and NoSQL hybrids. Jim ----- Original Message ----- From: "Stuart McLachlan" <stuart at lexacorp.com.pg> To: "Discussion of Hardware and Software issues" <dba-tech at databaseadvisors.com> Sent: Saturday, April 12, 2014 3:52:54 PM Subject: [dba-Tech] NoSQL? Posted without further comment :-) http://www.theregister.co.uk/2014/04/11/nosql_to_sql_migration/ -- Stuart _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com