Relational Databases
As mentioned earlier, SQL Anywhere Studio 8.0 includes two powerful DBMS products, each targeted at different classes of users and applications:
The flagship product, Adaptive Server Anywhere (ASA) 8.0, is a powerful client/server RDBMS capable of running on anything from multiprocessor Solaris boxes all the way down to Windows CEbased Pocket PC devices. It offers support for stored procedures, triggers, database security, and Java in the database, and its maximum size is contained only by the physical storage limits of the host computer. Thanks to the included ODBC and JDBC drivers, ASA databases can be accessed from virtually any modern development language.
The Ultralite deployment option is a file-based database that supports a large subset of SQL, offers an extremely small memory-footprint, a minimum 50KB file size, and support for C, C++, and Java development. The Ultralite deployment option is intended for resource-constrained devices (such as Windows CE or the PalmOS) as well as for those applications seeking to keep client-side installation and management issues to a minimum.