the Advantages of Using DBMS

Advantages of Using DBMS

Advantages of Using DBMS
n Controlling Redundancy
n Restricting Unauthorized Access
n Providing Persistent Storage
n Permitting Inferencing
n Providing Multiple User Interfaces
n Presenting Complex Relationship
n Enforcing Integrity Constraints
n Providing Backup and Recovery

Some other benefits
n Enforcing Standards
n Reduced Application development time
n Flexibility
n Up-to-date Information
n Economies of Scale

When Not to Use a DBMS
n Unnecessary overhead costs
(high initial cost – Generality – overhead of capabilities)
n Database and applications are simple
n Stringent real-time requirements
n Multiple-user access is not required
Some Previous I talked about

n Database Administrator (DBA)
DBA administrates DB, DBMS, applications, user accessing authorization, monitoring and tuning.
n Database Designers
DB designers identify the data to be stored and its structure to efficiently fulfill all users requirements.
n End Users
Ø Casual end users:Occasionally access DB using sophisticated query language (Managers)
Ø Naive end users: Querying and updating DB using canned transactions (bank tellers, etc..)
Ø Sophisticated end users: familiar with DBMS capabilities and using it to implement their complex requirements (engineers, scientists, analysts, etc. )
Ø Stand-alone users: using ready-made packages and tools to handle their personal DB.
n System Analysts and Application Programmers
Analysts determine the users requirements and develop the appropriate transaction specifications.
Application programmers implement these requirements to programs.
Analysts + Programmers are called SOFTWARE ENGINEERS