Date:         Sat, 17 Feb 1996 16:26:00 1000
Reply-To:     "Alex M. Wolf" <wolfam@WERPLE.NET.AU>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Alex M. Wolf" <wolfam@WERPLE.NET.AU>
Subject:      Re: SAS vs Oracle
Comments: To: luke@CS.CITY.AC.UK

Using Oracle for the Database would enable various privileges to be defined for different users, SAS you may allow Update or Read Access only. In terms of processing, updating and manipulating data in an Oracle database, if you use SQL then the speed of processing is very slow, I have worked with SAS and Oracle in various environments and to illustrate a process of updating a Master File of 1 million records with 50,000 transaction records;
 
SAS took 10 minutes and the  Oracle system took 6 hours elapsed time.
 
 
Cheers
 
Alex M. Wolf
 
----------
From:  Luke Whitaker[SMTP:luke@CS.CITY.AC.UK]
Sent:  Friday, 16 February 1996 3:39
To:  Multiple recipients of list SAS-L
Subject:  SAS vs Oracle
 
Sorry if this came up a while ago - it wasn't relevent to me before but
now it is. Is there any advantage to using Oracle for a medium/large
sized data base of say 100 MBytes up to possibly 1 Gbyte consisting of
maybe two or three tables compared to SAS ? I have a lot of SAS
experience and no Oracle experience. The hardware would be Sun SPARC.
 
What advantages (if any) does Oracle have over SAS as a DBMS ?
 
Thanks,
 
Luke Whitaker,
Epidemiology,
St Mary's Med School,
London