IDS Forum

RE: IWA vs Teradata

Posted By: Harold Luse
Date: Wednesday, 20 November 2013, at 12:50 a.m.

In Response To: Re: IWA vs Teradata (Carlton Doe)

Thanks, Art and Carlton.

Art, thanks for the offer to benchmark performance, but I may have given the
wrong impression. I worked with Informix in the late 1990's and then for
IBM Informix in the early 2000's, but due to declining market share I left
to pursue other interests. Now that IBM is putting some marketing muscle
behind Informix, I am considering reentering the Informix arena, but having
been burned once before with declining Informix demand, I am just checking
it out before I decide to jump in. It is one heck of a database, and I
loved working with it, but I need to assess the realities before I leap.

Cheers,
Harold

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Carlton Doe
Sent: Friday, November 15, 2013 8:22 AM
To: ids@iiug.org
Subject: Re: IWA vs Teradata [31956]

For what it's worth, in the presentations I use with customers / =
Roadshows on IWA, I include a number of *customer generated* benchmarks =
/ comparisons, one of which was done by a large retailer against =
Teradata.

=46rom them: Teradata query: 26 seconds With IWA: 1.8 =
seconds

Teradata #2: 36 seconds =
IWA: 4.05 seconds

Teradata #3: 1 minute 15 seconds IWA: =
17.3 seconds

Teradata #4: 6 minutes + =
IWA: 1.3 seconds

Yes, the customer did buy IWA! :)

Carlton

-------------------------------------------------
Carlton Doe
Flower Mound, TX

No trees were killed in the transmission of this email, however a large =
number of electrons were temporarily inconvenienced.=20

On Nov 15, 2013, at 8:15 AM, "Art Kagel" <art.kagel@gmail.com> wrote:

> There are no published benchmarks. Note that IWA does not attempt to =
be=20
> the ultimate fastest DW system, it's primary purpose is to accelerate=20=

> analytical queries against both DW schema and OLTP/Operational schema=20=

> databases into the realm of performance traditionally only available =
on a=20
> DW appliance like Nettezza, Teradata, and Exadata.=20
>=20
> That said, since IWA is fully scalable and can be run on a cluster of =
very=20
> inexpensive machines each processing a subset of the data, it is =
possible=20
> to get performance that can compete with these standards of the DW =
world.=20
> In addition, IWA handles multiple concurrent queries and multiple data=20=

> marts far better than some of the competitive systems.=20
>=20
> You are going to have to do your own benchmarking if you want to know =
which=20
> will give you the absolute best performance for your particular data =
and=20
> queries. However, if you want to know will IWA accelerate your queries=20=

> over your data sufficiently to satisfy your project SLAs and save you =
a=20
> fortune over the traditional DW appliances, then you can set up a =
Proof of=20
> Concept with one of the consultancies that partner with IBM. If you=20
> contact me directly I can arrange just such a POC for you. Advanced=20
> DataTools Corp. is an IBM partner with experience with IWA and we can =
set=20
> up a POC for you to benchmark it in your own environment.=20
>=20
> Art=20
>=20
> Art S. Kagel, Principal Consultant=20
>=20
> Advanced DataTools (www.advancedatatools.com)=20
> Blog: http://informix-myview.blogspot.com/=20
>=20
> Disclaimer: Please keep in mind that my own opinions are my own =
opinions=20
> and do not reflect on my employer, Advanced DataTools, the IIUG, nor =
any=20
> other organization with which I am associated either explicitly,=20
> implicitly, or by inference. Neither do those opinions reflect those =
of=20
> other individuals affiliated with any entity with which I am =
affiliated nor=20
> those of the entities themselves.=20
>=20
> On Fri, Nov 15, 2013 at 7:36 AM, Harold Luse <hluse@centurylink.net> =
wrote:=20
>=20
>> Hi all,=20
>>=20
>> I m trying to get a picture of the potential of IWA verses its =
competitors.=20
>> One of the big players in the "big data" field is Teradata, but I =
can't=20
>> seem=20
>> to find any unbiased, independent information on the competitiveness =
of the=20
>> product. Are there any benchmarks or articles that compare the two? =
Thanks=20
>> in advance.=20
>>=20
>> Cheers,=20
>>=20
>> Harold=20
>>=20
>>=20
>>=20
>>=20
> =
**************************************************************************=
*****=20
>> Forum Note: Use "Reply" to post a response in the discussion forum.=20=

>>=20
>>=20
>=20
> --089e01182812c2936f04eb37d5e2=20
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=

>=20

****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• IWA vs Teradata
  Harold Luse -- Friday, 15 November 2013, at 7:36 a.m.
  • Re: IWA vs Teradata
    Art Kagel -- Friday, 15 November 2013, at 9:15 a.m.
    • Re: IWA vs Teradata
      Carlton Doe -- Friday, 15 November 2013, at 10:21 a.m.
      • RE: IWA vs Teradata
        Harold Luse -- Wednesday, 20 November 2013, at 12:50 a.m.
        • Re: IWA vs Teradata
          Art Kagel -- Wednesday, 20 November 2013, at 6:41 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.