Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / meena
A surrogate key in a database is a unique identifier for
either an entity in the modeled world or an object in the
database. The surrogate key is not derived from application
data.
There appear to be two definitions of a surrogate in the
literature. We shall call these surrogate (1) and surrogate
(2):
Surrogate (1) This definition is based on that given by
Hall, Owlett and Todd (1976). Here a surrogate represents
an entity in the outside world. The surrogate is internally
generated by the system but is nevertheless visible by the
user or application.
Surrogate (2) This definition is based on that given by
Wieringa and de Jung (1991). Here a surrogate represents an
object in the database itself. The surrogate is internally
generated by the system and is invisible to the user or
application.
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
Explain where do we use semi and non additive facts?
What is the difference between er modeling and dimensional modeling?
What is the main difference between schema in rdbms and schemas in datawarehouse?
How can we run the graph? How can we schedule the graph in unix?
Explain me what are conformed dimensions?
What is Sequence clustering algorithm?
How can you clear the cache?
List down some of the real time data-warehousing tools?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What is Active Datawarehousing?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Explain what are non-additive facts?
What is the use of tabular model, tabular sql, tabular reference in real time application?
Why should you put your data warehouse on a different system than your oltp system?
What is a staging area? Do we need it? What is the purpose of a staging area?
