Showing posts with label DBMS Tutorial. Show all posts
Showing posts with label DBMS Tutorial. Show all posts

Wednesday, June 05, 2013

Database Management System Architecture: DBMS Architecture

Leave a Comment Follow us on twitter
In this DBMS tutorial we are going to discuss about architecture of Database Management System (DBMS), also called as three-level architecture. Database Management System (DBMS) architecture is used to distinguish between the physical database and user applications. Let's see the different levels of Architecture.

Also read :



Physical Level


Also known as Internal Level. It basically describes how actually the data is stored. The reason why it is called internal level is, it has an internal schema which shows the physical storage of database. This is the first level of DBMS Architecture.

Conceptual Level


This is the second level of DBMS Architecture. It has conceptual schema which describes how the data is shown to the community users.

View Level


Also known as External Level. This is the third and highest level of DBMS architecture. As it is view level, it includes how the data is viewed to each individual i.e. user.

READ MORE...

Friday, May 31, 2013

An Overview to Database Management System (DBMS)

Leave a Comment Follow us on twitter
In this post we are going to learn about Database Management System (DBMS): An Overview. Now the question arises that What actually is the Database Management System? So before going though the DBMS concept we are going to see what actually is Database.

Database is nothing but the collection of Data. Taking example of "School" which stores the data of students. Another good example is "Library" which stores Books data. Now moving back of our main question i.e. Database Management System (DBMS) is the collection of Database. In other words, it is a software or system which enables to insert, update and select the data from database.

Common examples of Database Management System are Oracle, Gupta SQL, FoxPro etc. We generally use the Database Management System in Railway, Banking, Hospitals, Airlines, Schools, Universities and many more.


What is the need for Database Management System?

Many of you are thinking that What is the Need for Database Management System? Why should we use Database Management System and many more... The answer is very simple. Here are some point that will show you the Need for DBMS. They are :

* Data is difficult to access i.e. Data cannot be retrieved in a convenient and efficient manner using file system. Suppose you have a saving account in a bank with fields account number, name, address and balance; and you are asked to show the account name having balance greater than Rs. 5000 and if the program is not written then it is difficult to do that.

* Inconsistency and Redundancy of Data i.e. As the data is stored at multiple places. So redundancy means duplication of data. Because of data redundancy, file system suffers from data inconsistency which means attribute values changes at different places.

* Security i.e. Security is an essential factor in all fields. Database Management System provides the security feature to the database and protect the database from the intruders.

* Concurrency Control i.e. Some times more than one transaction are using the same data item at the same time which will result into inconsistency in database. To remove this inconsistency we use Concurrency Control which is the feature of Database Management System. This feature is not available in Application program.

I hope that the concepts of database, database management system and need of database management system are now cleared to you.
READ MORE...