Benefits and drawbacks of sequential file organisation, Database Management System

Assignment Help:

Benefits of Sequential File Organisation

It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system).

Drawbacks of sequential File Organisation

Needs that all new transactions be sorted into the proper series for sequential access processing.
Storing, Locating, modifying, deleting, or adding records in the file need rearranging the file.
This process is too slow to handle applications needs immediate responses or updating.

Related Discussions:- Benefits and drawbacks of sequential file organisation

What do you understand by data ware house, Question 1: Define the term ...

Question 1: Define the term business intelligence tools? Briefly explain how the data from one end gets transformed into information at the other end? Definition Exp

Maping constraits, #question.what is mapping constraints and types?.

#question.what is mapping constraints and types?.

What three major types of actions includes databases, What three major type...

What three major types of actions includes databases? Briefly discuss these The three major types of actions including databases are: (i) Defining: It includes specifyin

Backup - restore utilities, These are designed to reduce the effects of a d...

These are designed to reduce the effects of a database failure and make sure a database is restored to a consistent state if a failure does arise. Manual backup/restore utilities n

Naïve bayesian approach-id3 algorithm, You are working for the ABC Telecom ...

You are working for the ABC Telecom and are given some customer records for data mining. You are asked to discover, from the data, patterns that characterize low-, medium- and high

What is dag, What is DAG? The class-subclass relationship is shown by a...

What is DAG? The class-subclass relationship is shown by a directed acyclic graph.eg: employees can be temporary or permanent. We might be create subclasses temporary \and perm

Log based recovery, under what condition log based recovery is feasible?

under what condition log based recovery is feasible?

The concurrent transactions, The Concurrent Transactions Almost every ...

The Concurrent Transactions Almost every commercial DBMS support multi-user environment. Therefore, allowing multiple transactions to proceed concurrently. The DBMS must make

Data fragmentation, Data Fragmentation "Fragmentation includes decompos...

Data Fragmentation "Fragmentation includes decomposing the data in relation to non-overlapping component relations". Why do we require fragmenting a relation?

Explain p command in the respect of qbe, Explain P command in the respect o...

Explain P command in the respect of QBE? P: It is the command in which is used to print (logically display) the value of the attribute in whose cell it is writ

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages