answersLogoWhite

0


Best Answer

There are two answers to this.

Sybase, or Sybase Incorporated, is a company that makes software products for enterprise systems. The company has two subsidiaries, iAnywhere and Sybase 365, both of which focus on mobility solutions. So when you say "Sybase", you are actually talking about a company.

A lot of people use the term "Sybase" to describe Sybase Adaptive Server Enterprise, or Sybase ASE. This is similar to saying "Oracle", when you mean "Oracle 10g". ASE is the large scale enterprise database, and competes directly with Oracle 10g and IBM DB2. It is a row based storage RDBMS, suitable for On Line Transaction Processing (OLTP) as well as data storage and reporting.

Sybase has three other database products: Sybase IQ, SQL Anywhere, and Advantage. Each is designed for a specific market.

Sybase IQ is an RDBMS which uses a column-based storage system. This means it stores data based the column the data comes from, and not the row the data is associated with.

Column based storage has become a very popular design over the last few years, because it is very efficient at producing reports and can hold a lot of archival data in a much smaller footprint.

Sybase IQ has been around for over 10 years, and is about to hit release 15.0 (sometime in the first half of 2009). This is signifcantly longer than some of it's competitors, who have only just started building column oriented storage systems. For this reason it is very popular for most reporting applications, incuding data warehouses and datamarts.

Sybase IQ uses the same SQL syntax as Sybase ASE, and is fully ANSI SQL compliant. It stores data in tables, the same way as other relational databases. Any application or reporting engine that can run queries against Sybase ASE (or any relational database, for the most part) can use Syabse IQ. The only difference is "under the hood" in the disk storage mechanism.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Difference between Sybase and Sybase IQ?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the difference between sybase and oracle?

difference is only in their name. Sybase is developed by a farmer named sybase and oracle is developed by an actor oracle. sybase is tool which will help farmers and oracle is used to invent the actor inside us.


What is the difference between sybase and rdbms?

Sybase is a specific product and company that provides relational database management systems (RDBMS). RDBMS is a general term for a type of database management system that stores data in a structured format using tables. Sybase is one of the many vendors that offer RDBMS solutions.


What is the difference between Sybase ASE and Sybase IQ?

There are two answers to this. Sybase, or Sybase Incorporated, is a company that makes software products for enterprise systems. The company has two subsidiaries, iAnywhere and Sybase 365, both of which focus on mobility solutions. So when you say "Sybase", you are actually talking about a company. A lot of people use the term "Sybase" to describe Sybase Adaptive Server Enterprise, or Sybase ASE. This is similar to saying "Oracle", when you mean "Oracle 10g". ASE is the large scale enterprise database, and competes directly with Oracle 10g and IBM DB2. It is a row based storage RDBMS, suitable for On Line Transaction Processing (OLTP) as well as data storage and reporting. Sybase has three other database products: Sybase IQ, SQL Anywhere, and Advantage. Each is designed for a specific market. Sybase IQ is an RDBMS which uses a column-based storage system. This means it stores data based the column the data comes from, and not the row the data is associated with. Column based storage has become a very popular design over the last few years, because it is very efficient at producing reports and can hold a lot of archival data in a much smaller footprint. Sybase IQ has been around for over 10 years, and is about to hit release 15.0 (sometime in the first half of 2009). This is signifcantly longer than some of it's competitors, who have only just started building column oriented storage systems. For this reason it is very popular for most reporting applications, incuding data warehouses and datamarts. Sybase IQ uses the same SQL syntax as Sybase ASE, and is fully ANSI SQL compliant. It stores data in tables, the same way as other relational databases. Any application or reporting engine that can run queries against Sybase ASE (or any relational database, for the most part) can use Syabse IQ. The only difference is "under the hood" in the disk storage mechanism.


Will the difference between IQ levels of 150 and 155 be similar to difference between IQ levels of 95 and 100?

Difference between IQ levels of 150 and 155 will be similar to differences between IQ levels of 95 and 100


What is the difference between a blonde and a potato?

about 3 IQ points


Comparision between Intel and sybase?

Both of them are torally differant to each other Intel is a processor while sybase is a database


Where you can get the Sybase DBA training in delhi?

SAP is going to 2nd Database Vendor by 2015 !Sybase Training Sessions: Regular Program & Fast Track Program for exp Ora/DB2/MS SQL DBAs & Developers !Join Demo session without any fee...!!For All Available Sessions you can visit @ http://sybaseblog.com/sybase-dba-training/Publication : http://sybaseblog.com & http://sybasewiki.comPrerequisite of Training:i) For the Sybase Adaptive Server(ASE): Basic Understanding of Database & Unix.ii) For the Sybase Replication Server : System Administration of ASE.iii) For the Sybase IQ : System Administration of ASE. iv) Sybase Development : Basic Understanding of Database.iv) Sybase Performance & Tuning : Basic Understanding of Database.(Those who dont have the DBMS or unix understanding, they first will go through 2 days basic unix & dbms training.)Courses : Sybase Adaptive Server 12.5 & 15.x Administration(Some P&T Stuff), Sybase Replication 12.6 & 15.x, Sybase IQ 12.x & 15.x, Sybase ASE P&T .Syllabus : Sybase ASE/Rep/IQ Certification Syllabus.Training Duration : For each course, 2 Months(4*2=8 8 Weekend)=16 Days + 2 days(For basic dbms & unix concept).Trainer Profile : Having around 6+ year exp in Sybase Database and replication in largest financial institutions.Exclusive Benefits : Real Time Scenarios discussion & Support even after completion of the course, assistance in certification.Training Place : online mode worldwide.Please note that training will be on weekend only.If any of yours friend also interested for sybase training, kindly also let him know.Feel Free to contact @ sybanva@gmail.comHappy Sybase Learning & Fun!Thanks.sybanva@gmail.com


Where can you get Sybase Training?

Sybase Training is currently being offered by SybaseTeamat reasonable charges.You may email Training@SybaseTeam.Com for more details.SybaseTeam offers below mentioned coursesSybase ASE DBASybase SQL DeveloperSybase Performance TuningSybase Replication server DBASybase IQ DBASybase IQ DeveloperSybase Unwired Platform ( SUP ) AdministrationSybase Unwired Platform ( SUP ) Mobile Application DevelopmentUnix BasicsUnix advanced Shell ScriptingPerl ProgrammingSEd,AWK programmingThanks, SybaseTeam - Sybase Technical support,Consulting, Training and Placement


When was Sybase created?

Sybase was created in 1984.


What is the population of Sybase?

Sybase's population is 2,012.


What is Sybase's population?

The population of Sybase is 3,576.


What is the difference between IQ and aptitude tests?

whats the diffrence between intelligence and aptitude