Thread: SAP DB Featuers

SAP DB Featuers

From
Kaare Rasmussen
Date:
I found it myself:

SQL Features
- SQL 92 entry level with several extensions
- Oracle 7 compatibility mode

Key benefits

- Referential integrity (to be defined in CREATE TABLE or ALTER Tablestatement)
- Stored procedures
- After statement trigger (INSERT/UPDATE/DELETE) 
- Updateable views, although not every view is updateable
- Datatype BOOLEAN
- A number of functions including functions for date values
- Maximum length of object names is 32 characters
- Subtransactions
- Sequences (number generator)
- Roles (compositions of user authorizations that can be granted/revoked as a 
whole)
- Subselects that can be specified in the FROM clause of a query
- Outer joins
- Scrollable cursor
-Temporary tables that will be destroyed if the application ends the sessionThese tables can be created within a stored
procedureand selected from 
 
outside this procedure. They are updateable, although there is no implicit 
update of the rows that created the temporary table.
-Explicit and implicit locking on row level

NOT supported features:
- Collations
- Result sets that are created within a stored procedure and fetched outside. 
This feature is planned to be offered in one of the coming releases.Meanwhile, use temporary tables.
- Multi version concurrency for OLTPIt is available with the object extension of SAPDB only.
- Hot stand byThis feature is planned to be offered in one of the coming releases. 

Enterprise Features
- The Microsoft cluster server is supported. For other systems scripts have 
to be written according to the failover solution of the system.
- Online backup
- Online expansion of the database
- No explicit reorganization

- Supported backup tools:
-- ADSM + adint2  Networker  Netvault, HiBack  (soon) Backint for Oracle  Tools supporting this interface are:
ARCserve,Backup Express, dbBRZ for    R/3, DBVAULT, DoroStore, EASY_BASE, EMC, EPOCH, FDR/UPSTREAM, HIBACK,   HSMS-CL
Backint,NetBackup, NetVault, NetWorker, Omniback, Seagate Backup,   SESAM, Solstice Backup, Sys-Save, TIME NAVIGATOR
forR/3,   Tivoli
 

Programming Interfaces
- ODBC
- C/C++ Precompiler (Embedded SQL)
- JDBC
- Perl DBI
- Python
- PHP

-- 
Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2501
Howitzvej 75               Åben 14.00-18.00        Email: kar@webline.dk
2000 Frederiksberg        Lørdag 11.00-17.00       Web:      www.suse.dk


Re: SAP DB Featuers

From
Bruce Momjian
Date:
[ Charset ISO-8859-1 unsupported, converting... ]
> I found it myself:

Yes, this was on the Features web page.

> SQL Features
> - SQL 92 entry level with several extensions

> - Oracle 7 compatibility mode

Yes, that was a major feature to me.  I just couldn't find it in the
code.

> - Updateable views, although not every view is updateable

Also nice.

> Enterprise Features
> - The Microsoft cluster server is supported. For other systems scripts have 
> to be written according to the failover solution of the system.

This seemed interesting.  And I saw replication mentioned too.


> - Supported backup tools:
> -- ADSM + adint2
>    Networker
>    Netvault, HiBack
>    (soon) Backint for Oracle
>    Tools supporting this interface are: ARCserve, Backup Express, dbBRZ for  
>    R/3, DBVAULT, DoroStore, EASY_BASE, EMC, EPOCH, FDR/UPSTREAM, HIBACK, 
>    HSMS-CL Backint, NetBackup, NetVault, NetWorker, Omniback, Seagate Backup, 
>    SESAM, Solstice Backup, Sys-Save, TIME NAVIGATOR for R/3, 
>    Tivoli

That's a lot of backup tools.  Can we grab that code somehow?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026