File manager-database management system, Database Management System

File Manager

File manager handles the allocation of space on disk storage. It starts and maintains the list of structures and indices described in the internal schema that is used to show information stored on disk. Therefore, the file manager does not directly manage the input of data and physical output. It passes the requests on to the suitable access methods, which either write data or read data from into the system cache or buffer. The file manager can be executed using an interface to the existing file subsystem given by the operating system of the host computer or it can have a file subsystem written especially for the DBMS.

 

Posted Date: 3/5/2013 5:12:27 AM | Location : United States







Related Discussions:- File manager-database management system, Assignment Help, Ask Question on File manager-database management system, Get Answer, Expert's Help, File manager-database management system Discussions

Write discussion on File manager-database management system
Your posts are moderated
Related Questions
Define Aggregate functions and what aggregate functions supported by the MySQL To calculate a summary value from a set of individual values and uses one of the functions known

Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

What do you mean by Correlated subquery? Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is writ

How does a query tree represent a relational algebra expression?  Discuss any three rules for query optimisation, giving example as to when should each rule be applied.     Ans

What are the advantages and disadvantages of merging an association into a class?  Advantages: i)  Less number of tables ii) Faster performance due to the fewer tables

Foreign Keys and NULL Let us take the relation:                 DEPT DEPT ID DNAME BUDGET D1 M

Define object-relational systems? Systems that give object-oriented extensions to relational systems are known as object-relational systems.

I need solution of the question posted at http://www.expertsmind.com/questions/sql-query-for-testing-triggers-and-stored-procedures-30140149.aspx

Discuss deferred update technique of recovery.  What are the advantages?  Ans:  The deferred update methods do not physically update the database on disk till after a transact

Given the following set of functional dependencies {cf?bg, g?d, cdg?f, b?de, d?c} defined on R(b,c,d,e,f,g) a.Find a non-redundant cover. b.Find a canonical cover.