The data used by the sample data mining programs is based on these tables in the SH
schema:
SH.CUSTOMERS SH.SALES SH.PRODUCTS SH.SUPPLEMENTARY_DEMOGRAPHICS SH.COUNTRIES
The dmshgrants
script grants SELECT
access to the tables in SH
. The dmsh.sql
script creates views of the SH
tables in the schema of the data mining user. The views are described in Table A-3.
Table A-3 The Data Mining Sample Data
View Name | Description |
---|---|
|
Joins and filters data |
|
Data for building models |
|
Data for testing models |
|
Data to be scored |
|
Data for building models that include text |
|
Data for testing models that include text |
|
Data, including text columns, to be scored |
|
Data for anomaly detection |
The association rules program creates its own transactional data.