•
•
•
•
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 397,603 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 2,666 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.
Please support our Database Design advertiser:
Views: 539 | Replies: 3 | Solved
 |
•
•
Join Date: Jun 2008
Posts: 8
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi
Please tell me if you know a dis-advantage of auto-incerment PK
Thanks
Please tell me if you know a dis-advantage of auto-incerment PK
Thanks
•
•
Join Date: Apr 2008
Posts: 295
Reputation:
Rep Power: 1
Solved Threads: 41
Posting Whiz in Training
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)
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)
Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.
•
•
Join Date: Jun 2008
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by tesuji 
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)
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
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,183
Reputation:
Rep Power: 10
Solved Threads: 264
EERM = Extended Entity Relationship Model
I would say auto increment column as if you want to keep track of next item number to be used you need to run extra query to get current number. Plus there are other thing you would have to take care from coding point of view
@tesuji, please drop that joke about "id-iots"
I would say auto increment column as if you want to keep track of next item number to be used you need to run extra query to get current number. Plus there are other thing you would have to take care from coding point of view
@tesuji, please drop that joke about "id-iots"
Last edited by peter_budo : Jul 10th, 2008 at 8:28 am. Reason: typo
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
Linear Mode
Other Threads in the Database Design Forum
- Previous Thread: Cpying Tables from one DB to another
- Next Thread: Stored Procedures / Functions
