MySQL is a relational database which is based on structured query language. This is a very popular language for accessing and managing data in databases. MySQL is an open-source software which is under GNU license and supported by Oracle. It is commonly used with PHP for data handling. MySQL follows client-server architecture for data access, it shows the data as per user request.
Data warehousing is a process of collecting data from various resources and then giving the proper business insights. Data warehouse system is placed centrally and all the information coming from different sources is there. Data coming from a warehousing system may be structured, unstructured and semi-structured. Data is processed here so users can access proper and processed data.