This package provides java classes whose methods can build data tables in the SQL database. However, this package can not create a database, it can only connect to an existent database specified in the 'jdbc url'. Also, to fill tables with data, it uses jdbc "INSERT" methods. Thus, it is very slow. To use this package, you can use the "make_user_db", "make_item_db", and "make_rating_db" shell scripts in the bin directory to build usertable, itemtable and rating table.

We also provide a faster way to build SQL database -- use "make_db" shell script and "make_db.script" mysql script in the bin directory.

The CalcUserInfo class is for loading computed data to USER_INFO table, which is also a required table for our prediction. Run through shell " calcUsersInfo " in command line.

Please note all USER_TABLE, ITEM_TABLE and RATING_TABLE are TAB deliminated.