Relational database systems

SQL Anywhere offers two databases: SQL Anywhere Server and UltraLite.

SQL Anywhere Server

SQL Anywhere Server provides enterprise-caliber functionality including full transaction processing, referential integrity, materialized views, snapshot isolation, high availability via database mirroring and server clustering, SQL and Java stored procedures, triggers, row-level locking, automatic event scheduling, automatic backup and recovery, and much more. SQL Anywhere Server can easily scale to hundreds of concurrent users and hundreds of gigabytes of data. Yet its small footprint and its many features that automate administration make it an ideal database to embed into server and desktop applications that are widely deployed in customer and remote sites.

UltraLite

For environments that demand smaller data-driven applications, the UltraLite database is ideal. UltraLite is a full relational database management system designed specifically to minimize memory and system requirements for deployment to handhelds and other mobile devices, including the Blackberry. It provides full transaction-processing, a choice of development models, and a synchronization client built directly into the database for exchanging data with other databases.

UltraLiteJ is a Java implementation of a subset of UltraLite, which is designed for BlackBerry smartphones and for Java ME. See UltraLiteJ overview.

See Hallmarks of SQL Anywhere 11.