MySQL

After installing mysql with synaptic package manger

Goto the menu Applications/Programming/MySQL Administrator
hostname: localhost
username: root
password: your password

If you are not using mysql server all the time you may want to remove it from the services and start it manually by System/Administration/Services

Taste

Taste version 1.7.1 was used

To create database named taste -- click on Catalogs and then under Schemata right click and select create schema "taste"

Then use MySQL Query Browswer and follow the instructions to create table at http://taste.sourceforge.net/javadoc/com/planetj/taste/impl/model/jdbc/M...

Loading MovieLens Data

LOAD DATA INFILE 'ratings.dat' INTO TABLE taste_preferences FIELDS TERMINATED BY '::';

# for 1 million

LOAD DATA INFILE '/home/neil/tmp/u.data' INTO TABLE taste_preferences FIELDS TERMINATED BY '\t';

# for 100K

Notes:

Some say that recommendation technology represents the new paradigm of search: interesting items find the user instead of the user explicitly searching for them. In an article published in CNN Money, entitled “The race to create a 'smart' Google”, Fortune magazine writer Jeffrey M. O'Brien, writes:

Various Issues

Issue 1

WARNING: You are not using ConnectionPoolDataSource. Make sure your DataSource pools connections to the database itself, or database performance will be severely reduced.
 

FIX: ConnectionPoolDataSource dataSource = new MysqlConnectionPoolDataSource();