Database Management System-(DBMS)| Relational Database|Database Management And Database System
Database Management System -(DBMS) | Relational Database | Database Management And Database System
“Database Management System”-A Database Management System (DBMS) is a set of computer programs that controls the creation, maintenance, and the use of a database. It permits administrations to place control of database development in the hands of database administrators (DBAS) and other authorities. A DBMS is a system software package that benefits the use of a combined group of data records and documents well-known as databases. It allows different user application programs to easily acce4ss the same database. The database management system, basically works based on a computer program. Different types of files can be arranged using a specific sequence using the DBMS process. Depending on data management, different types of databases are designed. The examples of database applications are computerized library systems, automated teller machines, flight reservation systems, etc.
Some DBMS examples include
- MS Office Access
- MS SQL Server
- MS Visual FoxPro
Major Functions of DBMS And Database Management System
‘DBMS‘-Currently, the database management system is an advanced and popular data collection process. There are basically many types of data stored in a database through a particular serial, which can be found at any point in time at any time when data is needed. There are also many advantages of DBMS.
- Represents a complex relationship between data
- Ensures data sharing
- Enforces user-defined rules
- Enforces data access authorization
- Controls data redundancy and data integrity
- Ensure data reality and validity
- Automatic and intelligent backup and recovery procedures
- Pertaining to data and its manipulation
- Ensure the integrity of data in a table form
- Maintaining a data dictionary for the storage of information
- Viewing sorting and indexing
- Data integrity and concurrency
- Data security and encryption
- Design and documentation
- Update and query
- Monitor and control user access
- Provide the different type of forms and reports
Advantages of using Database Management System (DBMS) instead of a fie processing System:
The database method offers a number of potential benefits compared to old-fashioned file processing systems. Due to this, the demand for a database management system is increasing day by day.
- Program-Data Independence: The parting of data descriptions from the submission programs that use the data is named Data independence. With the database approach. Data explanations are stored in a vital location named the repository. This property of the database system allows an organization’s data to change without changing the application programs that process the data.
- Data Redundancy and Inconsistency: In File-processing Method, files have dissimilar designs and submission programs may create by dissimilar programmers. Also, different programs may be written in some programming languages. The same information may place at different files which cause redundancy and inconsistency consequently higher storage and access cost. DBMS can handle Data Redundancy and Inconsistency.
- Difficulty in accessing Data: In the Traditional file association the data is kept in the files. Whenever data has to be retrieved as per the requirements then a new application program has to be written. This is a tedious process.
- Data isolation: Since data is dispersed in several files, and files may be in different designs, it is difficult to write fresh application programs to recover the appropriate data.
- Concurrent access: There is no central control of data in the classical file organization. So, the concurrent access of data by many users is difficult to implement.
- Security Problems: Since there is no centralized control of data in a classical file organization. So, security, enforcement is difficult in File-processing system.
- Integrity Problems: The data values stored in the database must satisfy certain types of consistency constraints.
- Improved Data Sharing: A database is designed as a shared corporate resource. Authorized internal and external users are granted permission to use the database, and each user is provided one or more user views to facilitate this use, A user view is a logical description of some portion of the database that is required by a user to perform some task.
- Increased Productive of Application Development: A Major advantage of the database approach is that it greatly reduces the cost and time of developing new business applications.
The database system is a simple and perfect process.SO Now everyone is interested in using database management. Different database software is used to make database work easier.