Oracle Data Mining (ODM) provides data mining functionality as a part of Oracle Advanced Analytics Option. I have used this tool to model database login activity which was used to establish database activity trends and help in fraud detection and prevention. Once the data was loaded, used Oracle supplied analytical functions like Regression and “attribute Importance” to create a predictive model. Viewing the data on the Dashboard with charts is a great option this tool provides. Data Mining models can be included in SQL queries and embedded in applications to offer improved business intelligence.
Room for Improvement:
Since a separate Oracle database is needed, the data loading and cleansing the raw data can be a time consuming process.Licensing can be tricky with all the options in the Oracle OLAP suite.It is better to get the whole OLAP suite and use the features one needs rather than buying piece meal.
One should try to automate the whole data loading and cleansing process using scripts to get a quick turnaround. Using shell and sql scripts one can automate this process. This product was chosen to establish database login patterns as a custom solution for a DAM (Data Access Monitoring) tool.