IWA vs Teradata

Hi all, I m trying to get a picture of the potential of IWA verses its competitors. One of the big players in the "big data" field is Teradata, but I can't seem to find any unbiased, independent information on the competitiveness of the product. Are there any benchmarks or articles that compare the two? Thanks in advance. Cheers, Harold

There are no published benchmarks. Note that IWA does not attempt to be the ultimate fastest DW system, it's primary purpose is to accelerate analytical queries against both DW schema and OLTP/Operational schema databases into the realm of performance traditionally only available on a DW appliance like Nettezza, Teradata, and Exadata. That said, since IWA is fully scalable and can be run on a cluster of very inexpensive machines each processing a subset of the data, it is possible to get performance that can compete with these standards of the DW world. In addition, IWA handles multiple concurrent queries and multiple data marts far better than some of the competitive systems. You are going to have to do your own benchmarking if you want to know which will give you the absolute best performance for your particular data and queries. However, if you want to know will IWA accelerate your queries over your data sufficiently to satisfy your project SLAs and save you a fortune over the traditional DW appliances, then you can set up a Proof of Concept with one of the consultancies that partner with IBM. If you contact me directly I can arrange just such a POC for you. Advanced DataTools Corp. is an IBM partner with experience with IWA and we can set up a POC for you to benchmark it in your own environment. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Nov 15, 2013 at 7:36 AM, Harold Luse <hluse@centurylink.net> wrote: > Hi all, > > I m trying to get a picture of the potential of IWA verses its competitors. > One of the big players in the "big data" field is Teradata, but I can't > seem > to find any unbiased, independent information on the competitiveness of the > product. Are there any benchmarks or articles that compare the two? Thanks > in advance. > > Cheers, > > Harold > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01182812c2936f04eb37d5e2

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

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.

Understood. The realities of life always seem to get in the way. ;-) Informix is still an amazing database and it gets more amazing every year. It is gaining traction in the market for certain niches including deep embedding and sensor data using the Timeseries feature (we don't talk about Datablades as such anymore). IBM won't publish benchmarks with Informix - period. They don't have reasons that we, as users, accept. IBM doesn't know what to do with the product - how to sell it without impacting DB2's sales. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Nov 20, 2013 at 12:50 AM, Harold Luse <hluse@centurylink.net> wrote: > 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. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c36f44791bb504eb9a4148