Please enable JavaScript.
Coggle requires JavaScript to display documents.
DBMS 1 - Coggle Diagram
DBMS 1
The DBMS
Data definition
Data manipulation
Optimization and execution
Data security and integrity
Concurrency and recovery
Data dictionary
Performance
Why is database
Compactness
Less drudgery
Speed
Protection
Currency
Benifts of approach
Data can be sared
Redundancy can be reduced
Inconsistency can be avoided
Transaction support can be provided
Integrity can be maintained
Security can enforced
Conflicting requirements can be balanced
Standards can be enforced
DBA
Schema definition
Storage structure and access method definition
Granting authorization for data access
Monitoring performance and responding requirements
Defining security and integrity constraints
What is database
Enterprise
Manufacturing company
Product data
Bank
Account data
Government department
Planning data
Hospital
Patient data
University
Student data
Entities and relationships
Properties
Relational System
Oracle 9i
IBM DB2
Onformix
Architecture
External
Internal
Conceptual
Mapping
Conceptual/Internal level
Conceptual external level
Client server system
User written applications
Vendor provided applications
Data mining and data vis tools
Query lang processor
Report writers
NLP
Bussiness graphics systems
Spreadsheets
Statistical packages
Data independence
Physical level
Logical level
What is database system
Components
Users
Data
HW
SW
Introduction
Data independence