Ask Question
Computers & TechnologyComputers & Technology
14 May, 06:06

What is a surrogate key, and under what circumstances would you use one?

+5
Answers (1)
  1. 14 May, 06:23
    0
    Subrogated keys are a concept used in database design, especially in Data Warehouse (DW) and Business Intelligence (BI) enviroments. Subrogated Keys are often used especially in versioned or historical dimension tables, that is, dimesion tables that store both current data and historical data. The concept of Subrogated Key is not unique to SQL Server, that is, Subrogated Keys are a general concept that can be applied to any database engine (oracle, MySQL, etc).

    The benefits of Subrogated Keys are:

    - It facilities efficient partitioning of physical data.

    - Create a separation of multidimensional models to facilitate change control.

    - Improve the performance of operations.

    - It allows you to read more data with less input and output operations because the indexes are smaller.

    In conclusion, the main one is to improve the response time of the database since searching between integers is the least cost of the database; but there are also others, for example, if we are gathering information from different transactional systems in a data warehouse and each one of them has keys that do not look anything like each other, the surrogated keys will allow us to have a homogeneous key for both systems.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “What is a surrogate key, and under what circumstances would you use one? ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers
You Might be Interested in
Does the ad traffic only work if the person does not block the ip? does the ad traffic count work if it's an anonymous person?
Answers (1)
Section: Friction If there were no resistive forces, your vehicle would continue to travel at its maximum speed forever. True False
Answers (1)
What type of maintenance can prevent the computer from breaking? Add oil to internal components Load anti-virus software Rotate input peripherals Transfer files to a flash drive
Answers (2)
Which of the following is an example of a logic bug? A. Multiplying strings together B. An infinite loop C. A missing parenthesis D. A string that has no quotation marks or apostrophes around it
Answers (1)
Write a function named shareALetter that takes one parameter, wordList - a list of words. Create and return a dictionary in which each word in wordList is a key and the corresponding value is a list of all the words in wordList that share at least
Answers (1)
New Questions in Computers & Technology
Which of the following is considered an IT career
Answers (1)
Implement a Python function with the signature Transfer (S, T) that transfers all elements from the ArrayStack instance S onto the ArrayStack instance T, so that the element that starts at the top of S is the first to be inserted onto T, and the
Answers (1)
Writing a story with a proper sequence and orginization is important because what?
Answers (2)
In Linux, you are preparing to delete the user account tprice, because this user has just left the company. However, before you delete the account, you want to list all files owned by tprice so that you can locate them and decide which files to keep.
Answers (1)
How many service packs did windows 7 have?
Answers (1)
Home » Computers & Technology » What is a surrogate key, and under what circumstances would you use one?
Sign Up Forgot Password?