Geeks Talk

Prepare for your Next Interview




Difference between dbms and dataware house

This is a discussion on Difference between dbms and dataware house within the Data Warehousing forums, part of the Databases category; Sir What is DataWarehouse. Difference between DBMS and DataWarehouse. When to use DataWarehouse. Pls sir give me some details about this topics ......


Go Back   Geeks Talk > Databases > Data Warehousing

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 08-05-2008
Junior Member
 
Join Date: Aug 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
yaman is on a distinguished road
Difference between dbms and dataware house

Sir
What is DataWarehouse.
Difference between DBMS and DataWarehouse.
When to use DataWarehouse.

Pls
sir give me some details about this topics ...
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 08-06-2008
Expert Member
 
Join Date: Jan 2007
Location: Chennai
Posts: 139
Thanks: 1
Thanked 44 Times in 29 Posts
Sridevichitthu is on a distinguished road
Re: Difference between dbms and dataware house

Hi Yaman,

A data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis.

This classic definition of the data warehouse focuses on data storage. However, the means to retrieve and analyze data, to extract, transform and load data, and to manage the dictionary data are also considered essential components of a data warehousing system.

Many references to data warehousing use this broader context. Thus, an expanded definition for data warehousing includes business intelligence tools, tools to extract, transform, and load data into the repository, and tools to manage and retrieve metadata.

Find this link ScienceDirect - European Journal of Operational Research : Integrated model management in the data warehouse era

Cheers,
Sridevichitthu
Reply With Quote
  #3 (permalink)  
Old 08-07-2008
Contributing Member
 
Join Date: Dec 2007
Location: INDIA
Posts: 36
Thanks: 1
Thanked 6 Times in 6 Posts
cme_prak is on a distinguished road
Smile Re: Difference between dbms and dataware house

Database -- dwh

1)oltp -- olap

2)transaction -- analysis

3)er-diagram -- data modeling

4)normalized data -- denormalized data

5)inserts & update insert (for rows)


oltp - online transaction processsing

olap - online analytical processing

Last edited by cme_prak : 08-07-2008 at 01:39 AM. Reason: For Alignment purpose
Reply With Quote
  #4 (permalink)  
Old 08-11-2008
Junior Member
 
Join Date: Aug 2008
Location: chennai
Posts: 6
Thanks: 3
Thanked 0 Times in 0 Posts
janaraj is on a distinguished road
Re: Difference between dbms and dataware house

Hi..


dbms-- oltp-- online transaction processing..
here we cont analysis bcos data changes day by day...




data warehousing--- olap-- online analytical processing..
it maintains historical data..
it collects data from diff databases like oracle,sybase and so on..

it is used to find analysis and generate reports...
Reply With Quote
Reply

  Geeks Talk > Databases > Data Warehousing


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Dbms vidwans_abhinav Database General 7 08-26-2008 08:31 PM
the difference between dbms and rdbms in detail shruti_raman Database General 1 07-29-2008 05:52 AM
Dbms output babi_geek Oracle 2 03-12-2008 05:19 AM
dbms jasjas Database Design 1 10-24-2007 04:23 AM
Query with a command in DBMS fred SQL 1 10-01-2006 03:51 PM


All times are GMT -4. The time now is 07:33 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved