ICS Part 2 Computer Lectures Chapter 1 Data Basics | What is DBMS and Objectives
 |
| DBMS & Objectives |
#ICS #Chapter1 #Databasics #DBMS #Database #Objectives
A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database. A DBMS generally manipulates the data itself, the data format, field names, record structure and file structure. It also defines rules to validate and manipulate this data.
The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs. Some DBMS examples include MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro.
Types of DBMS
- Hierarchical Databases.
- Network Databases.
- Relational Databases.
- Object-oriented Databases.
- ER model Databases.
A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data. These are systems that can be used to manage transactional databases, such as HR systems, banking systems and so on.
Objectives of Database Management System
1. Share ability:
An ability to share data is a fundamental objective of database management system. Shareability
means that data is shared by different people at the same time.
2. Availability
Availability means that the users must be able to access data and DBMS easily. The data should be available when and where it is required.
3. Evolvability.
Evolvability means that DBMS should provide the facility to change the Database due to increase in user requirements or change in the technology. The change in database may occur in two ways, it may change by contents or by structure. for example the structure of the database may be changes if the operation of an organization is expanded.
4. Data Integrity:
Database Integrity ensures that data entered in the database is accurate and consistent. Database is normally share among different users. Some measures must be maintained to ensure database integrity.
0 Comments