oracle.dmt.op.re.reapi.batch
Class REProxyBatch

java.lang.Object
  |
  +--oracle.dmt.op.re.reapi.batch.REProxyBatch

public class REProxyBatch

extends Object

Constructor Summary

REProxyBatch(String sProxyName, String sDbURL, String sUserName, String sPassword)
Constructor.

Method Summary

Type	Method
void	crossSellForItem(Location oItemTableLocation, int iNumberOfItems, TuningSettings oTuningSettings, FilteringSettings oFilteringSettings, Location oResultLocation) Recommends cross-sell items for a specified item.
void	destroy() Destroys REProxyBatch object.
void	loadCustomerProfiles(Location oCustomerIdsTable, String sCustomerProfileTableName) Load scustomer profile.
void	purgeCustomerProfiles(String sCustomerProfileTableName) This API drops the customer profiles table, identified by the input name from current RE schema.
void	rateItem(String sCustomerProfileTableName, Item item, int taxonomyId, TuningSettings oTuningSettings, Location oResultLocation) Rates a single item for all customers in the profile table.
void	recommendTopItems(String sCustomerProfilesTableName, int iNumberOfTopItems, TuningSettings oTuningSettings, FilteringSettings oFilteringSettings, Location oResultLocation) Recommends top N items for all customers whose profiles are found in the customer profiles table.
void	recordResultTableName(Location resultLocation) Records name of the result table we created.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

REProxyBatch

public REProxyBatch(String sProxyName,
                    String sDbURL,
                    String sUserName,
                    String sPassword)
             throws StringTooLargeException,
                    SQLException,
                    REProxyInitException

Constructor.

Method Detail

destroy

public void destroy()
             throws SQLException

Destroys REProxyBatch object.

Throws:

SQLException -

loadCustomerProfiles

public void loadCustomerProfiles(Location oCustomerIdsTable,
                                 String sCustomerProfileTableName)
                          throws StringTooLargeException,
                                 BadDBConnectionException,
                                 ErrorExecutingRE

Load scustomer profile.

PL/SQL signature

PROCEDURE load_customer_profiles_batch (

p_customer_ids_table_name VARCHAR2,

p_database_alias VARCHAR2,

p_user_name VARCHAR2,

p_password VARCHAR2,

p_schemaName VARCHAR2,

p_output_customer_table_name VARCHAR2);

Parameters:

oCustomerIdsTable - location of customer profile table

sCustomerProfileTableName - name of the output table to be created in the RE.

purgeCustomerProfiles

public void purgeCustomerProfiles(String sCustomerProfileTableName)
                           throws StringTooLargeException,
                                  BadDBConnectionException,
                                  ErrorExecutingRE

This API drops the customer profiles table, identified by the input name from current RE schema.

PL/SQL signature

PROCEDURE purge_customer_profiles_batch (

p_customer_table_name VARCHAR2);

Parameters:

sCustomerProfileTableName - name of the output table to be dropped from the RE

recommendTopItems

public void recommendTopItems(String sCustomerProfilesTableName,
                              int iNumberOfTopItems,
                              TuningSettings oTuningSettings,
                              FilteringSettings oFilteringSettings,
                              Location oResultLocation)
                       throws StringTooLargeException,
                              NullParameterException,
                              BadDBConnectionException,
                              ErrorExecutingRE,
                              SQLException,
                              CreateResultTableError

Recommends top N items for all customers whose profiles are found in the customer profiles table.

PL/SQL signature

PROCEDURE recommend_top_items_batch (

p_customer_profile_table_name VARCHAR2,

p_result_table_name VARCHAR2,

p_result_database_alias VARCHAR2,

p_result_user_name VARCHAR2,

p_result_password VARCHAR2,

p_result_schema_name VARCHAR2,

p_number_of_items NUMBER,

p_item_category ITEM_CATEGORY_LIST_TYPE,

p_category_membership NUMBER,

p_category_filtering NUMBER,

p_taxonomy NUMBER,

p_exclude_profile NUMBER,

p_interest_dimension NUMBER,

p_data_source_type NUMBER,

p_serendipity NUMBER);

Parameters:

sCustomerProfilesTableName - name of the customer profiles table already existing in the RE

iNumberOfTopItems - number of items to recommend, per customer

oTuningSettings - various parameters needed for making recommendations

oFilteringSettings - various filtering parameters needed for making recommendations

oResultLocation - database location where the resulting recommendations are stored

rateItem

public void rateItem(String sCustomerProfileTableName,
                     Item item,
                     int taxonomyId,
                     TuningSettings oTuningSettings,
                     Location oResultLocation)
              throws StringTooLargeException,
                     ErrorExecutingRE,
                     BadDBConnectionException,
                     CreateResultTableError

Rates a single item for all customers in the profile table.

PL/SQL signature

PROCEDURE rate_item_batch (

p_customer_profile_table_name VARCHAR2,

p_result_table_name VARCHAR2,

p_result_database_alias VARCHAR2,

p_result_user_name VARCHAR2,

p_result_password VARCHAR2,

p_result_schema_name VARCHAR2,

p_item_type VARCHAR2,

p_item_id NUMBER,

p_taxonomy NUMBER,

p_interest_dimension NUMBER,

p_data_source_type NUMBER,

p_serendipity NUMBER);

Parameters:

sCustomerProfileName - name of the customer profiles table already existing in the RE

oTuningSettings - various parameters needed for making recommendations

oFilteringSettings - various filtering parameters needed for making recommendations

oResultLocation - database location where the resulting recommendations are stored

crossSellForItem

public void crossSellForItem(Location oItemTableLocation,
                             int iNumberOfItems,
                             TuningSettings oTuningSettings,
                             FilteringSettings oFilteringSettings,
                             Location oResultLocation)
                      throws NullParameterException,
                             BadDBConnectionException,
                             InvalidIDException,
                             ErrorExecutingRE,
                             SQLException,
                             CreateResultTableError

Recommends cross-sell items for a specified item.

PL/SQL signature

PROCEDURE cross_sell_items_batch (

p_item_table_name VARCHAR2,

p_item_Database_alias VARCHAR2,

p_item_user_name VARCHAR2,

p_item_Password VARCHAR2,

p_item_Schema_Name VARCHAR2,

p_result_table_name VARCHAR2,

p_result_database_alias VARCHAR2,

p_result_user_name VARCHAR2,

p_result_password VARCHAR2,

p_result_schema_name VARCHAR2,

p_num_of_items NUMBER,

p_interest_dimension NUMBER,

p_data_source_type NUMBER,

p_serendipity NUMBER,

p_item_category ITEM_CATEGORY_LIST_TYPE,

p_category_membership NUMBER,

p_category_filtering NUMBER,

p_taxonomy NUMBER,

p_exclude_profile NUMBER);

Parameters:

oItemTableLocation - location of the input item table

iNumerOfItems - number of cross-sell items to return

oTuningSettings - various parameters needed for making recommendations

oFilteringSettings - various filtering parameters needed for making recommendations

oResultLocation - database location where the resulting recommendations are stored

recordResultTableName

public void recordResultTableName(Location resultLocation)
                           throws SQLException,
                                  BadDBConnectionException

Records name of the result table we created.