Benefits and drawbacks of heap files, Database Management System

Assignment Help:

Benefits of heap files

1. This is a easy file Organisation method.

2. Insertion is somehow capable.

3. Good for bulk-loading data into a table.

4. Best if file scans are general or insertions are frequent.

Drawbacks of heap files

1. Retrieval needs a linear search and is inefficient.

2. Deletion can result in unused space/require for reorganisation.

Related Discussions:- Benefits and drawbacks of heap files

Integrity of a database enforced by integrity rules, Question: This Que...

Question: This Question refers to the database schema given in the Appendix. (a) The integrity of a database is enforced by integrity rules. Discuss what should happen on a

Describe relational model, Describe relational model? Structure of rela...

Describe relational model? Structure of relational data base Basic structure Database schema Keys Schema diagram Query languages

Explain the static or conservative two phase locking, Explain the Static or...

Explain the Static or conservative Two Phase Locking: Static (or conservative) Two Phase Locking: In this type of scheme, all the data items are locked earlier than any opera

Explain data models namely relational network - hierarchical, Explain the t...

Explain the three data models namely relational, network and hierarchical and evaluate their relative advantages and disadvantages. Hierarchical Model: In hierarchical model, da

Example-revoke all on emp from mca12, Example: //REVOKE ALL ON EMP FROM MC...

Example: //REVOKE ALL ON EMP FROM MCA12; (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-

Increased parallelism-data replication, Increased parallelism : Since the r...

Increased parallelism : Since the replicated date has several copies a query can be distributed or can be answered from the smallest loaded site. Also, with more replicas you have

Explanation on data sharing, Explanation on Data Sharing?

Explanation on Data Sharing?

What is foreign key, What is foreign key? A relation schema r1 derived ...

What is foreign key? A relation schema r1 derived from an ER schema may contain among its attributes the primary key of another relation schema r2.this attribute is known as a

Explain the systems development life cycle, Explain the systems development...

Explain the systems development life cycle. This is the traditional method to develop, maintain, and replace information systems that contains the project identification and se

Define deferred update technique of recovery, Discuss deferred update techn...

Discuss deferred update technique of recovery. What are the advantages? Ans: The deferred update methods do not physically update the database on disk till after a transact

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages