Home » DBMS

Introduction of Database Management system



Learn: In this article we are going to discuss about the Introduction of Database and Database Management System and its advantages.
Submitted by Prerana Jain, on May 20, 2018

DBMS - Database

Database

A database is a collection of related data. In database any user can efficiently access the data which users want to retrieve. It can be anything from a simple collection of roll numbers, names, addresses and phone numbers of students to a complex collection of sound, images, and even video or film clippings. Though they are generally computerized, instances of non-computerized database from everyday life can be cited in abundance. A dictionary, a phone book, a collection of recipes and a TV guides are the examples of non computerized database. The examples of computerized database include customer files, employee rosters, books catalogue, equipment inventories and sales transactions.

Database Management System (DBMS)

It is a collection of interrelated data usually called database and a set of programs to access, update and manage those data which form part of management system. In word, it is a software package to facilitate creation and maintenance of computerized database.

It is general purpose software that facilitates creation the following...

  • Defining
    It specifies the data types and structures and some constraints for data to be stored.
  • Constructing
    It Helps us to construct a new database and storing data in a storage medium.
  • Manipulating
    Its helps us to manipulate existing data involving new queries, updating and generating reports.
  • Sharing
    Its allowing the multiple users and programs to access data simultaneously. It allows multiple users to work on the same time.

Examples: Ms Access, Dbase, FileMaker, ORACLE etc.

Needs of database Approach

  • Before database approach, information on a computer is stored in OS files. To allow users to manipulate the information, the system has a number of applications programs that manipulate files. This is known as File processing system.
  • File based system uses all early attempt to computerize the manual filling Systems However, rather than a centralized approach , to steer data decentralized approach where each department store and control its data.


Advantages of Database Management System

  • Reduction of redundancies
    In this there is a centralized control of data and DBA (database administrator) which avoids unnecessary duplication of data. It also eliminates the extra processing necessary.
  • Elimination of inconsistencies
    The main advantage of avoiding duplication is the elimination of inconsistencies that tend to present in redundant data files. Redundancies of data in the DBMs are controlled and multiple copies of data are consistent.
  • Shared data
    A database allow the sharing of data under its control by any number of application programs or users.
    Example: the application for the public relations and payroll departments can share the same data.
  • Integrity
    Data Integrity means that the data contained in the database in both accurate and consistent. DBMS provides the function of security and some types of checks which main the data integrity.
  • Security
    Data is of vital importance to an organization and may be confidential. Such confidential data must not be accessed by unauthorized persons. The DBA who has the ultimate responsibility or the data in the DBMS can ensure that proper access procedure is allowed.
  • Conflict resolution
    Since the database is under control of the DBA, he/she should resolve the conflicting requirements of various users and applications.

Reference: Database






Was this page helpful? YES NO

Are you a blogger? Join our Blogging forum.



Comments and Discussions





© https://www.includehelp.com (2015-2018), Some rights reserved.




close Like other websites, this site uses cookies to deliver relevant ads based on your interest, by using our website, you acknowledge that you have read our privacy policy.