pg.ddx.io  pgsql-chat@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Makoto Yui <yuin@bb.din.or.jp>
To: pgsql-hackers@postgresql.org
Subject: Re: is GiST still alive?
Date: Thu, 23 Oct 2003 22:38:09 +0900
Message-ID: <20031023223809.7de8804e.yuin@bb.din.or.jp> (raw)
In-Reply-To: <3F96FA03.6040009@dunslane.net>
References: <200310220438.h9M4cY232554@hosting.commandprompt.com>
	<200310221219.43179.josh@agliodbs.com>
	<60ptgpf175.fsf@dev6.int.libertyrms.info>
	<3F96FA03.6040009@dunslane.net>

> *nod* I have tried this several times - it just doesn't work well, 
> because the maps are too different.
> 
> You could do something like this:
>    . a table for each element type, fields being the attributes, plus 
> the node id.
>    . a table to tie everything together (parent_id, child_id, 
> child_order, child_type).
> In theory you could even generate the DB schema from an XML schema and 
> evaluate it with XPath-like expressions.

Although bits separated from a topic, I am developing XML database enviroment 
based on PostgreSQL, XpSQL.
http://gborg.postgresql.org/project/xpsql/

The enviroment decompose XML documents into fragments and uses PostgreSQL 
to store them in a set of relations. 
Users do not have to know that they are stored as relations.

It provides a variety of means to access XML Documents;
(a) DOM functions to build and traverse XML Documents
(b) XPath engine to extract infomation from documents
(c) update functions to modify documents

Although the development is on going, 
the performance is better than Apache Xindice.
#if you require, I'll send you the result after.

- points -
* node labeling is based on dewey decimal classification,  
 so updating performance is well.
* The index method is general (postgres) B-tree.

this is a programing image.
http://gborg.postgresql.org/project/xpsql/cvs/co.php/XpSQL/doc/USAGE?r=1.4

+-------------------------------------------------------------------+
Makoto Yui <yuin@bb.din.or.jp>
Key fingerprint = 6462 E285 97D8 1323 40C4  F9E5 EB0F 9DE6 1713 219E
+-------------------------------------------------------------------+



view thread (16+ messages)  latest in thread

Message-ID: <20031023223809.7de8804e.yuin@bb.din.or.jp>
Permalink:  ../20031023223809.7de8804e.yuin@bb.din.or.jp/
Also on:    postgresql.org/message-id/20031023223809.7de8804e.yuin@bb.din.or.jp

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-chat@postgresql.org
  Cc: yuin@bb.din.or.jp, pgsql-hackers@postgresql.org
  Subject: Re: is GiST still alive?
  In-Reply-To: <20031023223809.7de8804e.yuin@bb.din.or.jp>
  References: <200310220438.h9M4cY232554@hosting.commandprompt.com> <200310221219.43179.josh@agliodbs.com> <60ptgpf175.fsf@dev6.int.libertyrms.info> <3F96FA03.6040009@dunslane.net> <20031023223809.7de8804e.yuin@bb.din.or.jp>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox