Characters Of Database Management System Approach| characters of dbms-education notes for study
In this article, we will discuss the overview of the Database Approach and will mainly focus on its characteristics. Also, we will cover the Characteristics of the Database Approach in detail. Let’s discuss it one by one.
Characteristics of database approach :
Some of the most important characteristics of the database approach to the file processing approach are the following as follows.
four basic characters of Database Management system Approach.
1.Self Describing nature of a Database System .
2.Insulation between programs and data abstraction.
3.Support of multiple views of DBMS
4.Sharing of Data and multiuser transaction processing.
Let us discuss in details each character:
1.Self Describing nature of a Database System:-
A Fundamental characteristics of the database approach is that the database system contains not only the database itself but also a complete definition or description of the database structure and constraints this definitions stored in the dbms catalog which contains information such as the structure of each file the type and storage format of each data items. And various constraints on the data,the information stored in the catalog is called metadata and it is described the structure of primary database.
2.Insulation between programs and data abstraction:-
In traditional file processing the structure of data files is embedded in the application programs.so any changes to the structure of of a file may require changing all programs that access programs do not require such changes in most cases.
Example :- a file access program may be written in such a way that it can access only student records of the structure.
3.Support of multiple views of DBM:-
A database is typically has many users each of whom may required a different perspective or view of the database a view maybe a subset of the datsbase or it contains virtual data that is derived from the database files but is not explicity stored.
Example:-
One user of the database may be interested only in accessing and printing the transcript of each student a second user who is interested only in checking that the students have taken all the pre requests of each cause for which they register.
4.Sharing of Data and multiuser transaction processing:-
A multiuser dbms as its name implies must allow multiusers to access the database at the same time this is essential if data for multiple applications is to be integrated and maintained in single database.
The DBMS must include concurrency control software to ensure that several users trying to update the same data do so in controlled manner in that the result of the updates is connect.
Example:- when several reservation clerks try to assign by only one clerk at a time for assignment to a passenger these types of applications are generally called online transaction processing applications.
So this are some Characters Of Database Management System Approach| characters of dbms-education notes for study
If You Like my Article do Share with your Friends.
If you have any queries,questions related to any notes please do comments me in my comments section.
😊😊😊😊
RECOMMENDED ARTICLES :-
1.DBMS-Database system concept
0 Comments