Advantage Database Server
| This article may not meet the general notability guideline. Please help to establish notability by adding reliable, secondary sources about the topic. If notability cannot be established, the article is likely to be merged, redirected, or deleted. (July 2009) |
| This article needs additional citations for verification. Please help improve this article by adding reliable references. Unsourced material may be challenged and removed. (July 2009) |
| This article relies largely or entirely upon a single source. Please help improve this article by introducing appropriate citations of additional sources. (July 2009) |
| This article needs references that appear in reliable third-party publications. Primary sources or sources affiliated with the subject are generally not sufficient for a Wikipedia article. Please add more appropriate citations from reliable sources. (July 2009) |
| Developer(s) | Sybase |
|---|---|
| Initial release | Template:Start-date |
| 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
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
- Replication (computer science)
- 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
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.
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 – The latest version was released, Advantage Database Server 9.1.
See also
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
External links
If you like SEOmastering Site, you can support it by - BTC: bc1qppjcl3c2cyjazy6lepmrv3fh6ke9mxs7zpfky0 , TRC20 and more...
- Pages with broken file links
- Articles with topics of unclear notability from July 2009
- Articles with invalid date parameter in template
- All articles with topics of unclear notability
- Articles needing additional references from July 2009
- All articles needing additional references
- Articles lacking reliable references from July 2009
- All articles lacking sources
- All articles lacking reliable references
- Database management systems
- SQL
- Cross-platform software
