Assisted data comparison
Table partitioning in relational databases
Graph extensions in SQL Server 2017
Why should you care about SQL?
What are the advantages of using a graph database?
The data usage patterns have changed dramatically in last ten years or so, and various organizations are interested in 'hidden' relationships between data - ones that were not initially recognized or planned for the database. This is when the graph databases may be used.
NoSQL or SQL?
The article focuses on these two database technologies, but in fact it can be extended to the whole realms of RDBMS and NoSQL databases.
Certain aspects of both domains can be considered as advantages or disadvantages, depending on the point of view and particular business case. The flexibility of schema in MongoDB is appealing to teams who implement applications dealing with unstructured data. The strictness of schema definition required by relational databases can be beneficial when the application needs to ensure that the data quality meets certain requirements.