Transcript What is Advantage?

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
 Advantage is specifically designed to be embedded with
business applications
 Advantage is designed to be low-cost and low-maintenance
2
Consisting of...
 Advantage Client Engine
 Advantage Local Server
 Advantage Communications Layer
 Advantage Client Interfaces
 Advantage Database Server
3
Architecture Overview
Advantage Database Server
Advantage Client Engine
Advantage
Local
Server
Advantage
Communication
Redirector
4
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
5
core values
 Flexibility
 Cross platform
 Supports multiple development environments
 Scalability
 Performance
 Stability
 Cost
 Initial & perpetual
 Reliability
6
core values
 Easily embeddable
 ADS is specifically designed for easy distribution
 Specifically designed for vertical application developers
(OEMs)
 Premier technical support & customer service
7
Advantage is a SQL database
 Advantage provides a standards based SQL engine
 ANSI 92
 ANSI SQL PSM 2003 scripting
8
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
9
Advantage is standards based
 JDBC- Level 4
 ADO.NET- 2.0
 OLE DB- ADO 2.1
 ODBC- Level 3
10
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
11
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
12
security advantage
 Encrypted data files
 Encrypted network communication
 Granular access control
 User/Group management
 Database objects level
 Tables on field level
13
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
14
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
15
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
16
.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
17
contact
Sybase GmbH
Schwarzwaldstraße 99
71083 Herrenberg
E-Mail: [email protected]
Telefon: +49 (0) 7032 – 798 200
Web: http://www.AdvantageDatabase.de
18