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

What is data independence, What is data independence? Data Independenc...

What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data

Which is an advantage of view, Which is an advantage of view? The Advan...

Which is an advantage of view? The Advantages of view is Data security, Derived columns and Hiding of complex queries

Two approaches to store relations in distributed database, What are the two...

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

Examine about the behavioural diagrams, Examine about the Behavioural Diagr...

Examine about the Behavioural Diagrams The main objective of behavioural diagrams is to visualize, specify, construct and document dynamic aspects of a system. The interactio

In which format database schema is written, In which format database schema...

In which format database schema is written ? Data base schema is written in the DDL format.

Extended star schema, Northwind Pty Ltd sells a variety of food products th...

Northwind Pty Ltd sells a variety of food products throughout the world. They want to use the reporting features of SAP's Business Information Warehouse to better understand their

Describe the objective of structural diagrams, Describe the objective of St...

Describe the objective of Structural Diagrams The main objective of structural diagram is to visualize, construct, specify and document static aspects of a system. Their eleme

Concurrency control, Give the two reasons for allowing concurrency

Give the two reasons for allowing concurrency

What is a merge sort, QUESTION (a) Using an appropriate example, explai...

QUESTION (a) Using an appropriate example, explain what is a recursive function? (b) Explain in detail the C++ function given below. void search2(int list[],int n,int ele

E - r schema with weak entity, Consider the E/R schema with weak entity set...

Consider the E/R schema with weak entity sets shown below. Come up with the SQL CREATE TABLE statements (with appropriate primary key, unique and foreign key constraints). Include

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages