Table Formats

Oracle Data Mining supports two formats for data tables:

Multi-Record Case format is typically used for market basket data.

Algorithms and Table Format

Not all algorithms support transactional data for input.

For Association models, require transactional format.

All other models require a non-transactional case table. Transactional data can be added by joining it to the case table.

All models except for Association models can have either pure single-record case format input or input consisting of transactional data joined to a non-transactional case table.

RESTRICTION: Attribute Name in Multi-Record Case format should be no longer than 30 characters. ODM does not support longer attribute names (that is, attribute names having data type VARCHAR2(n) with n>30) in operations such as model building.