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
Consider the subsequent relations for a database which keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, start_year, Dept_no) TRIP (SSN, Fr

what is relationship inheritance and attribute inheritance

What is object containment? References among objects can be used to model dissimilar real-world concepts.

Greater potential for bugs: Since the sites of a distributed system operate simultaneously, it is more complex to ensure the correctness of algorithms. The art of constructing dis


UNION If R1 and R2 are two union compatible relations then R3 = R1 ∪ R2 is the relation having tuples that are either in R1 or in R2 or in both. In case, R3 will have tuples

Define average seek time. The average seek time is the average of the seek times, calculated over a sequence of random requests.

What is substitutability? Any method of a class-say A can equally well be adjured with any object belonging to any subclasses B of A. This characteristic leads to code reuse, a

List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

What are the DBMS languages? Briefly explain? Data Definition language (DDL):A database schema is specified through a set of definitions expressed through a special language