This last week has been frustrating. I spent almost the entire last week trying to figure out how to upload three tables from one part of the server into MySQL's databases on the server. So far, it's been one gigantic trial. With the help of Reed, I've managed to get two of the tables on. Unfortunatly, the third table is proving to be very difficult. It refuses to upload correctly the way either of the other two databases uploaded. I've tried going into MySQL and using the INSERT DATA INFILE command, I've tried staying in linux and using the databasename < filepath command, I've tried using the mysqlimport command, all to no avail. I've gotten a little more then fed up with this. I guess it's been a learning experience, I've had to learn alot more about how a database is put together. I've also gotten to learn some more linux commands.
Update: Just finished uploading the tables. I think I actually only need to have two of the tables - the two orders tables actually contain identical columns, so I'll just mine one of them for now. I've started extracting useful columns from the tables.
I'm having trouble coming up with a good business objective to mine for. One thing that could be interesting is to try to identify what might prompt a user to make a purchase through a particular channel. Another interesting thing could be to figure out patterns in where people tend to shop in relation to where they live.
Tuesday, June 9, 2009
Subscribe to:
Posts (Atom)