Classic RDBMS Architecture is slowly being phased out

Classic RDBMS Architecture is slowly being phased out

by Darko Miletić -
Number of replies: 7
Picture of Core developers Picture of Plugin developers

Michael Stonebraker on Current Developments in Databases

http://www.se-radio.net/2013/12/episode-199-michael-stonebraker

Average of ratings: -
In reply to Darko Miletić

Re: Classic RDBMS Architecture is slowly being phased out

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

... says a "technology entrepreneur" who presumably has something to sell.

No-one gets rich if everyone uses a 30-year-old tried and tested technology that works reliably and is available for commodity prices. (E.g. MySQL and Postgres are free). However, the lack of vigorous marketing does not mean that it is a bad idea.

In reply to Tim Hunt

Re: Classic RDBMS Architecture is slowly being phased out

by Darko Miletić -
Picture of Core developers Picture of Plugin developers

He does have a sales pitch but he is not some generic silicone valley dude. He has a significant career in DB area and it is at least interesting to listen to what he says.


In reply to Darko Miletić

Re: Classic RDBMS Architecture is slowly being phased out

by Anne Krijger -

Were do you see an overlap with Moodle though?

NoSQL is indeed interesting, but I don't quite see what area of Moodle would benefit from it?

Anne.

In reply to Anne Krijger

Re: Classic RDBMS Architecture is slowly being phased out

by Dan Marsden -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Plugins guardians Picture of Testers Picture of Translators

we already have a mongodb plugin for caching and logging is another area that could potentially benefit from using NoSQL

In reply to Anne Krijger

Re: Classic RDBMS Architecture is slowly being phased out

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

I sometimes think that it would work better to store question definitions in the question bank using a NoSQL approach, rather than the current multiple relational tables. (e.g. it would make full-text search easier). However, since all the rest of Moodle uses a relational approach, I think it would a bad idea for one specific area (the questoin bank) to break that pattern.

Arguably, blocks have alwas taken a sort-of 'NoSQL' aproach (since before that buzz-word existed) with the block_instances.configdata column storing a blob of data, rather than using a normalised database structure for those settings.

In reply to Tim Hunt

Re: Classic RDBMS Architecture is slowly being phased out

by Marcus Green -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers

Oooh those blobs are horrible.

In reply to Anne Krijger

Re: Classic RDBMS Architecture is slowly being phased out

by Darko Miletić -
Picture of Core developers Picture of Plugin developers

NoSQL is not panacea and I'm not advocating that current Moodle switches to NoSQL. I'm just thinking about future. Moodle can be scaled but it is a pain to do so because of the way it is built. If full power of horizontal scaling is to be achieved Moodle needs to be completely redesigned internally, and at least partially nosql could be part of that effort.