DATABASE MANAGEMENT SYSTEM (DBMS)

Data : Data are the raw facts,the word raw indicates the facts have not proceed to reveal their meaning . The row data must be properly formatted for storage, processing and presentation.

Information : Information is the result of processing row data to reveal it's meaning . Data processing is simple as organizing data.

DATABASE : Database is a collection of data and information and it is form a structure that store a collection of data.

Database management system ( DBMS ) :

A DBMS is a collection of database and management system . The database is a collection of data and management is a set of programs to store and manage the data.

                    A DBMS developed for to store a large amount of data . There are two things that required optimization : storage of data and retrieval of data .

STORAGE OF DATA : In DBMS the data is stored in thousands, it require less space and it is remove duplicate data before storage.

RETRIEVAL OF DATA : Retrieval means manage a storage data . It is important that in DBMS . It is quickly access to adding a new data ( or ) delete data .

OBJECTIVES OF DBMS :  There are seven types of objectives in DBMS . They are,

* Mass storage

* Remove duplicate

* Multiple user access

* Data protection

* Data backup / recovery

* Integrity

* Platform indipendent

( i ) Mass storage :  DBMS can store a lot of data . DBMS is really ideal technology to use it can store thousands of records and can access the data when ever .

( ii ) Remove duplicate : DBMS donot store same data it will be remove duplicate data among all the records .

( iii ) Multiple user access :  DBMS make it possible to handle multiple users concurrently access the database.

( iv ) Data protection :  DBMS gives a high level security to the data stored in the DBMS . No one can modify the information without the user permission.

( v ) Data backup and recovery :  DBMS has the ability to backup and recover all the data in database when there is a crash in the database .

( vi ) Integrity :  Integrity means your data is authentication . DBMS has various validity checks .

( vii ) Platform indipendent :  DBMS run at any platform . No particular platform is required to DBMS .

 

 COMPONENTS OF DBMS

The database system refers to an organization of components that defined and regulate the collection storage management . The database system composed of five major parts . They are :

1 . Hardware
2 . Software
3 . People 
4 . Procedure
5 . Data

1 . HARDWARE : 

                                                It is refers to all of the system physical devises . The database system main and most easily identify hardware components is the computer . The hardware also include all of the computer partials which are the physical devices that control computer input and output . Such as keyboard , moniter , mouse , cpu , modems and printers .

2 . SOFTWARE : 

                                               Software is a collection of programs used by the computers with in the database system . They are three types of softwares are needed :  

 (i) Operating system      (ii) DBMS       (iii) Application software / Utility software

 (i) Operating system :

                                            It manage all hardware components and make it possible for all other software to run on the computers . 

 (ii) DBMS software :

                                            It manages the database with in the database .

 (iii) Application and utility software :

                                            Application program are use to access the data with in the database to generate report , table . Utility are the software tools used to help manage the database system computer components . This software provide "GUI"(Grafical user interface) . 

3 . PEOPLE : 

                                            The components include all users of the database system . There are four types of users in DBMS :

                                            (a) System administrater  
                                            (b) Database administrater
                                            (c) System analist
                                            (d) Users

(a) System administrater :

System administrater over see the database system general operations .

(b) Database administrater :

This user is also known as "DBA" manage the DBMS use and ensure that the database is functioning properly . 

(c) System analist : 

They design and implement the application program . They design data entry script screens reports and procedures through which end users access and maanipulate database data . 

 (d) Users : 

These are the people who use the application  program to run the organization daily operations . 

                    (i) Naive user

                   (ii) Sofisticated user

                  (iii) Specialised user

   (i) Naive user :

                              These users are interact with the system by exiguiting application programs that have already written in previously . 

  (ii) Sofissticated users : 

                              These users are interact with the system without writting the programs .

 (iii) Specialised user : 

                              These user directly write the programs .

4 . PROCEDURE :

                                Procedure are instructions and rules that instruct the design and use of the database system .

5 . DATA :

              

                                Data is a collection of rawfacts stored in database with out reveale it's meaning .