User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
All
•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 455,865 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,649 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Join our community!
Please support our Database Design advertiser: Programming Forums

What is dis-advantages of auto-increment pk

•
•
Join Date: Jun 2008
Posts: 8
Reputation: motofoto is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
motofoto motofoto is offline Offline
Newbie Poster

Re: What is dis-advantages of auto-increment pk

  #3  
Jul 10th, 2008
•
•
•
•
Originally Posted by tesuji View Post
Ah, you again

Did you proceed in understanding EERM?

I call people who put a magical, universal "id" column with an auto-increment on all their tables "id-iots" ! (Joe Celko)
No I mean that if you design a table like Book which is containing duplicate ISBN(s) for some reason,

and you have the choice between
creating a random unique generated PK from say (Java code)
and
creating an auto incerment Column

What do u choose and why?

I thought you will talk to me about deletion problems or overflow problems regardless of id-iot people.

and I searched about EERM in google, I don't know what is its stands for, I can conclude that you are talking about Relational Modeling but I want to know what that stands for.

Thank you for your time
Reply With Quote  
Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 6:17 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC