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 do you understand by ACID? - ACID (Atomicity Consistency Isolation Durability) is a quality sought after in a reliable database. Here's the relevance of each quality:

What Count function return in SQL? Count function within SQL returns the number of values. (Count function counts all the not null values in the exact column. If we need to cou

What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

What is Asterisk in SQL? Asterisk (*): In SQL, the columns for all the tables and views in the FROM clause will be displayed.

a) Distinguish between ‘database' and ‘Database Management Systems (DBMS)'. b) List and briefly describe five potential benefits of the database approach compared to conventio


Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or   among various values of the sam

Explain data independence ? Data independence is the capacity to modify the schema at one stage of a database system without having to change the schema at the further level.

CAN SOMEONE HELP ME WITH ENTITY DIAGRAMS IN FIRST NORMAL FORM?

Describe the various types of Online Analytical Processing (OLAP) tools and briefly discuss how the support common analytical operations.