We programmers keep cargo culting these wrong ideas. Recently, we said "NO" to Venn diagrams. Today we're going to say no to surrogate keys. The surrogate keys vs. natural keys non-debate is one of the most overheated debates in data architecture, and I don't get why everyone is so emotional. Both sides claim to hold … Continue reading Say NO to Excessive Use of Surrogate Keys if Performance Really Matters to You
Tag: relational model
There is no Such Thing as Object-Relational Impedance Mismatch
Much of the ORM criticism of the last decade missed the point, being inaccurate. By the end of this article, we will conclude with the following: There is no significant difference between the relational (data) model and object oriented models How to come to this conclusion? Read on! How we came to believe in this … Continue reading There is no Such Thing as Object-Relational Impedance Mismatch
Use ModelMapper and jOOQ to Regain Control of your Domain Model
Please note that this is an old article and we no longer recommend using any third parties to map SQL results to domain models. Instead, use jOOQ's own capabilities of nesting records, nesting collections, and applying ad-hoc conversion If you're operating on rather complex relational models, mapping data onto rather complex domain models, then you … Continue reading Use ModelMapper and jOOQ to Regain Control of your Domain Model