Open benclmnt opened 1 year ago
From Kleppmann's Designing Data Intensive Applications page 37
With both the hierarchical and the network model, if you didn’t have a path to the data you wanted, you were in a difficult situation. You could change the access paths, but then you had to go through a lot of handwritten database query code and rewrite it to handle the new access paths
... joins on foreign keys are performed at query time, whereas in CODASYL, the join was effectively done at insert time.
This is reading from the first chapter of Redbook
Stonebraker summarizes 35 years of data model proposals, grouped into 9 eras.
Lessons: