In order to accommodate WebSphere Commerce data in the LikeMinds Personalization server's database, the following extensions are made to the LikeMinds database:
Database Table | Extension | Reason |
---|---|---|
LPS_ITEM_DATA | Add STORE_ID column | Associates a product with a store. This allows us to scope a recommendation to a specific store. |
Add WCS_ITEM_ID column | Maps the WebSphere Commerce CatentryId to the LikeMinds internal ID for the item. | |
LPS_USER_DATA | Add WCS_USER_ID column | Maps a WebSphere Commerce userId to the LikeMinds internal ID for the user |
WebSphere Commerce also requires the following additional tables:
- WCS_TRX_TYPE:
- This table stores information about the type of transactions recorded in
the WCS_User_Trx table. It is only used by the Clickstream, Item Affinity, and
Purchase engines.
Column Name Column Type Description type_id (primary key) number(12,0) Type of transaction. This must mactch the type_id specified in the LMEVENTMAP table in the WCS Database type_name varchar(64) String name for the transaction type. decay_weight float Rate at which information used for an activity's similarity measurement diminishes. procFlags number(12,0) Enables or disables transaction sets from storing multiple transactions. mentor_weights number(12,0) Sets the mentor weight for an activity type. Mentor weights are used to calculate the similarity between users. type_adj_total float For internal use only. type_total float For internal use only. - WCS_USER_MENTOR
- This table contains the mentors for a user. It is written to by the sifter.
The primary key of this table is (user_id, mentor_user_id).
Column Name Column Type Description user_id
(foreign key, indexed)number(12,0) User ID mentor_user_id (foreign key) number(12,0) User ID of a mentor for the user value number(12,0) A measure of the similarity between user and mentor time_stamp number(12,0) Time the record was last modified, in seconds since January 1, 1970 - WCS_USER_TRX
- This table stores a record of user behavior in your application. The
WCS_User_Trx records user behavior as the user navigates through a Web site;
that is, a history of user "clicks" during the user's Web site
visit. It records data such as the items the users view, click on, and add to
their shopping carts.
Column Name Column Type Description user_id (primary key) number(12,0) User identifier item_id (primary key) number(12,0) Item identifier trx_id (primary key) number(12,0) Transaction identifier type_id (foreign key) number(12,0) Type of transaction; for example, a purchase, detailed product view,shopping cart addition, shopping cart deletion, and so on. This field is read from the type_id field in thewcs_Trx_Type table. value float Data value associated with the transaction. adj_count float Adjusted count of transactions. If a new activity is recorded to the transaction table, this value is increased. It may diminish over time. - WCS_MENTOR_POOL
- This table stores a pool of users who are current, unique mentors.
Column Name Column Type Description user_id
(foreign key)number(12,0) Unique identifier for a user. mentor_quality number(12,0) Mentor quality; set and used by theLikeMinds RecommendationServer. mentor_count number(12,0) Total number of users mentored by this user. time_stamp number(12,0) Time of last modification of information about the item, in seconds since January 1, 1970.