Online Data warehouse:-These are the data warehouse that are updated frequently (daily,monthly or monthly). Data are stored in an integrated structure so that everyone can access it and perform reporting. Integrated Data warehouse: These are the data warehouse that can be used for other systems to access them for operational systems. Real time Datawarehouse: These are the data warehouse that are updated each moment with new transact data.