"problem accessing database"

NersoNerso Member Posts: 3 Contributor I
edited May 2019 in Help
Hi All!!
I need to access to a relational mysql data base with rapid miner, the fact is that it's a huge data base and when I try to load it RM run out of memory, so my question is: how can I access it?there's a way to access it by parts or by tables?Or where can I found documentation related to issuess like this?
Whoever has an idea it would be welcome!
Thanks!
Tagged:

Answers

  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 2,531 Unicorn
    Hi,
    first of all, you can specify an arbitrary SQL statement for selecting the data. Use the query parameter in the database example source.

    If you have too much data for your memory, you could use the CachedDatabaseExampleSource, with will in fact only keep a subset in memory and fetches the data directly from the database on any cache miss. But keep in mind, that applying some operators will last a long time if you have so many data and working on a database.

    Greetings,
      Sebastian
Sign In or Register to comment.