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 |
Can foreign key be duplicate?
What is the maximum number of index per table?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What is a cursor, index in sql?
What is the difference between a local and a global temporary table?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What is a function? Give some example?
What is Sqlpaging in SqlServer 2005 ?
What is the openxml statement in sql server?
what stored procedure can you use to display the current processes? : Sql server administration
Is trigger fired implicitely?
What are the new features in SQL Server 2005?