The logical dbms architecture, Database Management System

The Logical DBMS Architecture

Database Management Systems are very difficult, sophisticated software applications that give reliable management of huge amounts of data. To explain general database concepts and the structure and capabilities of a DBMS better, the structural design of a typical database management system should be studied.

There are two dissimilar ways to look at the architecture of a DBMS: the physical DBMS architecture and the logical DBMS architecture. The physical architecture is deals with the software components that create up a DBMS while the logical architecture deals with the way data is stored and presented to users.


Posted Date: 3/5/2013 4:53:07 AM | Location : United States

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

Write discussion on The logical dbms architecture
Your posts are moderated
Related Questions
DROP TABLE Command: When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the databas

Define hot swapping? Hot swapping permits the removal of faulty disks and changes it by new ones without turning power off. Hot swapping decreases the mean time to repair.

Inconsistent Analysis : The problem as given with transactions T1 and T2 where two transactions interleave to make incorrect result during an analysis by Audit is the instance of s

Super keys of a relation can have extra attributes. Candidate keys are minimal super key, i.e. such a key have no extraneous attribute. An attribute is known as extraneous if even

The Third Normal Form (3NF) Even though, transforming a relation that is not in 2NF into a number of relations that are in 2NF take out many of the anomalies, it does not neces

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

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

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

What do you mean through integrity constraints? Integrity Constraints -An integrity constraint is a condition specified on a database schema and restricts the data in which

Explain Foreign Key? Foreign Key - Let there are two relations (tables) R and S. Any candidate key of the relation R that is referred within the relation S is known as the fo