Thanks Sean, We will try ReloadFromJDBCDataMode. It seems to be exactly what we want.
We are using mysql so there is no need to write a JDBCDataModel implementation since it is available in Mahout. Ahmet ________________________________ From: Sean Owen <[email protected]> To: [email protected]; Ahmet Ylmaz <[email protected]> Sent: Thursday, November 1, 2012 12:08 PM Subject: Re: Reading data from a database table You want ReloadFromJDBCDataModel + a JDBCDataModel implementation. On Thu, Nov 1, 2012 at 10:05 AM, Ahmet Ylmaz <[email protected]>wrote: > Hi, > > We want to build a data model from a ratings table (userid, itemid, > rating) stored in a database. We want the model to be stored in memory. > However, we couldn't find a way to do this using the available Mahout > codes. > > JDBC based data models don't work because, as it is said in Mahout > in Action book, they are used when the data does not fit into memory. > > Actually > what we need is a class similar to FileDataModel which will return a > GenericDataModel from a database table (not from a file). > > What are your suggestions to solve this problem? > > Thanks > > Ahmet >
