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
Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined):       Ans:  The relational database schema f

Define the five basic operators of relational algebra? Five basic operators of relational algebra are: 1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both

I want Database Of United Kingdom with Criteria of:\r\n\r\n1). Name, Number, City, State, Postal Code, Address, Email id, DOB.\r\n\r\n2). Unsecure Debts only adds Credit Card Payme

Data Independence This brings us to our next topic: data independence. It is the property of the database which tries to make sure that if we make any change in any level of sc

Consider a database schema consisting of four relations, whose schemas are: Product (maker, model, type) PC (model, speed, ram, hd, price) Laptop (model, speed, ram, hd, s


Define Cascading rollback The phenomenon where a single transaction failure leads to a series of transaction rollbacks is known as Cascading rollback.

What are the two approaches to store relations in distributed database? a) Replication b) Fragmentation

Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th

In Database software have only pure security or some dis secured by administrator?