Re: diff bewteen 8i and 9i?

From: Mark Townsend <markbtownsend_at_home.com>
Date: Sat, 21 Jul 2001 21:44:30 GMT
Message-ID: <B73539D1.C278%markbtownsend@home.com>

in article 9eoosp$c6l$1_at_m2wpersoisp01.wanadoo.es, Ca at carpet_at_wanadoo.es wrote on 5/26/01 10:25 AM:

> Dear Eric,
>
> some time ago I asked exactly the same question, however, I still haven't
> got an answer. Maybe the question is too insignificant for the experts (I
> mean those who some time ago started out with questions like yours).
> I will try to find some time and just install 9i on a computer and compare
> it for myself. After having gained some experience I will sure post a
> message.
> If you find out about it earlier, could you please send me a brief message?
>
> Thank you in advance,
> Kind regards,
> Carsten
>
> carsten.peters_at_unavarra.es
>
> "Eric" <staceye_at_picknowl.com.au-NOSPAM> escribió en el mensaje
> news:3b0fb78c_6_at_news.chariot.net.au...

>> Hi,
>> Can any please explain the difference between 8i and 9iAS.
>> I thought 8i is their main database product but then why have 9i? Does 9i
>> include the database program or does it work together with 8i?
>> Are there any real world examples where you would use each product in a
>> specific setting?
>> I have tried reading the docs but as I am new to databases I am having
>> trouble distinguishing between them.
>> Any help appreciated,
>> regards
>> Eric.
>> 

Carsten and Eric - it is a little confusing. Anyhow, here's the skinny.

Oracle9i is now a generic term for the infrastructure Oracle provides you to run your applications on. It consists of two products - an appliction server and a database. Currently, Oracle9i consists of the Oracle9i Application Server (aka iAS), and the Oracle8i database (aka Oracle8i). In about a week or two, Oracle9i will consist of the Oracle9i Application Server, and the next release of the Oracle8i database, called the Oracle9i Database.

So you put your data in the back-end database (Oracle8i Database or Oracle9i Database), and you run your mid tier applications in the Oracle9i Application Server (Dynamic/Static HMTL, Java, Forms, Reports, etc).

To add to the confusion, the Oracle9i Application Server includes it's own copy of the Oracle8i Database - for mid tier data caching. However, YOU don't put data there - the application server does it for you when you set up mid tier caching of data from the back end. Received on Sat Jul 21 2001 - 16:44:30 CDT