Обсуждение: 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
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@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
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:You could also possibly pay a consulting company to implement it, but even that isn't as easy as it may sound. :)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).
--
Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.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@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