Re: Alterian

I don't know the other tools mentioned by Nigel. But you might most probably
also find similar techniques in this other tools.

J.

"Joerg Narr" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
> Hello John,
>
> you can definitely get this technology from Sybase (IQ) and SAND (Analytic
> Server). Both use quite similar techniques as descriped by Steve Tolkin in
> the "Taxir" thread. To keep the story simple both vendors use algorithms
> that highly compress the source data and only keep one occurance of every
> attribute stored. This means that you will find in a per se "normalized"
> attribute only one occurance of "John" and in another only one occurance
of
> the value field "12.5" (USD). This contributes a lot to a good ratio
between
> source data and data base size.  The databases make intensive use of
> pointers to this occurances. Both also use index techniques. SAND uses
> implicit indexes, Sybase IQ additionally allows administrators to define
> several indexes. Due to this form of data storage you have implicit
> partitioning and both vendors calculate fields which store data like the
> number of total rows or distinct occurances as metadata to each column.
Both
> tools are especially suitable for analytic analysis as being done for aCRM
> or aSCM and offer very good response times i. e. for dynamically involved
> filtes. Also both vendors provide a normal OLE DB or ODBC interface to
query
> the data base using SQL. Whilst SAND Analytic Server can be reduced to a
> "high performance" analytic platform, Sybase offers a much broader range
of
> products especially for database and data model design, Enterprise
> Application Integration (EAI not ETL) and supports decentralized data
> storage (Hub and Spoke architectures) quite well.
>
> Kind regards,
>
> Joerg
>
>