Valentina DB 4.1 Introduces Groundbreaking SQL Feature

[Ruslan Zasukhin]

On 4/22/09 1:52 PM, "Brian Yennie" <briany at qldlearning.com> wrote:

Hi Brian,

For people who not aware -- Brian Yennie was man, which have push us to
MetaCard, and even better, have help a lots create first Valentina external
for MetaCard. 

:-)

> Very interesting and congratulations on this new feature!

Thank you.

> Can you  comment on how it compares to Oracle's "START WITH ... CONNECT BY"?

I see that this form of existed recursive commands is not considered in our
article

<http://valentina-db.com/dokuwiki/doku.php?id=valentina:articles:recursive_q
uery>

Ivan, I think it needs find some nice example from Oracle with this syntax,
And "convert" it to our syntax.

> That is the only comparable feature I've seen, and of course requires  paying
> a high price for Oracle. Of course now Oracle owns Sun which  owns MySQL, so
> who knows where that will go! Maybe they will want to  acquire Paradigma next
> =).
> 
> - Brian


When Ivan do work on above article, he have check existed solutions for
recursion.

Interesting observation was that they all try resolve only search DOWN by
hierarchy. You will not find talks or examples about search UP and than more
WIDE by hierarchy.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]