Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone explain difference between Database, Data warehouse
and Data mart with some example?````
- 4 Answers
- 6883 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the sql case statement used for?
Where do you find the default Index fill factor and how to change it?
What is the stored procedure?
How can you tell if a database object is invalid?
What is the difference between delete and truncate statements?
What is a database in ms sql server?
Explain Reporting Life Cycle?
What are the security related catalog views? : sql server security
How to run sql server 2005 books online on your local system?
What is the command used to recompile the stored procedure at run time?
What are a scheduled jobs?
What stored by the tempdb ? : sql server database administration
Name the different type of indexes in sql?
What is SQL Azure Federations?
What is query parameter in ssrs?
