Data Warehousing.lectures

Data Warehousing

 Data Warehousing.lectures

Why a DWH?

• Data recording and storage is growing.

• History is excellent predictor of the future.

• Gives total view of the organization.

• Intelligent decision-support is required for decision-making.

Data recording and storage is growing.

Moore’s law on increase in performance of CPUs and decrease in cost has been surpassed by the increase in storage space and decrease in cost. Meaning, it is true that the cost of CPUs is going down and the performance is going up, but this is applicable at a higher rate to storage space and cost i.e. more and more cheap storage space is becoming available as compared to fast CPUs.

As you would have experienced, when you (or your father’s) briefcase seems to be small as compared to the contents carried in it, it seems a good idea to buy a new and larger briefcase. However, after sometime the new briefcase too seems to be small for the contents carried. On the practical side, it has been noted that the amount of data recorded in an organization doubles every year and this is an exponential increase.

Data Warehousing.lectures