Characteristics of Data Base:
There are four Characteristics of Data Base System
1. Self-describing nature of database system.
2. Insulation between program data and data abstraction.
3. Support of multiple views of the data.
4. Sharing of data and multi transaction processing.
1. Self-describing nature of database system.
A fundamental character of a database approach is that the database system contains not only the database but also a complete definition or description of data structure and constraints.
DBMS catalog contains information such as a structure of each file and storage format of each data item. the information stored in the catalog is called metadata. it describes the structure of the primary database.
2. Insulation between program data and data abstraction.
3.Support of Multiple views of the data.
A database has many users each of the users require the view of the database. the view is the subset of a database, it contains the virtual data which is derived from the database file, but it is not explicitly stored. each and every user will search the database according to different needs.
Ex: In a Banking System when a transaction occurs like deposit this should be reflected immediately in the bank database. The Bank database should have a Support of Multiple views of the data so that the balance amount can be viewed in ATM or any other transaction.
4. Sharing of data and multi transaction processing.
The DBMS must include concurrency control software to ensure that several users trying to update same do so in the manner.so that the results of the update is correct.
In the traditional file processing system, the structure of data files is embedded in the application program so any changes to the structure of file may require changing all the program that access the file by contrast the DBMS access program does not require such changes in most of the cases.
The structure of Data files is stored in the DBMS catalog separately from the access program this property is known as program data independence.
3.Support of Multiple views of the data.
A database has many users each of the users require the view of the database. the view is the subset of a database, it contains the virtual data which is derived from the database file, but it is not explicitly stored. each and every user will search the database according to different needs.
Ex: In a Banking System when a transaction occurs like deposit this should be reflected immediately in the bank database. The Bank database should have a Support of Multiple views of the data so that the balance amount can be viewed in ATM or any other transaction.
4. Sharing of data and multi transaction processing.
The DBMS must include concurrency control software to ensure that several users trying to update same do so in the manner.so that the results of the update is correct.
Ex: When Airline reservation agent tries to assign seat of an airline flite. the DBMS should ensure that each seat is accessed by only one agent at a time for the assignment of the passenger. this application follows OLTP (OnLine Transaction Processing)
I hope this article is useful to you, plz follow the next volume for more information.
please post your doubts in the comment box.
You can write to me at codingallrounders@gmail.com
Subscribe by Email
Follow Updates Articles from This Blog via Email
No Comments