Features of Database Management Systems.pptx

Features of Database Management Systems
Database management system (DBMS)
Collection of programs used to create maintain and access database
Features of Database Management Systems
Data Dictionary
Utilities
Query Language
Report Generator
Access Security
Backup and Recovery

1. Features of Database Management Systems A Detailed Overview

2. Database management system (DBMS) Collection of programs used to create maintain and access database Database managers software are used to control the overall structure of a database Used by different organizations for different purposes

3. Features of Database Management Systems Data Dictionary Utilities Query Language Report Generator Access Security Backup and Recovery

4. Data Dictionary Stores all data definitions for a database Monitors data entry Ensures data adheres to defined rules Used for data access authorization Also called repository

5. Utilities Used to maintain databases Processes data, records, and files Backup and recovery procedures

6. Query Language Performs operations on databases Popular query language is SQL (Structure Query Language) Commands: SELECT, DELETE, CREATE, MODIFY, UPDATE, INSERT Purposes: - Create table structures - Enter data in tables - Retrieve data from tables - Update data in tables - Delete data from tables

7. Report Generator Produces reports in different formats Formats page numbers, dates, titles, and column headings Also called report writer

8. Access Security Protects database from unauthorized access Several procedures for data security Allows access through passwords Different users have different access levels

9. Backup and Recovery Provides facility for backup and recovery Stores an additional copy of data Data can be recovered if original file is lost or damaged

10. Conclusion Database Management Systems have various features that ensure data integrity, security, and accessibility. Understanding these features is crucial for efficient database management.