Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is ADABAS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
jobseeker

New User


Joined: 07 Mar 2005
Posts: 26

PostPosted: Mon Feb 15, 2016 11:59 pm    Post subject: What is ADABAS
Reply with quote

Can someone please guide me what is Adabas is and what its used for? heard its a database and used with Natural 4G Language, but need more details like advantages and real time usages.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Tue Feb 16, 2016 12:05 am    Post subject: Reply to: What is ADABAS
Reply with quote

what about doing a bit of research Yourself ?
googling for adabas returned about 440000 hits
one of the first ones was
http://www.softwareag.com/corporate/products/adabas_natural/adabas/overview/default.asp

where You will find all You might want to know about it
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Tue Feb 16, 2016 1:04 am    Post subject: Reply to: What is ADABAS
Reply with quote

Adabas is a data base -- and hence it can be used for whatever you want to use a data base for (manufacturing, inventory, sales, financials, etc). It has a COBOL interface, but much programming for Adabas is done in Natural, which is a language Software AG developed specifically for Adabas. Unlike many competitors, Adabas is NOT a relational data base and hence SQL is not generally used to access records in Adabas (although with the purchase of third-party products, SQL can be used with Adabas). Advantages / disadvantages and real time usage are fairly specific -- are you looking to write a paper on Adabas, or is this a homework assignment?
Back to top
View user's profile Send private message
jobseeker

New User


Joined: 07 Mar 2005
Posts: 26

PostPosted: Tue Feb 16, 2016 1:13 am    Post subject:
Reply with quote

No sir, I have to provide a speech about Adabas tomorrow. I heard Adabas was the fastest database ever produced. Is that applicable till now? I also learned from google that Adabas was originally developed for DOS/360, my question is, does it still work in z/OS? Also anyone have idea about the 3rd party tools needed to run SQL queries in ADABAS?

I heard adabas can handle large amounts of data more better than DB2. if anybody worked with Adabas here, tell me more about Advantages / disadvantages and real time usage, please.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Tue Feb 16, 2016 2:00 am    Post subject:
Reply with quote

Yes, Adabas runs just fine with z/OS -- at least through 2.1; I haven't had a chance to install z/OS 2.2 but presumably Adabas will run with it, too. The software has been updated over the years so what ran on DOS/360 in 1971 is not the same Adabas that is running today. But then, that is true for pretty much all software. The site I work with uses Adabas today with z/OS 2.1 in batch and CICS.

You are asking very broad, difficult-to-answer questions. What do you mean by "fastest" -- I/O time? CPU time? single record retrieval? million-record retrieval? The internal structure of Adabas is quite different than DB2 or other relational data bases; that can be good or bad. And, again, in your question what is "better"? Running an Adabas retrieval that does not use an indexed field may run MUCH worse than a DB2 query using an indexed column. The nature of an inverted list (Adabas) means that relatively more resources are required to add records to the data base than for a relational data base. So if your comparison includes adding records (instead of just retrieving them), you may well find that Adabas does worse than DB2 or Oracle.

There is a tremendous amount of research done on data base benchmarks every year and the main thing that everyone agrees on is that nobody agrees which is "fastest" or handles the most data or is "best".

And terminology is critical in IT, where similar terms may mean very different things. The phrase "real time" is most commonly associated with embedded systems, which would not usually be involved with Adabas or DB2 or Oracle or any other data base.
Back to top
View user's profile Send private message
jobseeker

New User


Joined: 07 Mar 2005
Posts: 26

PostPosted: Tue Feb 16, 2016 1:03 pm    Post subject:
Reply with quote

Thanks a lot sir, you made my day. By fastest I mean the fetching time of the queries. I haven't used Adabas, hence I just quoted what I found in internet.

Quote:
Adabas has maintained its position as one of the world's fastest OLTP databases, offering 24x7 functioning, Parallel Sysplex support, real-time replication capability, SQL and XML access and other leading edge capabilities.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Tue Feb 16, 2016 9:36 pm    Post subject:
Reply with quote

Please refer TECHcommunity on Software AG website.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Natural ADABAS Opening with CTS enikhilk Mainframe Jobs 0 Wed Nov 30, 2016 5:37 pm
No new posts Casting a Binary Number to Numeric in... Bob Steinkraus Java & MQSeries 6 Tue Aug 09, 2016 5:58 pm
No new posts How Adabas works in Mainframe ranujn Java & MQSeries 5 Sat Jun 04, 2016 11:20 am
No new posts Natural/Adabas - Migration/Replatform Virendra Shambharkar Java & MQSeries 5 Tue Apr 05, 2016 2:37 pm
No new posts ADABAS to DB2 Data migration Testing Ashish.Srivastava.123 DB2 0 Fri Mar 06, 2015 2:13 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us