buy cheap web hosting


What is Clustering? What are its types.

Database

CLUSTERING: If the page containing the requested record is already in the memory, retrieval from the disk is not necessary. In such a situation time taken for the whole operation will be less. Thus, if records which are frequently used together are placed physically together, more records will be in the same page. Hence the number of the pages to be retrieved is less and this reduces the number of disk accesses which intern gives a better performances. “The method of storing logically related records, physically together is called clustering.”

Types of Clustering::

  • INTRA FILE CLUSTERING: - Clustered records belong to the same file.
  • INTER FILE CLUSTERING: - Clustered records belong to different files. This type of clustering may be required to enhance the speed of queries retrieving related records from more than one table. Here interleaving records is used.

 

Bookmark and Share




Gallery

Related Topics

Comments



Submit Reviews:


(Enter the characters seen on the image below.)



Promotional Ads

Advertisement

New DTH DISH HD Connection
Geeta Enterprises 2521 Mari Wala town
Manimajra
Chandigarh

Leo Safe Packers and Movers in Chandigarh
lot-34,1st Floor, New Timber Market,Transport Nagar
Secto 26,Chandigarh
Chandigarh

Woodville High School
11 Actil Avenue
St Clair SA 5011
Adelaide

Cedar College
215-233 Fosters Rd Northgate
South Australia 5085
Adelaide

Adelaide High School
West Terrace Adelaide
South Australia 5000
Adelaide

Mohinder GST TDS TAN Consultant Panchkula
12 Maheshpur Sector 21 Panchkula
Panchkula

ALARSIN (PHARMACEUTICALS)
A/32 Street No. 3
M.I.D.C. Andheri (East)
Mumbai

ALICE PHARMA PVT. LTD.
A-302 Everest Nivara Infotech Park
MIDC Main Road Indira Nagar Turbhe
Navi Mumbai

Roller shutter in melbourne
18 Kooyong Way Craigieburn
East Melbourne

Seal Care (S) Pte Ltd - Mechanical seal Singapore
106 Bedok Reservoir Road, #08-378
Singapore