1 / 19

Advantage Database Server

Advantage Database Server. Dipl.-Ing.(FH) Joachim Dürr Sybase GmbH. Sybase Confidential Propriety. What is Advantage?. Advantage is a high-performance client/server relational database management system Advantage is an alternative solution to high-priced relational database systems

rusty
Download Presentation

Advantage Database Server

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advantage Database Server Dipl.-Ing.(FH) Joachim Dürr Sybase GmbH Sybase Confidential Propriety.

  2. What is Advantage? • Advantage is a high-performance client/server relational database management system • Advantage is an alternative solution to high-priced relational database systems • Advantage is specifically designed to be embedded with business applications • Advantage is designed to be low-cost and low-maintenance

  3. Consisting of... • Advantage Client Engine • Advantage Local Server • Advantage Communications Layer • Advantage Client Interfaces • Advantage Database Server

  4. Architecture Overview Advantage Database Server Advantage Client Engine Advantage Local Server Advantage Communication Redirector

  5. Value Proposition • High performance/cost ratio • Advantage is inexpensive to license and maintain • No administration requirements • Cross platform • Windows NT, 2000, XP, 2003, Vista • Linux • Novell NetWare • Advantage is mature • actively developed for 15 years • Advantage scales to hundreds of users

  6. core values • Flexibility • Cross platform • Supports multiple development environments • Scalability • Performance • Stability • Cost • Initial & perpetual • Reliability

  7. core values • Easily embeddable • ADS is specifically designed for easy distribution • Specifically designed for vertical application developers (OEMs) • Premier technical support & customer service

  8. Advantage is a SQL database • Advantage provides a standards based SQL engine • ANSI 92 • ANSI SQL PSM 2003 scripting

  9. Advantage is an ISAM Database • Advantage provides an alternative data access methodology • Allows for direct, table-access • navigate directly within the dataset • Mostly used by dBase, Xbase or FoxPro developers (legacy applications) • Advantage provides a bridge for these applications

  10. Advantage is standards based • JDBC- Level 4 • ADO.NET- 2.0 • OLE DB- ADO 2.1 • ODBC- Level 3

  11. Variety of Native Client Interfaces • TDataset Descendant • Delphi 3-7, C++Builder 3-6, Kylix 1-3 • Advantage Data Access Components • Delphi 8-2006, TurboDelphi Pro • PHP Driver • DBI Driver • Visual Objects RDD • Clipper RDD • Crystal Reports Driver

  12. development advantage • Easy integration • Stored Procedures and Triggers • SQL Scripting • Windows DLLs / Linux Shared Objects • COM DLLs / .NET Assemblies • User defined functions (UDF) • SQL Scripting • Configurable Full Text Search • Live Indexing • Scalability • Local  Client/Server  Internet without Code Changes • Free Local Server (DLL) for PC based database applications

  13. security advantage • Encrypted data files • Encrypted network communication • Granular access control • User/Group management • Database objects level • Tables on field level

  14. stability advantage • Server based transaction processing system (TPS) • Including SavePoint • No read locks • Read committed • Auto rollback on failure • Referential integrity • Update and delete rules • Supports Restrict, Cascade, Set Null and Set Default • Constraints • Field level constraints • Row level constraints

  15. availability advantage • High Availability (HA) Cluster • fail over clustering with shared data resource • Replication • asynchronous 1-to-many push replication • supports cascading • automatic briefcase without application changes • Hot Backup • creates a snapshot of a database in use • Full and incremental backup • respects RI and transactions

  16. deployment advantage • Easy installation • no need to install the client engine • silent installation for server available • low hardware requirements • Multi platform • Windows NT, 2000, XP, 2003, Vista • Linux • Novell Netware 4,5,6 • NAS and SAN support • Zero administration

  17. .NET advantage • ADO.NET Data Provider • Multiple AdsDataReader objects per connection possible • AdsHelper classes • RowVersion field type • Easier optimistic locking • AdsExtendedReader • Server side cursor • Connected, true navigational data access in .NET • Stored procedures and triggers as .NET assemblies • Visual Studio 2005 integration • AdsDataAdapter configuration wizard • Server explorer / data source explorer integration

  18. contact • Sybase GmbH • Schwarzwaldstraße 99 • 71083 Herrenberg • E-Mail: ads-team@ianywhere.com • Telefon: +49 (0) 7032 – 798 200 • Web: http://www.AdvantageDatabase.de

More Related