Jim Lawrence
jlawrenc1 at shaw.ca
Tue Sep 20 19:23:49 CDT 2011
You are living out of stream John. I know of a number of people now who are working with such technology and very successfully, I might add, but the technology is not Main Street, as it is not advertised similar to Linux. It will take longer to be common knowledge, as there is no huge advertising machine behind Open Source products. Our provincial government has been working with Google to build a huge land database and the results are stellar. Milliseconds to pull all data on any encumbrances on a lot or parcels of lots. Before, running with the traditional SQL technologies it would take hours to get the same results. People working with the new system thought it was broken at first as the results were so fast...now they have become use to instantaneous gratification. The interesting thing is that the new system is using the old hardware as the project was supposed to be just a test...some test. A few years ago, I installed a blade, painted indigo and marked Google, at the legislator. The box was supposed to take all the comments from the sessions, translate them into text and then allow anyone to pull the comments back from any time within that session. Again, standard SQL had been tried and had failed...and again instantaneous gratification. There are many other instananeous of this type Reduces map technology is being used but it is only for situations where huge chunks of data need to pull results from very complex queries and quickly. It is also for someone with a limited budget as NOSQL databases do not need place holder fields for partially filled rows. This generally translates into a complex set of data filling less than half the space of a traditional SQL DB and therefore less hardware. There are even new hybred data solutions coming out where both Map Reduce and traditional SQL are being used to extract data. " ...LexisNexis is releasing a set of open-source, data-processing tools that it says outperforms Hadoop and even handles workloads Hadoop presently can't. The technology (and new business line) is called HPCC Systems... " http://gigaom.com/cloud/lexisnexis-open-sources-its-hadoop-killer/ Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, September 20, 2011 1:03 PM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] [AccessD] MySQL Jim, > The truth be known, NOSQL or Reduce data-set databases would solve your data, memory and resource problems with effortless ease. I have never seen anything to support that. I also don't see anybody moving their relational databases to these things? Where are you seeing this? John W. Colby www.ColbyConsulting.com On 9/20/2011 2:10 PM, Jim Lawrence wrote: > Hi John: > > The truth be known, NOSQL or Reduce data-set databases would solve your > data, memory and resource problems with effortless ease. That could not be > said for the support tech, yourself; who would would virtually have start > learning from square one, with little help or documentation. > > Getting skilled in the new frontier is for bright young techs and old techs > with more time on their hands than money. ;-) > > Jim _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com