Reply to: NoSQL database

[swamp]

Tis interesting. Apparently, traditional RDBMS couldn’t handle the vast amount of data the likes of Google processes.

Facebook used to run on MySQL. It didn't scale so they wrote Cassandra instead.

[oscarose]

NoSQL:

1. Little or no normalisation or type safety.
2. Data structures have to be designed in terms of how you retrieve them.

Now point 1. may be a bit scary for old-school developers/DBAs, but with vast numbers of automated tests you can argue you don't really need guaranteed DB integrity.

Point 2. sounds awkward, but on the flip side you can change your schemas whenever you want.

Mix it all together and you get something that is massively scalable.

Tis interesting. Apparently, traditional RDBMS couldn’t handle the vast amount of data the likes of Google processes. I’ll be learning these new techniques over the season of good will and applying to the portfolio – a new box is on order to conduct these tests.

[Sysman]

Several TB of data, all memory resident, spread across a 20 node, 80 CPU, 640 core cluster - with guaranteed sub millisecond access to any piece of data, including complex aggregations?

That really was some impressive "stuff" you were doing "back in the day."

Ahem.

For the hardware available 30 years ago we got some impressive results.

Says Sysman who managed to cut something that took all weekend to run down to 20 minutes...

By redesigning keys.

My statement still stands.

[swamp]

NoSQL:

1. Little or no normalisation or type safety.
2. Data structures have to be designed in terms of how you retrieve them.

Now point 1. may be a bit scary for old-school developers/DBAs, but with vast numbers of automated tests you can argue you don't really need guaranteed DB integrity.

Point 2. sounds awkward, but on the flip side you can change your schemas whenever you want.

Mix it all together and you get something that is massively scalable.

[eek]

They're potty to use[*] - I got the hang of MongoDB in half an hour and was merrily coding away using it in perl & python scripts

[*] But for flip's sake don't tell the clients that!

+1. Mongodb is easypeasy.

[OwlHoot]

Sum bozo was on 'bout this today. What's the crack with NoSQL databases; google and others use 'em? Do I need to worry?

(if there is a solution to the problem don't worry - if there's no solution to the problem don't worry)

Yours in peace.

They're potty to use[*] - I got the hang of MongoDB in half an hour and was merrily coding away using it in perl & python scripts

[*] But for flip's sake don't tell the clients that!

[nomadd]

Some of us were quite good at that stuff back in the day.

Several TB of data, all memory resident, spread across a 20 node, 80 CPU, 640 core cluster - with guaranteed sub millisecond access to any piece of data, including complex aggregations?

That really was some impressive "stuff" you were doing "back in the day."

[d000hg]

Perhaps CUK General is not the best place to ask this question. I wonder if the internet might hold any information Or even CUK Technical!

[Sysman]

They'll do it wrong. The thing to ask them is why do they want to do it and then why at least three more times.

At its crudest No SQL is really just glorified key values and unless you have those keys set up correctly the data is worse than useless. Well not quite but it's work to get it out

Some of us were quite good at that stuff back in the day.

[eek]

You need to hire an experienced contractor who knows what he/she is doing.

Unfortunately, I'm just about to start a new gig. next week.

Give me a call in the Spring.

I'm possible available January. i'm not however planning for a commute much further than bedroom to my office in the spare bedroom.

[nomadd]

Sum bozo was on 'bout this today. What's the crack with NoSQL databases; google and others use 'em? Do I need to worry?

You need to hire an experienced contractor who knows what he/she is doing.

Unfortunately, I'm just about to start a new gig. next week.

Give me a call in the Spring.

[garethevans1986]

TekPub - RavenDb videos...go watch.

[BrilloPad]

Having to put some effort in and learn new stuff.

Most of these tools are quite easy for any half competent developer. Its great if you get in first then can add another £100 a day for these skills.

[eek]

NoSQL database

They'll do it wrong. The thing to ask them is why do they want to do it and then why at least three more times.

At its crudest No SQL is really just glorified key values and unless you have those keys set up correctly the data is worse than useless. Well not quite but it's work to get it out

[oscarose]

Why do you need to worry. Its another tool which can be used for particular tasks which has its own set of advantages and disadvantages.

Having to put some effort in and learn new stuff.