Database

Introduction:

• Data is can be recorded and have an implicit meaning.
• Database is a collection of related data.
• Database Management System is a software package system to facilitate the creation and maintenance of a computerized database.
• A DBMS consists of a group of programs that manipulate the database and provide an interface between the database, the user of the database and other application programs.
• It allows changing data storage structures and operations without having to change the DBMS access programs.

Advantages of DBMS: DBMS uses a variety of techniques to store & retrieve data

• Data Integrity & Security: Data Administration is when several users share data, centralizing the administration offers significant improvement.
• Concurrent Access & Crash Recovery DBMS schedules concurrent access to the data in such a manner that users think of the data as being accessed by only one user at a time.
• DBMS protects users from the ill-effects of system failures.
• Reduced Application Development Time Many important tasks are handled by the DBMS.
• Centralized control of data by the DBA avoids unnecessary duplication of data and effectively reduces the total amount of data storage required.
• Elimination of Inconsistencies: The main advantage of avoiding duplication is the elimination of inconsistencies that tend to be present in redundant data files.

• A database allows the sharing of data under its control by any number of application programs or users.
• Data Model: A set of concepts to describe the structure of a database, and certain constraints that the database should obey.

• Easy to identify specific data required to support each business unit’s operations.
• Databases support storage and manipulation of data. Databases make data management easy.
• Database Management System is a collection of programs which enables its users to access database, manipulate data, reporting, representation of data.