02-07-2013, 02:15 PM
Introduction to DBMS (Database Management Systems)
Introduction to DBMS.ppt (Size: 232 KB / Downloads: 325)
Why Database ?
Redundancy can be reduced
Inconsistency can be avoided
The data can be shared
Standards can be enforced
Security restrictions can be applied
Integrity can be maintained
Provision of data independence
Functions of the DBMS
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Security and Integrity
Data Recovery and Concurrency
Data Dictionary
Performance
Distributed Databases
Advantages:
efficiency of local processing
data sharing
Disadvantages:
communication overhead
implementation difficulties