• 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