Benefits and drawbacks of sequential file organisation, Database Management System

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.

 

 

Posted Date: 3/7/2013 6:16:40 AM | Location : United States







Related Discussions:- Benefits and drawbacks of sequential file organisation, Assignment Help, Ask Question on Benefits and drawbacks of sequential file organisation, Get Answer, Expert's Help, Benefits and drawbacks of sequential file organisation Discussions

Write discussion on Benefits and drawbacks of sequential file organisation
Your posts are moderated
Related Questions
What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.

A relation has: Relational Schema Relation instance Relational Schema: A relational schema shows the relation's name, its attributes and the domain of every a

The following data are required to be stored by a family physician. Family#, FamilyAddress, Patient#, PatientName, ServiceCode, ServiceFee, ServiceDate A family can have seve

#questiontypes of keys examples..

We want have a website; we need to test the security of our website. You need to: -Try to bypass our security by simulate a website hacking -Try some hack Techniques like

What is recursive closure? Why is it not possible to describe this operation in relational algebra? Recursive closure is applied to recursive relationship. An instance of rec

What is Conceptual Schema? Conceptual Schema - Conceptual schema elaborates the structure of the overall database for a community of users. It hides the details of physical sto

What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the

Explain I command in QBE ? I : It is the command in QBE that is used to insert tuple (s) into the database

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