Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sybase IQ

Sybase IQ

Sybase IQ

Anyone have any experience working with or evaluating Sybase IQ (note - this is not the Sybase ASE database which is similar to MS Sql Server)?  In particular, we are interested in performance gains associated with the column based RDBMS technology, and a few other items such as indexing, deleting records, and optimal design techniques.

The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

RE: Sybase IQ

I've used the earlier version "Adaptive Server Anywhere" v6, and it works great. Very low overhead on the host system, and the admin tools are easy to use.
However, we didn't compare it to other systems so can't really give a definitive view compared to its rivals.


RE: Sybase IQ

I have used Sybase IQ, and Multiplex for over 5 years.  What kind(s) of business problems are you planning to solve using IQ?  Data Magnitudes?  Iron (os/San...)?

RE: Sybase IQ

We are considering using Sybase IQ for Marketing Campaign analysis. We do a large amount of direct marketing (auto insurance, credit card) and want to analyze the results quickly. We often have 30 million solicitations in a campaign and over a dozen campaigns a year. Our standard database is Oracle and Sybase IQ tech folks have indicated that they will beat Oracle many fold in performance while occupying considerable less disk space. Your thoughts?

The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

RE: Sybase IQ

We are in a very similar situation to the initial post. We are having a consulting firm suggest Sybase IQ as a solution for our Marketing Campaign needs. We are also a direct marketers. Our volumes will be tens of millions. We are also primarily an Oracle shop. And are trying to determine if we wish to go to Sybase IQ as opposed to implementation with Oracle.
Have you made more progress on this effort? Did you go with IQ? If so, what has been your experience so far? I'd love to compare thoughts and notes.

RE: Sybase IQ

I had evaluated Sybase IQ 12.5 in my former job. The other competitors were Oracle 9i and DB2 UDB... I changed my job and I must evaluate again here, in my new job. We have a case study, but for my evaluation document I need a feature comparison list (Sybase ASIQ 12.5 vs. Oracle 9.2) in detail. Can anybody help me? thnx.

RE: Sybase IQ

gobel - are you sure you are talking about Sybase IQ and not Sybase ASE (Adaptive Server Enterprise)?

Sybase IQ is a column based database and is a different animal from most relational databases. Sybase ASE is a relational database and the offspring of the one that Microsoft pillaged during its one-sided partnership with Sybase which resulted in their SQL Server product.


ericeade - I have since been reassigned to another project. Our Oracle guru is now assigned the project and is convinced that Oracle with bitmap indexes can be as fast as Sybase IQ.  It's just as well that he is on the project as he would always be complaining if we picked Sybase IQ over Oracle without his involvement. I will keep everyone posted in this thread regarding our head-to-head evaluation of Oracle 10g with bitmaps versus Sybase IQ column database.

The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw

RE: Sybase IQ

We used sybase IQ multiplex at our company as a data warehouse. We loaded over 200 tables from many different applications; from Oracle, DB2, VSAM files ect...
We would load production data every night from these tables and use the data warehouse for reporting using business objects and other tools.
The speed and compressability of data was tremendous. Because of its capabilities, more and more users wanted to use the data warehouse to load their data. Now it supports most of the reporting needs of the company.

RE: Sybase IQ

Yes, I definitely talk about Sybase Adaptive Server IQ 12.5.
Bitmap indexes in Oracle are useful, but it has cardinality limitations as you know. By experience, I have convinced that Oracle can never run as quick as Sybase IQ, unless the result set is too wide (for example select all columns from a 300-400 columned table).
So, if anybody has a feature comparison list (Sybase ASIQ vs. Oracle 9i), please let me know.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close