answersLogoWhite

0

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

13y ago

What else can I help you with?

Related Questions

Difference between Sybase 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.


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


Where can you get Sybase Performance and Tuning Training?

Sybase ASE Performance and Tuning Training is currently being offered by SybaseTeam at reasonable charges.You many email Training@SybaseTeam.Com orcall - US: 201-298-3267 India:+91 964 000 4747for more details.SybaseTeam also offersSybase ASE DBA TrainingSybase developer trainingSybase Performance and Tuning TrainingSybase Replication server TrainingSybase IQ TrainingUnix basic and advanced Shell scripting TrainingPerl Programming TrainingThanks,Training DepartmentSybaseTeam - Sybase Technical support,Consulting, Training and Placement


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


Where can you get Sybase Training in US?

Sybase Training is currently being offered by SybaseTeam at reasonable charges.You many email Training@SybaseTeam.Com orcall - US: +1 201-298-3267 India:+91 964 000 4747for more details.SybaseTeam offersSybase ASE Performance and TuningSybase developer trainingSybase Performance and Tuning TrainingSybase Replication server TrainingSybase IQ TrainingUnix basic and advanced Shell scripting TrainingPerl Programming TrainingThanks,Training DepartmentSybaseTeam - Sybase Technical support,Consulting, Training and Placement


What is the difference between a blonde and a potato?

about 3 IQ points


Where can you get Sybase Unwired Plaform SUP Training?

The Sybase Unwired Platform (SUP) Training is currently being offered by SybaseTeam at reasonable charges.Sybase Unwired Platform (SUP) Mobile Application Development CourseSybase Unwired Platform (SUP) Administration CourseYou may email Training@SybaseTeam.Com for more details.SybaseTeam also offersSybase ASE DBA TrainingSybase Replication DBASybase T-SQL Developer trainingSybase Performance and Tuning TrainingSybase IQ DBA TrainingUnix basic and advanced Shell scripting TrainingPerl Programming TrainingThanks,SybaseTeam - Sybase Technical support,Consulting, Training, Placement


Where can you get Sybase Replication Server Training?

The Sybase Replication server Training is currently being offered by SybaseTeam at reasonable charges.You many email Training@SybaseTeam.Com orcall up - US: 201-298-3267 India:+91 964 000 4747for more details.SybaseTeam also offersSybase ASE DBA TrainingSybase developer trainingSybase Performance and Tuning TrainingSybase IQ TrainingUnix basic and advanced Shell scripting TrainingPerl Programming TrainingThanks,JoshiSybaseTeam - Sybase Technical support,Consulting, Training, Placement


What is the difference between aptitude and IQ?

Aptitude is the innate ability to do a given task. IQ may indicate the likliness (or unlikliness) of the ability to understand how to learn how to do that task.


Difference between Wechsler Scales and the SBIS?

A great difference is that Wechsler scale doens't calculate your IQ the same way as STanford-binet intelligence scale. 132 iQ (wechsler) => something like 140...in the SBIS scale. You will find a really complete answer by going on best-iq-test (dot) on the title: IQ: IQ Test scales - The Stanford-Binet scale.


What is the difference between filipino chemist to forent chemist?

the difference is .. sometimes it was base in the curriculum of the other foreign chemist .. but then . still the Filipino have a Higg IQ ., and where ever in the World ., i think Filipinos are much more Knowledge .. and IQ ..