Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Differences between data mining, BI and analytical tools

What are the differences between data mining tools, business intelligence/reporting tools and analytical tools?

Business Intelligence is the newer sexy name for the OLAP tools that have been available for over 5 years now. BI tools allow for simple list management, graphing reporting and managed query functionality. The more comprehensive "BI" tools extend that functionality to drill up, down and across your data and allow some level of multi-dimensional analysis, aggregating, etc.

Data mining goes one step further than a simple data warehouse. Whereas data warehousing is simply a method for organization of data, data mining is a database application that can take advantage of that organization to find hidden patterns in the data. For example, data mining software can find customers with common interests (think of Amazon recommending books that other customers liked who also bought A Wrinkle in Time). The term data mining is commonly misused to describe software that presents the data in new ways. True data mining software doesn't just change the presentation, but actually discovers previously unknown relationships among the data.

What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.

Next Steps

The Best Data Warehousing and Business Intelligence Web Links: tips, tutorials, scripts, and more.

Have an DW tip to offer your fellow administrators and developers? The best tips submitted will receive a cool prize. Submit your tip today!

Ask your technical data warehousing questions -- or help out your peers by answering them -- in our live discussion forums.

Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.

Dig Deeper on Oracle business intelligence and analytics

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.