What is Data Warehouse

Data Warehouse

Data from different data sources is stored in a relational database for end use analysis

Data from different data sources is stored in a relational database for end use analysis Data is organized in summarized, aggregated, subject oriented, non volatile patterns.

Data is a data warehouse is consolidated, flexible collection of data Supports analysis of data but does not support online analysis of data.

Showing Answers 1 - 8 of 8 Answers

Prathiba

  • Nov 17th, 2005
 

datawarehouse is integrated , non vilotae ,timeviarnt and historical re of entrie cororate related data.

  Was this answer useful?  Yes

shalini

  • Nov 23rd, 2005
 

What  is difference in  DSS  and OLTP ?

  Was this answer useful?  Yes

DasK

  • Dec 19th, 2005
 

The  DSS is (Decision  Support System) used for the   decision making  purposes, not for day-2 day issues.by the top level/ sr/middle level managments people in a  established company.

but the OLTP  SYSTEMS handles the day-day transactions, data entries, billing etc issues .  

The  DSS  WILL  be handled by only a   few  users , especially  

top poeple in the   corporate ladder hence The number of users who  are making  use of DSS are  less.

 but in OLTP(ONLINE   TRANSACTION PROCESSING) the number  of the   users are  high, since no such kind of decision making is entailed.

regds

DAs.

  Was this answer useful?  Yes

sithusithu

  • Jan 4th, 2006
 

?         Subject oriented

?         Time variant

?         Historical

?         Process oriented

?         Integrated

 

Sithu

  Was this answer useful?  Yes

sithusithu

  • Jan 10th, 2006
 

A data warehouse is a database geared towards the business intelligence requirements of an organisation. The data warehouse integrates data from the various operational systems and is typically loaded from these systems at regular intervals. Data warehouses contain historical information that enables analysis of business performance over time

Cheers,

Sithu

  Was this answer useful?  Yes

mohanraj

  • Jan 17th, 2006
 

A process of transforming data into information and making it available to users in a timely enough manner to make a difference. 

 
 

  Was this answer useful?  Yes

jglickma

  • Nov 25th, 2008
 

Okay there are two camps on this Bill Inmon which is Date and Coddbased database design that has grown into the ODS reporting DSS database and of course Ralph Kimball whose mythology comprises of a star schema and dimension modeling... I could go on and on but basically a data warehouse is a database that is specifically designed for reporting, I leave Inmon to the oltp ODS and a true data wareshouse to Ralph Kimball. When I have to interview a data warehouse DBA et al the first question I ask "who is Ralph Kimball and can you tellme about the data warehouse toolkit"

  Was this answer useful?  Yes

idanh79

  • Dec 2nd, 2009
 

DWh is (6 important points about DWH) :

1. Dedicated Data Base
2. Integrated Data
3. Subject Oriented
4. Time Variant
5. Nonvolatile
6. Decision Support

Idan Halfon

  Was this answer useful?  Yes

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions