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/postgr...el-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

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/postgr...el-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?"

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

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/postgr...el-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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

> 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/postgr...el-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
>


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

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)

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

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

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

> 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.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

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?"

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

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?"

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly