COMPUTER APPLICATIONS
ENTERPRISE RESOURCE PLANNING ERP SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Normalized data
|
|
|
Denormalized data
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Data warehouses often use denormalized or partially denormalized schemas (such as a star schema) to optimize query performance. OLTP systems often use fully normalized schemas to optimize update/insert/delete performance, and to guarantee data consistency.
Detailed explanation-2: -A data mart holds highly denormalized data in a summarized form. A data warehouse has large dimensions and integrates data from many sources, which may cause a risk of failure. A data mart has smaller dimensions to integrate data sets from a smaller number of sources, so there’s less risk of failure.
Detailed explanation-3: -Denormalization of Data in Star Schemas The star schema achieves this goal through the “denormalization” of the data within the network of dimension tables.