IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Why it is called DB2 ?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Thu Nov 06, 2008 5:36 pm
Reply with quote

Hi ALL,

I have been having been wondering about this for a long time.
I google'd but, i couldn't find the answer. what i want to know is......

Why it is CALLED DB2 ?
I know DB - DataBase.
I want to know the reason for the number "2".
First when i heard about the number. I thought, it was the version number.
Later came to know that, it is not the version number

My another question is, which is the first DATABASE ?

I got this from wikkipedia,

ORACLE
Quote:
Larry Ellison and his friends and former co-workers Bob Miner and Ed Oates started the consultancy Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software.

1979: SDL changed its company-name to "Relational Software, Inc." (RSI) and introduced its product Oracle V2 as an early commercially-available relational database system.


This i got from a blog,
Quote:
In 1980, Oracle version 2 was released and with it RSI became the first ever company to release a commercial relational database using SQL.

IBM DB2
From wikkipedia,
Quote:
DB2 has a long history and is considered by many to have been the first
database product to use SQL (also first developed by IBM).

The name DB2 was first given to the Database Management System or DBMS in 1983 when IBM released DB2 on its MVS mainframe platform.


My 2 basic questions.....
What is the reason the letter 2 in DB2 ?
Which is the first DATABASE(ORACLE or DB2 or is there somthing else) ?

Since, i am working on DB2, i am getting questions such as this....

Please clarify and clear my doubt ?
I know this sounds little childish to ask ?


Please ENLIGHTEN me,
Sushanth Bobby
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1353
Location: Israel

PostPosted: Thu Nov 06, 2008 5:59 pm
Reply with quote

In Israel, we had (back in the 80's) a product called DB1.
AFAIK, it still exist today, being the database used by Sapiens, a 4th generation language.

That may be why IBM had to choose DB2!?
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1353
Location: Israel

PostPosted: Thu Nov 06, 2008 6:07 pm
Reply with quote

Oh, I forgot to say that DB1 does not use SQL, so the following is still valid:
Quote:
DB2 has a long history and is considered by many to have been the first
database product to use SQL (also first developed by IBM).
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Thu Nov 06, 2008 6:11 pm
Reply with quote

Oh THANK YOU! THANK YOU! THANK YOU!
MARSO.............

For this precious information.....

Sushanth
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Thu Nov 06, 2008 6:15 pm
Reply with quote

Some DB2 History

wiki.ibmdatabasemag.com/index.php/DB2_History_--_A_Timeline#DB2_Debuts
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Thu Nov 06, 2008 6:20 pm
Reply with quote

Quote:
Name


it.toolbox.com/blogs/db2zos/what-is-in-a-name-9138
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Thu Nov 06, 2008 6:35 pm
Reply with quote

Thank You Prasanth,
Those links were all interesting ones.......

Sushanth
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Thu Nov 06, 2008 6:44 pm
Reply with quote

Quote:
Which is the first DATABASE(ORACLE or DB2 or is there somthing else) ?
IMS dates back to 1968. SYSTEM 2000 dates back to the late 60's or early 70's (I'm not sure how far back). IDMS was based on an earlier product developed in the early 60's. Hierarchical and network database structures were well understood by the mid to late 60's so several database software products were available. Relational databases for a mainframe didn't come around until 1983 with DB2, and DB2 was based on research IBM did on System R in the early to mid 70's.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu Nov 06, 2008 7:41 pm
Reply with quote

IIRC in the IBM world the precursors of database systems were
BOMP - born to support bill of material processing
and it's offpring
D-BOMP

BOMP was originally designed as a file access method for MRP ( material requirement and planning )
from some MRP blogs Gene Thomas invented BOMP in 1961
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Nov 07, 2008 1:19 am
Reply with quote

Hello,

Quote:
Which is the first DATABASE(ORACLE or DB2 or is there somthing else)
Oracle and DB2 are rather late-comers to the database engine game.

Before DB2, IBM had an offering called SQL/DS (which may have been IBM's first sql-based db).

As mentioned, IMS has been around since the late 60's. So were/are TOTAL, Datacom, Model204, and IDMS. I believe Adabas arrived in the early 70's.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Fri Nov 07, 2008 6:12 am
Reply with quote

I heard many years ago that DB2 was given the number 2 because IMS was considered to be DB1 although it was never called that.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Fri Nov 07, 2008 2:06 pm
Reply with quote

Thank You Guyz,
Sushanth Bobby
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts step by step trace 4 ISPF dialog call... TSO/ISPF 17
No new posts Intertest Batch issue with called ass... COBOL Programming 4
No new posts Execute DSNTEP2 in REXX which is call... CLIST & REXX 4
No new posts CICS called and calling program CICS 1
No new posts LIBDEF not working in called proc CLIST & REXX 0
Search our Forums:

Back to Top