Objekt Orient | |
There are unknown knowns. |
status
Youre not logged in ... Login
menu
search
calendar
recent updates
Goodbye Antville, hello Blogspot Its
time to move! Antville is a symatic community but I'm...
by rolandk (11/8/08, 4:00 PM)
SOA at Deutsche Post Deutsche
Post is THE company which implemented SOA the first time,...
by rolandk (11/4/08, 2:59 PM)
The model and the architecture
Hypothesis: Since infrastucture code is not part of the domain...
by rolandk (10/17/08, 1:24 PM)
Hope joost does it right
this time It's the content, stupid http://www.joost.com/home?playNow=33l83ke#id=33l83ke
by rolandk (10/14/08, 1:00 PM)
Siri Bringing AI to the
interface. I'm sceptical http://news.cnet.com/8301-17939_109-10065136-2.html
by rolandk (10/14/08, 9:47 AM)
Generative Sequencing is what MDSD
gives to the Pattern Movement Look what I've found: A...
by rolandk (10/12/08, 12:48 PM)
A thought on MDSD Christoper
Alexander—The pattern language that we began creating in the 1970s...
by rolandk (10/10/08, 6:09 PM)
Fresh and inspiring as a
hill in the morning mist. Nasim Taleb explains the...
by rolandk (9/30/08, 9:23 PM)
Roland Kofler's Blog on Software Engineering on |
Tuesday, 22. January 2008
About Natural Keys and Surrogate Keyvil Tuesday, January 22, 2008 at 3:12:57 PM Central European Standard Time
Get in the ring: Natural Keys vs. Surrogate Keys ... The identification of business objects and the identifier in the persistence store are concepts of different concern: on the object side there is the need to identify a domain entity, while in the persistence layer the focus is on retrieving and storing data efficiently, by normalization over artificial Surrogate Keys. Using the database specific identification in the business layer means coupling this layer to a internal and technical usage of Surrogate Keys. In many projects the Surrogate Key is propagated from the database to the business layer and also to the front-end. By doing so a technical detail - the identification technique of a certain persistence store - is adopted in all further layers, thus the Surrogate Key gains business meaning and the persistence layer is not decoupled from the others anymore. BTW another original paper: "A Relational Model of Data for Large Shared Data Banks" In this paper Codd explains the benefit of the relational model in a Mainframe World over a tree based navigational model wich prevailed in the late 60theens. The arguments presented touch me because I worked two years with JCR a pure tree based naivgational model. Its easy to see that a nonhierarchical model in a multi-application environment is superior. But probably it is far more maintainable also in an App-DB world. |