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