What are OLAP systems for clustering data in a database?

Question

MySQL

It is necessary to analyze in real time a large amount of constantly changing data in several tables connected by relationships.

I know about Microsoft SQL Server Data Mining algorithms.

Has anyone faced this kind of problem? What solution can you recommend?

Answer 1

palo olap, mondrian
But neither one nor the other will cope if there is really a lot of data

Answer 2

Here I found more: www.greenplum.com/
Has anyone come across?

Answer 3

MSSQL AS has clustering.
It's not entirely clear what you mean by "analyze a large amount of constantly changing data in real time". Clustering is an algorithm that you first train on some large sample and then apply it to the data. To retrain (that is, force it to redefine the clustering criterion - the rule by which an object belongs to any of the clusters), run the algorithm again. Having such a rule, the algorithm can tell which cluster an object belongs to (in terms of mssql, this is called prediction and is performed on MDX like this).

Answer 4

look towards CEP products e.g. www.datameer.com