"How to connect with MYSQL database"

afandiphd
afandiphd New Altair Community Member
edited November 5 in Community Q&A
Hi, I'm a newbie here.

I'd like to use the database store in MySQL database
Does anybody have such idea about it.
I'd like to use for mining.TQ
Tagged:

Answers

  • keith
    keith New Altair Community Member
    You should be able to use the JDBC database driver for MySQL that comes with RapidMiner.  I haven't used MySQL, but I have successfully used JDBC to connect to Microsoft SQL Server using the DatabaseExampleSource operator.

    Hope this helps.
    Keith
  • afandiphd
    afandiphd New Altair Community Member
    Thanks.

    now able to connect with MysqL using IO/DatabaseExampleSource, but I don't know what other operators should be included? or if you have an example of SQL server, could you please capture and paste it here..
  • TobiasMalbrecht
    TobiasMalbrecht New Altair Community Member
    Hi,

    well if you set up the [tt]DatabaseExampleSource[/tt] operator properly you already finished the initial part of every Data Mining process which is to load the data. What operators you need to put into your process after the input operator depends on what you intend to do, transform your data, learn a prediction model, etc. There are numerous operators since there are innumerable data mining tasks. To summarize, unless you do not tell us what you intend to do with your data we unfortunately are not able to tell you how to set up a process for your task in RapidMiner. Sorry, but you have to be really more specific!

    Cheers,
    Tobias
  • afandiphd
    afandiphd New Altair Community Member
    Hi,

    I want to classify the data. for example the first field is according to Group A,B,C.........K
    What operator should I use after employing DatabaseExample
  • steffen
    steffen New Altair Community Member
    Hello afandiphd

    I really really suggest to....
    - do the tutorial (RapidMinerGUI->Help->RapidMiner Tutorial)
    - download the tutorial.pdf from here. Beside further explanations all operators are described in this document

    Then: If you still have any more questions, feel free to come back and ask  :)

    greetings

    Steffen
  • TobiasMalbrecht
    TobiasMalbrecht New Altair Community Member
    Hi afandiphd,

    additionally, I would like to recommend to attend one of our introductary data mining & RapidMiner courses (http://rapid-i.com/content/view/7/95/lang,en/) ... ;)

    But seriously, if you want to learn a classification model, the first steps are to mark an attribute as a label by applying the [tt]ChangeAttributeRole[/tt] operator. After that, you may try a learner such as a [tt]DecisionTree[/tt], the [tt]LibSVM[/tt], [tt]NaiveBayes[/tt] .. which learner you actually can (and might want to) use depends once again on your analysis goals as well as on your data!

    Cheers,
    Tobias

Categories