Illustrates the applications of ASA

Question

Illustrates the applications of ASA?

Answer 1

ASA seems to have many of niches. This is generally good at OLTP and can be used like a basis for a common database project. Certainly examples are there of implementations supporting 100 or many more users.

A main area for ASA databases is with applications which need to distribute the database along with the application as a common storage area for internal components, other than the database is not a main part of the deliverable. Therefore, Sybase themselves have done it with the IQ Meta data storage. Previous to release 11 of IQ, the Meta data was stored within an ASE database. Here, with IQ 12, the Meta data has moved to being stored within ASA. It makes the installation of IQ in production environments very simpler.

ASA has good ODBC support that makes it very attractive to tools oriented in the direction of ODBC.