Database Design
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Database Design

  1. #1
    Join Date
    Feb 2002
    Posts
    12

    Post

    how to design physical database from logical database in
    oracle?

    whar are the guidelines for designing database and
    sizing SGA and other factors?

    Can i get any books or articles on this?

    regards
    atul

    atul

  2. #2
    Join Date
    Sep 2002
    Posts
    40

    designer

    If you would like to create a physical database from a logical database you can use the designer tool of Oracle.
    I am not sure where you could get the documentation for it,
    but designer is a very powerful tool which not only is used to create but reverse engineer and in some cases edit to
    OCP DBA 7.3,8,8i,9i

  3. #3
    Join Date
    Sep 2002
    Posts
    40

    sizing sga

    I almost forgot , as far as the sizing of sga is concerned if you have the manuals for Oracle performance and tunning they have all the information needed.
    OCP DBA 7.3,8,8i,9i

  4. #4
    Join Date
    May 2004
    Posts
    1

    Database Modelling in UML

    This article offers a step by step approach to transform a UML object-oriented class model in a purely relational database.

    http://www.methodsandtools.com/archive/archive.php?id=9

  5. #5
    Join Date
    Jun 2004
    Location
    ludhiana
    Posts
    15
    hi atul


    i afaird that No book will tell u the right size of the SGA rather book will tell u how to think before sizing i.e, it really depands on the workload of the database, how much entries u may have each day and on monthly bases. but one thing u should kept in ur mind to logically devide ur database based on the departments . that is try to think about different tablespace for diff.departments and make multiple files in each tablespace.SGA ROUGHLY SHOULD BE 50% OF UR RAM
    and RAM should be according to workload.


    bhatia_dba

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