Overview and Concepts

Question 1

who needs strategic information in an enterprise?
-are responsible for keeping the enterprise competitive need information to make proper decisions.

Answer 1

executives and managers

Question 2

-combined essential information needed to make decisions in the formulation and execution of business startegies and objectives
-is not for running the day-to-day operations of the business. It is not intended to produce an invoice, make a shipment, settle a chain, or post a withdrawal from a bank account.
-far more important for the continued health and survical of the operation
-critical business decisions depend on the availability of proper strategic inforation in an enterprise.

Answer 2

strategic information

Question 3

(characterisitics of strategic information)
-must have a single, enterprise-wide view.

Answer 3

integrated

Question 4

(chracteristics of strategic information)
-information must be accurate and must conform to business rules.

Answer 4

data integrity

Question 5

(chracteristics of strategic information)
-easily accessible with intuitive access paths, and responsive for analysis.

Answer 5

accessible

Question 6

(chracteristics of strategic information)
-every business factor must have one and only one value.

Answer 6

credible

Question 7

(chracteristics of strategic information)
-information must be available within the stipulated time frame

Answer 7

timely

Question 8

-user needs information
-iser requests reports from IT
-IT places request on backlog
-IT creates ad hoe queries
-IT sends requested reports
-User hopes to find the right answers.

Answer 8

The familiar merry-go-round
-inability to provide information (4-6weeks)

Question 9

-get the data in
-making the wheels of business turn
0take an order
-process a clain
-make a shipment
-generate an invoice
-receive cash
-reserve airline seat

Answer 9

operational systems

Question 10

-get the information out
-watching the wheels of business turn
-show me the top-selling products
-show me the problems regions
-tell me why (drill down)
-let me see other data (drill actions)
-show me te hgihest margins
-alert me when a district sells below target

Answer 10

decision-support systems

Question 11

-serve different purposes
-scopes are different
-data content is different
-the data usage patterns are different
-the data acess types are different

Answer 11

informational systems

Question 12

-a physical repository where relational data (current and historical) are specially organized to provide enterprise-wide, cleansed data in a standardized format.
Operational systems -> Data Trnasformation -> Key Measurements/ Business Dimensions

Answer 12

data warehouse

Question 13

(characteristics of Data Warehouse)
-data are organized by detailed subject containing only information relevant for decision support. It provides a more comprehensive view of the organization

Answer 13

subject oriented

Question 14

(chracteristics of data warehouse)
-data warehouses must place data from different sources into a consistent format.

Answer 14

integrated

Question 15

(chracteristics of data warehouse)
-it contains historical (daily, weekly and monthly) inc additions to current data (real-time).

Answer 15

time variant (time series)

Question 16

(chracteristics of data warehouse)
-data can not be changed or updated after it had been entered into data warehouse. Obsolete (old) data are discarded and changes are recorded as new data.

Answer 16

non-volatile

Question 17

(chracteristics of data warehouse)
-designed for web based applications

Answer 17

web based

Question 18

(chracteristics of data warehouse)
-its structure is either relational or multidimensional.

Answer 18

relational/multidimensional

Question 19

(chracteristics of data warehouse)
-to be easy to be accessed

Answer 19

uses client server

Question 20

(chracteristics of data warehouse)
-this a charcter for new data warehour

Answer 20

real-time

Question 21

(chracteristics of data warehouse)
-it is a data about data (about how data are organized and to use them)

Answer 21

include metadata

Question 22

• a logical and physical subset of a data warehouse; in its most simplistic form, represents data from a single business process (e.g., retail sales, retail inventory, purchase orders). Basically, a departmental data warehouse.

Answer 22

data mart

Question 23

-a subset that is created directly form a data warehouse

Answer 23

dependent data mart

Question 24

-a small data warehouse designed for a strategic business unit (SBU) or a department and its source is not the EDW (Enterprise Data Warehouse)

Answer 24

independent data mart

Question 25

-a type of databaseoften used as an interim (temporal) area for a data warehose, especially for cutomer information files.

Answer 25

operational data stores (ODS)

Question 26

-an operational data mart -is a small-scale data mart typically used by a single department or functional area in an organization when they need to analyze operational data.

Answer 26

oper marts

Question 27

- a technology that provides a vehicle for pushing data from source systems into a data warehouse that is used across the eneterpise for decision support.

Answer 27

enterpise data warehouse (EDW)

Question 28

-data about data. In a data warehouse, describes the contents of a data warehouse and the manner of its use.

Answer 28

metadata

Question 29

-organizations continuously collect data, information,and knowledge at an increasingly accelerated rate and store them in compterized systems. -the number of users needing to access the infomration continues to increase as a result of imporved reliability and availability of network access, especially the Internet.

Answer 29

data warehousing process overview

Question 30

-internal, external (data provider), OLAP, ERP, Web data

Answer 30

data sources

Question 31

-using custom-written or commerical software called (ETL)

Answer 31

data extraction

Question 32

-loaded into a staging area to be transformed and cleased, then loaded into the warehouse.

Answer 32

data loading

Question 33

-it is the EDW to support all decision analysis

Answer 33

comprehensive database

Question 34

to enable access to DW. It includes data mining tools, OLAP, reporting tools and data visualization tools

Answer 34

middleware tools

Question 35

-a datawarehouse is designed for analytics transactional models, while efficient for transaction processing, are not good for analytics. --goal of transactiona system is to capture data quicly, Users use the system to do their jobs. --transactional systems are not designed to minimize the time or complexity of retrieving large amount of data for analysis.

Answer 35

use a separate system

Question 36

-designed to extract and query data quickly • Access speed is the main concern • Hence, normalization which is widely used for transactional databases, is generally not appropriate for data warehouse design • Design should reflect multidimensional view

Answer 36

star schema/dimensional model