Thread: postgreSQL and history of relational databases
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/ I'd be very grateful for any corrections and comments. It could be used in PostgreSQL related presentations, source file is available http://www.sai.msu.su/~megera/postgres/history/rel-db-hist.svg Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
Maybe it's just me, but it's pretty hard to read, especially at the top. Other than that, it's great, and very informative. Thanks! On Mon, Mar 28, 2005 at 01:33:58AM +0400, Oleg Bartunov 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/ > > I'd be very grateful for any corrections and comments. > It could be used in PostgreSQL related presentations, > source file is available > http://www.sai.msu.su/~megera/postgres/history/rel-db-hist.svg > > Regards, > Oleg > _____________________________________________________________ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > -- Jim C. Nasby, Database Consultant decibel@decibel.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?"
On Sun, 27 Mar 2005, Jim C. Nasby wrote: > Maybe it's just me, but it's pretty hard to read, especially at the top. what do you mean ? Too crowdy or text is too small ? > Other than that, it's great, and very informative. Thanks! > > On Mon, Mar 28, 2005 at 01:33:58AM +0400, Oleg Bartunov 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/ >> >> I'd be very grateful for any corrections and comments. >> It could be used in PostgreSQL related presentations, >> source file is available >> http://www.sai.msu.su/~megera/postgres/history/rel-db-hist.svg >> >> Regards, >> Oleg >> _____________________________________________________________ >> Oleg Bartunov, sci.researcher, hostmaster of AstroNet, >> Sternberg Astronomical Institute, Moscow University (Russia) >> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ >> phone: +007(095)939-16-83, +007(095)939-23-83 >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 8: explain analyze is your friend >> > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
> 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. 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? IS there a relation between IBM System R and INGRES or is that just a placement issue? What is the raltionship between System R and SQL and DB2? What does Agatha Christie have do do with anything? (Other than having Hecule investigate the death of SCO.) 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'd be very grateful for any corrections and comments. > It could be used in PostgreSQL related presentations, > source file is available > http://www.sai.msu.su/~megera/postgres/history/rel-db-hist.svg > > Regards, > Oleg > _____________________________________________________________ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend >
On Mon, Mar 28, 2005 at 10:09:19AM +0400, Oleg Bartunov wrote: > On Sun, 27 Mar 2005, Jim C. Nasby wrote: > > >Maybe it's just me, but it's pretty hard to read, especially at the top. > > what do you mean ? Too crowdy or text is too small ? I found it a little confusing. Do the lines go one way or the other? Maybe sticking arrowheads could explain that. Also, is there a timeline-like ordering? (horizontal or vertical? or maybe diagonal) It doesn't seem so to me but I may be wrong. It looks a cool thing to have, to me anyway ... -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) "Estoy de acuerdo contigo en que la verdad absoluta no existe... El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama)
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@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
On Mon, 28 Mar 2005, Alvaro Herrera wrote:
> On Mon, Mar 28, 2005 at 10:09:19AM +0400, Oleg Bartunov wrote:
>> On Sun, 27 Mar 2005, Jim C. Nasby wrote:
>>
>>> Maybe it's just me, but it's pretty hard to read, especially at the top.
>>
>> what do you mean ? Too crowdy or text is too small ?
>
> I found it a little confusing. Do the lines go one way or the other?
> Maybe sticking arrowheads could explain that. Also, is there a
Hey, I learn inkscape only 1 day, I don't know how to create arrows.
> timeline-like ordering? (horizontal or vertical? or maybe diagonal)
> It doesn't seem so to me but I may be wrong.
Hmm, I felt I need some ordering. This picture appears in process of
playing with inkscape, I recall some facts I know and put them into
canvas in form of rectangles and circles. Inkspace worked very well and my
sketch survived, so I decided to show it to community if it could be useful.
Probably I'll use in my talk in conference this april.
Regards, Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
> 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. I would indicate that differently, maybe a dash or dotted line? > > >> >> 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. It is hard to imply relationships without also implying derivation. > >> >> 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 I loved the movie "Gross Point Blank" :-) > > We used jaguar(leopard) before (famous postgresql empowered). > I don't remember who was the first author of Elephant logo. I think the elephant logo is great. Between Elephants, penuins, open source is starting to look like a zoo.
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@sai.msu.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@decibel.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?"
On Mon, Mar 28, 2005 at 10:09:19AM +0400, Oleg Bartunov wrote: > On Sun, 27 Mar 2005, Jim C. Nasby wrote: > > >Maybe it's just me, but it's pretty hard to read, especially at the top. > > what do you mean ? Too crowdy or text is too small ? It's just too hard to grok what the relationships are. Spacing things out some more would help, as would a legend. -- Jim C. Nasby, Database Consultant decibel@decibel.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?"
On Mon, Mar 28, 2005 at 07:24:24PM +0400, Oleg Bartunov wrote: > On Mon, 28 Mar 2005, Alvaro Herrera wrote: > > >On Mon, Mar 28, 2005 at 10:09:19AM +0400, Oleg Bartunov wrote: > >>On Sun, 27 Mar 2005, Jim C. Nasby wrote: > >> > >>>Maybe it's just me, but it's pretty hard to read, especially at the top. > >> > >>what do you mean ? Too crowdy or text is too small ? > > > >I found it a little confusing. Do the lines go one way or the other? > >Maybe sticking arrowheads could explain that. Also, is there a > > Hey, I learn inkscape only 1 day, I don't know how to create arrows. Hmm. I think you could create a triangle using the "star" tool, and stick a straight line to it. Then make a group of both (Ctrl-G IIRC). Then you can make duplicates (Ctrl-D) of the arrow and move/rotate (Alt-mouse or Ctrl-mouse IIRC -- press the key and watch the statusbar) them to wherever you need. I also used inkscape some time ago and I found it very good. It took me a while to get used to it though (and I'm not claiming I'm an artist.) -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) Criptografía: Poderosa técnica algorítmica de codificación que es empleada en la creación de manuales de computadores.
On Mon, 28 Mar 2005, Jim C. Nasby wrote: > It'd probably be helpful to include this info in a document to go along > with the image. I'll do this unless more experienced (Bruce, Elein) writers do that. > > 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@sai.msu.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 >> > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
On Mon, 28 Mar 2005, Alvaro Herrera wrote:
> On Mon, Mar 28, 2005 at 07:24:24PM +0400, Oleg Bartunov wrote:
>> On Mon, 28 Mar 2005, Alvaro Herrera wrote:
>>
>>> On Mon, Mar 28, 2005 at 10:09:19AM +0400, Oleg Bartunov wrote:
>>>> On Sun, 27 Mar 2005, Jim C. Nasby wrote:
>>>>
>>>>> Maybe it's just me, but it's pretty hard to read, especially at the top.
>>>>
>>>> what do you mean ? Too crowdy or text is too small ?
>>>
>>> I found it a little confusing. Do the lines go one way or the other?
>>> Maybe sticking arrowheads could explain that. Also, is there a
>>
>> Hey, I learn inkscape only 1 day, I don't know how to create arrows.
>
> Hmm. I think you could create a triangle using the "star" tool, and
> stick a straight line to it. Then make a group of both (Ctrl-G IIRC).
> Then you can make duplicates (Ctrl-D) of the arrow and move/rotate
> (Alt-mouse or Ctrl-mouse IIRC -- press the key and watch the statusbar)
> them to wherever you need.
I found a lot arrows in "Stroke style" of "Fill and Stroke" dialog.
>
> I also used inkscape some time ago and I found it very good. It took me
> a while to get used to it though (and I'm not claiming I'm an artist.)
>
I got only one core dump :)
>
Regards, Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83