What is the difference between the Database and Datawarehouse?

Database

  • It contains Normalized data
  • Group of databases form a data mart
  • E-R modeling techniques are used for database design

Datawarehouse

  • It contains De-Normalized data
  • It is the collection of data marts
  • Data modeling techniques are used for database design

Latest Comments
  1. Vikram

    I think for database the performance should be high. As the database having less amount of data stored in compare to datawarehouse

Leave a Reply

Your email address will not be published. Required fields are marked *