Ask the Expert

The roles of data warehousing, data mining and OLAP in knowledge discovery

Can you provide an overview of knowledge discovery and how data warehousing, data mining and OLAP factor into it?

    Requires Free Membership to View

The data warehouse provides the data foundation for the data - the place where the data that goes into the process of knowledge discovery is stored. Data mining may be used to automatically perform knowledge discovery by giving the mining algorithm loose cues about potential relationships and letting the algorithm work on the data to discover the relationships and items to focus on further. OLAP is complimentary to data mining and is most likely the first, and most preferred, manner of discovering knowledge. OLAP works through a user performing specific, rather than general, interactive analysis with the data. If a data warehouse is present in the environment, either it or a data mart, would be the database used by OLAP.

For example, if you were analyzing sales, the data warehouse could contain 3 years of item level detail. Data mining could perform the advanced analytics required to determine what items are generally purchased together (market basket analysis) or what shopper demographics lead to the highest sales volume. These pieces of knowledge could lead to better product placement and marketing strategies. Likewise, an analyst could perform OLAP on the data warehouse to determine what products sell the most and what customers buy the most. While this information lacks the correlations that data mining would yield, it is nonetheless still valuable. This could also drive promotions strategy as well as vendor management strategies.


Browse through our business intelligence stories from around the Web.

This was first published in August 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: