The relational nature of data reaches far beyond that of a traditional Relational Database Management System (RDBMS), and in fact I have found it to be the core component needed to understand and develop any database design or schema. In this chapter I will cover:
• Why is all data relational?
• How can you use the theory of relational data in your own database design?
• How does the concept of relational data fit with Big Data scalability?
As discussed earlier in the book, you have more choices than ever when it comes to DBMS engines. There are the “traditional” RDBMS engines like MySQL, PostgreSQL, Microsoft SQL Server, and Oracle; an ever-growing group of NoSQL/NewSQL engines such as MongoDb, ...