Re: [HACKERS] SAP-DB
> Have you considered that the development tools may > > be abstracting out the directory names in their development > environment? I never considered this, but it makes sense. I didn't try the development tools and went right to the code. I did find a web site that described the two-letter directory names and their meanings so I thought that was all there was. Seems their development tools make the code more understandable. Has anyone tried it? > I humbly suggest you don't write them off quite so quickly. I never wrote them off. I just couldn't figure any of it out. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [HACKERS] SAP DB Featuers
[ 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] SAP DB Featuers
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 -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse.dk ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] SAP-DB
Hi guys, > > I've used the open source SAPDB and the performance is pretty damned > impressive. However, 'open source' in application to it is somewhat > deceptive, since you have to make it with SAP's proprietary build > tools/environment. > > In my opinion, however, it would be worth closely auditing SAP DB to see > what postgres can learn. I downloaded it. The directories are two characters in length, the files are numbers, and it is a mixture of C++, Python, and Pascal. Need I say more. :-) I swore I'd never post to the hackers list again, but this is an amazing statement by Bruce. Boy, the robustness of the software is determined by the number of characters in the directory name? By the languages used? Have you considered that the development tools may be abstracting out the directory names in their development environment? Someone else dissed this release because you need their development tools. Well, guess what big boys, the development tools are being released open source, too. And SAP has a history of giving you sources (not fiche or whatever) of their licensed technology so this is a fairly easy step for them. Not by the fact that SAP is a monster company, with a monster customer base, with a DB engine hardly used over here but actually quite popular in Germany? Quite popular in exactly the kind of enterprise environments that PG has yet to crack and, if you dismiss this offering with silly hand-waving, may never crack? Have you ever heard of Adabas? If you don't believe that SAP and SAP-DB are real, go talk to your fellow Great Bridge employee Jan Wieck. OK, I'll unsubscribe now ... I'm still a fan of PG, but not stupid enough to dismiss a robust, industrial-strength RDMBS system based on naive and uneducated criticism. PG has a lot to offer, and the upscale is still amazingly positive judging by the pace of development over the past two years. This is hardly a basis for hand-waving SAP DB into MySQL-land, however. I like PG, I will continue to personally use PG, and I will support SAP DB along with Oracle and PG with OpenACS 4.x. And I would expect most of my clients using that toolkit to use Oracle, with SAP DB coming in second, and PG third ... I'm not trying to demotivate or discourage the PG crowd. However, when you're in a competitive battle the best prescription for getting your bell run is to taunt and tease competitors who actually are in better shape than you. And ... SAP DB is, in many ways important to the enterprise organization. They may have an inferior page-locking concurrency scheme, I need to check on this, but in many enterprise-level commercial environments this isn't such a big deal. Since your (Bruce's) hopes for a wealthy future depends on GB IPO'ing which will only come with significant penetration of the enterprise commercial environment, I humbly suggest you don't write them off quite so quickly. SAP is, after all, a very successful company. - Don Baccus, Portland OR <[EMAIL PROTECTED]> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert Service and other goodies at http://donb.photo.net.
