That is data warehouse what,how?
In other words, the data warehouse is a relational database designed to be used for querying and analysis rather than database movement. In general, date information obtained from motion data may contain information from other sources as well. Loads that are borrowed from database transactions break apart from the load of the analysis and allow it to be organized more easily in the Channel collected from different sources. As mentioned above, information to be transferred to the data warehouse passes through a number of operations before being transferred to the data warehouse. The data passes through the ETL process before entering the data warehouse. Confirm what you want in this way and use it.
So why is the quality of the data warehouse so important?
If the data in the data warehouse were very irregular and were in a situation where it was not possible to operate on the allele, we could get wrong results in our queries. For example; When we want to choose unmarried women over 18, the data in the gender block are female, female, May be entered in shapes. In this case, we will have lost a significant amount of future data when we take our inquiry as a lady. As a result, we will get wrong values.
Well, why did the data warehouse come up?
The concept of data warehouse emerges from the need to provide easy access to structured quality information that can be used in decision making. Hence, data warehouses are established for easy access to high quality databases that will be used for decision making and analysis purposes. It is generally accepted that in the competitive environment of the business world knowledge will provide important advantages to the organization. Despite the fact that organizations have large amounts of data, unfortunately accessing and using these data becomes more difficult as the amount of data increases. Data warehouse access data sources in different planes, clean up the data, filter them, and store them in an understandable and easily accessible structure. This data is then used in querying, reporting and data analysis.
What is data mining? What are the benefits?
There is a lot to say about data mining, some of which are:
Data mining; Statistical data is used for analysis and discovery of information. Statistical data analysis identifies unusual patterns on the verse and applies statistical and mathematical modeling techniques to explain these patterns. These models are then used for prediction and estimation.Data mining; Is to discover the most beneficial way to use it. Data mining; Is a newer analysis technique than other techniques. Because of the use of a method called discovery technique, reporting is very different from questioning and multidimensional analysis techniques. the data. Data warehouse includes the data mining.