MIS 430 Quiz 2 & Answers 100% pass
A typical organization - ANSWERSmaintains and utilizes a number of operational data
sources.
The operational data sources include - ANSWERSthe databases and other data
repositories which are used to support the organization's day-to-day
operations
A data warehouse is created - ANSWERSwithin an organization as a separate data
store whose primary purpose is data analysis.
Two main reasons for the creation of a data warehouse as a separate analytical
database - ANSWERSThe performance of operational day-to-day tasks involving data
use can be severely diminished if such tasks have to compete for computing resources
with analytical queries
It is often impossible to structure a database which can be used in an efficient manner
for both operational and analytical purposes
Operational information (transactional information) - - ANSWERSthe information
collected and used in support of day to day operational needs in businesses and other
organizations
Analytical information - - ANSWERSthe information collected and used
in support of analytical tasks
Analytical information is based on operational (transactional) information
Operational Data - ANSWERSData Makeup Differences
--Typical Time-Horizon: Days/Months
--Detailed
--Current
Technical Differences
--Small Amounts used in a Process
--High frequency of Access
--Can be Updated
--Non-Redundant
Functional Differences
--Used by all types of employees for tactical purposes
--Application Oriented
, Analytical Data - ANSWERSData Makeup Differences
--Typical Time-Horizon: Years
--Summarized (and/or Detailed)
--Values over time (Snapshots)
Technical Differences
--Large Amounts used in a Process
--Low/Modest frequency of Access
--Read (and Append) Only
--Redundancy not an Issue
Functional Differences
--Used by a narrower set of users for decision making
--Subject Oriented
The data warehouse is - ANSWERSa structured repository of
integrated, subject-oriented, enterprise-wide,
historical, and time-variant data.
The purpose of the data warehouse is - ANSWERSthe retrieval
of analytical information. A data warehouse can
store detailed and/or summarized data.
Structured repository - ANSWERSThe data warehouse is a database containing
analytically useful information
Any database is a structured repository with its structure represented in its metadata
Integrated - ANSWERSThe data warehouse integrates the analytically useful data from
the various operational databases (and possibly other sources)
Integration refers to this process of bringing the data from multiple data sources into a
singular data warehouse.
Subject-oriented - ANSWERSThe term subject-oriented refers to the fundamental
difference in the purpose of an operational database system and a data warehouse.
An operational database system is developed in order to support a specific business
operation
A data warehouse is developed to analyze specific business subject areas
Enterprise-wide - ANSWERSThe term enterprise-wide refers to the fact that the data
warehouse provides an organization-wide view of the analytically useful information it
contains
A typical organization - ANSWERSmaintains and utilizes a number of operational data
sources.
The operational data sources include - ANSWERSthe databases and other data
repositories which are used to support the organization's day-to-day
operations
A data warehouse is created - ANSWERSwithin an organization as a separate data
store whose primary purpose is data analysis.
Two main reasons for the creation of a data warehouse as a separate analytical
database - ANSWERSThe performance of operational day-to-day tasks involving data
use can be severely diminished if such tasks have to compete for computing resources
with analytical queries
It is often impossible to structure a database which can be used in an efficient manner
for both operational and analytical purposes
Operational information (transactional information) - - ANSWERSthe information
collected and used in support of day to day operational needs in businesses and other
organizations
Analytical information - - ANSWERSthe information collected and used
in support of analytical tasks
Analytical information is based on operational (transactional) information
Operational Data - ANSWERSData Makeup Differences
--Typical Time-Horizon: Days/Months
--Detailed
--Current
Technical Differences
--Small Amounts used in a Process
--High frequency of Access
--Can be Updated
--Non-Redundant
Functional Differences
--Used by all types of employees for tactical purposes
--Application Oriented
, Analytical Data - ANSWERSData Makeup Differences
--Typical Time-Horizon: Years
--Summarized (and/or Detailed)
--Values over time (Snapshots)
Technical Differences
--Large Amounts used in a Process
--Low/Modest frequency of Access
--Read (and Append) Only
--Redundancy not an Issue
Functional Differences
--Used by a narrower set of users for decision making
--Subject Oriented
The data warehouse is - ANSWERSa structured repository of
integrated, subject-oriented, enterprise-wide,
historical, and time-variant data.
The purpose of the data warehouse is - ANSWERSthe retrieval
of analytical information. A data warehouse can
store detailed and/or summarized data.
Structured repository - ANSWERSThe data warehouse is a database containing
analytically useful information
Any database is a structured repository with its structure represented in its metadata
Integrated - ANSWERSThe data warehouse integrates the analytically useful data from
the various operational databases (and possibly other sources)
Integration refers to this process of bringing the data from multiple data sources into a
singular data warehouse.
Subject-oriented - ANSWERSThe term subject-oriented refers to the fundamental
difference in the purpose of an operational database system and a data warehouse.
An operational database system is developed in order to support a specific business
operation
A data warehouse is developed to analyze specific business subject areas
Enterprise-wide - ANSWERSThe term enterprise-wide refers to the fact that the data
warehouse provides an organization-wide view of the analytically useful information it
contains
