Adaptive Server Anywhere and Ultralite

Compare adaptive Server Anywhere and UltraLite

This article focuses on the differences between adaptive Server Anywhere and UltraLite to help you determine which technology is more appropriate for your needs.

If you understand the resources you already have, it is easy to choose between adaptive Server Anywhere and Ultralite. However, if you plan to deploy to a platform supported by both technologies, such as Windows CE, you should consider the following issues.

Adaptive Server Anywhere

For years, adaptive Server Anywhere has provided relational database technology dedicated to workgroup, mobile, and embedded computing. The design of the product always considers the market factor. The advantages of selecting adaptive Server Anywhere include:

Adaptive Server Anywhere can run efficiently with limited memory, CPU power, and disk space. Specifically designed, its core functions, such as the query optimizer and the data caching mechanism, are not overly resource-occupied at run time. While

Adaptive Server Anywhere also contains the functionality required to use a workgroup server, including support for multiple users, scalability for multiple CPUs, and advanced concurrency features. If you are primarily deployed to a PC, adaptive Server Anywhere is more appropriate for you.

Adaptive Server Anywhere is a cross-platform solution. On Windows 95 and later, Windows NT and its later versions, and Windows CE, UNIX (including Linux), and Novell NetWare, you can

Run the same database. You can move a database file from one operating system to another.

Adaptive Server Anywhere does not need to be managed, so it is well-suited for embedded databases. Adaptive Server Anywhere provides a self tuning query optimizer, some built-in scheduling and event handling capabilities, and

Dynamic startup and automatic stop mechanism.

After years of joint efforts with successful customers, we have developed a set of rich features of on-site testing. This includes not only the standard checklist functionality (stored procedures, triggers, declarative referential integrity, full transaction processing, and recovery), but also all the new small features, and the success of the project may be in the presence of these new features.

With SQL Anywhere synchronization technology (SQL Remote and MobiLink), you can integrate the adaptive Server Anywhere database into your organization's infrastructure.

Adaptive Server Anywhere can offer more advantages if you prefer to use an interface other than Embedded SQL or Java, such as ODBC or OLE DB, and the resource constraints on the target platform are not as stringent as UltraLite requires.

ultralite:[Pocket] Database

UltraLite is a new technology that uses a reference database and your application source code to build a relational database engine that contains only those adaptiveserver Anywhere features that your application uses. The advantages of choosing UltraLite include:

The Ultralite database engine contains only the code needed to perform the specified task (as specified when the application is compiled), so you cannot use dynamic SQL to perform ad hoc queries against the UltraLite database.

Each UltraLite database and database engine is intended for use by a single application: If multiple applications want to use a database, you should choose adaptive serveranywhere.

UltraLite's programming model supports platform-independent database access code, so you can migrate user interfaces to new platforms and devices without modifying the underlying data access layer.

If you deploy to a small device, such as Palm Computing Platform, Ultralite is more appropriate for your needs.