Re: Oracle vs. Access

From: Drazen Zoric <drazen.zoric_at_vip.hr>
Date: Thu, 22 Nov 2001 11:02:46 +0100
Message-ID: <9tiidl$76m$1@fstgss02.tu-graz.ac.at>

Access is low-end relationel database but Oracle is high-end (highest). Oracle is using client/server architecture, Access file sharing. In client/server arch database engine is located on server, but in Access every client has its own engine (DAO).
In Oracle communication between client/server is done using network protocol, Named Pipes (WinNT). Access is like opening single file simultanously
on more computers.
There are also a lot of features build into databases (SQL language, triggers, etc),
database size (Access 2000 is 2GB, Oracle 'unlimited'), speed (quality of SQL engine).

For simple database application Access could be better (and cheaper of course) but
when security, number of users, replication is in question than Oracle is better way.

"Keld Forchhammer" <forchhammer_at_mail.tele.dk> wrote in message news:3bfc1ad8$0$735$edfadb0f_at_dspool01.news.tele.dk...
> Hi,
>
> Hope someone can help me with the following:
>
> I have an exam-question regaring in which degree Access and Oracle fulfill
> being relationel databases?
>
> Secoundary I would like to know the big diferences between these two
> databasesystems and their limitations? Can anyone shortly tell me these?
>
> Hope someone can help me soon :o)
>
> Hopefull regards - T.
>
>
>
>
Received on Thu Nov 22 2001 - 04:02:46 CST