Re: Re: OT - new datablade announced for informix
Jean Sagi said: > > Ummm... I read > http://www.coppereye.com/coppereye_datablade.htm > and it looks very interesting, indeed. > > I think this could be done only thanks to the datablade architecture of > Informix... > > This could be done with DB2? > > Or Oracle/Sql-Server? ... ;) As far as I know, they punt their technology as an alternative to RDBMSs, but yes, I think this is a classic example of how easy it can be to extend IDS. Still, at least DB2 only has a single code base. And Oracle wears army boots! -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html sending to informix-list
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:cbaefd$1rc$1@news.xmission.com... > Jean Sagi said: > > > > Ummm... I read > > http://www.coppereye.com/coppereye_datablade.htm > > and it looks very interesting, indeed. > > > > I think this could be done only thanks to the datablade architecture of > > Informix... > > > > This could be done with DB2? > > > > Or Oracle/Sql-Server? ... ;) > > As far as I know, they punt their technology as an alternative to RDBMSs, > but yes, I think this is a classic example of how easy it can be to extend > IDS. As I understand it, exactly. To achieve the same in DB2 or Oracle would require a code re-write, to have the index-functionality code written into the "engine" software. The datablade functionality of Informix obviates the need for this. I've deliberatly cross-posted in case I'm talking crap, to give experts in the other DBMSs the chance to correct me. Somthing tells me I will regret it though ...!
> I've deliberatly cross-posted in case I'm talking crap, to give experts in > the other DBMSs the chance to correct me. Well, I'm no expert, but Oracle does have a published extensibility framework, that does allow for new indexes, operators and optimizer directives to be added to the language. This is extensively used within Oracle to develop things such as intermedia, spatial etc. There is not a lot of third-party uptake of this capability, however, although some did - for instance http://www.daylight.com/dayhtml/doc/sql/daycart_indexes.html Anyhow, for those interested, see - http://download-west.oracle.com/docs/cd/B13789_01/appdev.101/b10800/toc.htm for a description of what is provided > Somthing tells me I will regret >> it though ...! >> I think the whole Universal Server wars are long gone.
AFAIK it does work with Oracle or at least can. With Informix we've seen 75% reduction in load times when compared with std b-tree indexes. Neil Truby wrote: > > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message > news:cbaefd$1rc$1@news.xmission.com... > > Jean Sagi said: > > > > > > Ummm... I read > > > http://www.coppereye.com/coppereye_datablade.htm > > > and it looks very interesting, indeed. > > > > > > I think this could be done only thanks to the datablade architecture of > > > Informix... > > > > > > This could be done with DB2? > > > > > > Or Oracle/Sql-Server? ... ;) > > > > As far as I know, they punt their technology as an alternative to RDBMSs, > > but yes, I think this is a classic example of how easy it can be to extend > > IDS. > > As I understand it, exactly. To achieve the same in DB2 or Oracle would > require a code re-write, to have the index-functionality code written into > the "engine" software. The datablade functionality of Informix obviates the > need for this. > > I've deliberatly cross-posted in case I'm talking crap, to give experts in > the other DBMSs the chance to correct me. Somthing tells me I will regret > it though ...! -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #