mysql taste recommender ubuntu movielens

warning: Creating default object from empty value in /homepages/5/d120552937/htdocs/neil/drupal/or/modules/taxonomy/taxonomy.pages.inc on line 34.

MySQL and Taste

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:

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

 

 

Syndicate content