-
Who wins ??
Oracle 9i Vs Sybase IQ.
Why do we to use Oracle ??
Why can't we use Sybase IQ ???
Hey Guys, I have created an Oracle Database and running the quesries against it and comparing it with Sybase IQ.
Issues are Performce, Maintenance, Manageability etc etc.
Please write your comments on the above topic. I will be posting the results here very soon.
Who will win ??
fossil
-
The simple reason why I am not favouring Sybase is concurrency and locking mechanism. Sybase handles all transactions locks through a lock manager which is not good.
-
Actually, Sybase is very good. One reason it's going down is because of marketing issues, I think.
-
Originally posted by dba1
Actually, Sybase is very good. One reason it's going down is because of marketing issues, I think.
if you think sybase is good then sql server must be superb
-
Oracle vs Sybase IQ
It seems to me people are confusing Sybase ASE with Sybase IQ. Sybase IQ is a datawarehouse-specific RDBMS, and as such, is lightning fast - way, way faster than Oracle or Sybase ASE - only Teradata can compete.
Sybase IQ does not use traditional locking, but a snapshot-approach (MVC) like Oracle. Tables are stored vertically, each column for itself, which means that I/O is only a fraction of Oracle's for most DW-type queries. IQ uses multiple types of indexes, set up in advance (usually you index every column with at least 1 index) . this means that there is no administration/reorgs of tables/indexes later on. In IQ I can run updates/deletes with full recoverability about as fast as loading/inserting to a table - and at the same time that other users have full access to the same tables. Try that in your standard relational DB!
IQ is meant to be used in a SAN-type of environment, with 2 or more servers accessing the same disks. Scalability when putting in a new server is in the high nineties.
There are good reasons SUN chose Sybase IQ as a partner in it's datawarehousing efforts in the VLDB space - Oracle and the like just couldn't compare when it comes to performance. I addition IQ compresses data, so instead of ending up with 3X your raw data, IQ typically will compress to less than your raw data. When you're talking Terabytes of storage in a SAN, this has a real cost impact.
-
Hi, IQ brings the result of query joining 9 tables in 2-3 minutes and Oracle sitting for hours. Also, there is no need to analyze any table.
Is there anything can be done to make queries in Oracle as fast as Sybase IQ ?
thanks,
fossil
-
Everyone knows SAP is very popular now. I went to a seminar on 'SAP overview' last week. During the seminar, a story was told: a few years ago, SAP tried to contact Sybase for collaboration on their product. Unfortunately, Sybase turned it down. Sysbase was No. 1 database provider at that time. The SAP guy was very angry and said: "OK, you don't collaboration with SAP, you would disappear in one year". That's why Sybase has no much market share in database world. Oracle is number 1 because of SAP.
-
Originally posted by dba1
Everyone knows SAP is very popular now. I went to a seminar on 'SAP overview' last week. During the seminar, a story was told: a few years ago, SAP tried to contact Sybase for collaboration on their product. Unfortunately, Sybase turned it down. Sysbase was No. 1 database provider at that time. The SAP guy was very angry and said: "OK, you don't collaboration with SAP, you would disappear in one year". That's why Sybase has no much market share in database world. Oracle is number 1 because of SAP.
Hahahah... And you belive such fairy tales? Geee....
Sysbase was No. 1 database provider at that time.
Er, what time was that?
Oracle is number 1 because of SAP.
FYI, Oracle was RDBMS leader loooong time before first SAP sistem was was ever run on Oracle database.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
IQ brings the result of query joining 9 tables in 2-3 minutes and Oracle sitting for hours.
Very scientific presentation of a performance issue. What are people supposed to say about this? Personally, I've never seen a 9 table join in a DW, but i guess there's all sorts of designers out there ...
IQ was presented to my project the other day -- every one of the comparisons with Oracle was against 8i, it was like 9i didn't exist. The sybase reps boasted about data compression and guess what? -- we were already using it in Oracle 9i, achieving compression ratios of up to 5:1 on data that wasn't even compression optimized.
Had the same crap from Teradata a year ago. An NCR guy said to me (in front of a senior audience) "so you have to export/import your entire database every few months to get rid of Oracle's fragmentation problems, don't you?" "I would do", I said, "if I was an idiot. Never have done that, never will do that. I'd fire any dba who had to do that oncea year, let alone evry few months".
That shut'em up.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|