What is Data ware house ? How it is different from databases ?
Datawarehouse Data warehousing is a collection of tools and techniques using which more knowledge can be driven out from a large amount of data. This helps with the decision-making process and improving information resources. Datawarehouse is basically a database of unique data structures that allows the relatively quick and easy performance of complex queries over a large amount of data. It is created from multiple heterogeneous sources. A data warehouse is built to store a huge amount of historical data and empowers fast requests over all the data, typically using Online Analytical Processing (OLAP). Data Warehousing vs. Databases Data warehouses and databases both are relative data systems, but both are made to serve different purposes. A data warehouse is built to store a huge amount of historical data and empowers fast requests over all the data, typically using Online Analytical Processing (OLAP). A database is made to store current transactions and allow ...