Storage of database on hard disks, Database Management System

Assignment Help:

Storage Of Database On Hard Disks

At this point, it is worthwhile to note the difference among the terms file Organisation and the access method. A file organisation shows to the organisation of the data of a file into blocks, records and access structures; this contains the way records and blocks are placed on the storage medium and interconnected. An access method, on the other hand, is the mode how the data can be retrieved based on the file Organisation.

Mainly the databases are stored persistently on magnetic disks for the reasons given below:

  • The databases being very big may not set completely in the main memory.
  • Storing the data permanently using the non-volatile storage and give access to the users with the help of front end applications.
  • Primary storage is considered to be very costly and in order to cut short the cost of the storage per unit of data to substantially less.

Every hard drive is usually composed of a set of disk platters. Every disk platter has a layer of magnetic material deposited on its surface. The whole disk can have a large amount of data, which is organised into minor packages known as BLOCKS (or pages). On most computers, one block is equal to 1 KB of data (= 1024 Bytes).

A block is the least unit of data transfer among the processor and the hard disk of the computer. Every block thus has a fixed, address, assigned. Typically, the computer processor will give in a read/write request, which contains the address of the block, and the address of RAM in the computer memory area known as a buffer (or cache) where the data must be stored / taken from. The processor then reads and changes the buffer data as needed, and, if needs, writes the block back to the disk. Let us observe how the tables of the database are stored on the hard disk.


Related Discussions:- Storage of database on hard disks

#cursor, #what is cursor its uses ? Explain it

#what is cursor its uses ? Explain it

Describe the nested-loop join and block-nested loop join, Describe the nest...

Describe the nested-loop join and block-nested loop join.   Ans:   The block nested- loop join algorithm is as described below:     for every block B r of relation R do beg

Draw enhanced er-diagram for hierarchy of a student database, Draw an EER d...

Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)

Database management issues, You are required to write a report which evalua...

You are required to write a report which evaluates two of the following issues in relation to your case study database: a. Security issues b. Performance issues c. Backup

How can redundant associations be done, How can Redundant Associations be d...

How can Redundant Associations be done It can be done by asking questions: i)  Is there a specific arrangement of network which would optimize critical aspects of completed

Types of locks, Types of Locks There are two necessary types of locks: ...

Types of Locks There are two necessary types of locks: Binary lock : This locking mechanism has two states for to a data item: locked or unlocked Multiple-mode loc

Which is the properties of entities, Which is the properties of entities? ...

Which is the properties of entities? Attributes is the properties of entities.

Describe the composite key, Describe the Composite Key Composite Key: ...

Describe the Composite Key Composite Key: Sometimes one key is not enough to uniquely recognize a row. E.g. in a single class Roll is enough to search a student, but in the w

Cascading, what is cascading? what is rollback cascading? please explain in...

what is cascading? what is rollback cascading? please explain in detail

What is natural language interfaces, What is Natural Language Interfaces? ...

What is Natural Language Interfaces? Natural Language Interfaces - These interfaces accept requests written within English or a few other language and attempt to "understand" t

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd