What are OLAP systems for clustering data in a database?

K

karenishe2012-07-09 16:01:13

MySQL

karenishe, 2012-07-09 16:01:13

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?

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

K

kuzemchik, 2012-07-09
@kuzemchik

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

K

karenishe, 2012-07-09
@karenishe

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

A

Antelle, 2012-07-09
@Antelle

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).

A

Arexander, 2015-02-13
@fivec

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