DBMS

DBMS

 Definition:

• A database management system (DBMS) is a software package with
• computer programs that control the creation, maintenance, and the use of
• a database.
• It allows organizations to conveniently develop databases for
• various applications by database administrators (DBAs) and other
• specialists.
• A database is an integrated collection of data records, files, and
• other database objects.
• A DBMS allows different user application programs to concurrently access the same database.
• DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated  database languages that considerably simplify writing database application programs.
• Database languages also simplify the database organization as
• well as retrieving and presenting information from it.
• A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, recovering the database after failures and restoring it from backup files, as well as maintaining database security.

Advantages of DBMS

• Reduced data redundancy
• Reduced updating errors and increased consistency
• Greater data integrity and independence from applications
• programs
• Improved data access to users through use of host and query
• language
• Improved data security
• Reduced data entry, storage, and retrieval costs
• Facilitated development of new applications program

Disadvantages of DBMS

• Database systems are complex, difficult, and time
• consuming to design
• Substantial hardware and software start-up costs
• Damage to database affects virtually all applications
• programs
• Extensive conversion costs in moving form a file-based
• system to a database system
• Initial training required for all programmers and users