Features of Database Management Systems.pptx

AaashaRana 104 views 10 slides Jul 07, 2024
Slide 1
Slide 1 of 10
Slide 1
1
Slide 2
2
Slide 3
3
Slide 4
4
Slide 5
5
Slide 6
6
Slide 7
7
Slide 8
8
Slide 9
9
Slide 10
10

About This Presentation

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


Slide Content

Features of Database Management Systems A Detailed Overview

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

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

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

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

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

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

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

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

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