Re: MaxDB = SAPDB = ADABAS (was: Sorts (revised)

From: Robert Wagner (robert.deletethis_at_wagner.net)
Date: 07/22/04 

Date: Wed, 21 Jul 2004 22:10:10 GMT

riplin@Azonic.co.nz (Richard) wrote:

>robert.deletethis@wagner.net (Robert Wagner) wrote
>
>> Oracle says they did it for IBM compatibility; I believe them.
>
>Which is really strange because DB2 still uses BEGIN DECLARE and I see
>no evidence that this is optional at all.

Here is evidence on AS/400.

http://publib.boulder.ibm.com/html/as400/v4r5/ic2924/index.htm?info/db2/rbafzmst69.htm

I had one on zOS but lost it and cannot find it again. It didn't say 'optional';
it said 'documentary' or similar.

>In fact it your: "Oracle dropped that in version 8 to be compatible
>with IBM, which dropped it earlier." is completely the reverse.
>
>Oracle _ADDED_ BEGIN DECLARE to be compatible with ANSI and IBM, who
>had added it earlier, but Oracle left it optional depending on flags.

It was not recently added to either. It has been required on both for ages.

I recall working on zOS in 2000 and being told it had recently been made
optional. Perhaps mainframers reading CLC will provide facts.

>> A little research reveals that MaxDB/SAPDB is a rebadged ADABAS (sans
Natural),
>> developed by Software AG (the SAP folks)
>
>Software AG and SAP are completely different companies.

You're right.

>> [MaxDB] is unsuited to large tables because it insists on sucking the whole
>> table into memory, which makes it fast but unscalable.
>
>Which Adabas did that actually relate to ? More 'something I learnt
>in the 70's and never bothered checking since' is it ?

The one used in at least one current SAP product. Most SAP shops have it
installed to support that application.

>> Involved parties are Texas A&M, long out of the picture, and Computer
>> Associates, who appear to be a marketing agent milking it for cash, as is
>> their wont.
>
>You just make this stuff up. CA has Ingress and will soon be
>releasing Ingress II. It does have a connection with SAP's DB, but
>only with its database tools, such as ERWin, which work with a number
>of databases including Adabas-D (and Oracle, Ingres, MS SQL etc).

I heard it from a DBA the day before writing. When I asked why SAP doesn't
promote its own database, he responded "Because it sucks. They bought it from
Computer Associates and tried to make it work with R3, without success. Now
they've dumped it into the Open Source market."

You are correct; he was mistaken; I should have checked.

Relevant Pages

  • Re: SAP BW compared to Essbase/SQLServer/Oracle as a Enterprise Data
    ... and I too have not seen business content used effectively... ... SAP did considerable tuning but to no avail. ... > I will give you another interesting scenario we had cube in SAP BW ... > database for the schema for this table there were 6900 objects of this ...
    (microsoft.public.sqlserver.olap)
  • Re: SAP BW compared to Essbase/SQLServer/Oracle as a Enterprise Data
    ... and I too have not seen business content used effectively... ... SAP did considerable tuning but to no avail. ... > I will give you another interesting scenario we had cube in SAP BW ... > database for the schema for this table there were 6900 objects of this ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Datenbank SQL-Server vs. MySQL
    ... > OK to argue against mySQL is easy, you always can argue of missing ... SAP DB is ADABAS D. Software AG was failing and decided to exit the ... in the database business and started to look for ways to keep SAP DB going ... industrial strength you have to use the InnoDB storage engine. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: Does Oracle have anything like SAP Business Intelligence Accelerator?
    ... So when one looks at SAP ... technology one is asking about an SAP technology built with an ... Oracle database as its foundation.. ...
    (comp.databases.oracle.server)
  • Re: SAP BW compared to Essbase/SQLServer/Oracle as a Enterprise Data
    ... with Business Objects as the reporting tool for about 4000 users on ... enterprise data warehouse on a Oracle 817 database handles 80 million ... I will give you another interesting scenario we had cube in SAP BW ... database for the schema for this table there were 6900 objects of this ...
    (microsoft.public.sqlserver.olap)