You’re absolutely right about the organizational dynamics.
Many mangers in large companies, derive their status and power from a knowledge of existing business processes and procedures. Any substantive changes to those procedures obviously represent an existential threat to that position and they generally resist it, often very vigorously.
Kent’s original book is a masterpiece. He pretty much defined data modelling nearly fifty years ago. It’s depressing how little of real interest has been added since.
For the reasons you rightly pointed out, the current edition is a disaster.
I tried to get through the book, but I was bored out of my mind. Chapter after chapter, it wasn't getting to any coherent point.
I seem to remember that I really long initial chunk of the book consisted of presenting a barrage of self-evident problems in the modeling of real world entities in databases, without offering any solutions.
There's no shortage of people that will fill your ears with problems, so tuning that kind of talk out after a while could actually be an evolutionary self-defense mechanism.
You certainly won’t hit it with most corporate OLAP processing, which is nearly all read-only SQlite. Writes are generally batched and processed outside ‘normal’ business hours, where the limitations of SQlite writing are irrelevant.
