Characteristics of dbms approach

Characteristics of Database Management System

Provides security and removes redundancy. Self-describing nature of a database system. Insulation between programs and data abstraction. Support of multiple views of the data. DBMS supports multi-user environment that allows users to access and manipulate data in parallel.

Characteristics of File Processing System

Each file is independent from one another. Each file is called a flat file. Each file contained and processed information for one specific function, such as accounting or inventory. Files are designed by using programs written in programming languages such as COBOL, C, C++.

But in traditional file processing system the application is developed for a specific purpose and they will access specific database only. The other main characteristic of the database is that it will allow multiple users to access the database at the same time and sharing of data is possible.

There are five traits that you’ll find within data quality: accuracy, completeness, reliability, relevance, and timeliness – read on to learn more.

DBMS Components: Database Access Language

User can create new databases, tables, insert data, fetch stored data, update data and delete the data using the access language.

A database intends to have a collection of data stored together to serve multiple applications as possible. Hence a database is often conceived of as a repository of information needed for running certain functions in a corporation or organization.

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 ten functions in the DBMS are: data dictionary management, data storage management, data transformation and presentation, security management, multiuser access control, backup and recovery management, data integrity management, database access languages and application programming interfaces, database communication

There are several advantages of database management systems. Chief among them are data redundancy and consistency, data sharing, integrity restrictions, and greater security.

one of the disadvantages of dbms is Database systems require sophisticated hardware and software and highly skilled personnel. Training, licensing, and regulation compliance costs are often overlooked when database systems are implemented.

Cost of Hardware and Software –

This is the first disadvantage of the database management system. This is because, for DBMS, it is mandatory to have a high-speed processor and also a large memory size. After all, nowadays there is a large amount of data in every field which needs to be store safely and with security.

A Database Management System (DBMS) is software designed to store, retrieve, define, and manage data in a database.

Although SQL has many advantages, still there are a few disadvantages. SQL has a difficult interface that makes few users uncomfortable while dealing with the database. Some versions are costly and hence, programmers cannot access it. Due to hidden business rules, complete control is not given to the database.

Why SQL? Allows users to access data in the relational database management systems. Allows users to describe the data. Allows users to define the data in a database and manipulate that data.