Hi Kalman,
Yes, I recall a RedBrick salesman being very upset one day that the oracle rep lied about oracle performance...
A sales rep lied??? Oh my!!
SQL Server 2005 is now not so cheap.....true it is only USD6K/cpu for standard edition...but if you want enterprise edition it is now USD25K/cpu.
IQ list price last time I saw was USD50K/cpu but when was the last time a vendor sold list....and yes, you can start at one CPU because even that will do a lot....
IQ barely has a UI.......there is a very small DBA application that does just a few things and an ancient SQL Query interface.....
You are supposed to query it via something......
The reason there is no UI is there is nothing to do.....you can tell it all you need to in a few command files and parameter files...you tell it how much memory it is allowed and how much of the disk it is allowed, how many concurrent users it is allowed....and that's about it.....
There are no tablespaces...in fact, there are no tables, tables are only an abstraction on the physical storage which is in columns so that us mere people can ask it questions using sql 92 or some such....
Like I said...it's quite an amazing beast....but your are right...marketing is king...
And for all the talk IT people put forth about 'feeds and speeds' buyers of IT are mostly FAR more ignorant of the process than the sellers of IT solutions....
I know....I have been both sides of that desk.....
Some time ago I represented a large client in the buying transaction....and after they had settled on how much they thought they had to pay...I took over USD1M off the prices the vendors were prepared to accept.
The client later said I seemed to enjoy the whole experience....I replied "I had so many clients give me such a hard time over so many years...it was really nice to give some back!!"
Needless to say the sales reps on the transactions felt they were pushed very hard......and that was great!! But the guys who won eventually got plenty more business behind it which is why they were so willing to 'sharpen the pencil'...
Peter
-----Original Message-----
From: SQLUSA via dw-select [
Sent: 13 August 2006 00:33
To: pete...
Subject: Re: RE:[dw-select] Re: RE: Teradata Vs Oracle
> That Sybase are not selling it like hotcakes is a sad indictment of
our
> industry
Market is the king Pete.
Microsoft SQL2K (including DB and DW) is around $5K. A Windows server is
$20K.
What is a typical entry cost for Sybase IQ?
Question: what is the UI like to IQ ? URL?
Kalman Toth, Database, Data Warehouse & BI Architect
URL:
Practices
----- Original Message -----
From: " pete... via dw-select" <dw-select@Groups.ITtoolbox.com>
To: "SQLUSA" <technicalsqlusa@earthlink.net>
Sent: Saturday, August 12, 2006 2:04 PM
Subject: RE:[dw-select] Re: RE: Teradata Vs Oracle
>
> Hi All,
> I see discussions like this and I despair of our industry....
> In all this discussion nothing about delivering more sustainable
profit
> growth the the organisation....sigh...
> Anyway, feeds and speeds....Sybase IQ...
> I've used it....it is nothing short of amazing....
> industry and how so many people think the only answer to any database
> question is 'Oracle' having never experienced anything else.
> If only a small percentage of people buying EDW databases showed a
small
> modicum of common sense Sybase would have a hit on their hands....
> alas,
> they don't.
> I can personally assure and guarantee the following in comparing IQ
and
> Oracle having used both....
> 1. IQ will use 20% of the disk of oracle for the SAME input data for
the
> SAME target model.
> 2. IQ will run between 10 and 100 times faster than the SAME QUERY on
th
> e
> SAME database design as Oracle on the SAME hardware. IQ will NEVER run
> slower.....
> 3. Total system cost for hardware and software for similar performance
i
> s
> about 50% when using IQ vs Oracle. That is an 8CPU oracle system will
> easily be outperformed by a 4 CPU IQ system but probably not by a 2
CPU IQ
> system......
> 4. If you spend the SAME amount of money on hardware (CPUs because you
o
> nly
> need to buy 20% of the disk) and database license....IQ is priced
> in parity
> with Oracle on a CPU bases...at least at list price with means nothi
> ng any
> more....you can reasonably expect performance to be 10-100 times f
> aster for
> every query you run.
> Like I said...at half the price for similar performance and 10-100 t
> imes
> faster for the same money you might wonder how IT people keep buying
Oracl
> as an EDW database....
> I don't wonder...it's because people who buy oracle as an EDW databa
> se seem
> to have extremely limited experience of other database technologies...
> they
> have an 'Oracle hammer' and all the world is a nail.....sigh..
> .
> Having said that...of course all databases have their 'features' and
> IQ has
> it's share...but once you know what you are doing it is something of
> a joy
> to work with.....
> Best Regards