RE: Large databases

Access actually does pointy clickey pretty well. Is quick if you need to put GUI front end on something and don't have Forms to use (I still like Forms better than Access, but that is more bias for toys I like). We use Access to create a front end, sometimes, so some of us don't have to count values in an insert statement... To have the chair of the CS department tell me that Oracle isn't nearly as good a database as Access because it couldn't do Query by Example, though was somewhat of a culture shock. HE didn't even advocate pushing "real" life past 3rd normal, because of the diminishing returns.

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
Well-behaved women rarely make history

-----Original Message-----
Sent: Wednesday, April 16, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L

I always do this.

I tell people the difference between back-end and front-end. Oracle is more of a back-end database with very rich back-end functions.

Access is more front-end database(yes, Access is known to be a front-end to other databases) with a very rich user interface.

Either database is OK depending on the needs. Most users are only interested in what they see and when they see that Access has a really rich user interface, then they think it is THE database.

Same thing wehen developing a data drivern website. Most people think what they see on the website is the work that you did (Wow nice flashy colors!!). They do not know that the amount of work that goes in the rear(things that you do not see) makes up more than 80% (my experience) of the work.

-- 
Lyndon Tiu


Quoting April Wells <awells_at_csedge.com>:



> 

> No, wait... read the whole statement.  " I took an ACCESS course

> last year"

>  

> Comparing that to People Soft, SAP, Oracle (my pet system) or any

> other one

> defies logic in itself.  PLUS... this is exactly the kind of thing

> I know

> they teach at the local university, here in the Texas panhandle.  I

> was

> working with the instructor of the undergrad database class (who

> taught that

> Access was a fully functional totally acceptable relational

> database,

> suitable for any corporation) and he asked me to install the Query

> By

> Example interface for Oracle... Oracle must have one, or else it

> isn't half

> the database that Access is because QBE is encouraged in Access.

>  



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Lyndon Tiu
  INET: ltiu_at_alumni.sfu.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: April Wells
  INET: awells_at_csedge.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).