Adaptive Server Anywhere is built on the following technical features:
Full SQL relational database management system Adaptive Server Anywhere is a transactional relational database management system (relational Database-management System,rdbms), which has a variety of functions, Includes full recovery functionality, online backup, referential integrity actions, stored procedures, triggers, row-level concurrency control, schedules and events, rich SQL languages, and all the features that should be available in a full SQL RDBMS.
Cost-effective hardware requirements Adaptiveserver Anywhere requires less memory and disk resources than other database management systems.
Easy to use adaptive Server Anywhere can be self-regulating and manageable. You can easily use adaptive Server Anywhere without having to do a lot of database management work like other relational database management systems.
Adaptive server Anywhere can be used in an independent manner, such as an embedded database in a data-centric application, or as a network server in a multiuser client/server or a three-tier environment. As an embedded database system, it can be started automatically by the application as needed.
Although adaptive Server Anywhere is designed to emphasize simple management and modest resource requirements, it is still a scalable, high-performance DBMS. Adaptive Server Anywhere can run on multiple CPUs, has an advanced query optimizer, and provides performance monitoring and tuning tools.
Industry standard Interface Adaptive Server Anywhere provides native ODBC 3.5 drivers to enable an ODBC application to remain high-performance; it also provides OLE DB drivers for ActiveX Data Objects (ActiveX ECT, ADO)
Programming environment. It is provided with Sybase JConnect for JDBC and Jdbc-odbcbridge, and supports embedded SQL and Sybase Open Client interfaces.
Cross-platform Solutions Adaptive Server Anywhere can run on many operating systems, including Windows, Novell NetWare, Sun Solaris, and Linux.
Different platforms, the components provided on each platform will vary.