Gaurav Gupta
Explain the Relationship between database and data warehouse?
By Gaurav Gupta in Databases & DBA on Jun 27 2012
  • Munesh Sharma
    Apr, 2014 14

    In simple words, a database is used to store information, and a data warehouse is used to query and analyse the stored data in several ways. Data warehouse helps business management to take important choices and decisions by providing them with detailed analysis on historical data.While databases are OLTP (On-Line Transaction Processing) systems, data warehouse is an OLAP (On-Line Analytical Processing) system.Databases are write-optimised, Data warehouse are read-optimised

    • 0

Most Popular Job Functions