3 ms·
Underneath the hood all database systems contain the same basic elements: an implementation of relational algebra operators and a concurrency control mechanism.
by jandrewrogers 14y ago
Underneath the hood all database systems contain the same basic elements: an implementation of relational algebra operators and a concurrency control mechanism. Even nominally "non-relational" databases, like graph databases, are built on top of relational operator implementations (you say "graph traversal" and I say "join recursion").
What has traditionally separated the NoSQL databases from the SQL databases is that they implement a smaller subset of relational algebra e.g. the famous lack of join operators. This gave them the latitude to throw out the SQL interface and build interfaces that were more domain specific and a better match for what some applications need to do.
Now we are starting to see new databases that are discarding the SQL orthodoxy but with a relational algebra implementation that is as expressive as anything found underneath a conventional SQL database. They could implement SQL if they wanted to but there is less of a compulsion to do so than there used to be. Hopefully this will lead to the best of both worlds.
- MattRogish 14y ago"NoSQL" projects have thrown out the relational baby with the bath water and instead implemented their own data model (mostly made-up). The Relational Model is (hugely simplified) predicate logic and set theory combined with logical/physical data independence and integrity. Relational algebra (selection, projection, union, etc.) are important but just a part (very important, of course, as it gives us a sound theoretical foundation to implement from) of the query language. The "Management System" part of the "DataBase Management System" are the constraints, logical/physical representation, data model, etc. - which IMHO represent the bulk of what a DBMS ought to do. What sounds interesting about Nuodb is that they've kept the sound relational fundamentals and created something that is what the relational model has espoused from the beginning. Or so it reads.