Chapter 3

Question 1

Can there be multiple operational systems in dataware house

Answer 1

Yes

Question 2

What is data extraction

Answer 2

Getting data from operational systems

Question 3

What is the process of dataware house

Answer 3

Get data from internal and external sources. Transform it into uniform format. Access it

Question 4

What is header of table

Answer 4

Table structure

Question 5

What are the differences between dataware house and management information system

Answer 5

• Different patterns of hardware utilization
• Dataware house combines operational and historical data
• Updates are in batch and periodic rather than real-time

Question 6

Which factors determine how much history should be maintain for a particular business

Answer 6

• Industry

- Cost

Question 7

What is the period time for telecom industry for data storage

Answer 7

18 months

Question 8

What is the equation for data storage

Answer 8

Economic value of data vs storage cost (economic value should be higher)