Problem solve Get help with specific problems with your technologies, process and projects.

DW vs. DBMS vs. data mining

What's the difference between data warehousing, a DBMS, and data mining? Please explain what is data mining in detail.

You could think of data warehousing as an environment that provides a vehicle to deliver meaningful information to the business community to enable effective operations oversight and business decision support.

A DBMS is a "Database Management System". This is the software that manages data on physical storage devices. The software provides the ability to store, access and modify the data. The software also provides a suite of utilities to manage & monitor the performance on those actions against the data. Examples of a dbms would be Oracle, SQL/Server, DB2 and Informix in the relational (rdbms) world.

Data Mining: A hot buzzword for a class of database applications that look for hidden patterns in a group of data. For example, data mining software can help retail companies find customers with common interests. The term is commonly misused to describe software that presents data in new ways. True data mining software doesn't just change the presentation, but actually discovers previously unknown relationships among the data.


Dig Deeper on Oracle DBA jobs, training and certification