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
- 6787 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 are page splits?
Write SQL queries on Self Join and Inner Join.
what are the different types of replication you can set up in sql server? : Sql server database administration
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How many triggers you can have on a table?
What is difference between rownum and rowid?
Which tcp/ip port does sql server run on? How can it be changed?
How to use union to merge outputs from two queries together in ms sql server?
Can you explain what are various ways to enhance the ssrs report?
How many triggers are possible per table?
Does a sql server 2005 select statement require a from?
How to delete multiple rows with one delete statement in ms sql server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What are different replication agents and what's their purpose? : sql server replication
What does top operator do?
