Explain dbms and its characteristics and its application and function
Answers
Answered by
3
DBMS is a collection of inter related data and
set of programs to access that data.
It contain information about a particular interprises. it is a collection of data which is eelated to user and environment.it is convenient and efficient to use.
Application of DBMS
1) Banking and Airlines
2) University and credit card transaction
3) Tele communication
4) Online Retailer and Sales
5) Manufacturing in factory and human resources.
Database is used at all aspects of our life.
Characteristics of DBMS:-
1) Self describing of nature of database - It also contain database structure and constraints.
2)Insulation Between programs and data - In file system structure of data can be written in application programs but in DBMS data structure is stored in system catlog not in program.
3) Supports multiple view of data.
4) Sharing of data and multiuser system.
5) Restricting unathorised access of data.
6) Transaction processing.
7) Provide backup and recovery facility.
8) Managing information to itself.
9) Sharing of Data.
10) Controlling Data Redundancy.
www.myreadingroom.co.in
Notes and Study Materials
You are here: HomeNotes and Study MaterialsDBMSFunctions of Database Management System (DBMS)
Functions of Database Management System (DBMS)
THIRU DBMS 0 COMMENTS
0 Comments
DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. The most important functions of Database Management System are
Data Dictionary Management,
Data Storage Management,
Data Transformation and Presentation,
Security Management,
Multi user Access Control,
Backup and Recovery Management,
Data Integrity Management,
Database Access Languages andApplication Programming Interfaces and
Database Communication interfaces.
Functions of Database Management System DBMS
Functions of DBMS
1. Data Dictionary Management
Data Dictionary Management is the one of the most important function of database management system.DBMS stores definitions of the data elements and their relationships (metadata) in a data dictionary.So, all programs that access the data in the database work through the DBMS.The DBMS uses the data dictionary to look up the required data component structures and relationships which relieves you from coding such complex relationships in each program.Additionally, any changes made in a database structure are automatically recorded in the data dictionary, thereby freeing you from having to modify all of the programs that access the changed structure.In other words, the DBMS system provides data abstraction, and it removes structural and data dependence from the system.
2. Data Storage Management- One of the DBMS functionality is creating and managing the complex structures required for data storage, thus relieving you from the difficult task of defining and programming the physical data characteristics.A modern DBMS system provides storage not only for the data, but also for related data entry forms or screen definitions, report definitions, data validation rules, procedural code, structures to handle video and picture formats, and so on.Data storage management is also important for database performance tuning. Performance tuning relates to the activities that make the database perform more efficiently in terms of storage and access speed. So, the data storage management is another important function of Database Management System.
3. Data transformation and presentation
The DBMS 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. That is, the DBMS formats the physically retrieved data to make it conform to the user’s logical expectations.
4. Security Management-Security Management is another important function of Database Management System(DBMS). The DBMS 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. This is especially important in multiuser database systems.
5. Multi User Access Control - Multiuser access control is another important DBMS Function. To provide 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 - The DBMS provides backup and data recovery to ensure data safety and integrity.Current DBMS systems provide 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. Such capability is critical to preserving the database’s integrity.
set of programs to access that data.
It contain information about a particular interprises. it is a collection of data which is eelated to user and environment.it is convenient and efficient to use.
Application of DBMS
1) Banking and Airlines
2) University and credit card transaction
3) Tele communication
4) Online Retailer and Sales
5) Manufacturing in factory and human resources.
Database is used at all aspects of our life.
Characteristics of DBMS:-
1) Self describing of nature of database - It also contain database structure and constraints.
2)Insulation Between programs and data - In file system structure of data can be written in application programs but in DBMS data structure is stored in system catlog not in program.
3) Supports multiple view of data.
4) Sharing of data and multiuser system.
5) Restricting unathorised access of data.
6) Transaction processing.
7) Provide backup and recovery facility.
8) Managing information to itself.
9) Sharing of Data.
10) Controlling Data Redundancy.
www.myreadingroom.co.in
Notes and Study Materials
You are here: HomeNotes and Study MaterialsDBMSFunctions of Database Management System (DBMS)
Functions of Database Management System (DBMS)
THIRU DBMS 0 COMMENTS
0 Comments
DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. The most important functions of Database Management System are
Data Dictionary Management,
Data Storage Management,
Data Transformation and Presentation,
Security Management,
Multi user Access Control,
Backup and Recovery Management,
Data Integrity Management,
Database Access Languages andApplication Programming Interfaces and
Database Communication interfaces.
Functions of Database Management System DBMS
Functions of DBMS
1. Data Dictionary Management
Data Dictionary Management is the one of the most important function of database management system.DBMS stores definitions of the data elements and their relationships (metadata) in a data dictionary.So, all programs that access the data in the database work through the DBMS.The DBMS uses the data dictionary to look up the required data component structures and relationships which relieves you from coding such complex relationships in each program.Additionally, any changes made in a database structure are automatically recorded in the data dictionary, thereby freeing you from having to modify all of the programs that access the changed structure.In other words, the DBMS system provides data abstraction, and it removes structural and data dependence from the system.
2. Data Storage Management- One of the DBMS functionality is creating and managing the complex structures required for data storage, thus relieving you from the difficult task of defining and programming the physical data characteristics.A modern DBMS system provides storage not only for the data, but also for related data entry forms or screen definitions, report definitions, data validation rules, procedural code, structures to handle video and picture formats, and so on.Data storage management is also important for database performance tuning. Performance tuning relates to the activities that make the database perform more efficiently in terms of storage and access speed. So, the data storage management is another important function of Database Management System.
3. Data transformation and presentation
The DBMS 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. That is, the DBMS formats the physically retrieved data to make it conform to the user’s logical expectations.
4. Security Management-Security Management is another important function of Database Management System(DBMS). The DBMS 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. This is especially important in multiuser database systems.
5. Multi User Access Control - Multiuser access control is another important DBMS Function. To provide 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 - The DBMS provides backup and data recovery to ensure data safety and integrity.Current DBMS systems provide 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. Such capability is critical to preserving the database’s integrity.
Answered by
2
What is DBMS
- ⟹ DBMS software primarily functions as an interface between the end user and the database, simultaneously managing the data, the database engine, and the database schema in order to facilitate the organization and manipulation of data.
━━━━━━━━━━━━━━━━━━━━━━
Features of DBMS
- ⟹ Structure: Where data is structured in hierarchical form in a DBMS, data is structured in tabular form in a RDBMS.
- ⟹ User capacity: A RDBMS is capable of operating with multiple users. DBMS can only manage one user at a time.
- ⟹ Software/hardware requirements: A RDBMS has greater software and hardware requirements.
- ⟹ Programs managed: DBMS maintains databases within the computer network and system hard disks. A RDBMS manages the relationships between its incorporated tables of data.
- ⟹ ACID (Atomicity, Consistency, Isolation, and Durability) model.
━━━━━━━━━━━━━━━━━━━━━━
Function of DBMS
- ⟹ Data Dictionary Management,
- ⟹ Data Storage Management,
- ⟹ Data Transformation and Presentation,
- ⟹ Security Management,
- ⟹ Multi user Access Control,
- ⟹ Backup and Recovery Management,
━━━━━━━━━━━━━━━━━━━━━━
Similar questions