Characteristics of DBMS

• To incorporate the requirements of the organization, system should be designed
for easy maintenance.
• Information systems should allow interactive access to data to obtain new
information without writing fresh programs.
• System should be designed to co-relate different data to meet new requirements.
• An independent central repository, which gives information and meaning of
available data is required.
• Integrated database will help in understanding the inter-relationships between data stored in different applications.
• The stored data should be made available for access by different users
simultaneously.
• Automatic recovery feature has to be provided to overcome the problems with
processing system failure.
DBMS Utilities
• A data loading utility:
Which allows easy loading of data from the external format without writing
programs.
• A backup utility:
Which allows to make copies of the database periodically to help in cases of
crashes and disasters.
• Recovery utility:
Which allows to reconstruct the correct state of database from the backup and
history of transactions.
• Monitoring tools:
Which monitors the performance so that internal schema can be changed and
database access can be optimized.
• File organization:

Which allows restructuring the data from one type to another?

0 comments