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
Explain the following functions of Oracle with suitable examples: (i) To_Char( ) (ii) Count( ) (iii) Trim( ) (iv) Length( ) Ans: (i) To_char( ): The TO_CHAR function conver

Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le

Let us first look into some of the important features of ER model. Entity relationship model is a high-level conceptual data model. It permits us to define the data invo

basic structure of xml

What is an ER diagram? Why is it used in Database management system (DBMS)?

Define average seek time. The average seek time is the average of the seek times, calculated over a sequence of random requests.


An instance of relational schema R (A, B, C) has distinct values of A including NULL values. then A is a candidate key or not? If relational schema R (A, B, C) has distinct val

UNION If R1 and R2 are two union compatible relations then R3 = R1 ∪ R2 is the relation having tuples that are either in R1 or in R2 or in both. In case, R3 will have tuples

Explain the Cartesian product:  The Cartesian product operation does not need relations to union-compatible.  The meaning of this is that the involved relations may have dissim