Skip site navigation (1) Skip section navigation (2)

Re: postgreSQL and history of relational databases

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Mark Woodward <pgsql(at)mohawksoft(dot)com>,Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: postgreSQL and history of relational databases
Date: 2005-03-28 21:01:15
Message-ID: 20050328210115.GA51784@decibel.org (view raw or flat)
Thread:
Lists: pgsql-hackers
It'd probably be helpful to include this info in a document to go along
with the image.

On Mon, Mar 28, 2005 at 07:16:23PM +0400, Oleg Bartunov wrote:
> On Mon, 28 Mar 2005, Mark Woodward wrote:
> 
> >>Hi there,
> >>
> >>while learning inkscape I did a sketch of picture describing
> >>history of relational databases. It's available from
> >>http://mira.sai.msu.su/~megera/pgsql/
> >
> >Is there a direct line from INGRES to Postgres? I was under the impression
> >that Postgres is a "new" lineage started after INGRES sharing little or no
> >code.
> 
> No code sharing, but only Stonebraker and his ideas about extensibility,
> objects and lessons learned after Ingres, so it's named Postgres.
> 
> 
> >
> >The line from Ingres through RDb, Oracle, to Informix seems to indicate a
> >lineage. Is there one? Is Oracle based, in some way, on INGRES?
> >
> 
> No, line just crossing Oracle which bought Rdb/VMS. I'll adjust picture.
> 
> 
> >IS there a relation between IBM System R and INGRES or is that just a
> >placement issue?
> 
> No, I placed them close to underline their importance for relational 
> databases.
> 
> >
> >What is the raltionship between System R and SQL and DB2?
> 
> Sure. System R was a research project of IBM
> SEQUEL is a language designed to work with data stored in System R. 
> SEQUEL was renamed to SQL then because there was existed trademark.
> IBM developes SQL/DS database which then became DB2.
> 
> >
> >What does Agatha Christie have do do with anything? (Other than having
> >Hecule investigate the death of SCO.)
> >
> 
> "elephants can remember" - elephant here is a keyword
> 
> IIRC, it was this proposal for postgresql logo
> http://www.pgsql.ru/db/mw/msg.html?mid=1238939
> 
> We used jaguar(leopard) before (famous postgresql empowered). 
> I don't remember who was the first author of Elephant logo.
> 
> 
> >While it is interesting, there seems to be implied connections by
> >proximity, and I'm not sure of the explicit connections by line. You'll
> >need some references.
> 
> I tried to separate INGRES family by color (color hue)
> Bright red  - is for IBM family (probably wrong color)
> Oracle is closer to IBM, because they both used SQL, 
> while INGRES family use QUEL at the beginning.
> 
> Ilustra was bought by Informix, which was bought by IBM and 
> incorporated into DB2, that's why they are close.
> 
> Illustra is a commercialized Postgres (1992), that's why there is line
> connecting them.
> 
> Sybase (Sybase SQL Server) and MS SQL are close because until 1992 there 
> was Sybase and license
> agreement with Microsoft, which ported Sybase to Windows NT. In 1993
> Microsoft rebranded Sybase and named MS SQL. Sybase in 1995 released v 11.0 
> and
> renamed them to ASE to be distinct from MS SQL.
> 
> 
> As I wrote, I'm not sure I got everything right, so any corrections are
> welcome. If you improve my picture (get .svg and inkscape), then I'd
> be glad to have it.  The reason I made this picture not just learning
> inkscape (great program!), I tried to show the place of PostgreSQL 
> between all major databases.
> 
> 
> 	Regards,
> 		Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
> 

-- 
Jim C. Nasby, Database Consultant               decibel(at)decibel(dot)org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

In response to

Responses

pgsql-hackers by date

Next:From: Jim C. NasbyDate: 2005-03-28 21:02:03
Subject: Re: postgreSQL and history of relational databases
Previous:From: Tom LaneDate: 2005-03-28 17:46:53
Subject: Re: Making oidvector and int2vector variable-length

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group