SAP DB Featuers
От | Kaare Rasmussen |
---|---|
Тема | SAP DB Featuers |
Дата | |
Msg-id | 01042910271102.09277@bering обсуждение исходный текст |
Ответы |
Re: SAP DB Featuers
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: