What is Data Warehouse?

Data warehouse is a Warehouse of data. Place where all the data kept

In real time, it may be possible that a company or a business maintain their data via more than one system. Let’s takean example of an organization called ABC organization. It maintain Employee related information in Sql Server database, Client information in Excel, Sales and Purchase information is Oracle DB. Now information/knowledge generation  involves three steps.

  • Gathering data from all of these subsystems.
  • Applying some computation on all of these data – Data retrieved from each data source will be analysed for information and may be clubbed together.
  • Finally displaying them in an easy to understand format.


More the data is scattered more complex data retrieval becomes and more time will be taken to generation information/knowledge.

To solve this problem, industry identified a solution called Data warehouse. It’s going to be a simple database like Oracle, Sql or any other.

All the data maintained inside different sub systems in different format will be retrieved and converted into a common format and stored into this data warehouse. It became the first step in Business intelligence process. Data stored inside this Data Warehouse becomes source for the Information creation. Instead of analysing data in each data source, simply Data Warehouse data will be analysed.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s