The internal or physical level in dbms, Database Management System

The Internal or Physical Level

The collection of files permanently stored on secondary storage devices is called as the physical database. The internal or physical level is the one nearby to physical storage, and it gives a low-level description of the physical database, and an interface among the operating systems file system and the record structures used in higher levels of abstraction. It is at the level that record types and methods of storage are definite, as well as how stored fields are shown, what physical sequence the stored records are in, and what other physical structures exist.

 

Posted Date: 3/5/2013 5:01:36 AM | Location : United States







Related Discussions:- The internal or physical level in dbms, Assignment Help, Ask Question on The internal or physical level in dbms, Get Answer, Expert's Help, The internal or physical level in dbms Discussions

Write discussion on The internal or physical level in dbms
Your posts are moderated
Related Questions
Describe the functions and features of foreign key? Foreign Key : The primary key of one file or table that is implanted in another file or table to implement the relationships

Server Control It is usual to control access to the data via the front end application, for example by displaying data as ‘read only'. This part of the assignment illustrates ho

The need for three level architecture The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.

Physical Database Design Issues The database design includes the process of logical design with the use of E-R diagram, normalisation, etc., followed by the physical design.

entity relationship diagram for online examination system

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

Primary index A primary index is a file that has a sorted series of records having two columns: a block address for that key field in the data file; and the ordering key field.

Explain Strict Two-Phase locking A transaction T does not release any type of its exclusive (X) locks until that transaction commits or aborts. In this method no other transact

This constraint shows that the key attribute value in each tuple must be unique, i.e., no two tuples have the similar value for the key attribute. This is because the value of the

MySQL statements for extending the database to incorporate new facilities Deliverables for submission You must submit the following deliverables in the Assignment Dropbox in