Software:Advantage Database Server

From HandWiki
Revision as of 11:08, 9 February 2024 by NBrush (talk | contribs) (change)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

}}

Advantage Database Server
Developer(s)Sybase
Initial releaseAugust 1993 (1993-August)
TypeRDBMS
Websitesap.com/products/advantage-database-server.html

Advantage Database Server is a relational database management system (RDBMS) for small to medium-sized businesses by SAP SE (formerly Sybase iAnywhere, formerly Extended Systems).

Description

Advantage was introduced in 1993, for Clipper[clarification needed] developers.[1] Advantage Database Server is used by application developers as a client/server backend for shared, networked, standalone, mobile and Internet database applications. ADS provides both ISAM table-based and SQL based data access.[2]

Features include:

  • 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

  • Popular development environments including Embarcadero Delphi, CodeGear C++Builder, Microsoft Visual Basic, Microsoft Visual C++, CA-Visual Objects, CA-Clipper, Uniface, Microsoft Visual FoxPro, Alaska XBase++, Harbour compiler and xHarbour.
  • Supports standard interfaces such as ODBC, OLE DB, JDBC, PHP, and ADO.NET.

History

  • 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.
  • September 2003 - Advantage Database Server 7.0
  • July 2004 - Advantage Database Server 7.1
  • November 2005 – Advantage Database Server: The Official Guide published.[3]
  • November 2005 – Extended Systems acquired by Sybase, rolled in to iAnywhere Solutions subsidiary, version 8.0
  • October 2006 - Advantage Database Server 8.1
  • March 2008 - Advantage Database Server 9.0
  • 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
  • December 2012 - Advantage Database Server 11.1
  • October 2015 – Advantage Database Server 12.0 (acquired by SAP)

See also

References

  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