What? - Who? - Why?

Hmm.., don't get confused....

What? - Who? - Why? means..

What is DataWareHousing?
Who needs it?
Why they need it?

Let me answer for

WHAT?
A DataWareHousing is a Database, which is Specially designed to store the information of summery of Business.

WHO?
Who needs the summery?
Lets assume that you own a Business, and you have many employees.
The low level executives maintains the detailed information, and High level executives go through the Summery for Analysis of Business. (Like Daily, Weekly, Monthly, Quarterly... and so on.....)
As a Owner or CEO or Chairman, you need not go through detailed information.
So What ever Summery information we are storing, will be useful for Middle Level Management and Top Level Management.

Why?
Yeah, your next question is WHY?
As you have already a Database which consists detailed information, why won't you give desired reports or summery from there itself?

Here is a Simple answer...
You can call a DataWareHousing is DSS i.e Decision Supporting System.
That means, you are maintaining a individual database only to take Decision by analyzing the Business. Like Current Daily Revenue, Current Weekly Revenue, Last month Daily Revenue, Current Weekly.... so that you can analyze whether your business is growing or falling. and also you can take Actions to Improve Business. That's why DataWareHousing is DSS.

But why need to build seperate database?
Because in Current (regular transaction) data consists detailed information, it will be Time consuming to retrieve information from the existing database.
And also it maintains only one Branch transactions (Assume you have two branches in DilshukhNagar and KukatPalli)., in DataWareHousing, you can Integrate Multiple Branches Business Data to Single.


Note: Here Current database is called as Operational Database. That means, from Operational Database(s) we are developing a (Data)WareHouse.

Note: You will see "Business" term commonly. The thing is a DataWareHouse is a tool for BI (Business Intelligence). So what ever we deal in DataWareHousing, is all about a Business.

Well.., thats all in for this Day.

Keep Rocking....