However, most OLAP systems do not have inductive inference capabilities beyond the support for time-series forecast. Inductive inference, the process of reaching a general conclusion from specific examples, is a characteristic of data mining. Inductive inference is also known as computational learning. OLAP systems provide a multidimensional view of the data, including full support for hierarchies. This view of the data is a natural way to analyze businesses and organizations.

Data mining, on the other hand, usually does not have a concept of dimensions and hierarchies.

What type of data mining has your organization embraced?

Data mining and OLAP can be integrated in a number of ways. For example, data mining can be used to select the dimensions for a cube, create new values for a dimension, or create new measures for a cube. OLAP can be used to analyze data mining results at different levels of granularity. Data Mining can help you construct more interesting and useful cubes.

For example, the results of predictive data mining could be added as custom measures to a cube. Such measures might provide information such as “likely to default” or “likely to buy” for each customer. OLAP processing could then aggregate and summarize the probabilities. Data Mining and Data Warehousing Data can be mined whether it is stored in flat files, spreadsheets, database tables, or some other storage format.

The important criteria for the data is not the storage format, but its applicability to the problem to be solved. Proper data cleansing and preparation are very important for data mining, and a data warehouse can facilitate these activities.

However, a data warehouse will be of no use if it does not contain the data you need to solve your problem. Oracle Data Mining requires that the data be presented as a case table in single-record case format. All the data for each record case must be contained within a row. Most typically, the case table is a view that presents the data in the required format for mining.