-
Essay / Data mining and data warehousing
Today's economy is made up of a large and continuous flow of data. A person's ability to collect, analyze and use data to benefit their business is an invaluable asset. The process of compiling and organizing data into a common database is data warehousing. The data mining process leverages the data compiled during the data warehouse hosting phase to detect meaningful patterns. Say no to plagiarism. Get a tailor-made essay on “Why violent video games should not be banned”?Get the original essayA data warehouse is a database used to store data. It is a central data repository where data from various sources is stored. This data warehouse is then used for reporting and data analysis. It can be used to create trend reports for senior management reporting, such as annual and quarterly comparisons. The purpose of a data warehouse is to provide the user with flexible access to data. Data warehousing generally refers to the combination of many different databases across an enterprise. Data warehousing focuses on capturing data from various sources for useful analysis and access, but generally does not start from the perspective of the end user who may need access to databases. specialized data, sometimes local. This latter idea is known as a data mart. There are two approaches to data warehousing, top-down and bottom-up. The top-down approach creates data marts for specific groups of users after the entire data warehouse is created. The bottom-up approach first creates the data marts and then combines them into a single overall data warehouse. Typically, a data warehouse is hosted on an enterprise mainframe server or, increasingly, in the cloud. Data from various online transaction processing (OLTP) applications and other sources is selectively extracted for use by analytical applications and user queries. The term data warehouse was coined by William H. Inmon, known as the father of data warehousing. Inmon described a data warehouse as a collection of subject-oriented, integrated, time-varying, non-volatile data that supports management decision-making. Data Mining is actually the analysis of data. It is the computer-assisted process of mining and analyzing huge sets of data that have either been compiled by the computer or entered into the computer. In data mining, the computer will analyze the data and extract meaning from it. It will also look for hidden patterns in the data and attempt to predict future behavior. Data Mining is mainly used to find and display relationships between data. The goal of data mining, also known as knowledge discovery, is to allow businesses to visualize these behaviors, trends and/or relationships and be able to factor them into their decisions. This enables businesses to make proactive, knowledge-based decisions. The term "data mining" comes from the fact that the process of data mining, that is, finding relationships between data, is similar to mining and the search for valuable materials. Data mining tools use artificial intelligence, machine learning, statistics and database systems to find..