Are data mining and data warehousing related?

Both data mining and data warehousing are line of work intelligence puppet that are used to turn information ( or data ) into actionable knowledge . The important distinctions between the two putz are the methods and processes each uses to achieve this destination .

datum mining is a process of statistical depth psychology . Analysts use technical tools to query and sort through TiB of data take care for patterns . Usually , the psychoanalyst will explicate a hypothesis , such as customers who buy product X usually buy Cartesian product Y within six months . Running a interrogation on the relevant data to test or confute this theory is data excavation . Businesses then use this information to make serious business decision base on how they understand their customers ' and suppliers ' behaviour .

Data warehousing describes the operation of designing how the data is stack away in monastic order to improve coverage and depth psychology . datum warehouse experts look at that the various stores of data are connected and related to each other conceptually as well as physically . A business ’s data is ordinarily store across a phone number ofdatabases . However , to be able to analyze the broadest orbit of data , each of these database need to be connected in some direction . This means that the data within them need a way of being relate to other relevant information and that the strong-arm databases themselves have a connection so their information can be calculate at together for reporting purposes .

So the crux of the relationship between information minelaying and data storage is that data , properly warehoused , is easier to mine . If a data point mining enquiry has to incline through terabytes of information spread across multiple database , which sit on different forcible networks - - that is not an efficient query and getting results will take a long a clock time . However , if the datum warehouse expert designs a information storage system that intimately connects relevant data point in different database , the data miner can now run much more meaningful and effective queries to improve the byplay .