Re: deductive databases in postgreSQL

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

On Wed, Jan 21, 2009 at 6:09 PM, Carlos Gonzalez-Cadenas
<carlos(at)gonzalez(dot)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]. 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]. 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(at)decibel(dot)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(at)decibel(dot)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(at)decibel(dot)org
> Give your computer some brain candy! www.distributed.net Team #1828
>
>
>

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(at)postgresql(dot)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(at)decibel(dot)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(at)decibel(dot)org
> Give your computer some brain candy! www.distributed.net Team #1828
>
>
>

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