Physical dbms architecture, Database Management System

PHYSICAL DBMS ARCHITECTURE

 The physical architecture defines the software components used to process and enter data, and how these software components are related and interconnected. Though it is not possible to simplify the component structure of a DBMS, it is possible to recognize a number of key functions which are similar to most database management systems. The components that normally execute these functions are shown in Figure , which depicts the physical architecture of a typical DBMS.

2386_DBMS structure.png

                                                              Figure: DBMS Structure

Based on many functions, the database system may be partitioned into the following modules. Some functions (for example, file systems) may be given by the operating system.

Posted Date: 3/5/2013 5:08:11 AM | Location : United States







Related Discussions:- Physical dbms architecture, Assignment Help, Ask Question on Physical dbms architecture, Get Answer, Expert's Help, Physical dbms architecture Discussions

Write discussion on Physical dbms architecture
Your posts are moderated
Related Questions
gyan gurukul is a software company that provides software related solution.

INTRODUCTION Databases and database systems have become an essential part of our daily life. We encounter many activities that involve some interaction with a database almost

The entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No o

What is Message switching Message switching transmits data units which can be arbitrarily long. Packet switching has a utmost packet size, if any message longer than that, it s

Define multivalued dependency and 4NF.  Ans:  Multivalued Dependency - Assume R be a relation schema and let α ⊆ R and β ⊆ R. The multivalued dependency  α →→β   holds o

What is the need for triggers? Triggers are useful mechanisms for alerting humans or for starting particular tasks automatically when particular conditions are met.

sql is relationally complete-justify

Example:  //REVOKE ALL ON EMP FROM MCA12;                              (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-

write a short note on participation role? Participation role: roles are indicating in E-R diagram by labelling the lines that connect diamonds to rectangles.

For the relations answer the following queries in SQL Street (name, location, city) House (number, street_name) Lives (name, house_number) (i) Obtain the names of persons who liv