Differences between Sybase ASE and ASA

1. The targets of ASE and ASA are different.

The Sybase Database Engine has three products:

The ASA lightweight database server is suitable for mobile computing (PDA, mobile phones with operating systems, etc.), Embedded Computing (POS machines, routers, etc.), and working group-level OLTP environments, especially for mobile computing and Embedded Computing

ASE enterprise and database server, suitable for enterprise-level OLTP (and hybrid load) Environments

Asiq enterprise-level data warehouse database server, suitable for enterprise-level data warehouse and data mart in DSS Environment

2. There are no inheritance relationships between two different products, ASE and ASA. There are differences in details between ase and ASA.

A. Asa does not yet have a database layer logical structure (one server manages only one database)

B. The T-SQL of ASA contains some special statements not available in ase, and vice versa

C. The expression of ASA and ASE on a few SQL semantics, using a different T-SQL syntax

D. Asa also supports WATCOM-SQL, especially triggers, which may be used

E. Many functions and options required by enterprises and applications in the ASE. There is no corresponding function in the ASA (because it is not an enterprise-level OLTP application)



Other features of ASA:

1. ASA is a real relational DBMS. Although small, it has all the basic elements of RDBMS (such as logs, forced consistency, divisor, and so on)

2. Asa supports a considerable portion of the T-SQL Syntax of ASE

3. The default connection interfaces of ASA are ODBC and JDBC, but they also support interfaces such as Sybase open client (including DB-Library) and ole db.

4. Asa supports mainstream ms, UNIX, Linux, and embedded operating systems (for PDAs and routers), including Sun iSCSI Solaris 8.0



Because the application target of the ASA product is not deployed on enterprise-level OLTP applications, the performance is much lower than that of the ASE when processing such applications.