Author Question: If everything isn't ready by the first readiness assessment, the go live date should be pushed back. ... (Read 95 times)

student77 · **on:** Jul 7, 2018

If everything isn't ready by the first readiness assessment, the go live date should be pushed back.

Indicate whether the statement is true or false

Question 2

Explain the term historical in the following data warehouse definition:The data warehouse is a structured repository of integrated, subject-oriented, enterprise-wide, historical, and time-variant data.

The purpose of the data warehouse is the retrieval of analytical information. A data warehouse can store detailed and/or summarized data.

aidanmbrowne · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

FALSE

Answer to Question 2

When compared to operational information, analytical information has a longer time horizon. Given that a data warehouse contains analytical information, its time horizon is longer (usually substantially so) than the time horizon in the operational databases. The term historical refers to the larger time horizon in the data warehouse than in the operational databases. For example, many traditional operational databases have a time horizon of 60 to 90 days, where it is quite common for data warehouses to contain multiple years' worth of data.