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

Ask an Expert

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

Write your message here..

Related Questions

Describe the functions and features of foreign key, Describe the functions ... 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

Relational declarative database language environment, Server Control It ... 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 need for three level architectur... 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, Physical Database Design Issues The da... 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.

Online examination system project, entity relationship diagram for online e... entity relationship diagram for online examination system

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

Primary index, Primary index A primary index is a file that has a sorte... 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, Explain Strict Two-Phase locking A tr... 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

Key constraint - relational constraints, This constraint shows that the key... 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

Create table statements for original database, MySQL statements for extendi... MySQL statements for extending the database to incorporate new facilities Deliverables for submission You must submit the following deliverables in the Assignment Dropbox in