Can anyone explain difference between Database, Data warehouse
and Data mart with some example?````
Answers were Sorted based on User's Feedback
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 |
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 |
About types of indexes in SQL server ?
Why de-normalization required?
Can you insert NULL in unique column?
What is the difference between Procedure and Function
4 Answers Accenture, Nagarro, TCS,
How to retrieve error messages using mssql_get_last_message()?
What is raid, and how it can influence database performance?
Which tcp/ip port does sql server run on? How can it be changed?
how to take backup bcp out for a column in table in sql server?
What are types of scd? : sql server analysis services, ssas
What are the steps you will take to improve performance of a poor performing query?
What is a subquery in a select query statement in ms sql server?
What is transaction server consistency?