Read the HarperDB teams’ thoughts on database technology topics such as SQL, NOSQL, Edge Computing, IoT, Industry 4.0, and more
After coming up with the worst pun ever made in the database community, this title, to talk about one of if not the most powerful features in relational databases: the SQL join. I believe that the joins are a big reason the relational databases have stayed so relevant in a world where everyone seems to be talking Big Data. NoSQL databases cannot perform join operations. Sure there are a ton of articles out there describing work arounds, but at the end of the day they all come to the same conclusion and that is if you need to join, you need a relational database.
If you’ve looked around our website, talked to us at a trade show, or read an article about us, you’ve probably heard about our exploded data model. This is the keystone of HarperDB’s innovative database solution. Our patent-pending exploded data model is the reason we are fully-indexed with no data duplication, it’s why we can support full SQL and NoSQL within a single model, and it’s the basis for even more innovative features to come. I know, I know, that’s all well and good, but how does it work?Read More