39.3 OML4SQL Sample Data

The data used by the OML4SQL examples is based on these tables in the SH schema.

Those tables are: 

SH.CUSTOMERS 
SH.SALES 
SH.PRODUCTS 
SH.SUPPLEMENTARY_DEMOGRAPHICS
SH.COUNTRIES

The dmshgrants script grants SELECT access to the tables in the SH schema. The dmsh.sql script creates views of the SH tables in the schema of the OML4SQL user. The views are described in the following table.

Table 39-2 Views Created by dmsh.sql

View Name Description

MINING_DATA

Joins and filters data

MINING_DATA_BUILD_V

Data for building models

MINING_DATA_TEST_V

Data for testing models

MINING_DATA_APPLY_V

Data to be scored

MINING_BUILD_TEXT

Data for building models that include text

MINING_TEST_TEXT

Data for testing models that include text

MINING_APPLY_TEXT

Data, including text columns, to be scored

MINING_DATA_ONE_CLASS_V

Data for anomaly detection

The association rules example creates its own transactional data.