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
How to create a biological database based on viruses. How to decide which attribute should be there in the table and schema? How to identify the primary keys, foreign keys, domain,

What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock?         Ans: A few transaction will must rolled back (made a victim)

Mention the type of constraints we can specify in the CREATE command of DDL. The type of constraints that can be specified are as follows:- PRIMARY KEY, NOT NULL, UNIQUE, FOR

The figure below depicts the conceptual diagram of a banking system. (a) Describe one example relevant to the system in figure, for each of the 4 types of enterprise appl

In Database software have only pure security or some dis secured by administrator?

The External or View Level The external or view level is the highest level of abstraction of database. It gives a window on the conceptual view, which permits the user to see

What is the use of with clause in SQL? The with clause gives a way of defining a temporary view whose explanation is available only to the query in which the with clause occurs

I have a small project that contains 3 deliverable s. I have done the first one and I would like you to help me with second one

Define about the Stored Procedure - It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks. - When you essentiall

under what condition log based recovery is feasible?