Wednesday, 6 August 2014

What is Data Storage - Definition Language?


The storage structures and access methods used by database system are specified by a set of definition in a special type of DDL called data storage-definition language.

What is 'inode'?

     
All UNIX files have its description stored in a structure called 'inode'. The inode contains info about the file-size, its location, time of last access, time of last modification, permission and so on. Directories are also represented as files and have an associated inode. In addition to descriptions about the file, the inode contains pointers to the data blocks of the file. If the file is large, inode has indirect pointer to a block of pointers to additional data blocks (this further aggregates for larger files). A block is typically 8k.
Inode consists of the following fields:
Ø  File owner identifier
Ø  File type
Ø  File access permissions
Ø  File access times
Ø  Number of links
Ø  File size

Ø  Location of the file data