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
- 6858 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
Explain the properties of subqueries in sql server?
what is bit datatype? : Sql server database administration
what is a live lock? : Sql server database administration
Tell me in brief how sql server enhances scalability of the database system?
What according to you is the difference between mysql and sql server performance?
where can you add custom error messages to sql server? : Sql server administration
can a table be moved to different filegroup? : Sql server administration
how to take backup bcp out for a column in table in sql server?
How to turn off warning messages during php execution?
What are the differences between web role and worker role?
What are the database objects? : SQL Server Architecture
How to connect a database with sql express.?
What is table join?
Why main is user defined function?
What is the downside of using udf?
