Elements
Ø Kernel
Code:
àPart of system OS, keeps the
system up and running from the time of booting, till shutdown.
àIt is responsible for
allocating resources ,Memory management, Storage .
Ø Repository
of metadata:
àdata dictionary(meta data about the database)
àFor ex. Creating a new table
,that meta data(ie. Columnnames, Length , Attributes) stored in data
dictionary.
Ø Query
Language: Access the data.
Ø Database
Applications: Access and Manipulate data
Advantages of DBMS
Ø Control
of data Redundancy
Ø Integrity
– data is accurate using constraints
Ø Data
Consistency – Correct information
Ø Data
Sharing
Ø Standards
can be enforced
Ø Restricting
Un authorized access
Ø Backup and Recovery
Ø Concurrency
control
Dis Advantages of
DBMS
Ø Complexity
Ø Size
Ø Cost
of DBMS
No comments:
Post a Comment