handling large data on single computer differentbecause the algorithm could converge slightly differently if you don' mind waiting whileyou can go for the full data set you can now handle all the data without problems we won' have sixth step (presentation or automationin this case study now let' look at second application of our techniquesthis time you'll build recommender system inside database for well-known example of recommender systems visit the amazon website while browsingyou'll soon be confronted with recommendations"people who bought this product also bought case study building recommender system inside database in reality most of the data you work with is stored in relational databasebut most databases aren' suitable for data mining but as shown in this exampleit' possible to adapt our techniques so you can do large part of the analysis inside the database itselfthereby profiting from the database' query optimizerwhich will optimize the code for you in this example we'll go into how to use the hash table data structure and how to use python to control other tools tools and techniques needed before going into the case study we need to have quick look at the required tools and theoretical background to what we're about to do here tools mysql database --needs mysql database to work with if you haven' installed mysql community serveryou can download one from www mysql com appendix "installing mysql serverexplains how to set it up mysql database connection python library--to connect to this server from python you'll also need to install sqlalchemy or another library capable of communicating with mysql we're using mysqldb on windows you can' use conda right off the bat to install it first install binstar (another package management serviceand look for the appropriate mysql-python package for your python setup conda install binstar binstar search - conda mysql-python the following command entered into the windows command line worked for us (after activating the python environment)conda install --channel againfeel free to go for the sqlalchemy library if that' something you're more comfortable with we will also need the pandas python librarybut that should already be installed by now with the infrastructure in placelet' dive into few of the techniques