Re: Other tree representations in SQL

Carl Rosenberger wrote:
>

> (2) All object databases products with noticeable market
> share between 1980 and 2000 were transparent persistency
> systems. Transparent persistency can only work in
> concurrent-multi-user environments, if a "read back in
> time" isolation level is provided. As far as I am informed,
> none of the available "best selling" products has this
> feature. Instead they still work with read locks to ensure
> consistent objects.
> ...so they are still not ready for prime-time today.
>

Oracle 9 (available for 2 years now) does allow for a complete read-back in time, that is, one can query the database for a table as it existed at a specified time in the past.

Depending on exactly what is meant by "transparent persistency", Oracle may have had this feature for the last 12 years. Certainly, for at least that time, the Oracle Mantra "reads don't block writes, and writes don't block reads" has been true.

-- 
Phil Singer                |    psinger1ATchartermiDOTnet
Oracle DBA