Feature Of Database Management System



Salient Features of DBMS

Salient features of a database management system include database engine, data dictionary, query processor, report writer, forms generator, application generator communication, integration, and security

  • Database Engine

The database engine is the heart of DBMS. I stores, retrieves, and updates the data Other components of database system rely on the database engine for their functioning

  • Data Dictionary

The data dictionary holds definitions of all data items
stored in a database. It describes the data type of each data item e DBMS to keep track of the data.

  • Query Processor

The query processor is a fundamental component DBMS.it is used to locate and manipulate data. All database operations are run through the query language. For example, it is Used 1o create data structures, enter, read, and delete data in database structures, Normally, SQL (Structured Query Language) is used for these purposes

  • Report Writer

The report writer is used to genera s usually generated by retrieving data from several tables. The report writer is usually integrated into the DBMS However, it can also be a standalone application

  • Form Generator

Form generator is used to create data input screens) The form generator enables developers to build forms by dragging and dropping form components such as text boxes, radio buttons, checkboxes, dropdown menus, etc.

  • Application Generator

The application generator is a part of DBMS. It consists of tools that are used to create a complete database management application. A database application is a collection of queries, forms, and reports that are used to input and output data and perform various data manipulation operations.

  • Communication and Integration

Some database management systems provide special communication and integration utilities.
These are used to import and export data with different databases running on different computers

  • Security and Other Utilities

Because a primary goal of a database is to share data with multiple users, the DBMS provides facilities for establishing and maintaining data security.

Post a Comment

0 Comments