Functions Of DBMS and Its Advantage and Disadvantage


 Functions Of DBMS and Its Advantage and Disadvantage




A. Functions of DBMS   


1. Data Dictionary Management

   -   DBMS stores definitions of the data elements and their relationships       (metadata)     in a data dictionary.

Example of  Data Dictionary Management:


2. Data Storage Management

  - creates and manage the complex structures required for data storage, thus relieving you from the difficult task of defining and programming the physical data characteristics.


3. Data transformation and presentation

- transforms entered data in to required data structures. The DBMS relieves you of the chore of making a distinction between the logical data format and the physical data format.

4. Security Management

- creates a security system that enforces user security and data privacy. Security rules determine which users can access the database, which data items each user can access, and which data operations (read, add, delete, or modify) the user can perform.


5. Multi User Access Control

- provides data integrity and data consistency, the DBMS uses sophisticated algorithms to ensure that multiple users can access the database concurrently without compromising the integrity of the database.
   
6. Backup and Recovery Management
 
- provides special utilities that allow the DBA to perform routine and special backup and restore procedures. Recovery management deals with the recovery of the database after a failure, such as a bad sector in the disk or a power failure.


7. Data Integrity Management

- promotes and enforces integrity rules, thus minimizing data redundancy and maximizing data consistency.


8. Database Access Languages and Application Programming Interfaces

- provides data access through a query language. A query language is a non procedural language-one that lets the user specify what must be done without having to specify how it is to be done.

9. Database Communication Interfaces

- Current-generation DBMS's accept end-user requests via multiple, different network environments. For example, the DBMS might provide access to the database via the Internet through the use of Web browsers such as Mozilla Firefox or Microsoft Internet Explorer. 

Advantages of DBMS




Disadvantages of DBMS




















Comments

Post a Comment

Popular posts from this blog

DATABASE MANAGEMENT SYSTEM

Image
DATABASE MANAGEMENT SYSTEM  A. What is a Database? - It is an organized collection of structure information, or data, typically stored electronically in computer system. B. What type of Software is Microsoft excel? - Microsoft Excel is a spreadsheet program included in Microsoft Office suite of application. C. What type of Software is Microsoft access? - Microsoft Access is a database management system DBMS that combines the relational Microsoft  Jet Database Engine with a graphical user interface and software development tools. D. think of at least two differences between access and excel. - Excel is made up of sheets with cells that can be used to perform calculations, create charts, and so on. Access, on the other hand, includes tables, queries, forms, and report modules. Overall, Excel is a spreadsheet, whereas Access is a database management system. B. Explore & Explain 1. What is Information Management? - It is the collection and management of informat...
Read more

Introduction to SQL 💗

Image
 Introduction to SQL💗 A. ENGAGE A. DATA DEFINITION LANGUAGE  - A data definition or data description language in the context of SQL is a syntax for creating and changing database objects such as tables, indices, and users. B. INTERACTIVE DATA MANIPULATION LANGUAGE - Interactive Data Manipulation Language or DML  is a set of computer languages that are expressly used to change the database, such as CRUD operations to create, read, update, and remove data. INSERT, SELECT, UPDATE, and DELETE commands are used. C. EMBEDDED DATA MANIPULATION LANGUAGE - Embedded SQL is a means of merging a programming language's computing capability with SQL's database manipulation capabilities. Embedded SQL statements are SQL statements that are written inline with the host language's program source code. B. EXPLORE & EXPLAIN  1. What are the basic sql expression?  - SQL expression can be classified into following categories.  SQL Boolean Expression -  fetches data bas...
Read more