Recently, I have been reading a lot about NoSQL and in particular the open source cassandra. From my current readings, it does not look like NoSQL is a direct competitor to SQL Server, since they seem to fill separate but closely related niches. Yet, it is a database technology and I could see situations where they might be deployed side by side.
So, I have 3 tightly related questions for the community:
asked Oct 21 '10 at 01:43 PM in Default
Timothy - good question! +1
I am sure that NoSQL has it's place for certain applications like Twitter and the like where data integrity is of much less importance than what a SQL Server DBA may see as a "real" database.
As I understand it NoSQL implementations drop performance killing features like referential integrity in order to make themselves more flexible and scalable - again, something that detracts from it being a "real" database and more a temporary/dispersed data store.
For those reasons, and many more, I don't think that NoSQL will move into a position where it could displace SQL Server. That is if they stay on their current path of development.
I still believe that learning a NoSQL variant can be valuable. You would have an insight into that type of system and it gives you another weapon in your arsenal. On top of that, it is just an interesting technology, so why not!As to which one is the right one to start with, no idea. Tell me once you have found out! I spend so much time trying to learn SQL Server already, I couldn't find the time for something that (currently) doesn't have any bearing at work.
answered Oct 21 '10 at 01:52 PM
yeah, great question Timothy.
my, largely uneducated, thoughts are:
answered Oct 21 '10 at 02:00 PM
I think it's useful to distinguish between NoSQL as an idea versus the collection of products that currently go under that name. In principle replacing SQL with something better ought to have a lot of benefits. It's bound to happen sooner or later and probably sooner than many people would expect. However, none of the current crop of software commonly called NoSQL looks like a serious SQL-beater (unfortunately). Mainly because they mostly eschew the relational model in favour of less useful alternatives.
According to this tiny news article, Cassandra may end up being capable of [sitting on top of SQL Server] & Oracle:
If that's the case, then Cassandra is not a direct competetor with SQL Server. But I'd be willing to bet that SQL DBA's will be asked to work with it!: h ttp://www.zdnet.com/blog/open-source/cassandra-becoming-the-nosql-alternative/5971
answered Oct 21 '10 at 02:30 PM