Database Partitioning

[GRAVIS]

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

[tamilselvan]

Are you talking about Table Partition?

[GRAVIS]

Is there anything like Database partitioning other than table partitioning?

[Rekha]

No, I never heard of Database Partitioning.
Good question..

[santoshym]

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

[GRAVIS]

Thanks santosh.I got it.