In-database Data Mining advantages/differences compared to compared to data mining done on a flat file extracted from the database/data warehouse?

Gregory Piatetsky-Shapiro answers:

Oracle, a vendor of in-database data mining, gives these advantages:

  • eliminates data movement,
  • speeds data mining,
  • simplifies model deployment, and
  • delivers security and scalability.


The disadvantages include potentially higher cost and reduced flexibility (some more advanced algorithms may be more difficult to implement in a database)