SQL Anywhere

This article needs additional citations for verification. Please help improve this article by adding reliable references. Unsourced material may be challenged and removed. (October 2009)

SQL Anywhere is a relational database management system (RDBMS) product from the company Sybase iAnywhere, a subsidiary of Sybase.

Features

SQL Anywhere can be run on Windows, Windows CE, Mac OS X, and various UNIX platforms, including Linux, AIX and Solaris. Database files are independent of the operating system, allowing them to be copied between supported platforms. The product provides several standard interfaces (ODBC, JDBC, and ADO.NET) and a number of special interfaces such as PHP and Perl. The engine supports stored procedures, user functions (using Watcom SQL, T-SQL, Java, or C/C++), triggers, referential integrity, row-level locking, replication, proxy tables, and events (scheduled and system events). Strong encryption is supported for both database files and client-server communication.

Uses

SQL Anywhere is used in several contexts, including as an embedded database, particularly as an application data store. For example, it is used in Intuit QuickBooks, in network management products, and in backup products. Its ability to be used with minimal administration is a distinguishing feature in this role. It can be used as a database server for work groups or for small or medium-sized businesses. It can also funcion as a mobile database. It includes scalable data synchronization technology that provides change-based replication between separate databases, including large server-based RDBMS systems.

As of 2006, there were over 10 million copies of SQL Anywhere in use.^[1]

History

• Initially created by Watcom as Watcom SQL.
• Version 3: 1992
• Watcom acquired by PowerSoft in 1993; Watcom SQL shipped with their visual programming environment PowerBuilder
• Version 4: 1994 (Stored procedures, triggers)
• PowerSoft and Sybase merged in 1995: Watcom SQL was renamed SQL Anywhere.
• Version 5: 1995 (SQL Remote data replication; graphical administration tools)
• Version 6: 1998. Renamed Adaptive Server Anywhere. (multi-processor support, Java objects in the database)
• Version 6.0.2: 1999 (MobiLink data synchronization, UltraLite mobile database for Palm OS and Windows CE)
• Version 7: 2000 (dynamic cache, task scheduling and event handling, cross-platform administration tools)
• Version 8: 2001 (Volcano query optimizer, encrypted data storage and transmission,
• Version 9: 2003 (Index consultant, embedded HTTP server)
• Version 10: 2006 - renamed SQL Anywhere (high availability, intra-query parallelism, materialized views)
• Version 11: 2008 (full text search, BlackBerry support)

See also

• IvanAnywhere

References

External links

• SQL Anywhere official product page
• Sybase iAnywhere main page

This database-related article is a stub. You can help Wikipedia by expanding it. v • d • e