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

Data analysis and design, #question benefits and limitations of data models...

#question benefits and limitations of data models..

Aggregation, What does Aggregation mean?

What does Aggregation mean?

Explain interblock gap, Explain Interblock gap? Interblock Gap - A trac...

Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th

What is recovery management component, What is recovery management componen...

What is recovery management component? Ensuring durability is the responsibility of a software component of the base system known as the recovery management component.

Concurrency control, discuss the purpose of the concurrency control?

discuss the purpose of the concurrency control?

Define query by example, Define Query by Example QBE is a query languag...

Define Query by Example QBE is a query language relies upon domain calculus and has two dimensional syntax. The queries are written in the horizontal and vertical dimensions of

What are the physical characteristics of magnetic disks, What are the physi...

What are the physical characteristics of magnetic disks? Ans: A magnetic disk is a circular plate or platter of plastic or metal that is coated with magnetizable material lik

Functional dependencies, CAR SALE (Car_id, Option_type, Option_listprice, S...

CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., cruise control) that were sold at a de

Give the general form of sql query, Give the general form of SQL query? ...

Give the general form of SQL query? Select A1, A2............., An From R1, R2..............., Rm Where P

Describe the statement in sql which allows to change, Describe the statemen...

Describe the statement in SQL which allows to change the definition of a table? In SQL Alter statement is used to allow the changes the definition of a table.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages