Database Partitioning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Database Partitioning

  1. #1
    Join Date
    May 2001
    Location
    Boston
    Posts
    24

    Question

    Can anyone let me know what is database partitioning and
    useful link where I can learn more about it.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Are you talking about Table Partition?

  3. #3
    Join Date
    May 2001
    Location
    Boston
    Posts
    24
    Is there anything like Database partitioning other than table partitioning?

  4. #4
    Join Date
    May 2001
    Posts
    49
    No, I never heard of Database Partitioning.
    Good question..
    Rekha

  5. #5
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Why tamilselvan asked you this question I feel is because Logically if you consider a Database it is made up of tablespaces and there at least one or many physical datafiles assiciated with each tablespace.We place the datafiles in different Hard Disks or storage media so that the performance of the data being accessed is no way slow and offcourse it is easier for maintainence so we can still call this as database partitioning.

    Whereas table partitioning is ur having a table which is split across different talbespace so that the performance is enhanced and easier to access.For example

    Let us consider a table EMP which has the following fields

    Empno
    Ename
    Bonus
    salary

    I can store the data as follows by using table partitioning

    For empno

    1-10000 -> users tablespace
    10000-20000 -> users1 tablespace
    20001-30000 -> users2 tablespace
    rest of them -> users3 tablespace

    Remember each and every tablespace has a physical datafile associated with it which might be in different hard disks so the access and storage of the data is real fast

    Hope this helped

    Regards
    Santosh

  6. #6
    Join Date
    May 2001
    Location
    Boston
    Posts
    24
    Thanks santosh.I got it.

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