Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17

SQL Anywhere - Introduction

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.

Describes data management, cloud infrastructure and data exchange technologies of the SQL Anywhere suite

SQL Anywhere offers:

  • Embeddability

    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.

  • Interoperability

    SQL Anywhere is available on many platforms, including Windows, Linux, Oracle Solaris, HP-UX, IBM AIX, and Mac OS X. Unique to SQL Anywhere, its database files can be copied between platforms. In addition, SQL Anywhere provides support for many smartphones using its UltraLite database technology for small devices. SQL Anywhere includes support for many common database interfaces, including ODBC, JDBC, ADO.NET, JavaScript, PHP, and Perl. Many popular application development tools can be used, including: Microsoft Visual Studio, SAP PowerBuilder, Eclipse, and various web tools. Stored procedures can be written in C/C++, Java, .NET, or Perl.

  • Performance out of the box

    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.

  • Mobility

    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.

  • Data encryption and security

    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.