Advantage Database Server
 |
This article has multiple issues. Please help improve it or discuss these issues on the talk page.
|
| Developer(s) | Sybase |
|---|---|
| Initial release | August, 1993 |
| 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].
Contents |
[edit] Uses
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.
[edit] Features
- Replication
- Online Backup
- ISAM 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
[edit] Programming Languages
- Popular development environments including CodeGear Delphi, CodeGear C++Builder, Microsoft Visual Basic, Microsoft Visual C++, CA-Visual Objects, CA-Clipper and Microsoft Visual FoxPro.
- Supports standard interfaces such as ODBC, OLE DB, JDBC, PHP, and ADO.NET.
[edit] 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.
- 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.
- December 2010 – The latest version was released, Advantage Database Server 10.
[edit] See also
[edit] References
- ^ 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
- ^ 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
- ^ 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
