Choosing between structured or NoSQL storage
As a software architect, you may consider some aspects of structured and NoSQL storage to decide the best storage option for you. In many cases, both will be needed. The key point here will surely be how organized your data is and how big the database will become.
In the previous section, we stated that NoSQL databases should be preferred when data has almost no predefined structure. NoSQL databases not only keep variable attributes close to their owners, but they also keep some related objects close since they allow related objects to be nested inside properties and collections.
Unstructured data can be represented in relational databases since variable properties of a tuple, t
, can be placed in a connected table containing the property name, property value, and the external key of t
. However, the problem in this scenario is performance. In fact, property values that belong to a single object would be spread all over the available...