Data Warehousing - What is the difference between database and data warehousing?What is the main advantages of data war

GeekInterview.com > Interview Questions > Data Warehousing

Go To First | Previous Question | Next Question

Data Warehousing | Question 6 of 98

What is the difference between database and data warehousing?
What is the main advantages of data warehousing
What is mean by data stage
What is the famous tools used for data warehousing?
What is the architecture of data warehouisng model?

Total Answers and Comments: 16

Last Update: September 04, 2009 Asked by: s.Narasimma subramanian

Sponsored Links

Best Rated Answer

—

Submitted by: sangroover

Database is the place where the data is taken as a base and managed to get avialable fast and efficient access.

Dataware house is the place where the application data is managed for analysis and reporting purposes.

Above answer was rated as good by the following members:
pramod Yadav

Sorting Options

Page 1 of 2

« First

Last »

February 15, 2006 13:03:31

sangroover

RE: what is the difference between database and data w...

Database is the place where the data is taken as a base and managed to get avialable fast and efficient access.

Dataware house is the place where the application data is managed for analysis and reporting purposes.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

February 26, 2006 02:31:18

sanyam mittal

RE: what is the difference between database and data w...

Major difference is the historical data which can be maintained in data warehouse instead of keeping it in your real time OLTP(database) system.Also we don't want to decrease the processing time of our oltp server for taking data for reporting and analysis purpose.Now why informatica and why other OLAP tools are required :coz companies don't want to spend lots of money in hiring fulltime database developer to write pl/sql packages and procedure to store all these information in ODS.Therefore most of the time they hire a short-period informatica/ETL developer to make mapping which is GUI based easy to maintain and easy to run.

Is this answer useful? Yes | No

October 20, 2006 07:04:31

velavan

RE: what is the difference between database and data w...

Database is the place where the data is taken as a base and managed to get avialable fast and efficient access.

Dataware house is the place where the application data is managed for analysis and reporting purposes.

Is this answer useful? Yes | No

October 25, 2006 12:17:14

jessa abraham

Member Since: October 2006 Contribution: 5

RE: what is the difference between database and data w...

dw is also a database but the purpose is for business analysis.

in general a database is a reservior having operational data needed for daily business and they are ever changing. since the new data is always overwriting the old one there is no way to compare the change in data this is wer a dw comes in picture. dw has historical datas and the current data so comparison becomes very easy for business analysis.

ds is a tool for ETL.

ETL tools: informatica ds junction abinitio ds cognos etc

reporting: cognos bo etc

Is this answer useful? Yes | No

December 14, 2006 17:21:56

anil

RE: what is the difference between database and data w...

DB and DWH Both support application data storage access and retrieval of data but only DWH support Decision making and Business intelligence.

Is this answer useful? Yes | No

January 01, 2007 01:10:15

b siva pratap

RE: what is the difference between database and data w...

database is used to store the current data this is the basic process of every company.by using database we dont know what is next

database means which provides the data.

dwh is used to maintain the historical data due to this historical data business user can take desicions.

dwh takes the data from database.

THE MAIN DIFFERENCE IS

DATABASE IS USED TO RUNNING THE BUSINESS

DWH IS HOW TO RUN THE BUSINESS

DWH TOOLS

ETL TOOLS:INFORMATICA DATA STAGE

OLAP TOOLS/REPORTING TOOLS:REPORTNET B.O

Is this answer useful? Yes | No

May 05, 2007 00:22:16

Jun

RE: what is the difference between database and data w...

Technically database and dw are same because data warehouse is also based on database.
Database is the basic tool for data warehouse data warehouse is more of a concept.
In the aspect of the content they are different because data warehouse has more historical data and oriented for data analysis.
Data warehouse sometimes contains the concept of data modelling as well which is based on data warehouse and utilizing the multidimensional star schema for fastening the analytical procedure.

Is this answer useful? Yes | No

May 22, 2007 08:50:27

phani

RE: what is the difference between database and data w...

Database is used for transactional purporse it is volatile in nature i.e values changes in database
Dataware house is used to store historical data it is non-volatile in nature.

Is this answer useful? Yes | No

July 10, 2007 02:57:32

rajesh

RE: what is the difference between database and data w...

Database:-

It store data in the form of tables if u want to access data by giveing query u can retrive data from the database.

DataWarehousing:-

Def:- It is subject oriented historical timely variented integrated and collection of data is called datawarehouse.

It is one type of techonolgy.

In this data call as Dimensions and useful for Anaysis and Reporting purpose.
It contains complete data like past and present based on OLTP systems.

Is this answer useful? Yes | No

July 18, 2007 09:45:22

#10

selvaraj.durairaj

Member Since: July 2007 Contribution: 3

RE: what is the difference between database and data w...

Normally Database is used for storing the data in the form of tables. And the table will be updated or overwritten depending upon the business requirement.

DataWare house DataBase is used for query and analysis i.e the data is never deleted. We can compare the old data as more and more data added .

Regards
Selva

Is this answer useful? Yes | No

Page 1 of 2

« First

Last »

Go To Top

User Name		Remember Me?
Password

Question Bank