Advantage Database Server

From Wikipedia, the free encyclopedia
  (Redirected from Advantage Database Server (ADS))
Jump to: navigation, search
Advantage Database Server
Developer(s) Sybase
Initial release August, 1993 (1993-08-05)
Written in C, C++
Operating system Cross-platform
Available in English
Type RDBMS
Website advantagedatabase.com

Advantage Database Server is a relational database management system (RDBMS) for small to medium sized businesses by Sybase iAnywhere. Database author Cary Jensen describes Advantage as follows: "Advantage has been around since 1993, when it was introduced to provide a stable solution for Clipper developers who were tired of slow performance and corrupt indexes inherent to file server-based databases. Over the years, ADS has grown in both popularity and features. Advantage is now a mature product with an impressive collection of features that rival many of the more expensive and complicated database servers".[1]

“In short, the Advantage Database Server is a high-performance, low-maintenance, remote database server that permits you to easily build and deploy client/server applications and web-based applications”.[2]

Uses[edit]

Advantage Database Server is most popular among application developers as a client/server backend solution for shared, networked, standalone, mobile and Internet database applications. ADS is unique among other database offerings because it provides both ISAM table-based and SQL based data access.

Features[edit]

  • Replication
  • Online Backup
  • ISAM access (Navigational Access)
  • SQL-92 compliant
  • SQL Query Optimizer
  • User Defined Functions
  • Triggers
  • Stored Procedures
  • Views
  • Server Side Aliases
  • Encrypted indexes and communications
  • DBF tables and memos greater than 4 gigabytes
  • Transactions
  • Events / Notifications
  • 64-bit support
  • Full Text Search
  • Multiple Processor support
  • Small footprint
  • Odata Web Service
  • Native DBF data format support
  • Unicode Support

Programming Languages[edit]

History[edit]

  • August 1993 – Initially released as Advantage xBase server by Extended Systems.
  • December 1995 – version 4.0 release, now called Advantage Database Server. This release included the first ODBC driver.
  • February 1997 – Advantage Internet Server released.
  • April 2000 – Advantage ODBC driver with StreamlineSQL released.
  • November 2005 – Advantage Database Server: The Official Guide published.[3]
  • November 2005 – Extended Systems acquired by Sybase, rolled in to iAnywhere Solutions subsidiary.
  • November 2008 – Advantage Database Server 9.1.
  • June 2010 – Advantage Database Server 10.0
  • December 2010 - Advantage Database Server 10.1
  • July 2012 – Advantage Database Server 11.0

See also[edit]

References[edit]

  1. ^ Cary Jensen, Ph.D.Loy Anderson, Ph.D, Advantage Database Server: A Developer's Guide, February 5, 2007, 616 pages, AuthorHouse, 978-1425-7726-9
  2. ^ Cary Jensen, Ph.D.Loy Anderson, Ph.D, Advantage Database Server: A Developer's Guide, February 5, 2007, page 7, AuthorHouse, 978-1425-7726-9
  3. ^ Cary Jensen, Ph.D.Loy Anderson, Ph.D, Advantage Database Server: The Official Guide, October 29, 2003, 496 pages, McGraw-Hill Osborne Media, 0-07-223084-1

External links[edit]