web analytics

Data, data everywhere 

Twitter LinkedIn RSS
magnify
Home Archive for category "Data administration"
formats

ORMs and key generation

In keeping with articles related to surrogate keys, here is another previously-published article that dealt with surrogate keys and their use with object-relational mapping tools (ORMs) such as Hibernate and Java’s JPA API. This blog entry is copyright by Sybase, Inc., an SAP Company, and first appeared on Glenn Paulley’s Sybase blog (http://iablog.sybase.com/paulley/) on 26

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Surrogate identifiers

This past week in my INFO2080 Systems Design class we began discussing database implementations and I made several points about surrogate keys, their formats, and their generation. I had published these thoughts in an article just over four years ago; here it is again. This blog entry is copyright by Sybase, Inc., an SAP Company,

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

Surrogate identifiers

This semester I’m teaching a course entitled “Application programming with Oracle” and one of the things I want to stress to my students is the interdependency between design decisions and database application performance. Early in the term we are looking at database design tradeoffs, and those discussions reminded me of this blog post from 2008,

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments