Why are data in a data warehouse stored in unnormalized tables?
Normalizing data in an operational database is necessary to reflect accurately the dynamic interactions among entities. While a fully normalized database provides the flexible model needed for supporting multiple users in operations environment, it also adds to complexity that translates into performance inefficiency. Because of the vast size of a data warehouse, such inefficiency can be devastating. A three-way join between tables in a large data warehouse may take an unacceptably long time to complete and may be unnecessary. In the data warehouse model, the relationship among attributes does not change. Because historical data are static in nature, nothing is gained by constructing normalized tables with dynamic links.
You might also like to view...
Which one of the following is a sound internal control procedure for cash disbursements?
a. Making copies of purchase orders for the receiving department so they know how many items to be expected upon delivery b. Using presigned checks to facilitate payment within the cash discount period c. Comparing purchase requisitions, purchase orders, receiving reports, and invoices d. Requiring the signature of the purchasing department supervisor on checks
All attempts to target marketing to children, minorities, or other special segments are discriminatory and unethical
Indicate whether the statement is true or false
How would you represent consumer preferences for frozen foods as dummy variables if the respondents were classified as heavy, medium, light, nonusers?
What will be an ideal response?
Squire Inc.'s 5-year bonds yield 6.75%, and 5-year T-bonds yield 4.80%. The real risk-free rate is r* = 2.75%, the inflation premium for 5-year bonds is IP = 1.65%, the default risk premium for Squire's bonds is DRP = 1.20% versus zero for T-bonds, and the maturity risk premium for all bonds is found with the formula MRP = (t ? 1) × 0.1%, where t = number of years to maturity. What is the liquidity premium (LP) on Squire's bonds?
A. 0.49% B. 0.55% C. 0.61% D. 0.68% E. 0.75%