File Organisation-1

Data base is a collection of files,each files is a collection of records,each record is a sequence of fields.

Blocking factor:

blocking factor is the avg no of records per block.


There are some strategies for storing file of record into block and they are as follows:

1)Spanned Strategy:

It allows partial part of record that can be stored in a block.It is suitable for variable length record.

some time we try to fatch the web page and put them as a record in a database and every webpage may have different sizes in that cas we use spanned stratergy.

Advantages: No wastage of memory

Disadvantage:Block access increases


2)UnSpanned Straregy:

no record can be stored in more than 1 block.It is suitable for fixed  length record.

If company record has eemploee data base that are fixed size ,in such case we go for un spanning.

Advantage: block access reduced

Disadvantage: wastage of memory





What to read next

Please Go through all these linksW3Schools – HTML Tutorial

DefinitionFiber optics is the technology used to transmit information as pulses of light through strands of fiber made of glass or plastic over long