Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle vs MS Access

RE: Oracle vs MS Access

From: David Barbour <dbarbour_at_connectsouth.com>
Date: Tue, 13 Feb 2001 16:35:40 -0800
Message-ID: <F001.002B33B8.20010213155532@fatcity.com>

Please try to be gentle with this soul.

Maria -

Access should not even be on your short list. The underlying architecture is not designed for simultaneous use by multiple sessions. What type of "web database" application(s) will you be creating? How many concurrent users do you expect for each application? How much data will you need to store/query per transaction? What webserver will you be using? On what platform will the webserver and database be running? How much data will you be storing overall? Will the different databases need to exchange information? What type of availability is required? What is your budget? What capability/capacity do you have to support the database?

These are only a couple of general questions, but I'm hoping you are beginning to understand that database selection is a pretty thought-provoking exercise.

You cannot compare Access and Oracle, they're sort of like Matchbox toys and Caterpillar trucks. One is used by children to move grains of sand, the other is used by knowledgeable adults and has the capability of hauling boulders.

You might start by looking at some of the comparisons available at: http://sqlexperts.aspcode.net/datcomp.asp

I'm sure others will weigh in with more sagacious advice. Good Luck.

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
Sent: Tuesday, February 13, 2001 2:11 PM To: Multiple recipients of list ORACLE-L

We are developing web database standards in my workplace. I need to identify advantages/disadvantages of using Oracle verses MS Access for web databases.

Does anyone know of any good resources for gathering this info (web sites, articles, etc)? Any help would be greatly appreciated.

Thanks Maria

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Maria Freytag
  INET: MFreytag_at_ci.fort-collins.co.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: David Barbour
  INET: dbarbour_at_connectsouth.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 13 2001 - 18:35:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US