Chapter 7 Using Adaptive Server Anywhere with EAServer

Adaptive Server Anywhere overview

Adaptive Server Anywhere provides a full-featured SQL database for EAServer applications. Adaptive Server Anywhere is designed to operate in environments with limited physical and database administration resources.

Adaptive Server Anywhere is a transaction-processing relational database management system (RDBMS) with full recovery capabilities, online backup, referential integrity actions, stored procedures, triggers, row-level concurrency control, and a rich SQL language. In addition, Adaptive Server Anywhere provides:

Economical hardware requirements Adaptive Server Anywhere requires fewer memory and disk resources than other database management systems.
Easy to use You can use Adaptive Server Anywhere without the extensive database administration efforts usually associated with an RDBMS.
Standalone and network use You can use Adaptive Server Anywhere in a standalone manner, for example as an embedded database in a data-centric application, or as a network server in a multiuser client/server or three-tier environment. As an embedded database system, it can be started automatically by an application when required.
High performance Adaptive Server Anywhere is a scalable, high-performance DBMS. Adaptive Server Anywhere can run on multiple processors, has an advanced query optimizer, and provides performance monitoring and tuning tools.
Industry standard interfaces Adaptive Server Anywhere provides a native ODBC 3.0 driver for high performance from ODBC applications. Adaptive Server Anywhere comes with Sybase jConnect (an all-Java JDBC driver), and supports Embedded SQL and Sybase Open Client interfaces.

For more information

For more information, see the Adaptive Server Anywhere documentation, which includes these books:

Adaptive Server Anywhere Reference Manual
Adaptive Server Anywhere User's Guide
Adaptive Server Anywhere Programming Interfaces Guide
Adaptive Server Anywhere Data Replication with SQL Remote

For basic information about databases, see the First Guide to SQL Anywhere Studio.