SQL Anywhere
 |
This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. 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.
Contents |
[edit] Features
SQL Anywhere can be run on Windows, Windows CE, Mac OS X, and various UNIX platforms, including Linux, AIX, HP-UX 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.
[edit] 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[1], 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 function as a mobile database. It includes scalable data synchronization technology that provides change-based replication between separate databases, including large server-based RDBMS systems.
[edit] 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)[2]
- Version 11: 2008 (full text search, BlackBerry support)[3]
- Version 12: 2010 (support for spatial data)[4]
[edit] See also
[edit] References
- ^ "QuickBooks replaces its flat file system with SQL Anywhere from Sybase iAnywhere". Sybase. http://www.sybase.com/detail?id=1061721.
- ^ "Sybase iAnywhere Announces the Release of SQL Anywhere 10". Sybase press release. August 7, 2006. http://www.sybase.com/detail?id=1042264.
- ^ "Sybase iAnywhere Announces Availability of SQL Anywhere 11". Sybase press release. August 5, 2008. http://www.sybase.com/detail?id=1057559.
- ^ "Sybase Advances its Mobile and Embedded Database Leadership Position with SQL Anywhere 12". Sybase press release. June 29, 2010. http://www.sybase.com/detail?id=1080500.
[edit] External links
- SQL Anywhere official product page
- Sybase iAnywhere main page
- SQL Anywhere (and more) Data Access Components for Embarcadero Delphi
 |
This database-related article is a stub. You can help Wikipedia by expanding it. |
