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
Determine the Objectives of object oriented design provide an overview of object oriented design; partitioning system to subsystems; describe how a software desig

Explain the term- Periodic recomputation Periodic recomputation:  Base values are often updated in bunches. Sometimes, it is possible to just recompute all derived attributes p

What is the difference between SQL Server 2000 clustered and nonclustered indexes? With a clustered index, the data are kept in the bottom level of the index and in the similar

Differentiate sub-class and super-class? The specialization of a class is known as subclasses.eg: employee is a subclass of person and teller is a subclass of employee. Convers

What is a Phantom Deadlock? In distributed deadlock detection, the delay in propagating local information might cause the deadlock detection algorithms to recognize deadlocks

Discuss how the bi-directional Implementations are made. In bi-directional implementation of the association, a pair of references must implement every link. The declarations a

CREATE YOUR DATABASE TABLES Your database project must have a minimum of four tables. Include the SQL scripts used to create the tables in your documentation. Explain the tables

Whst is logical schema ? Logical schema is the entire database.

Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i

When is UPDATE_STATISTICS command used? - When processing of large data is done, this command is used. - Whenever large number of modification, deletions or copy takes place