Scribd
Upload
53 views

Data Warehousing Concepts: Database Reporting

A data warehouse is a relational database that integrates data from different sources to convert it into information for managerial decision making. It stores current and historical data read-only. Data is raw material while information is organized data with meaning and value. Knowledge is processed information that provides understanding for problems or activities. In a data warehouse, data is converted to information to gain knowledge to make decisions.

Uploaded by

achuu1987
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
53 views

Data Warehousing Concepts: Database Reporting

A data warehouse is a relational database that integrates data from different sources to convert it into information for managerial decision making. It stores current and historical data read-only. Data is raw material while information is organized data with meaning and value. Knowledge is processed information that provides understanding for problems or activities. In a data warehouse, data is converted to information to gain knowledge to make decisions.

Uploaded by

achuu1987
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Data warehousing concepts

Data: Data is collection of raw material in unorganized format, which refers an object.
Information: Organized data that has been meaning & value.
Knowledge: Processed data or information that conveys understanding or learning applicable to a
problem or activity.
In Data warehouse, the data is converted into information format to get knowledge for making
decisions.
What is Data Warehouse?
Data
warehouse
is
a relational
database management
which
is
used
for reporting and analyzing the data to take managerial decisions. It is a central repository of data
which is created by integrating data from different sources and converting that data into
information format for taking managerial decisions. Data warehouses store current data as well
as historical data and Read only data for management reporting such as annual and quarterly
comparisons.
Eg: Big Bazar-->C.E.O needs data annual data --> Ipod --> Hyd --> 2011 -->Sales
In an organization we have different departments like Sales dept, product dept, HR dept
etc.. Now C.E.O wants ipod sales in hyd location for the year 2011. So, C.E.O collects the data
from sales dept and product dept and need to take some decisions on profits & loss based on the
information. If he want to take decisions he need historical data also.

You might also like