3 ms·
Your argument makes perfect sense. If all you need is storage and retrieval. Take storing project management data as JSON files. Suddenly the boss bursts in:
by jacques_chester 14y ago
Your argument makes perfect sense.
If all you need is storage and retrieval.
Take storing project management data as JSON files.
Suddenly the boss bursts in: he needs to know, right now, how many hours Jeremy has spent working on these three projects.
Given that your JSON hierarchy runs project->person and not person->project, you will now have to traverse your entire database to give an answer.
The deep magic of relational algebra or relational calculus is that they privilege no one view of the data over the other.
This is, incidentally, one of the causes of OO/relational mismatch. A class hierarchy locks in a particular view of the problem domain. Relational has many potential views of the problem domain.
The cost and inconvenience of traversing trees for ad hoc queries is one of the big reasons that RDBMSes swept away network and hierarchical databases.