Hi,

is anyone interested in, or actually working on advanced issues
with PostgreSQL, like:

- recursive queries and transitive closure optimization

- more sophisticated representation incomplete information
  (different null values)

- probabilistic relations

- temporal (preferrably bi-temporal) relations

I am planning to use PostgreSQL for medical information and medical
knowledge, so I run into all these problems.  I wonder whether it
makes sense to tweak on PostgreSQL for these matters or whether a
more generic approach (where the client does all the advanced stuff)
is more realistic.

any ideas appreciated,
-Gunther Schadow

-- 
Gunther_Schadow-------------------------------http://aurora.rg.iupui.edu
Regenstrief Institute for Health Care
1050 Wishard Blvd., Indianapolis IN 46202, Phone: (317) 630 7960
schadow@aurora.rg.iupui.edu------------------#include <usual/disclaimer>
Wed, 08 Dec 1999 15:15:19 -0500
Gunther Schadow <gunther@aurora.rg.iupui.edu>
Advanced projects ... anyone interested?
On Wed, Dec 08, 1999 at 03:15:19PM -0500, Gunther Schadow wrote:
> is anyone interested in, or actually working on advanced issues
> with PostgreSQL, like:

Yes and no.

> - recursive queries and transitive closure optimization

Yup, that's the topic I'm interested in.

> I am planning to use PostgreSQL for medical information and medical
> knowledge, so I run into all these problems.  I wonder whether it
> makes sense to tweak on PostgreSQL for these matters or whether a
> more generic approach (where the client does all the advanced stuff)
> is more realistic.

IMO the backend should be expanded to handle this stuff. In fact I had
actual plans to add the recursive stuff but have not even found enough time
to dig into the source code. 

For those who don't know, I made my Ph.D. in deductive database systems
which is mostly about recursive queries and transitive closures.

Michael

-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!

Thu, 9 Dec 1999 08:43:51 +0100
Michael Meskes <meskes@postgresql.org>
Re: [HACKERS] Advanced projects ... anyone interested?