What is a subject-oriented, integrated, time-variant, non-volatile collection of data in support of
managements decision-making process?
A.
Data mart
B.
Data model
C.
Data warehouse
D.
Data model
Explanation:
This definition of a data warehouse is that of Bill Inmon, a pioneer in the field. To create a data
warehouse, data is taken from an operational database, redundancies are removed, and the data is
cleaned up in general. This activity is referred to as normalizing the data. Then the data is placed into
a relational database and can be analyzed using On-Line Analytical Processing (OLAP) and statistical
modeling tools. The data warehouse can be used as a Decision Support System (DSS), for example,
by performing a time series analysis of the data. The data in the data warehouse must be maintained
to ensure that it is timely and valid. The term data scrubbing refers to maintenance of the data
warehouse by deleting information that is unreliable or no longer relevant. *A data mart, answer a,
is a database that is comprised of data or relations that have been extracted from the data
warehouse. Information in the data mart is usually of interest to a particular group of people. For
example, a data mart may be developed for all health care-related data. *Answers Data model and
Data model are distracters, although a data model, in this context, sometimes refers to the result of
analyzing relationships among enterprise-wide data items.