Database Management Systems: An Overview, Slides of Database Management Systems (DBMS)

Download Database Management Systems: An Overview and more Slides Database Management Systems (DBMS) in PDF only on Docsity!

• Slide

Slide 2

Over View of Last Lecture

Slide 4

• (^) File Processing System
• (^) Database approach
• (^) Database advantages

Slide 5

• (^) Data Sharing
• (^) Independent
• (^) Control Redundancy (Duplication)
• (^) Better Data Integrity (Validity)

Database Approach

Advantages

Slide 7

• (^) Better Concurrency control (ATM)
  • (^) Batter backup and recovery procedure

Database Approach

Advantages

Slide 8

Today

Slide 10 Data as Resource

Slide 11

Resource

• (^) Any asset that is of value to an

organization and that incurs

Cost

Slide 13 Yes

Slide 14

• (^) Need information
• (^) For Dead Items
  • (^) For Sales
  • (^) For Hot items
  • (^) For Customer
    • (^) For Delivery / Reorder

Slide 16

Level of Data

• (^) Real World Data
  • Running System Physically
  • Procedures and process
  • Identify / attributes of any entity
    • Name , Address , Age

Slide 17

Level of Data

• (^) Meta Data Data about data (way the data will be stored) Structures of data, Checks , properties Name text Age Number Salary Number

Slide 19

Database User

• (^) Application Programmer
• (^) End User
• (^) Database User (DBA)

Slide 20

Duties of DBA

• (^) Design
  • (^) Granting Data Access
  • (^) Maintenance
• (^) Monitor the disk space