A.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 A-2 Views Created by dmsh.sql
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 example creates its own transactional data.
Parent topic: Oracle Machine Learning for SQL Examples