File Operations

Operations on database files can be broadly classified into two categories −

• Update Operations
• Retrieval Operations

Update operations change the data values by insertion, deletion, or update. Retrieval operations, on the other hand, do not alter the data but retrieve them after optional conditional filtering.

In both types of operations, selection plays a significant role. Other than creation and deletion of a file, there could be several operations, which can be done on files.

• Open − A file can be opened in one of the two modes, read mode or write mode. In read mode, the operating system does not allow anyone to alter data. In other words, data is read only. Files opened in read mode can be shared among several entities. Write mode allows data modification. Files opened in write mode can be read but cannot be shared.
• Locate − Every file has a file pointer, which tells the current position where the data is to be read or written. This pointer can be adjusted accordingly. Using find (seek) operation, it can be moved forward or backward.
• Read − By default, when files are opened in read mode, the file pointer points to the beginning of the file. There are options where the user can tell the operating system where to locate the file pointer at the time of opening a file. The very next data to the file pointer is read.
• Write − User can select to open a file in write mode, which enables them to edit its contents. It can be deletion, insertion, or modification. The file pointer can be located at the time of opening or can be dynamically changed if the operating system allows to do so.
• Close − This is the most important operation from the operating system’s point of view. When a request to close a file is generated, the operating system
  • removes all the locks (if in shared mode),
  • saves the data (if altered) to the secondary storage media, and
  • releases all the buffers and file handlers associated with the file.

The organization of data inside a file plays a major role here. The process to locate the file pointer to a desired record inside a file various based on whether the records are arranged sequentially or clustered.

Disadvantages of File system

• Data redundancy and inconsistency.
• Difficulty in accessing data
• Data isolation
• Integrity problems.
• Atomicity problems.
• Concurrent-access anomalies
• Security Problem
  • Advanced recovery techniques in a database
  • Indexing Techniques in a Database