"problem accessing database"
Nerso
New Altair Community Member
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!
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!
0
Answers
-
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,
Sebastian0
