Sybase: Adaptive SQL Server Anywhere
Sybase Inc.'s Adaptive Server Anywhere 7.0.0 with C2 Update (ASA) is a client-server relational database management system (DBMS). In the evaluated configuration, ASA executes on the Microsoft Windows NT 4.0 with Service Pack 6a and C2 Update operating system. ASA is Sybase's commercial DBMS for mobile computing. Both the ASA stand-alone engine and the ASA network server were evaluated. However, the ASA server cannot be accessed remotely in the evaluated configuration. The client and server were evaluated running on the same machine.
ASA requires an integrated login mechanism that maps the ASA user ID to the NT user ID. ASA's discretionary access control (DAC) mechanism controls access of users and groups to tables, views, procedures and functions. ASA provides an audit mechanism that is separate from the NT audit mechanism. ASA also has integrity features such as triggers, declarative and referential integrity, and transaction control. In addition, ASA includes a suite of tools for system administration.
The ASA relational database delivers rich database functionality, including full transaction processing, stored procedures, row-level locking, and Java support. ASA is designed to be self-tuning and yet maintain a small footprint. ASA symmetric multi-processor (SMP) support ensures top performance for greater numbers of users. A high-performance, self-tuning query optimizer determines the most effective way to access information and utilize additional processors, thereby improving performance and eliminating the need for expert tuning.