DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006

    Tables & Databases


    I am new to database concepts and look to develop my skills in it.

    I am confused about the difference between "TABLES" and "DATABSASES"...are they the same thing? I read about "employee tables" "customer tables" and then i read about "employee databases" and "customer databases"...my questions are:

    1) are tables and databses same thing? (and used interchangibly?)
    2) how many databases are there typically in a small sized companies (say a company with 100 employess and about 600 customers)...what do you think will be the ideal number of databses in a comapny of that size?
    3) Will running an Oracle Database for such a coampny (with 100 employees and 600 customers) be feesable?

    Thanks!- look forward to your comments

  2. #2
    Join Date
    Aug 2002
    Colorado Springs
    1) The best thing here is to have a look at the Oracle Concepts Guide. Here's the index page ... http://download-west.oracle.com/docs...b14220/toc.htm Have a look at the "Oracle Database Architecture" section and it will give you an extremely thorough grounding in many important concepts -- tablespaces, data files, tables, indexes, views etc.

    2) Very difficult to answer. It could just be half a dozen important ones, oe if you include all the ad-hov desktop databases that individual employees throw together you could be looking at over a hundred.

    3) Absolutely. Oracle is not just the behemoth of Enterprise Edition -- look at the Standard Edition and how you could use Oracle's Application Express to centralise a shed-load of minor (and quite major) applications.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jul 2006
    Thanks for the link slimdave!!

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.