Reply to comment

MySQL and Taste


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 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


Loading MovieLens Data

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

# for 1 million

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

# for 100K








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:

The Web, they say, is leaving the era of search and entering one of discovery. What's the difference? Search is what you do when you're looking for something. Discovery is when something wonderful that you didn't know existed, or didn't know how to ask for, finds you.


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();




  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options