GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Concepts  >  Data Modeling
Next Question 
 Data Modeling  |  Question 1 of 27    Print  
What is an artificial (derived) primary key? When should it be used?

  
Total Answers and Comments: 4 Last Update: September 18, 2008   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 24, 2005 20:23:40   #1  
John        

RE: What is an artificial (derived) primary key? When should it be used?
Using a name as the primary key violates the principle of stability. The social security number might be a valid choice but a foreign employee might not have a social security number. This is a case where a derived rather than a natural primary key is appropriate. A derived key is an artificial key that you create. A natural key is one that is already part of the database.
 
Is this answer useful? Yes | No
July 21, 2005 00:03:23   #2  
ritwik roy        

RE: What is an artificial (derived) primary key? When should it be used?
whether artificial primary key is equvalent to the row_id of the table or it is the the combination of the previous primary key field and the new field which creates the importance of it.
 
Is this answer useful? Yes | No
October 04, 2005 13:50:19   #3  
SM        

RE: What is an artificial (derived) primary key? When ...

Many at times Natural Keys are based on Categorizations that are perceived permanent.However due to natural or artificial changes these nomenclatures bacome meaningless for the new transactions.It is also true that with the new transactions Natural Keys might loose their importance.Such are the situations with Slowly and Fast changing dimensions.

To avoid this Surrogate Keys are used that are Auto Generated are Integer Keys and they take less query execution time.


 
Is this answer useful? Yes | No
September 18, 2008 15:41:26   #4  
geeksds Member Since: September 2008   Contribution: 4    

RE: What is an artificial (derived) primary key? When should it be used?
It is a system-assigned number that is unique for each row of data in a table. It is used by database administrators to allocate rows of evenly and efficiently on data storage / servers.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape