Can anyone explain difference between Database, Data warehouse and Data mart w

Can anyone explain difference between Database, Data warehouse
and Data mart with some example?````

Question Posted / arunz550i

4 Answers
6005 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can anyone explain difference between Database, Data warehouse and Data mart with some example?```..

Database- is collection of data like transaction data,
DWH is nothing but database but it can maintain historical data,
data mart is slice of dwh

Is This Answer Correct ?

2 Yes

0 No

Can anyone explain difference between Database, Data warehouse and Data mart with some example?```..

Answer / manoj pandey

1. Database: primarily is a collection of Tables that are normalized upto 3-NF and can be interrelated by FKs. It is an OLTP system which is meant for storing data of Information systems, like a CRM, ERP, Company/College/School record management system, and similar Data Entry other tools.

2. Data Warehouse: DW or EDW (Enterprise DW) is a system created by combining more than one Database systems, and/or by getting data from different Sources like heterogeneous Databases, flat-files, data feeds, etc. The tables in this system are de-normalized like in 1-NF, so that all related information is in a single table. Is is an OLAP system which is meant mainly for Reporting.

3. Data Mart: are built on top of a Data Warehouse, either by creating Views from underlying tables or a CUBE from fact & dimension tables.

~Manoj (http://sqlwithmanoj.wordpress.com)

Is This Answer Correct ?

0 Yes

0 No

Can anyone explain difference between Database, Data warehouse and Data mart with some example?```..

Answer / sarva

database:collection of related records in 2D store media
eg:attendance register,empoly table;
whereas in DWH its capacity is enterprise wise and
multidimensional way eg:banking or any company websites;
whereas in datamart its capacity is department wise data
storage media eg:official logins.

Is This Answer Correct ?

3 Yes

4 No

Can anyone explain difference between Database, Data warehouse and Data mart with some example?```..

Answer / arunz550i

Need detailed explaination.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer