Characteristics of database approach | characteristics of DBMS | DBMS Characteristics
characteristics of database approach: In this DBMS tutorial we will learn characteristics of database approach, In detail explanation of each characteristic.
Characteristics of Database Approach:
The main characteristics of the database approach versus the file-processing approach are the following:
1.Self-describing nature of a database system
2. Insulation between programs and data, and data abstraction
3. Support of multiple views of the data
4. Sharing of data and multi-user transaction processing.
Self Describing nature:
Self describing nature of Database system means that the Database system not only contains the database but also the information about the structure and constraints of the database.
This information about database structure and constraints is known as Meta data.
The Meta data is stored in the catalog of the database.
Insulation between programs and data, and data abstraction
In a file system if some changes are made in the file structure, then to handle these changes, more changes have to be made in all the programs that access this file.
For example you want to add a piece of data, say date of birth of students. Just adding it to the database is not enough, the whole program will have to be re-written to make it work.
But In a Database system all you need to do is define another data item in the catalogue called date of birth and all the changes will be reflected and there is no need to change the whole program.
Support of multiple views of the data:
A database has multiple users, each user may need different view of the database.
Database “view” can be the information that is stored in the database or is derived from the database.
A database system allows multiple such “views” from the same database without letting the user know whether the information is stored just derived.
For example, a teacher wants to call parents of the students for a meeting, so she will have a different view which will display the contact details of the parents, while if a student wants to check the database for attendance percentage, he/she will only see names of the students and the percentages and not the contact details of parents in his “view”.
Sharing of Data and Multiuser Transaction Processing
A multiuser DBMS as the name suggest means has multiple users.
It must allows multiple users to access and use the database at the same time.
This is a must when multiple application use a single database to store and integrate data in one single database
To achieve this a concurrency control software must be included in the DBMS.
Concurrency control software make sure that the information is correct when multiple users try to access and update the data.
Such applications are known as online transaction processing (OLTP) applications.
THANK YOU GUYS FOR WATCHING, IF YOU LIKED THIS VIDEO, PLEASE HIT THE LIKE BUTTON AND SUBSCRIBE TO THIS CHANNEL AND SHARE THIS VIDEO. SEE YOU IN THE NEXT ONE.
thank you!!!!!!!!!!!!!!!!!!!!!
Check out my video on Rail fence cipher:
https://www.youtube.com/watch?v=uAFfy...
Check out my video on playfair cipher:
https://www.youtube.com/watch?v=2LwS7...
Check out my video on caesar cipher:
https://www.youtube.com/watch?v=k8W2S...
Check out my video on Hill cipher:
https://www.youtube.com/watch?v=wd0e1...
Check out my video on columnar transposition cipher:
https://www.youtube.com/watch?v=p9jz-...
Watch video Characteristics of database approach | characteristics of DBMS | DBMS Characteristics online without registration, duration hours minute second in high quality. This video was added by user QuickCS 05 October 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 25,700 once and liked it 597 people.