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
What are algorithms provided by Microsoft in SQL Server?
can anybody mail me the FAQS for hyperion essbase amd planning
Define Data Warehousing?
Explain the structure of cold fusion?
What is meant by metadata in context of a data warehouse?
What is data analysis?
What are the different types of data warehouses?
How can we run the graph?
What are the other names given to data warehousing?
I know of using applysimple, but there are other ways too?
How to stop a batch?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain the different types of data warehousing?
How can you import tables from a database?
Explain what are fact, dimension, and measure?
