WebSphere Commerce extensions to the LikeMinds Personalization server database

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.