[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Indexing solution for native XML database

• To: Michael Kay <mike@s...>
• Subject: Re: Indexing solution for native XML database
• From: Peter Hunsberger <peter.hunsberger@g...>
• Date: Tue, 29 Nov 2005 15:37:06 -0600
• Cc: Timo Hildén <castaway@d...>, xml-dev@l...
• Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=jz1o6cFwTdMUddTkB6rlD1XJMCEFzLUwR+1XgkqYzBuLuDzmTmhBOyqVwKULsVxJUmjDZe7ZteTx3FTHzcYC/WujsCtN5vSzD18wpNNZ4mqoA0ZLJeB5gEhz8zjPfks0LcMBZ0t/U8D3ncQdNQsPDl1ygQb6rOfdW3JbeGfozPk=
• In-reply-to: <20051129205237.54CCC2F4168@m...>
• References: <cc159a4a0511291240i5b1d344ft7a779e0de235499e@m...> <20051129205237.54CCC2F4168@m...>

On 11/29/05, Michael Kay <mike@s...> wrote:
> > Sure, a relational database might not be the best fit for a given
> > hierarchical structure. But for other cases the fit may be as good or
> > better than any other database....
>
> I was under the impression the OP was trying to design a relational database
> to hold arbitrary XML documents, not to hold a specific document. In other
> words, to implement a hierarchical database on top of a relational database.

Could be, given his examples I assumed otherwise...

> I don't think that's a good way of implementing a hierarchical database. I
> apologize that I don't have time to write a detailed rationale for that
> view, but it's based on a lot of experience, including expensive failures of
> projects that tried to do exactly that.

No need for a rationale.  I'd agree that for arbitrary documents, even
with XML Schema's generalized mapping to a RDB is a hard problem that
is unlikely to yield good results in most cases.

--
Peter Hunsberger

• References:
  • Re: Indexing solution for native XML database
    • From: Peter Hunsberger <peter.hunsberger@g...>
  • RE: Indexing solution for native XML database
    • From: "Michael Kay" <mike@s...>

• Prev by Date: RE: Common Word Processing Format
• Next by Date: Re: Indexing solution for native XML database
• Previous by thread: RE: Indexing solution for native XML database
• Next by thread: Re: Indexing solution for native XML database
• Index(es):
  • Date
  • Thread