Hi,
I am a new user who was attracted to MonetDB by the need to perform query operations in the area of data mining/ business intelligence and I have been doing some research and tried to download and play with MonetDB and so far I have been having a great experience!
The situation we are dealing here is that we have transactional data of various stores of the same retailer that go back several years in the history and we have several machines that we would like to install MonetDB and perform parallel query. (let 's assume that we have data for 8 stores and we have 8 machines for simplicity)
I have the following questions:
1. I understand that MonetDB automatically perform vertical partitioning on the same machine (correct me if I am wrong), would it be possible to perform vertical partitioning across several machines? Will it make the query faster by doing so?
Any pointers or guidance would be highly appreciated.
2. As of the current
release of MonetDB, I understand that it does not yet support horizontal partitioning, however, I am wondering that would it be possible to manually perform horizontal partitioning and put the horizontally partitioned database on different machines (i.e. each store on each machine in the example)? Then can we use tcpip module to communicate to each machine and assemble BAT together? How much effort-intensive is this approach? Any guidance is highly appreciated.
I guess, in all, we are wondering how can we get the most of MonetDB across multiple machines doing parallel query.
Thanks,
Natthapol