Database And Data Warehouse Difference. To effectively perform analytics you need a data warehouse. An olap online analytical processing database.
Database is application oriented collection of data whereas data warehouse is the subject oriented collection of data. A database often changes due to frequent updates done on it and hence it cannot be used for analysis or reaching. Information generated by both are used for different purposes.
It is not designed to perform big analytical queries the way a data warehouse is.
A database is normally optimized for performing read write operations of single point transactions. Database uses online transactional processing oltp whereas data warehouse uses online analytical processing olap. An olap online analytical processing database. These may range from simple informational queries to analytical reports used for improving performance of businesses.
