Storage of database on hard disks, Database Management System

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.

Posted Date: 3/7/2013 6:06:33 AM | Location : United States







Related Discussions:- Storage of database on hard disks, Assignment Help, Ask Question on Storage of database on hard disks, Get Answer, Expert's Help, Storage of database on hard disks Discussions

Write discussion on Storage of database on hard disks
Your posts are moderated
Related Questions

#Use the following database schema: 1) Patient—PatientID, Name, DOB 2) Doctor—DoctorID, Name, MedLicenseNumber, Phone 3) Medication—MedicationID, BrandName, GenericName 4) Prescrip

Assignment #1 Data Management The questions on this exam are based on the Baxter Aviation case scenario. 1. (5 points) The systems analyst proposes the following two relationshi

We are looking to find someone to prepare a database which improves upon the one we are using at present. The present database will be found here: Click on filter options and yo

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

Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's Web site (or create the tables in Table 4-5 in a relational DBMS product). Write queries to answer

XYZ is a large chain of home entertainment rental over 100 stores distributed over all states in Australia. XYZ lends entertainment products such as movies, TV shows and games on v

Explain the Management of Data Store Every system irrespective of its nature of application requires storing permanent data for consequent use in problem solving. Some objects

What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and

What is multiplicity in the associations? Give an example to explain multiplicity? Multiplicity in association indicate number of objects participate in any relationship. For