SQL Anywhere: An Embeddable DBMS

We present an overview of the embeddability features of SQL Anywhere, a full-function relational database system designed for frontline business environments with minimal administration. SQL Anywhere supports features common to enterprise-class database management systems, such as intra-query parallelism, materialized views, OLAP functionality, stored procedures, triggers, and hot failover. SQL Anywhere can serve as a high-performance workgroup server, an embedded database that is installed along with an application, or as a mobile database installed on a handheld device that provides full database services, including two-way synchronization, to applications when the device is disconnected from the corporate intranet. We illustrate how SQL Anywhere’s embeddability features work in concert to provide a robust data management solution in zero-administration environments.

• Type: Journal
• Year: 2007
• Where: DEBU
• Authors: Ivan T. Bowman, Peter Bumbulis, Dan Farrar, Anil K. Goel, Brendan Lucier, Anisoara Nica, G. N. Paulley, John Smirnios, Matthew Young-Lai
• Keywords: Database, DEBU 2007, Full-function Relational Database, SQL Anywhere