SAP DB je OpenSource
Karel Zak
zakkr na zf.jcu.cz
Pondělí Duben 30 10:07:55 CEST 2001
Mam pocit, ze si toho nikdo (v CR) moc nevsimnul -- SAP DB je OpenSource
(dalsi po Interbase:-). Tady je seznam zakladnich vlastnosti teto DB:
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 Table
statement)
- 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 session
These tables can be created within a stored procedure and 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 OLTP
It is available with the object extension of SAPDB only.
- Hot stand by
This 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 for R/3,
Tivoli
Programming Interfaces
- ODBC
- C/C++ Precompiler (Embedded SQL)
- JDBC
- Perl DBI
- Python
- PHP
--
Karel Zak <zakkr na zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
Další informace o konferenci Linux