GeekInterview.com
Series: Subject: Topic:
Question: 195 of 200

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?

Asked by: Interview Candidate | Asked on: Feb 1st, 2006
Showing Answers 1 - 17 of 17 Answers
sangroover

Answered On : Feb 15th, 2006

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.

Yes  3 Users have rated as useful.
  
Login to rate this answer.
sanyam mittal

Answered On : Feb 26th, 2006

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.

Yes  2 Users have rated as useful.
  
Login to rate this answer.
velavan

Answered On : Oct 20th, 2006

 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.

  
Login to rate this answer.
jessa abraham

Answered On : Oct 25th, 2006

View all answers by jessa abraham

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, etcreporting: cognos, bo, etc

  
Login to rate this answer.
anil

Answered On : Dec 14th, 2006

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

  
Login to rate this answer.
b siva pratap

Answered On : Jan 1st, 2007

hidatabase is used to store the current data,this is the basic process of every company.by using database we dont know what is nextdatabase 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 ISDATABASE IS USED TO RUNNING THE BUSINESSDWH IS HOW TO RUN THE BUSINESSDWH TOOLSETL  TOOLS:INFORMATICA,DATA STAGEOLAP TOOLS/REPORTING TOOLS:REPORTNET,B.O

  
Login to rate this answer.
Jun

Answered On : May 5th, 2007

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.

Yes  1 User has rated as useful.
  
Login to rate this answer.
phani

Answered On : May 22nd, 2007

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

  
Login to rate this answer.
rajesh

Answered On : Jul 10th, 2007

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.

  
Login to rate this answer.

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 .RegardsSelva

  
Login to rate this answer.
ramsun

Answered On : Jul 23rd, 2007

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.

  
Login to rate this answer.

Database is collection of inter related data. It is a storege place where the data is taken place. DWH is typical relational database. It is used for anlysing and quering business reqirements. It maintains historical data. Data stage is a temporary storage area where transformation is held. These are the famous tools used for DWH ETL and reports. Here we use 3 architecture models in DWH, star schema, snowflake, integrated schema.

  
Login to rate this answer.
Hamid

Answered On : Sep 11th, 2007

View all questions by Hamid   View all answers by Hamid

I will explain difference between data base and dataware house in the language of layman. Data base is like a market from where you can buy any product but data ware house is like a big store like Kmart, SEARS  where Every thing which is there is according to the need of surrounding people. Here in this big store all products are according to the need of customers  in arranged manner. All sections are clearly indicating the category of items. Its very easy for customers to grab what they need. same is here in data ware house. We usually bring the required data which is needed for the particular bussiness and it fulfilled the  requirements of business. We use different Bussiniess intellegence tools to extact the data e-g cognos

  
Login to rate this answer.
Tanveer Ahmed

Answered On : Jul 23rd, 2008

View all answers by Tanveer Ahmed

Ans: -- A database is an organized collection of information. -- A data warehouse is a very large database with special sets of tools to extract and cleanse data from operational systems and to analyze data. -- A data mart is a focused subset of a data warehouse that deals with a single area of data and is organized for quick analysis.

  
Login to rate this answer.
mohammad1962

Answered On : Mar 14th, 2009

View all answers by mohammad1962

The differences areDatabase hold current data
Stores detailed data
Data is dynamic,
Repetitive processing,
High level of transaction throughput,
Predictable patter of usage
Application-oriented and
Support day-to-day decision
While data warehouse holds historical data,
Stores detailed, lightly and highly summarized data
Data is largely static,
Medium to low level of transaction throughput,
Unpredictable pattern of usage,
Analysis driven,
Subject-oriented and support strategic decisions The main advantages
of data warehouse are1- High query performance2- Queries not visible outside warehouse3-
Local processing at sources unaffected4- Can operate when source unavailable5-
Can query data not stored in DBMS

  
Login to rate this answer.
sap_23

Answered On : Sep 3rd, 2009

View all answers by sap_23

Database: A database is used to record, retrieve, update business transactions which are occurred daily in business life. Data ware House: A data warehouse is used to record historical data, purely for analysis purpose for top management.

  
Login to rate this answer.
brahmiii

Answered On : Feb 28th, 2010

View all answers by brahmiii

Database is the root of any data releted operations where as datawarehousing is a schema or process how effectively we access or utilize a database. Datawarehousing follows the star schema and snowflake schema as its basic schemas and we two other schemas also which are not much important.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Abinitio Interview Questions

Analysis services Interview Questions

Data Warehousing Basics

BO Designer Interview Questions

Business Intelligence Interview Questions

Business Objects Interview Questions

Cognos Interview Questions

Data Warehousing Concepts

BO Data Integration

DataStage Interview Questions

ETL Interview Questions

Hyperion Interview Questions

Impromptu Interview Questions

Informatica Interview Questions

MicroStrategy Interview Questions

Reportnet Interview Questions

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.