deductive databases in postgreSQL

On Wed, Jan 21, 2009 at 6:09 PM, Carlos Gonzalez-Cadenas
<carlos@gonzalez.name> wrote:

If not, what do you think is the best and most efficient way of implementing
it?

Thank you very much in advance,

I think you should ask that sort of quesitons on -hackers list, not here.

--
GJ

Hi all,

We're looking for a deductive database for our application. Oracle, in the
11g version, has extended its RDBMS with deductive capabilities, supporting
a subset of OWL-DL[1]http://www.oracle.com/technology/tech/semantic_technologies/index.html. They are able to load an ontology, perform the
inferences, dump the inferred info in the database and after that answer
queries with the asserted plus the inferred info.

We would like to have similar functionalities in PostgreSQL. Do you know if
there's someone working on that or if there are plans to support it soon?.
If not, what do you think is the best and most efficient way of implementing
it?

Thank you very much in advance,

Carlos

[1]: http://www.oracle.com/technology/tech/semantic_technologies/index.html

Carlos Gonzalez-Cadenas escreveu:

We're looking for a deductive database for our application. Oracle, in
the 11g version, has extended its RDBMS with deductive capabilities,
supporting a subset of OWL-DL[1]. They are able to load an ontology,
perform the inferences, dump the inferred info in the database and after
that answer queries with the asserted plus the inferred info.

We would like to have similar functionalities in PostgreSQL. Do you know
if there's someone working on that or if there are plans to support it
soon?. If not, what do you think is the best and most efficient way of
implementing it?

No one that I know of. Well, it is a long road. The addition of a data type
xml is recent (8.3). We lack a set of features like indexing, a new data
structure (?), XQuery, XPath improvement and, so on [1]http://wiki.postgresql.org/wiki/XML_Todo. Don't expect much of
these TODO items completed before the next two releases (unless you want to
take a stab).
After all of these basic infrastructure, we need a language (SPARQL?) and an
inference engine -- this is a big task AFAICT. At this point, don't know if
hackers will agree in adding such a big feature in core that is not SQL
standard (aka SQL/XML) but maybe it could be an external module.

[1]: http://wiki.postgresql.org/wiki/XML_Todo

--
Euler Taveira de Oliveira
http://www.timbira.com/

On Jan 22, 2009, at 8:24 AM, Euler Taveira de Oliveira wrote:

No one that I know of. Well, it is a long road. The addition of a
data type
xml is recent (8.3). We lack a set of features like indexing, a new
data
structure (?), XQuery, XPath improvement and, so on [1]. Don't
expect much of
these TODO items completed before the next two releases (unless you
want to
take a stab).

You could also possibly pay a consulting company to implement it, but
even that isn't as easy as it may sound. :)
--
Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Yes it's an option, but you cannot rely on the typical consulting company to
do that. Do you know any specialized consulting boutique or individual
developer that could do that?

Carlos Gonzalez-Cadenas
CEO, ExperienceOn - New generation search
http://www.experienceon.com

Mobile: +34 652 911 201
Skype: carlosgonzalezcadenas
LinkedIn: http://www.linkedin.com/in/carlosgonzalezcadenas

On Thu, Jan 22, 2009 at 7:16 PM, decibel <decibel@decibel.org> wrote:

On Fri, Jan 23, 2009 at 10:10:55AM +0100, Carlos Gonzalez-Cadenas wrote:

Yes it's an option, but you cannot rely on the typical consulting company to
do that. Do you know any specialized consulting boutique or individual
developer that could do that?

Sending an email to pgsql-jobs@postgresql.org couldn't hurt.

--
Sam http://samason.me.uk/

At the risk of excluding people...

I know that 2ndQuadrant and Command Prompt will develop features for
hire. I'm not sure if EnterpriseDB will or not.

And yes, post is pgsql-jobs.

On Jan 23, 2009, at 3:10 AM, Carlos Gonzalez-Cadenas wrote:

Yes it's an option, but you cannot rely on the typical consulting
company to do that. Do you know any specialized consulting boutique
or individual developer that could do that?

Carlos Gonzalez-Cadenas
CEO, ExperienceOn - New generation search
http://www.experienceon.com

Mobile: +34 652 911 201
Skype: carlosgonzalezcadenas
LinkedIn: http://www.linkedin.com/in/carlosgonzalezcadenas

On Thu, Jan 22, 2009 at 7:16 PM, decibel <decibel@decibel.org> wrote:
On Jan 22, 2009, at 8:24 AM, Euler Taveira de Oliveira wrote:
No one that I know of. Well, it is a long road. The addition of a
data type
xml is recent (8.3). We lack a set of features like indexing, a new
data
structure (?), XQuery, XPath improvement and, so on [1]. Don't
expect much of
these TODO items completed before the next two releases (unless you
want to
take a stab).

You could also possibly pay a consulting company to implement it,
but even that isn't as easy as it may sound. :)
--
Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

--
Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828