This book describes SQL Anywhere 17, a comprehensive package that provides data management and data exchange technologies, that enables the rapid development of database-powered applications for server, desktop, mobile, and remote office environments.
SQL Anywhere offers:
SQL Anywhere can be easily embedded inside other applications. It combines high performance with a very small memory footprint. SQL Anywhere contains a range of features to enable self-management and maintenance in frontline environments, including features that enable optimization of computer resources, self-tuning for improved performance, and simplification of remote installation and support.
SQL Anywhere is designed to deliver outstanding performance without ongoing tuning and administration. Features such as dynamic cache sizing, automatic generation of statistics, a sophisticated query optimizer, parallel query processing, and materialized views mean that SQL Anywhere is ideal for environments that demand high performance but have no on-site database administrator. By offering, On-Line Analytical Processing (OLAP) SQL Anywhere offers the ability to perform complex data analysis within a single SQL statement, increasing the value of the results, while improving performance by decreasing the number of database queries.
SQL Anywhere provides enterprise-caliber databases that operate on frontline systems and devices whether connectivity with enterprise systems is available or not. Its synchronization technologies ensure data can be exchanged efficiently over wireless and wired networks with backend databases, application servers, and messaging systems.
SQL Anywhere provides full end-to-end data security with 128-bit strong encryption of database tables, files, and communications streams between the application and the database, and the MobiLink synchronization stream. SQL Anywhere can audit data access, offers built-in user authentication, and can integrate with third-party authentication systems. SQL Anywhere also offers a FIPS-certified version of encryption via a separately licensed component.