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
read-set(T) : Each data items that are read by a transaction T Timestamps : for all transaction T, the start-time and the end time are reserved for all the three phases.

Function requirement as given: 1> manage fans and likes and followings those information from facebook. twitter. google+ and linkedin etc 2> Organize the clients from email m

Give two profit of Reuse of Code. Reusing the implementation . Place existing class directly inside a new class. The new class can be made up of any number and type of the oth

What is Candidate Key Super Key or Candidate Key: It is such an attribute of a table that can uniquely recognize a row in a table. Generally they have unique values and can n

What is catalog in DBMS? Catalog - A relational DBMS maintains information about every table and index in which it contains. A catalog is a collection of special tables that st

Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department.

System level permissions : With the use of data dictionary you can view them.       Let us take the table name as user_sys_privs (used in oracle).       DESCRIBE USER_SYS_PRI

Describe in brief about the Sequence Diagrams Sequence diagrams are interaction diagrams which emphasize time ordering of messages. In UML, it is shown as a table which shows

Project Description: I would like to get a database of a website which has clients email name and phone number. If you are able to get information from a website, by entering

Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department. SELECT DEPTNO, MIN (SAL)