ASA provides all of the following features:
Full SQL RDBMS ASA is a transaction-processing RDBMS with full recovery capabilities, online backup, referential integrity actions, stored procedures, triggers, row-level concurrency control, schedules and events, a rich SQL language, and all the features you expect in a full SQL RDBMS.
Economical hardware requirements ASA requires fewer memory and disk resources than other database management systems.
Easy to use ASA is self-tuning and easy to manage. You can use ASA without the extensive database administration efforts usually associated with RDBMSs.
Standalone and network use ASA can be used 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 Although ASA is designed with simple administration and modest resource requirements in mind, it is a scalable, high-performance DBMS. ASA can run on multiple CPUs, has an advanced query optimizer, and provides performance monitoring and tuning tools.
Industry-standard interfaces ASA provides a native ODBC 3.5 driver for high performance from ODBC applications, and an OLE DB driver for use from ActiveX Data Object (ADO) programming environments. It comes with Sybase jConnect for JDBC as well as an iAnywhere JDBC driver, and supports embedded SQL and Sybase Open Client interfaces.
A cross-platform solution ASA can be run on many operating systems, including Windows, Windows PocketPC, Windows Mobile 2003, Novell NetWare, Sun Solaris, and Linux.
Copyright © 2004. Sybase Inc. All rights reserved. |
![]() |