Kindly explain the Concepts

[sammy]

I want to know what is chunk and extent in database concept. Can someone provide a detailed idea on this.

[ashlee]

Extent is space allocated by database server to store data plus the additional storage space for additional storage. Chunk is the largest unit of physical disk allocated by database server for data storage.

[rachelle]

It was a brief explanation. So does it mean an extent is a sub portion of chunk. Kindly tell me whether my idea is correct.

[Adrian]

Yes you have got it absolutely right. An extent is always entirely contained in a chunk. That is the extent cannot cross chunk boundaries.

[cyrus]

Will there be separate team of people for producing logical database design and physical database design in companies or will it be carried out by the same team.