Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
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 ......
|
|||||||
|
|||
|
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 ... |
| Sponsored Links |
|
|||
|
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 |
|
|||
|
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 |
|
|||
|
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... |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Dbms | vidwans_abhinav | Database General | 11 | 06-27-2009 09:20 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 |