Re: [GENERAL] arrays

From: Mike Sosteric <mikes(at)athabascau(dot)ca>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [GENERAL] arrays
Date: 2002-09-30 17:24:19
Message-ID: Pine.SUN.3.96.1020930112405.16690H-100000@aupair.cs.athabascau.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

On Mon, 30 Sep 2002, Josh Berkus wrote:

thanks for this. we will stick with the relational model.

m

>
> Mike,
>
> > I have a very good sense of the strengths of relational databases. But
> > they are also limited when it comes to object orientaed data (like XML
> > records). I though arrays would be a way to simply the complexity you get
> > when you try and map objects to relations.
>
> In my experience, most XML records are, in fact, simple tree structures that
> are actually easy to represent in SQL. But I don't know about yours.
>
> Certainly the translation of XML --> SQL Tree Structure is no more complex
> than XML --> Array, that I can see.
>
> > Is Cache open source?
>
> No. It's a proprietary, and probably very expensive, database. There are no
> open source OODBs that I know of, partly because of the current lack of
> international standards for OODBs.
>
> > are the XML databases that are evolved and sophisticated enough to use in
> > production environments.
>
> I don't know. The last time I evaluated XML databases was a year ago, when
> there was nothing production-quality in existence. But I don't know what
> the situation is now.
>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

Mike Sosteric <mikes(at)athabascau(dot)ca> Managing Editor, EJS <http://www.sociology.org/>
Department of Global and Social Analysis Executive Director, ICAAP <http://www.icaap.org/>
Athabasca University Cell: 1 780 909 1418
Simon Fraser University Adjunct Professor
Masters of Publishing Program
--
This troubled planet is a place of the most violent contrasts.
Those that receive the rewards are totally separated from those who
shoulder the burdens. It is not a wise leadership - Spock, "The Cloud Minders."

___
This communication is intended for the use of the recipient to whom it
is addressed, and may contain confidential, personal, and or privileged
information. Please contact us immediately if you are not the intended
recipient of this communication, and do not copy, distribute, or take
action relying on it. Any communications received in error, or
subsequent reply, should be deleted or destroyed.
---

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2002-09-30 17:29:34 Re: [GENERAL] arrays
Previous Message Ibrahim Shaame 2002-09-30 17:20:24 Unsubscribe

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-09-30 17:28:19 Re: CVS split problems
Previous Message Josh Berkus 2002-09-30 17:18:48 Re: [GENERAL] arrays

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-09-30 17:27:48 Re: converting Sybase RULE -> postgreSQL
Previous Message Thrasher 2002-09-30 17:22:23 Unique constraint over null values