Обсуждение: deductive databases in postgreSQL
Hi all,<br /><div class="gmail_quote"><br />We're looking for a deductive database for our application. Oracle, in the 11gversion, has extended its RDBMS with deductive capabilities, supporting a subset of OWL-DL[1]. They are able to load anontology, perform the inferences, dump the inferred info in the database and after that answer queries with the assertedplus the inferred info. <br /><br />We would like to have similar functionalities in PostgreSQL. Do you know if there'ssomeone working on that or if there are plans to support it soon?. If not, what do you think is the best and mostefficient way of implementing it?<br /><br />Thank you very much in advance,<br /><br />Carlos<br /><br />[1]: <a href="http://www.oracle.com/technology/tech/semantic_technologies/index.html" target="_blank">http://www.oracle.com/technology/tech/semantic_technologies/index.html</a><br/></div><br />
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 consultingboutique or individual developer that could do that?<br /><br clear="all" />Carlos Gonzalez-Cadenas<br /> CEO,ExperienceOn - New generation search<br /><a href="http://www.experienceon.com">http://www.experienceon.com</a><br /><br/>Mobile: +34 652 911 201<br />Skype: carlosgonzalezcadenas<br />LinkedIn: <a href="http://www.linkedin.com/in/carlosgonzalezcadenas">http://www.linkedin.com/in/carlosgonzalezcadenas</a><br/><br /><br/><br /><div class="gmail_quote">On Thu, Jan 22, 2009 at 7:16 PM, decibel <span dir="ltr"><<a href="mailto:decibel@decibel.org">decibel@decibel.org</a>></span>wrote:<br /><blockquote class="gmail_quote" style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">On Jan22, 2009, at 8:24 AM, Euler Taveira de Oliveira wrote:<br /><blockquote class="gmail_quote" style="border-left: 1px solidrgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> No one that I know of. Well, it is a long road.The addition of a data type<br /> xml is recent (8.3). We lack a set of features like indexing, a new data<br /> structure(?), XQuery, XPath improvement and, so on [1]. Don't expect much of<br /> these TODO items completed before thenext two releases (unless you want to<br /> take a stab).<br /></blockquote><br /><br /></div> You could also possiblypay a consulting company to implement it, but even that isn't as easy as it may sound. :)<br /><font color="#888888">-- <br /> Decibel!, aka Jim C. Nasby, Database Architect <a href="mailto:decibel@decibel.org" target="_blank">decibel@decibel.org</a><br/> Give your computer some brain candy! <a href="http://www.distributed.net" target="_blank">www.distributed.net</a>Team #1828<br /><br /><br /></font></blockquote></div><br />
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