Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Logical Database design

    Hi,

    I need some assistance for one of my assignments. Is there a programmer who can help me out with the following questions? Thanks!


    What file organizations are available in the various DBMSs used in your organization?
    What factors do you consider when selecting an organization for database files?
    For indexed files, how do you decide what indexes to create?
    Are indexes ever deleted? Why?

  2. #2
    Join Date
    Jan 2004
    Posts
    7

    *Correction, Physical Database design

    Actually this is for physical database design and not logical.

    Thanks

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    We probably use several hundred file organizations, if you mean file formats instead of just topographies.

    The factors that I consider are deployment platform (and in some cases the availability of the server platform as well), the initial user base, the potential user base (systems either grow or die, they almost never stay "stable"), and of course the cost.

    We no longer support any file formats that are intrinsically indexed. Nearly all of them support internal index structures (usually via SQL or another query language), but none that are external to the database engine.

    Some indicies are relatively constant. They live as long as the underlying structure (in SQL a table) does. Others come and go according to a schedule (for example warehousing query indicies are dropped before load, then rebuilt). Still other indicies are built and destroyed on a whim (sometimes built only to support a specific user query).

    -PatP

Posting Permissions

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