MySQL and Data Warehousing

What is MySQL?

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. 

Features of MySQL

  • MySQL is an open-source software and free to use so it is popularly used.
  • MySQL is customizable because it is open source and also has a GNU license.
  • MySQL is very powerful and can handle large amounts of data.
  • MySQL creates databases and allows us to make tables and rows and allows us to make relations between two or more tables.
  • MySQL supports various languages like C, C++, Java, Perl etc.

What is data warehousing?

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.

Features of Data warehousing

  • Data warehousing provides exact data and tries to avoid whole data of any specific topic.
  • It is a combination of data from various sources so that it provides better data analysis.
  • New changes don't get affected by the previous or old data.