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.
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
Related Q&A from Mike Lampa
When trying to design a data warehouse, we often try to model the database on the operational data model. Are there any guidelines in trying to ... Continue Reading
What is a surrogate key in a table? Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.