Sponsored Content
Full Discussion: ADABAS anyone?
The Lounge What is on Your Mind? ADABAS anyone? Post 302537348 by NaturalDave on Thursday 7th of July 2011 11:52:54 PM
Old 07-08-2011
Adabas was around before SQL had established itself as a standard.
It is extremely fast & reliable & has been known to run literally for years at customer sites.

As quadphonic observed, it uses Inverted Lists, which are really just Indices.

In theory, the performance is comparable with, lets say other all-pervasive SQL Databases you may have encountered out there.
In practice, real-life Adabas DB's run much faster, as SQL has some shortcomings:
for example, you can't formally specify which Index you want to use (instead you have to rely on hints).

My experience of Larrys DB (that & Java is what I work with these days) is that queries often can deteriorate into a full table scan, because the optimizer doesn't always get it right & that can be very costly.

With Adabas you have WITH (Index criteria) & WHERE (non-Index) clauses, which empower the expert programmer.
(There is also a special-case for mixing non-Index criteria with WITH, but lets not get into that here!)

You also have 3 major access-paths:
FIND - sort of like SELECT in SQL
READ - similar to SELECT...ORDER BY, but allows Index or Physical order to be specified
HISTOGRAM - like read, but operates only on Indices. Very fast.

For those who need it, there is an SQL-Engine available for Adabas.

Natural, the programming language, is mostly used together with Adabas, but the same queries can be mapped via the Data-Dictionary (PREDICT) to many different underlying DB's (Adabas, Oracle, DB2, IMS/DB (DL1), VSAM, even System-resources like Main-Memory & Job-Queues. The list is long...)

Natural is in use by many Major International corporations & runs on various Hardware, from Mainframes (IBM, Siemens) to Windows.

The name stams from the term "Natural Language", as you might speak, for example:
MOVE A TO B, or MULTIPLY A BY B
Very similar to Cobol, but much, much more powerful.
It is much easier to understand than the OO/Java/C-like object.method(...) * DWORD -> ~^ ! stuff thats prevalent these days.

Natural was probably the first language to make window-technology readily available on the mainframe & is lightyears ahead of Cobol which is the all-pervasive mainframe language in real-world Fortune500 IT.

It would be unfair to compare Natural with PL/SQL.
While Natural is also used to write Adabas Triggers, it is also a full-function language in its own right, not just some old scripting language.

Software AG also offer various middleware to connect old & new, for example an ILOG JView Java Frontend connected via their EntireX middleware to the old host-based applications is used to allocate Cargo-loks by the german state railways (DB). Through their aquisition of WebMethods, they are also well positioned in the SOA marketplace.
 
SQL::ReservedWords::DB2(3pm)				User Contributed Perl Documentation			      SQL::ReservedWords::DB2(3pm)

NAME
SQL::ReservedWords::DB2 - Reserved SQL words by DB2 SYNOPSIS
if ( SQL::ReservedWords::DB2->is_reserved( $word ) ) { print "$word is a reserved DB2 word!"; } DESCRIPTION
Determine if words are reserved by DB2. METHODS
is_reserved( $word ) Returns a boolean indicating if $word is reserved by either DB2 5, 6, 7 or 8. is_reserved_by_db2v5( $word ) Returns a boolean indicating if $word is reserved by DB2 5. is_reserved_by_db2v6( $word ) Returns a boolean indicating if $word is reserved by DB2 6. is_reserved_by_db2v7( $word ) Returns a boolean indicating if $word is reserved by DB2 7. is_reserved_by_db2v8( $word ) Returns a boolean indicating if $word is reserved by DB2 8. reserved_by( $word ) Returns a list with DB2 versions that reserves $word. words Returns a list with all reserved words. EXPORTS
Nothing by default. Following subroutines can be exported: is_reserved is_reserved_by_db2v5 is_reserved_by_db2v6 is_reserved_by_db2v7 is_reserved_by_db2v8 reserved_by words SEE ALSO
SQL::ReservedWords <http://www-306.ibm.com/software/data/db2/udb/> AUTHOR
Christian Hansen "chansen@cpan.org" COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.8.8 2008-03-28 SQL::ReservedWords::DB2(3pm)
All times are GMT -4. The time now is 01:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy