Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2005
    Posts
    39

    Unanswered: Oracle or Access

    I was wondering what some advantages are from using an Oracle database compared to Microsoft Access database.
    My company is considering the migration from Access to Oracle.
    Any suggestions?

    Thnx

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    There surely are pros and contras, but you gave too few information; why would you migrate? Are you not satisfied with Access any longer? If so, why? How large is your database? How many concurrent users do you have?

    Do provide more details to get a better answer.

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Access works best as a single-user, desktop app. Although multi-user support was added, it has never worked well in supporting multiple users, nor should Access be used in any sort of "mission critical" application, as it's just not reliable enough, per Microsoft.

    Oracle is an enterprise level realtional database system that is server-based. Unlike Access, which is file based, a service runs on the database seerver, handling all data requests by the client. This service is optimized for its task, and can be much more effecient in providing data than Access can possibly be. For instance, if you have a large table, and you need a single record from it, An oracle query can filter the data at the server, and only pass the single record to the client. With Access, at best, the entire index must be passed from the data file to the client, and only then can the record be copied. At worst, the entire table must be copied from data file to client.

    In addition Oracle supports a whole array of features that Access cannot dream of supporting. Stored Procedures. Triggers. Sequences. Point-in-time recovery. Full transaction control. Terrabyte sized databases. Reliability. Stability with concurrent users.

    However, Oracle does require a lot of expertise to install and maintain.

    Comparing the two is like comparing a rusty Yugo to a new BMW. Both have 4 wheels and are classified as automobiles, and both will usually get you from point A to point B.


    Take a look HERE for a discussion of choosing a database product.

    If you want to get a better feel for what a database server offers, download a copy of PostgreSQL from PostgreSQL.Org (it's totally free) and play with it.
    Last edited by loquin; 05-16-06 at 03:09.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  4. #4
    Join Date
    Jan 2005
    Location
    Green Bay
    Posts
    201
    There is another option.

    SQLServer
    Depending on your need, skillset, Budget, and potiential data delivery.

    I currentally support Oracle, SQL Server and Aaugh Access databases.

    I find
    Oracle to be more robust
    Sql to be easier to pick up for novices more point and click database functions.
    Access is access.

  5. #5
    Join Date
    Jan 2004
    Posts
    492
    Thats funny - I was going to use the exact same car analogy that loquin used. Access being the Kia or Daewoo and Oracle being a Lamborghini or other car of similar magnitude. They both have an engine and drive but the similarities stop there.

    Oracle OCPI (Certified Practicing Idiot)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •