SH Sample Schema Scripts and Objects

The following tables list the names of the scripts that create the Sales History (sh) schema and describe the objects in the schema. Table 4-19 lists the sh scripts in alphabetical order, while Table 4-20 lists the sh objects.

Table 4-19 SH Sample Schema Scripts

Script Name	Description
sh_create.sql	Creates the objects in the schema
sh_install.sql	Main script for schema sh; calls other scripts
sh_populate.sql	Populates the objects
sh_uninstall.sql	Uninstalls the schema

Table 4-20 SH Sample Schema Objects

Object Type	Objects
Dimension	channels_dim, customers_dim, products_dim, promotions_dim, times_dim
Index	channels_pk, countries_pk, customers_gender_bix, customers_marital_bix, customers_pk, customers_yob_bix, dr$sup_text_idx$x, fw_psc_s_mv_chan_bix, fw_psc_s_mv_promo_bix, fw_psc_s_mv_subcat_bix, fw_psc_s_mv_wd_bix, products_pk, products_prod_cat_ix, products_prod_status_bix, products_prod_subcat_ix, promo_pk, sup_text_idx, times_pk
Partitioned Index	costs_prod_bix, costs_time_bix, sales_channel_bix, sales_cust_bix, sales_prod_bix, sales_promo_bix, sales_time_bix
Materialized View	cal_month_sales_mv, fweek_pscat_sales_mv
Table	channels, countries, customers, products, promotions, times
Partitioned Table	costs, sales
View	profits